j2ddlmZdedeeeffdZdS)) query_onezjhmreturnc,d}d}d}t|d|i}|rdddifSt|d|i}|rddd ifSt|d|i}|rA|d pd }d |vsd |vsd|vrdd|dddfSdd|dddfSdddifS)NzZ SELECT zjhm, xm FROM "ywdata"."b_per_qscxwcnr" WHERE zjhm = %(zjhm)s LIMIT 1 zZ SELECT zjhm, xm FROM "ywdata"."b_per_qslswcnr" WHERE zjhm = %(zjhm)s LIMIT 1 z` SELECT zjhm, xm, jxqk FROM "ywdata"."b_per_qskjwcnr" WHERE zjhm = %(zjhm)s LIMIT 1 rstatusdropout lostjxqku频繁u严重u长期 truant_frequent2)rr truantrnormal)rget)r dropout_sqllost_sql truant_sqlr r rr s F/home/longshao/multi-rider-rag/modules/score/services/dim_education.pycalc_education_scorersKHJ fd^44G)Hi((( X~ . .D &Hf%%% zFD> 2 2F :zz&!!'R t  x4//8t3C3C"3T#2#YGGG GXtCRCy9999 x" ""N)shared.db.kingbaserstrtupleintdictrrrr!sL((((((#s#uS$Y'7######r