From 67f3795ea8eff9856ed2d91b01a63adf05ab9dbc Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期一, 08 一月 2024 14:38:40 +0800
Subject: [PATCH] 省市初始化数据
---
model/province.go | 23 +++++++++++++++++++++++
1 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/model/province.go b/model/province.go
index 6e9e908..186a902 100644
--- a/model/province.go
+++ b/model/province.go
@@ -3,6 +3,7 @@
import (
"aps_crm/pkg/mysqlx"
"gorm.io/gorm"
+ "sync"
)
type (
@@ -115,3 +116,25 @@
var db = slf.build()
return db.Updates(m).Error
}
+
+// InitDefaultData 鍒濆鍖栨暟鎹�
+func (slf *ProvinceSearch) InitDefaultData(errCh chan<- error, wg *sync.WaitGroup) {
+ var (
+ db = slf.Orm.Table(slf.TableName())
+ total int64 = 0
+ )
+ if err := db.Count(&total).Error; err != nil {
+ errCh <- err
+ return
+ }
+ if total != 0 {
+ return
+ }
+ sql := "INSERT INTO `province` VALUES (29,'鍖椾含甯�',3),(30,'澶╂触甯�',3),(31,'娌冲寳鐪�',3),(32,'灞辫タ鐪�',3),(33,'鍐呰挋鍙よ嚜娌诲尯',3),(34,'杈藉畞鐪�',3),(35,'鍚夋灄鐪�',3),(36,'榛戦緳姹熺渷',3),(37,'涓婃捣甯�',3),(38,'姹熻嫃鐪�',3),(39,'娴欐睙鐪�',3),(40,'瀹夊窘鐪�',3),(41,'绂忓缓鐪�',3),(42,'姹熻タ鐪�',3),(43,'灞变笢鐪�',3),(44,'娌冲崡鐪�',3),(45,'婀栧寳鐪�',3),(46,'婀栧崡鐪�',3),(47,'骞夸笢鐪�',3),(48,'骞胯タ澹棌鑷不鍖�',3),(49,'娴峰崡鐪�',3),(50,'閲嶅簡甯�',3),(51,'鍥涘窛鐪�',3),(52,'璐靛窞鐪�',3),(53,'浜戝崡鐪�',3),(54,'瑗胯棌鑷不鍖�',3),(55,'闄曡タ鐪�',3),(56,'鐢樿們鐪�',3),(57,'闈掓捣鐪�',3),(58,'瀹佸鍥炴棌鑷不鍖�',3),(59,'鏂扮枂缁村惥灏旇嚜娌诲尯',3),(60,'鍙版咕鐪�',3),(61,'棣欐腐',3),(62,'婢抽棬',3)"
+
+ err := slf.Orm.Exec(sql).Error
+ if err != nil {
+ errCh <- err
+ return
+ }
+}
--
Gitblit v1.8.0