golang修仙记之gorm（一）

学习了如何连接数据库、简单的错误处理、关闭数据库、创建表、创建表中的一条记录、读取表的记录、更新表的记录、删除标的记录

package main

import (
	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mysql"
	"time"
)

type User struct {
	gorm.Model
	Name     string
	Age      int
	Birthday time.Time
}

func main() {
	// connect the database
	db, err := gorm.Open("mysql", "user:password@tcp(ip:port)/database?charset=utf8&parseTime=True&loc=Local")

	// panic handle
	if err != nil {
		panic("failed to connect database")
	}

	// close the connection
	defer db.Close()

	// Migrate the schema
	db.AutoMigrate(&User{})

	// create user of table
	db.Create(&User{Name: "Jinzhu", Age: 19, Birthday: time.Now()})

	// read the user of table
	var user User
	db.First(&user, 1)
	db.First(&user, "Name = ?", "Jinzhu")

	//update
	db.Model(&user).Update("Name", "Michael")

	//delete
	db.Delete(&user)
}