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  }