使用beego原生sql操作数据库的例子

//用户获取礼包码
//@params gameid int 游戏的gameid
//@params userid string 用户的uid
func (u *GiftController) Get() {
	gameid := u.GetString(":gameid")
	userid := u.GetString(":userid")
	//首先查询是否已经分配，如果
	var gift models.Gift
	o := orm.NewOrm()
	err := o.Raw("select * from union_gift where game_id =? and userid=? limit 1", gameid,userid).QueryRow(&gift)
	if err != nil {
		//查找一个，并且惊醒存储
		err := o.Raw("select * from union_gift where game_id =? and userid='' limit 1", gameid).QueryRow(&gift)
		if err != nil {
			u.Data["json"] = map[string]interface{}{"status": 404,"msg":"服务器错误，无法获取礼包码"}
			u.ServeJSON()
		} else {
			gift.Userid = userid
			gift.Updated_at = time.Now()
			gift.State = 1
			o.Update(&gift, "Userid","Updated_at","State")
			u.Data["json"] = map[string]interface{}{"status": 0,"msg":"用户获取礼包码成功","data":gift}
			u.ServeJSON()
		}
	} else {
		//已经查到
		u.Data["json"] = map[string]interface{}{"status": 100,"msg":"已经分配过礼包码","data":gift}
		u.ServeJSON()
	}
}