golang sql根據struct欄位來產生記錄

這是一個建立於 的文章，其中的資訊可能已經有所發展或是發生改變。

/*Author        : tuxpyEmail         : q8886888@qq.com.comCreate time   : 2017-11-04 23:13:08Filename      : main.goDescription   :*/package mainimport ("database/sql""errors""fmt""reflect""time""utils"_ "github.com/mattn/go-sqlite3")func ToStruct(rows *sql.Rows, to interface{}) error {v := reflect.ValueOf(to)if v.Elem().Type().Kind() != reflect.Struct {return errors.New("Expect a struct")}scan_dest := []interface{}{}column_names, _ := rows.Columns()addr_by_column_name := map[string]interface{}{}for i := 0; i < v.Elem().NumField(); i++ {one_value := v.Elem().Field(i)column_name := v.Elem().Type().Field(i).Tag.Get("sql")if column_name == "" {column_name = one_value.Type().Name()}addr_by_column_name[column_name] = one_value.Addr().Interface()}for _, column_name := range column_names {scan_dest = append(scan_dest, addr_by_column_name[column_name])}return rows.Scan(scan_dest...)}func main() {db, err := sql.Open("sqlite3", "/tmp/firstlink.db")utils.CheckErrorPanic(err)fmt.Println(db)db.Exec(`CREATE TABLE userinfo (work_id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(64) NULL,departname VARCHAR(64) NULL,created DATE NULL)`)tx, err := db.Begin()defer func() {tx.Commit()}()utils.CheckErrorPanic(err)//stmt, err := tx.Prepare("INSERT INTO userinfo(name, departname, created) values(?, ?, ?);")//utils.CheckErrorPanic(err)////_, err = stmt.Exec("我", "爬蟲", "2015-12-15")//_, err = stmt.Exec("你", "客服", "2015-12-16")//utils.CheckErrorPanic(err)rows, err := tx.Query("SELECT work_id, name, created FROM userinfo")utils.CheckErrorPanic(err)type Record struct {Name    string    `sql:"name"`WorkID  int       `sql:"work_id"`Created time.Time `sql:"created"`}for rows.Next() {record := Record{}utils.CheckErrorPanic(ToStruct(rows, &record))fmt.Println(record.WorkID, record.Name, record.Created)}}

輸出:

&{0xc42000c3e0 /tmp/firstlink.db 0 {0 0} [] map[] 0 0 0xc4200ee060 false map[] map[] 0 0 0 <nil>}1 我 2015-12-15 00:00:00 +0000 UTC2 你 2015-12-16 00:00:00 +0000 UTC