package main

import (

    "fmt"

    "github.com/jinzhu/gorm"

    _ "github.com/jinzhu/gorm/dialects/sqlite"

)

type Product struct {

    Id  int

    Num int

}

func main() {

    db, err := gorm.Open("sqlite3", "/root/test.db")

    if err != nil {

        fmt.Println("连接数据库失败")

    }

    defer db.Close()

    // 自动迁移模式

    db.AutoMigrate(&Product{})

    // 创建

    test := Product{Id: , Num: }

    db.Create(&test)

    fmt.Println("test.id is ", test.Id)

    // 读取

    var product Product

    // 询id为1的product

    db.First(&product, )

    fmt.Println("product.id is ", product.Id)

    // 询code为l1212的product

    db.First(&product, "Num = ?", )

    fmt.Println("product.num is ", product.Num)

    // 更新 - 更新product的price为2000

    db.Model(&product).Update("Num", )

    var tests []Product

    db.Find(&tests)

    fmt.Println("Find tests: ", tests)

    for index, line := range tests {

        fmt.Println("index", index, " line ", line)

    }

    // 删除 - 删除product

    db.Delete(&product)

}

[root@wangjq test]# go run gorm_v1.go

test.id is

product.id is

product.num is

Find tests:  [{ }]

index   line  { }