4.3 调用Gorm

4.3.1 简介

4.3.2 配置

Gorm配置说明4.3 调用Gorm - 图1 (opens new window)

  1. [jupiter.mysql.test]
  2.    connMaxLifetime = "300s"
  3.    debug = true
  4.    dsn = "root:test@tcp(127.0.0.1:3306)/test?charset=utf8&parseTime=True&loc=Local&readTimeout=1s&timeout=1s&writeTimeout=3s"
  5.    level = "panic"
  6.    maxIdleConns = 50
  7.    maxOpenConns = 100

4.3.3 用法

  1. type User struct {
  2.     Id   int    `gorm:"not null" json:"id"`
  3.     Name string `gorm:"not null" json:"name"`
  4. }
  6. func main() {
  7.     gormDB := gorm.StdConfig("test").Build()
  8.     models := []interface{}{
  9.         &User{},
  10.     }
  11.     gormDB.SingularTable(true)
  12.     gormDB.Set("gorm:table_options", "ENGINE=InnoDB").AutoMigrate(models...)
  13.     gormDB.Create(&User{
  14.         Name: "jupiter",
  15.     })
  17.     var user User
  18.     gormDB.Where("id = 1").Find(&user)
  19.     xlog.Info("user info",xlog.String("name",user.Name))
  20. }

运行指令go run main.go --config=config.toml，可以得到以下结果 image