go-xorm / website Goto Github PK

数据库为sqlserver 2012
相关包 code.google.com/p/odbc
struct example：

type Group struct {
Id int64
Title string
}

使用xorm同步表结构
使用xorm插入数据：

group := new(Group)
            if _, err := engine.Insert(group); err != nil {
                panic(err)
            }
            log.Println("groupId:", group.Id)

打印的groupId永远为0.
查看数据库数据id为自增状态！

问题：
DbEngine.Join("INNER", "device_app", "device.sn=device_app.sn").
Join("INNER", "app", "app.id=device_app.app_id").
Desc("app.id").Limit(limit, start).Find(&devs, orm.Device{Sn: req.Sn})
打印出来的语句：
SELECT * FROM device INNER JOIN device_app ON device.sn=device_app.sn INNER JOIN app ON app.id=device_app.app_id ORDER BY app.id DESC LIMIT 1 OFFSET 1