go gorm gen根据数据库生成model

最新推荐文章于 2024-10-08 17:39:57 发布

那云上纸鸢

最新推荐文章于 2024-10-08 17:39:57 发布

阅读量167

点赞数 2

文章标签：数据库 golang sql

本文链接：https://blog.csdn.net/So_cute_girl/article/details/141815422

版权

下载
go get gorm.io/gen

// 定义查询
type IUserMethod interface{
	// where("open_id=@openId and seat=@seat")
	FindByOpenIDAndSeat(openId string, seat int32) (gen.T, error)

	//select count(*) from @@table where open_id=@openId
	GetCountByOpenID(openId string) (int32, error)
}

main

const dsn = "root:pwd123@tcp(127.0.0.1:3306)/db?charset=utf8mb4&parseTime=True&loc=Local"

func main(){
	g := gen.NewGenerator(gen.Config{
		OutPath:      "./dal/query",
		ModelPkgPath: "./dal/model",
		Mode:         gen.WithDefaultQuery | gen.WithQueryInterface,
	})

	db, _ := gorm.Open(mysql.Open(dsn))
	g.UseDB(db)

	userModel := g.GenerateModelAs("tb_user_seat", "UserSeat") // model生成
	g.ApplyInterface(func(IUserMethod ) {}, userModel)

	//g.GenerateAllTable()

	g.Execute()
}