github.com/easysoft/zendata@v0.0.0-20240513203326-705bd5a7fd67/cmd/test/others/func/import/name-enfamily.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/en.family.v1.xlsx"
    12  	sheetName := "英文姓"
    13  
    14  	db := comm.GetDB()
    15  	db.Exec(fmt.Sprintf(comm.TruncateTable, model.DataEnglishFamily{}.TableName()))
    16  	db.AutoMigrate(
    17  		&model.DataEnglishFamily{},
    18  	)
    19  
    20  	records := comm.GetExcelTable(filePath, sheetName)
    21  
    22  	for _, record := range records {
    23  		po := model.DataEnglishFamily{
    24  			Name:  record["name"].(string),
    25  			Index: record["index"].(string),
    26  		}
    27  
    28  		db.Save(&po)
    29  	}
    30  }