github.com/gogf/gf@v1.16.9/.example/database/gdb/mysql/gdb_update_field.go (about)

     1  package main
     2  
     3  import (
     4  	"database/sql"
     5  
     6  	"github.com/gogf/gf/os/gfile"
     7  
     8  	"github.com/gogf/gf/encoding/gjson"
     9  	"github.com/gogf/gf/frame/g"
    10  )
    11  
    12  func main() {
    13  	db := g.DB()
    14  	table := "medicine_clinics_upload_yinchuan"
    15  	list, err := db.Table(table).All()
    16  	if err != nil && err != sql.ErrNoRows {
    17  		panic(err)
    18  	}
    19  	content := ""
    20  	for _, item := range list {
    21  		if j, err := gjson.DecodeToJson(item["upload_data"].String()); err != nil {
    22  			panic(err)
    23  		} else {
    24  			s, _ := j.ToJsonIndentString()
    25  			content += item["id"].String() + "\t" + item["medicine_clinic_id"].String() + "\t"
    26  			content += s
    27  			content += "\n\n"
    28  			//if _, err := db.Table(table).Data("data_decode", s).Where("id", item["id"].Int()).Update(); err != nil {
    29  			//	panic(err)
    30  			//}
    31  		}
    32  	}
    33  	gfile.PutContents("/Users/john/Temp/medicine_clinics_upload_yinchuan.txt", content)
    34  }