golang map to struct

http://stackoverflow.com/questions/26744873/converting-map-to-struct

func SetField(obj interface{}, name string, value interface{}) error {     structValue := reflect.ValueOf(obj).Elem()     structFieldValue := structValue.FieldByName(name)      if !structFieldValue.IsValid() {         return fmt.Errorf("No such field: %s in obj", name)     }      if !structFieldValue.CanSet() {         return fmt.Errorf("Cannot set %s field value", name)     }      structFieldType := structFieldValue.Type()     val := reflect.ValueOf(value)     if structFieldType != val.Type() {         return errors.New("Provided value type didn't match obj field type")     }      structFieldValue.Set(val)     return nil }  type MyStruct struct {     Name string     Age  int64 }  func (s *MyStruct) FillStruct(m map[string]interface{}) error {     for k, v := range m {         err := SetField(s, k, v)         if err != nil {             return err         }     }     return nil }  func main() {     myData := make(map[string]interface{})     myData["Name"] = "Tony"     myData["Age"] = int64(23)      result := &MyStruct{}     err := result.FillStruct(myData)     if err != nil {         fmt.Println(err)     }     fmt.Println(result) }

从mysql的结果到某个struct

type operConf struct {     Id                 uint32 `sql:"oper_id"`     Name               string `sql:"oper_name"`     MsgRetyTimes       uint32 `sql:"msg_retry_times"`     MsgRetyInterval    uint32 `sql:"msg_retry_interval"`     HeartBeartInterval uint32 `sql:"heartbeat_interval"`     OfflineDetectTime  uint32 `sql:"offline_detect_time"` }  func GetOperConf() ([]operConf, error) {     host := GetConf().MySql.Host     port := GetConf().MySql.Port     user := GetConf().MySql.User     password := GetConf().MySql.Pwd     dbName := GetConf().MySql.Db     table := GetConf().MySql.Table      sql := new(mysql)     defer sql.Close()     if err := sql.Connect(host, port, user, password, dbName, table); err != nil {         logger.DEBUG(LOG_NAME, "slq.Connect err:%s", err.Error())         return nil, err     }      sqlStr := "SELECT oper_id, oper_name, msg_retry_times, msg_retry_interval, heartbeat_interval, offline_detect_time"     sqlStr += " From " + table      result, err := sql.Query(sqlStr)     if err != nil {         return nil, err     }     confArr := make([]operConf, len(result))     for i, v := range result {         oc := new(operConf)         DataToStruct(v, oc)         logger.DEBUG(LOG_NAME, "oc:%+v", oc)         confArr[i] = *oc      }     return nil, nil  }  type mysql struct {     m_db *sql.DB }  func (this *mysql) Connect(host string, port int, user, password, dbName, table string) error {     dsn := fmt.Sprintf("%s:%s@tcp(%s:%d)/%s?charset=utf8",         user, password, host, port, dbName)      var err error     this.m_db, err = sql.Open("mysql", dsn)     if err != nil {         fmt.Println("error: %s\n", err.Error())         return err     }     err = this.m_db.Ping()     if err != nil {         this.m_db.Close()     }     return err }  func (this *mysql) Close() {     this.m_db.Close() }  func (this *mysql) Query(sql string) (map[int]map[string]string, error) {     if this.m_db == nil {         return nil, errors.New("mysql not connect")     }     var query = strings.TrimSpace(sql)     s, err := regexp.MatchString(`(?i)^select`, query) //(?i) igonre upper/lower case      if err != nil {         return nil, err     }     if s == false {         return nil, errors.New("not select sql")     }      rows, _ := this.m_db.Query(sql)     c, err := this.GetQueryResult(rows)     return c, err }  func (this *mysql) GetQueryResult(rows *sql.Rows) (map[int]map[string]string, error) {     var result = make(map[int]map[string]string)     columns, _ := rows.Columns()     values := make([]sql.RawBytes, len(columns))     scanArgs := make([]interface{}, len(values))     for i := range values {         scanArgs[i] = &values[i]     }      var n = 0     for rows.Next() {         result[n] = make(map[string]string)         err := rows.Scan(scanArgs...)          if err != nil {             return nil, err         }          for i, v := range values {             result[n][columns[i]] = string(v)         }         n++     }      logger.DEBUG(LOG_NAME, "Query Result:%+v", result)     return result, nil }  func DataToStruct(data map[string]string, out interface{}) {     ss := reflect.ValueOf(out).Elem()     for i := 0; i < ss.NumField(); i++ {         val := data[ss.Type().Field(i).Tag.Get("sql")]         name := ss.Type().Field(i).Name         logger.DEBUG(LOG_NAME, "tag:%s, tag value:%s, filed name:%s", ss.Type().Field(i).Tag.Get("sql"), val, name)         switch ss.Field(i).Kind() {         case reflect.String:             ss.FieldByName(name).SetString(val)         case reflect.Int, reflect.Int16, reflect.Int32, reflect.Int64:             i, err := strconv.Atoi(val)             //  fmt.Println("i:", i, name)             if err != nil {                 logger.ERROR(LOG_NAME, "can't not atoi:%v", val)                 continue             }             ss.FieldByName(name).SetInt(int64(i))         case reflect.Uint16, reflect.Uint32, reflect.Uint64:             i, err := strconv.Atoi(val)             //  fmt.Println("i:", i, name)             if err != nil {                 logger.ERROR(LOG_NAME, "can't not atoi:%v", val)                 continue             }             ss.FieldByName(name).SetUint(uint64(i))         case reflect.Float32, reflect.Float64:             f, err := strconv.ParseFloat(val, 64)             if err != nil {                 logger.ERROR(LOG_NAME, "can't not ParseFloat:%v", val)                 continue             }             ss.FieldByName(name).SetFloat(f)         default:             logger.ERROR(LOG_NAME, "unknown type:%+v", ss.Field(i).Kind())         }     }     return }