gorm

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{})

}