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

     1  package main
     2  
     3  import (
     4  	"github.com/gogf/gf/database/gdb"
     5  	"github.com/gogf/gf/frame/g"
     6  	"github.com/gogf/gf/os/glog"
     7  )
     8  
     9  func main() {
    10  	gdb.AddDefaultConfigNode(gdb.ConfigNode{
    11  		Host:    "127.0.0.1",
    12  		Port:    "3306",
    13  		User:    "root",
    14  		Pass:    "12345678",
    15  		Name:    "test",
    16  		Type:    "mysql",
    17  		Role:    "master",
    18  		Charset: "utf8",
    19  	})
    20  	db, err := gdb.New()
    21  	if err != nil {
    22  		panic(err)
    23  	}
    24  	//db.SetDebug(false)
    25  
    26  	glog.SetPath("/tmp")
    27  
    28  	// 执行3条SQL查询
    29  	for i := 1; i <= 3; i++ {
    30  		db.Table("user").Where("uid=?", i).One()
    31  	}
    32  	// 构造一条错误查询
    33  	db.Table("user").Where("no_such_field=?", "just_test").One()
    34  
    35  	db.Table("user").Data(g.Map{"name": "smith"}).Where("uid=?", 1).Save()
    36  
    37  }