最近遇到了一些beego sql查询问题。简单总结一下。
//sql定义
func Getall_by_term_teacher_id_department_des(term ,department string)(maps []orm.Params,err error ) {
o := orm.NewOrm()
o.Raw("SELECT * From assign_info ,workload_info ,teacher_info WHERE workload_info.Term=? AND workload_info.is_assigned=? AND workload_info.Is_assign_done=?AND workload_info.Auditing = ? AND assign_info.Workload_id = workload_info._id AND assign_info.To_teacher_id = teacher_info.Teacher_id AND teacher_info.Department_des=?",term,true,true,0,department).Values(&maps)
return maps,err
}
//使用
as_infos,_:=models.Getall_by_term_teacher_id_department_des(utils.Term_year(),d_info[0].Department)
for _,each:=range as_infos{
if len(each["to_teacher_id"].(string))==0{
gather[each["to_teacher_id"].(string)] = dic
gather[each["to_teacher_id"].(string)]["teacher_name"] = each["to_teacher_name"]
}