golang orm

package main

import (
    "fmt"
    "github.com/astaxie/beego/orm"
    _"github.com/go-sql-driver/mysql"
)

type User struct{
    Id int
    Name string `orm:"size(100)"`
    Fuck string
    Admin int
}

func init() {
    // set default database
    orm.RegisterDataBase("default", "mysql", "root:root@tcp(127.0.0.1:3306)/fuck?charset=utf8", 30)

    // register model
    orm.RegisterModel(new(User))

    // create table
    orm.RunSyncdb("default", false, true)
}
func main() {
    o :=orm.NewOrm()

    user:=User{Name:"slene"}
    id,err :=o.Insert(&user)
    fmt.Printf("ID:%d,ERR:%v
",id,err)

    user.Name="astaxie"
    num,err:=o.Update(&user)
    fmt.Printf("NUM:%d,ERR:%v
",num,err)

    // read one
    u := User{Id: user.Id}
    err = o.Read(&u)
    fmt.Printf("ERR: %v
", err)

    fmt.Println("------------------")
    var maps []orm.Params
    num, err = o.Raw("SELECT * FROM user").Values(&maps)
    for _,term := range maps{
        fmt.Println(term["id"],":",term["name"],term["fuck"])
    }

    //// delete
    //num, err = o.Delete(&u)
    //fmt.Printf("NUM: %d, ERR: %v
", num, err)
}
原文地址:https://www.cnblogs.com/landv/p/10931733.html