github.com/easysoft/zendata@v0.0.0-20240513203326-705bd5a7fd67/cmd/test/others/func/import/name-cngiven.go (about) 1 package main 2 3 import ( 4 "fmt" 5 6 "github.com/easysoft/zendata/cmd/test/others/func/comm" 7 "github.com/easysoft/zendata/cmd/test/others/func/model" 8 ) 9 10 func main() { 11 filePath := "data/name/cn.given.v1.xlsx" 12 sheetName := "中文名" 13 14 db := comm.GetDB() 15 db.Exec(fmt.Sprintf(comm.TruncateTable, model.DataChineseGiven{}.TableName())) 16 db.AutoMigrate( 17 &model.DataChineseGiven{}, 18 ) 19 20 records := comm.GetExcelTable(filePath, sheetName) 21 22 for _, record := range records { 23 po := model.DataChineseGiven{ 24 Name: record["name"].(string), 25 Pinyin: record["pinyin"].(string), 26 Sex: record["sex"].(string), 27 } 28 29 db.Save(&po) 30 } 31 }