go-grom实现增删改查-蒲公英云

go-grom实现增删改查

package test
import (
    "database/sql"
    "errors"
    "fmt"
    "time"
    "wang/gorm_learn/config"
    "gorm.io/gorm"
)
type Model struct {
    UUIID uint      `gorm:"primaryKey"`
    Time  time.Time `gorm:"column:my_time"` //指定 db 列名
}
type User struct {
    Model        Model  `gorm:"embedded;embeddedPrefix:in_"`
    Name         string `gorm:"default:张三"`
    Email        string `gorm:"not null"`
    Age          uint8
    Birthday     *time.Time
    MemberNumber sql.NullString
    ActivatedAt  sql.NullTime
}
type res struct { //返回结果结构体
    Name string
    Age  uint8
}
func TestCreate() {
    db := config.Init()
    err := db.AutoMigrate(&User{})
    if err != nil {
        print(err)
        return
    }
}
func AddUserTest() {
    //create := config.Init().Create(&User{Name: "测试", Email: "45654", Age: 24})
    //create := config.Init().Select("name","email").Create(&User{Name: "测试", Email: "45654", Age: 24})//只创建name和email
    create := config.Init().Omit("age").Create(&[]User{
   {Name: "测试", Email: "45654", Age: 24}}) //除了age之外全部创建
    //print(create.Error)//是否报错
    if create.Error != nil {
        print(create.Error)
    }
    print(create.RowsAffected) //影响行数
    if create.RowsAffected != 0 {
        fmt.Printf("数据插入成功")
    }
}
func FindUserTest() {
    //result:=map[string] interface{}{}
    user := new([]User)
    //res:=new([]res)
    var res []res
    //config.Init().M
    //odel(&User{}).First(&result)//方式1
    //tx := config.Init().Where("name","测试1").Model(&User{}).First(&user) //方式2
    //tx := config.Init().Where(User{Name: "测试1"}).Model(&User{}).First(&user) //方式3
    //tx := config.Init().Where(map[string]interface{}{
    //    "name":"测试1",
    //}).Model(&User{}).First(&user) //方式4
    //tx := config.Init().Where("name =? and age =?","测试1",24).Or("email =?","1").First(&user) //方式5
    //tx := config.Init().First(&user,"name =?","测试1") //方式6
    //tx := config.Init().First(&user, map[string]interface{}{"name":"测试1"}) //方式6
    //tx := config.Init().Find(&user, map[string]interface{}{"age":"24"}) //方式6
    //tx := config.Init().Where("age =?",24).Find(&user) //方式7
    //tx := config.Init().Where("age like ?","%2%").Find(&user) //方式7
    //tx := config.Init().Select("name").Where("age like ?","%2%").Find(&user) //方式8
    //tx := config.Init().Omit("name").Where("age like ?","%2%").Find(&user) //方式8
    tx := config.Init().Model(&user).Omit("name").Where("age like ?", "%2%").Find(&res) //方式9，智能选择字段
    fmt.Println(errors.Is(tx.Error, gorm.ErrRecordNotFound)) //判断是否查询到记录,
    // 判断first是否查询成功
    fmt.Println(res)
    //config.Init().Model(&User{}).Take(&user)
    //fmt.Println(user)
    //config.Init().Model(&User{}).Last(&user)
    //fmt.Println(user)
}
func UpdateUserTest() {
    //update只更新你选择的字段
    // updates 更新所有字段此时有两种形式一种为Map一 种 为结构体结构体零值不参与更新
    //save无论如何都更新 所有的内容包括值
    var user []User
    // config.Init().Model(user).Where("age like ?", "%2%").Update("name", "111")
    // config.Init().First(&user).Updates(map[string]interface{}{"name": " ", "age": 0})
    config.Init().Find(&user).Updates(map[string]interface{}{"name": " ", "age": 0}) //批量更新
}
func DeleteUserTest() {
    var user []User
    // var res []res
    config.Init().Model(&user).Unscoped().Where("age = 20").Find(&user).Delete(&user) //删除
}