
    j2                     2    d dl mZ dedeeef         fdZdS )    )	query_onezjhmreturnc                 L   d}t          |d| i          }|sdddifS d}i }|                    d          pd}d|v sd	|v r|d
z  }d|d<   nd|v sd|v r
|dz  }d|d<   |                    d          pdt          fddD                       r
|dz  }|d<   |                    d          pd}|                    d          pd}|rd|v sd|v r|dz  }d|d<   nd|v r
|dz  }d|d<   t          |d          }||d <   |                    d!          pdd d"         |d!<   ||fS )#Nz
        SELECT
            qttsqk AS jtqk,
            knjtlx,
            etlb,
            NULL::VARCHAR AS fmsftswc,
            jhr1xm,
            jhr1lxdh
        FROM "ywdata"."b_per_qskjwcnr"
        WHERE zjhm = %(zjhm)s
        LIMIT 1
    r   r   sourceno_datafmsftswc u   双方u	   父母均   bothparents_outu   外出u   务工   oneknjtlxc              3       K   | ]}|v V  	d S )N ).0kr   s     C/home/longshao/multi-rider-rag/modules/score/services/dim_family.py	<genexpr>z$calc_family_score.<locals>.<genexpr>!   s'      
?
?11;
?
?
?
?
?
?    )u   低保u   边缘u   困难povertyjhr1xmetlbu   孤儿u   困境
   Tguardian_missingu   留守   left_behind   	raw_scorejtqkd   )r   getanymin)	r   sqlrowscoredetailr	   r   r   r   s	           @r   calc_family_scorer*      s   C C&$
(
(C (8Y'''EFwwz""(bH8{h66
 &}	X		X!5!5
 %}WWX$"F

?
?
?
? >
?
?
??? #
"yWWX$"F776?? bD %X%%T)9)9%)!""	T		
 $}rNNEF;ggfoo+TcT2F6N&=r   N)shared.db.kingbaser   strtupleintdictr*   r   r   r   <module>r0      sL    ( ( ( ( ( (.C .E#t)$4 . . . . . .r   