GORM 数据库

连接

go

dsn := "user:pass@tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True"
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})

模型定义

go

type User struct {
    gorm.Model
    Name  string `gorm:"size:100;not null"`
    Email string `gorm:"size:200;uniqueIndex"`
}

CRUD

go

// 创建
db.Create(&User{Name: "YC", Email: "yc@example.com"})

// 查询
var user User
db.First(&user, 1)
db.Where("name = ?", "YC").First(&user)

// 更新
db.Model(&user).Update("Name", "NewName")

// 删除
db.Delete(&user)