You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
56 lines
3.1 KiB
56 lines
3.1 KiB
9 months ago
|
package source
|
||
|
|
|
||
|
|
import (
|
||
|
|
"pure-admin/global"
|
||
|
|
"pure-admin/model"
|
||
|
|
"time"
|
||
|
|
|
||
|
|
"github.com/gookit/color"
|
||
|
|
|
||
|
|
"gorm.io/gorm"
|
||
|
|
)
|
||
|
|
|
||
|
|
var DictionaryDetail = new(dictionaryDetail)
|
||
|
|
|
||
|
|
type dictionaryDetail struct{}
|
||
|
|
|
||
|
|
//@description: dictionary_details 表数据初始化
|
||
|
|
func (d *dictionaryDetail) Init() error {
|
||
|
|
var details = []model.SysDictionaryDetail{
|
||
|
|
{"smallint", 1, status, 1, 2, global.MG_MODEL{ID: 1, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"mediumint", 2, status, 2, 2, global.MG_MODEL{ID: 2, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"int", 3, status, 3, 2, global.MG_MODEL{ID: 3, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"bigint", 4, status, 4, 2, global.MG_MODEL{ID: 4, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"date", 0, status, 0, 3, global.MG_MODEL{ID: 5, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"time", 1, status, 1, 3, global.MG_MODEL{ID: 6, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"year", 2, status, 2, 3, global.MG_MODEL{ID: 7, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"datetime", 3, status, 3, 3, global.MG_MODEL{ID: 8, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"timestamp", 5, status, 5, 3, global.MG_MODEL{ID: 9, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"float", 0, status, 0, 4, global.MG_MODEL{ID: 10, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"double", 1, status, 1, 4, global.MG_MODEL{ID: 11, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"decimal", 2, status, 2, 4, global.MG_MODEL{ID: 12, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"char", 0, status, 0, 5, global.MG_MODEL{ID: 13, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"varchar", 1, status, 1, 5, global.MG_MODEL{ID: 14, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"tinyblob", 2, status, 2, 5, global.MG_MODEL{ID: 15, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"tinytext", 3, status, 3, 5, global.MG_MODEL{ID: 16, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"text", 4, status, 4, 5, global.MG_MODEL{ID: 17, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"blob", 5, status, 5, 5, global.MG_MODEL{ID: 18, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"mediumblob", 6, status, 6, 5, global.MG_MODEL{ID: 19, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"mediumtext", 7, status, 7, 5, global.MG_MODEL{ID: 20, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"longblob", 8, status, 8, 5, global.MG_MODEL{ID: 21, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"longtext", 9, status, 9, 5, global.MG_MODEL{ID: 22, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
{"tinyint", 0, status, 0, 6, global.MG_MODEL{ID: 23, CreatedAt: time.Now(), UpdatedAt: time.Now()}},
|
||
|
|
}
|
||
|
|
return global.MG_DB.Transaction(func(tx *gorm.DB) error {
|
||
|
|
if tx.Where("id in (?)", []int{1, 23}).Find(&[]model.SysDictionaryDetail{}).RowsAffected == 2 {
|
||
|
|
color.Danger.Println("\n[Mysql] --> sys_dictionary_details 表的初始数据已存在!")
|
||
|
|
return nil
|
||
|
|
}
|
||
|
|
if err := tx.Create(&details).Error; err != nil { // 遇到错误时回滚事务
|
||
|
|
return err
|
||
|
|
}
|
||
|
|
color.Info.Println("\n[Mysql] --> sys_dictionary_details 表初始数据成功!")
|
||
|
|
return nil
|
||
|
|
})
|
||
|
|
}
|