首页 > 其他 > 详细

gorm

时间:2020-07-14 19:51:27      阅读:85      评论:0      收藏:0      [点我收藏+]
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{})

}

gorm

原文:https://www.cnblogs.com/dennylau/p/13300519.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!