目的:将SQLalchemy查询的多个值去重后拼接
过程:
#导包
from sqlalchemy import and_, distinct
from sqlalchemy import func
from sqlalchemy import or_
# 多表查询
bindusers = session.query(Userinfo.UserID, Userinfo.UserNo,Userinfo.UserName,
Userinfo.Sex, Userinfo.EntryTime,
Userinfo.DeptID, Userinfo.JobID, Dept.DeptName,
Userinfo.UserStatus, Userinfo.Photo,
Job.JobName, Userbind.PrivilegeLevel,
#将查询的值先 去重(distinct)后 拼接(group_concat),在SQLalchemy中使用方法要先使用func
func.group_concat(distinct(Cardinfo.CardNumber)), Cardinfo.CardType,
Cardtype.Content).filter(Userinfo.DeptID ==
Dept.DeptID)