package main
import (
"database/sql"
"fmt"
"github.com/jinzhu/gorm"
_ "github.com/go-sql-driver/mysql"
"time"
)
type UserInfo struct {
gorm.Model
//ID uint
Name sql.NullString `gorm:"type:varchar(30);default:‘denny‘"`
Age sql.NullFloat64
Birthday *time.Time
Email string `gorm:"type:varchar(100);unique_index"`
Address string `gorm:"index:idx_addr";not null`
Gender string `gorm:"size:255;default:‘nnn‘"`
Hobby string `gorm:"column:kike"`
IgnoreMe int `gorm:"-"`
}
func main() {
db, err := gorm.Open("mysql", "root:root@tcp(127.0.0.1:3306)/ytap?charset=utf8")
if err != nil {
panic(err)
}
defer db.Close()
gorm.DefaultTableNameHandler = func (db *gorm.DB, defaultTableName string) string {
return "mm_" + defaultTableName
}
db.AutoMigrate(&UserInfo{})
u1 := UserInfo{ Hobby:"sss22222ss"}
fmt.Println(db.NewRecord(&u1))
db.Create(u1)
//var u UserInfo
//db.First(&u)
//fmt.Printf("u:%#v\n",u)
//fmt.Println(u.Hobby)
//db.Model(&u).Update("Gender","男")
//db.Delete(&u)
//db.Table("xxxx").CreateTable(&UserInfo{})
}
原文:https://www.cnblogs.com/dennylau/p/13300519.html