GO语言基础之gorm操作MySQL删除数据

package mysql

import (
	"fmt"
	"testing"
	"time"

	"gorm.io/driver/mysql"
	"gorm.io/gorm"
	"gorm.io/gorm/logger"
)

type Userinfo struct {
	UserId    uint32    `gorm:"column:USER_ID;PRIMARY_KEY"`
	UserName  string    `gorm:"column:USER_NAME"`
	LoginDate time.Time `gorm:"column:LOGIN_DATE"`
	ClientVar string    `gorm:"column:CLIENT_VER"`
}

func (Userinfo) TableName() string {
	return "userinfo"
}

func deleteUserById() {
	// 根据ID删除数据
	db := sqlLocalClient()
	ub := &Userinfo{}
	err := db.First(&ub).Error // 根据主键排序查出一条数据
	if err != nil {
		panic(err)
	}
	fmt.Printf("userinfo: %+v", ub)
	err = db.Model(&Userinfo{}).Delete("USER_ID = ?", ub.UserId).Error
	if err != nil {
		panic(err)
	}
}

func TestDelete(t *testing.T) {
	deleteUserById()
}

func deleteUserById() {
	// 根据ID删除数据
	db := sqlLocalClient()
	ub := &Userinfo{}
	err := db.First(&ub).Error // 根据主键排序查出一条数据
	if err != nil {
		panic(err)
	}
	fmt.Printf("userinfo: %+v", ub)
	err = db.Model(&Userinfo{}).Delete("USER_ID = ?", ub.UserId).Error
	if err != nil {
		panic(err)
	}
}