golang orm操作mysql数据库

orm 中文文档地址：

​​go-orm中文文档​​

step1，下载gorm库:

go get -v github.com/jinzhu/gorm

step2，编写测试代码：

package main

import (
  "fmt"

  "github.com/jinzhu/gorm"
  _ "github.com/jinzhu/gorm/dialects/mysql"
)

//
type uid struct {
  ID          int64  `json:"id"  xorm:"int pk autoincr 'id'"`
  BusinessID  string `json:"BusinesId" xorm:"varchar(128) 'business_id'"`
  MaxID       int    `json:"MaxId" xorm:"bigint(20) 'max_id'"`
  Step        int    `json:"Step" xorm:"int 'step'"`
  Description string `json:"Description" xorm:"varchar(128) 'description'"`
}

// db parameter
const (
  USERNAME = "root"
  PASSWORD = "123456"
  HOST     = "192.168.1.28"
  PORT     = 3306
  DBNAME   = "test"
  TIMEOUT  = "10s"
)

func main() {
  dsn := fmt.Sprintf("%s:%s@tcp(%s:%d)/%s?charset=utf8&parseTime=True&loc=Local&timeout=%s", USERNAME, PASSWORD, HOST, PORT, DBNAME, TIMEOUT)
  db, err := gorm.Open("mysql", dsn)
  if err != nil {
    err = db.DB().Ping()
    if err != nil {
      fmt.Println("ping db failed!")
    }
    panic("连接数据库失败")
  }
  defer db.Close()

  // 自动迁移模式
  db.AutoMigrate(&uid{})

  // 创建
  db.Create(&uid{
    BusinessID:  "0123456789abcdefghijklmn",
    MaxID:       40000,
    Step:        1,
    Description: "orm"},
  )

  // 读取
  var uid []*uid
  db.First(&uid, 1)
  for _, v := range uid {
    fmt.Println(v)
  }
  db.Find(&uid, "max_id = ?", 1100)
  for _, v := range uid {
    fmt.Println(v)
  }

  // 更新 - 更新uid的price为1100
  db.Model(&uid).Update("max_id", 1100)

  // 删除 - 删除product
  //db.Delete(&uid)
}

step3，在vscode 终端进入main.go所在目录，执行编译命令

go mod init test
go get vendor
go build
./test.exe

step4，在linux mysql服务器查看执行结果：

mysql> select * from uids;
+----+--------------------------+--------+------+-------------+
| id | business_id              | max_id | step | description |
+----+--------------------------+--------+------+-------------+
| 18 | 0123456789abcdefghijklmn |   1100 |    1 | orm         |
| 19 | 0123456789abcdefghijklmn |   1100 |    1 | orm         |
| 20 | 0123456789abcdefghijklmn |   1100 |    1 | orm         |
+----+--------------------------+--------+------+-------------+
3 rows in set (0.01 sec)

mysql>