一. 安装gen tool
go install gorm.io/gen/tools/gentool@latest
二. 生成go文件
gentool -dsn "user:pwd@tcp(localhost:3306)/database?charset=utf8mb4&parseTime=True&loc=Local" -tables "orders,doctor"gentool -c "./gen.yml"
gen.yml文件:
version: "0.1"
database:# consult[https://gorm.io/docs/connecting_to_the_database.html]"dsn : "username:password@tcp(address:port)/db?charset=utf8mb4&parseTime=true&loc=Local"# input mysql or postgres or sqlite or sqlserver. consult[https://gorm.io/docs/connecting_to_the_database.html]db : "mysql"# enter the required data table or leave it blank.You can input : orders,users,goodstables : "user"# specify a directory for outputoutPath : "./dao/query"# query code file name, default: gen.gooutFile : ""# generate unit test for query codewithUnitTest : false# generated model code's package namemodelPkgName : ""# generate with pointer when field is nullablefieldNullable : false# generate field with gorm index tagfieldWithIndexTag : false# generate field with gorm column type tagfieldWithTypeTag : falseonlyModel: true