GO语言基础之gorm操作mysql数据库表

package mysql

import (
	"fmt"
	"testing"
	"time"
)

type Like struct {
	ID        int       `gorm:"ID,primary_key"`
	Ip        string    `gorm:"IP,type:varchar(20);not null;index:ip_idx"`
	UserName  string    `gorm:"USER_NAME,type:varchar(256);not null;"`
	Title     string    `gorm:"TITLE,type:varchar(128);not null"`
	CreatedAt time.Time `gorm:"CREATED_AT"`
}

type base struct{}

func (Like) TableName() string {
	return "like"
}

func createTableGorm() {
	// 创建表
	db := sqlLocalClient()
	db.Migrator().CreateTable(&Like{})
}

func TestCreateTable(t *testing.T) {
	createTableGorm()
}

func dropColumn() {
	db := sqlLocalClient()
	// 删除字段 ip
	db.Migrator().DropColumn(&Like{}, "ip")
}

func renameColumn() {
	db := sqlLocalClient()
	// 修改字段名称
	db.Migrator().RenameColumn(&Like{}, "user_name", "name")
}

func hasColumn() {
	db := sqlLocalClient()
	// 检查字段是否存在
	user_name := db.Migrator().HasColumn(&Like{}, "user_name")
	name := db.Migrator().HasColumn(&Like{}, "name")
	fmt.Printf("user_name: %+v,name:%+v\n", user_name, name)
}

func hasTable() {
	db := sqlLocalClient()
	// 检查表是否存在
	like := db.Migrator().HasTable(&Like{})
	base := db.Migrator().HasTable(&base{})
	fmt.Printf("like: %+v \t base: %+v\n", like, base)
}

func renameTable() {
	db := sqlLocalClient()
	// 修改表名
	db.Migrator().RenameTable("like", "info")
}

func deleteTable() {
	db := sqlLocalClient()
	// 删除表
	db.Migrator().DropTable(&Like{})
}