在Revel中使用Gorm查询表

go get -u github.com/jinzhu/gorm

import "github.com/jinzhu/gorm"

db.driver = mysql
db.spec = username:password@tcp(hostname:port)/database_name?charset=utf8&parseTime=True&loc=Local

type User struct {
    gorm.Model
    Name  string
    Email string
}

func init() {
    db, err := gorm.Open("mysql", revel.Config.StringDefault("db.spec", ""))
    if err != nil {
        revel.AppLog.Errorf("Failed to connect database: %v", err)
        panic(err)
    }
    // 将数据库连接保存到Revel的上下文中，以便在控制器中使用
    revel.OnAppStart(func() {
        revel.AppLog.Info("Connected to database")
        revel.AppControllerType.Bind((*gorm.DB)(nil))
        revel.InterceptMethod((*GormController).Begin, revel.BEFORE)
        revel.InterceptMethod((*GormController).Commit, revel.AFTER)
        revel.InterceptMethod((*GormController).Rollback, revel.FINALLY)
    })
}

func (c GormController) FindUserByID(id int) revel.Result {
    var user User
    if err := c.Txn.First(&user, id).Error; err != nil {
        revel.AppLog.Errorf("Failed to find user: %v", err)
        return c.RenderError(err)
    }
    return c.RenderJSON(user)
}