例1: 在数据库中创建一个表,然后添加一条数据
代码如下:
package main
import (
"context"
"fmt"
"git.byted.org/ee/gopkg/mysql"
)
type User struct {
Id string `gorm:"column:id"`
Name string `gorm:"column:name"`
Address string `gorm:"column:address"`
}
func main(){
dsn := "{{user}}:{{password}}?@tcp(127.0.0.1:3306)/test11?allowNativePasswords=true&charset=utf8mb4&parseTime=True&loc=Local&readTimeout=500ms"
db,_ := mysql.GetConn(dsn)
var user = User{
Name : "haha",
Address : "hehehe",
}
ctx := context.Background()
err := db.Context(ctx).Create(&user).Error
if err != nil {
fmt.Println("添加user失败")
}
}
结果:
添加成功