首页 > 数据库技术 > 详细

golang 遍历查询beego数据库结果

时间:2019-12-11 15:31:53      阅读:331      评论:0      收藏:0      [点我收藏+]
func (m *DecemberPrize) PrizeList(virtual int) ([]orm.Params, error) {
	o := orm.NewOrm()
	var maps []orm.Params
	if virtual == 1 {
		sql := "SELECT id,low_index,name,image,weight,num,virtual,if_reserve,stock,`left`,`top` FROM " + m.TableName() + " WHERE virtual=? and num>0 AND status=1 ORDER BY weight asc"

		_, e := o.Raw(sql, virtual).Values(&maps)
		return maps, e
	} else {
		sql := "SELECT id,low_index,name,image,weight,num,virtual,if_reserve,stock,`left`,`top` FROM " + m.TableName() + " WHERE virtual=? and num>0 AND status=1 ORDER BY weight asc"

		_, e := o.Raw(sql, virtual).Values(&maps)
		return maps, e
	}

}

 

 

for k, v := range params {
   s := v["weight"].(string)
    //fmt.Println("sss          ",s)

    //vWeight, _ := strconv.ParseInt(s, 10, 64)
    vWeight, _ := strconv.ParseFloat(s, 64)
    //fmt.Println(vWeight)
    params[k]["weight"] = vWeight * 10000
    //if($v->num == 0) $radio += $v->weight;
    num1 := v["num"].(string)
    num, _ := strconv.Atoi(num1)
    if num <= 0 {
      ratio += float64(vWeight)
    }

}

 

golang 遍历查询beego数据库结果

原文:https://www.cnblogs.com/shijiu520/p/12022661.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!