beego orm

A powerful orm framework for go.

It is heavily influenced by Django ORM, SQLAlchemy.

Support Database:

• MySQL: github.com/go-sql-driver/mysql
• PostgreSQL: github.com/lib/pq
• Sqlite3: github.com/mattn/go-sqlite3

Passed all test, but need more feedback.

Features:

• full go type support
• easy for usage, simple CRUD operation
• auto join with relation table
• cross DataBase compatible query
• Raw SQL query / mapper without orm model
• full test keep stable and strong

more features please read the docs

Install:

go get github.com/astaxie/beego/orm

Changelog

• 2013-08-19: support table auto create
• 2013-08-13: update test for database types
• 2013-08-13: go type support, such as int8, uint8, byte, rune
• 2013-08-13: date / datetime timezone support very well

Quick Start

Simple Usage

package main

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

// Model Struct
type User struct {
    Id   int    `orm:"auto"`
    Name string `orm:"size(100)"`
}

func init() {
    // register model
    orm.RegisterModel(new(User))

    // set default database
    orm.RegisterDataBase("default", "mysql", "root:root@/my_db?charset=utf8", 30)

    // create table
    orm.RunSyncdb("default", false, true)   
}

func main() {
    o := orm.NewOrm()

    user := User{Name: "slene"}

    // insert
    id, err := o.Insert(&user)

    // update
    user.Name = "astaxie"
    num, err := o.Update(&user)

    // read one
    u := User{Id: user.Id}
    err = o.Read(&u)

    // delete
    num, err = o.Delete(&u) 
}

Next with relation

type Post struct {
    Id    int    `orm:"auto"`
    Title string `orm:"size(100)"`
    User  *User  `orm:"rel(fk)"`
}

var posts []*Post
qs := o.QueryTable("post")
num, err := qs.Filter("User__Name", "slene").All(&posts)

Use Raw sql

If you don't like ORM，use Raw SQL to query / mapping without ORM setting

var maps []Params
num, err := o.Raw("SELECT id FROM user WHERE name = ?", "slene").Values(&maps)
if num > 0 {
    fmt.Println(maps[0]["id"])
}

Transaction

o.Begin()
...
user := User{Name: "slene"}
id, err := o.Insert(&user)
if err == nil {
    o.Commit()
} else {
    o.Rollback()
}

Debug Log Queries

In development env, you can simple use

func main() {
    orm.Debug = true
...

enable log queries.

output include all queries, such as exec / prepare / transaction.

like this:

[ORM] - 2013-08-09 13:18:16 - [Queries/default] - [    db.Exec /     0.4ms] - [INSERT INTO `user` (`name`) VALUES (?)] - `slene`
...

note: not recommend use this in product env.

Docs

more details and examples in docs and test

documents