beego orm sql语句

最近遇到了一些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"]
		}