beego orm sql语句_cumthxy的博客_beego 打印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
}//sql定义
func Get