a
    •˜ëj§× ã                   @  sÂ  d Z ddlmZ ddlZddlZddlmZ ddlmZ ddlmZ ddlm	Z	 ddlm
Z
 dd	lmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlmZ d
dlm Z  d
dl!m"Z" d
dl!m#Z# d
dl!m$Z$ d
dl!m%Z% d
d lm&Z& d
d!lm'Z' d
d"l(m)Z) d
d#l*m+Z+ d
d$l,m-Z- d
d%lm.Z. d
d&lm/Z/ d'd(lm0Z0 d'dlmZ1 d'd)lm2Z2 d'd*lm3Z3 d'd+lm4Z4 d'dlmZ d'dl4mZ5 d'd,l4m6Z6 d'd-l7m8Z8 d'd.l7m9Z9 d'd/l:m;Z; e
�rfd
d0l<m=Z= d
d1lm>Z> d'd2l?m@Z@ dZAdfd4d5„ZBejCjDd3d3d6�G d7d8„ d8e&ƒƒZEe3jFejCjDd9d3d6�G d:d;„ d;e&ƒƒƒZGe3jFejCjDd9d<�G d=d>„ d>eGƒƒƒZHe3jFejCjDd9d9d?�ejCjDd9d9d9d@�ejCjDd9dA�G dBdC„ dCe&ƒƒƒƒƒZIG dDdE„ dEƒZJG dFdG„ dGe&ƒZKe3jFej>jDd9dA�G dHdI„ dIe&ƒƒƒZLe3jFej>jDdJdK�ej>jDddK�G dLdM„ dMeKƒƒƒƒZMe3jFej>jDd9dK�ej>jDdNdK�ej>jDdOdK�ej>jDdPdK�ej>jDdQdK�G dRdS„ dSeKejNe3jOƒƒƒƒƒƒƒZPG dTdU„ dUƒZQG dVdW„ dWeKƒZRej>jDdXdK�G dYdZ„ dZeRƒƒZSe3jFej>jDd[dK�G d\d]„ d]eRƒƒƒZTe3jFej>jDd^dK�ej>jDd3dK�G d_d`„ d`eKƒƒƒƒZUe3jFej>jDdadK�G dbdc„ dceRejNƒƒƒZVddde„ ZWdS )gzTsqlalchemy.orm.interfaces.LoaderStrategy
implementations, and related MapperOptions.é    )ÚannotationsN)ÚAny)ÚDict)ÚOptional)ÚTuple)ÚTYPE_CHECKING)ÚUnioné   )Ú
attributes)Úexc)Ú
interfaces)Úloading)Úpath_registry)Ú
properties)Úquery)Úrelationships)Ú
unitofwork)Úutil)Ú_DEFER_FOR_STATE)Ú_RAISE_FOR_STATE)Ú_SET_DEFERRED_EXPIRED)ÚATTR_WAS_SET)ÚLoaderCallableStatus)ÚPASSIVE_OFF)ÚPassiveFlag)Ú_column_descriptions)ÚORMCompileState)ÚORMSelectCompileState)ÚQueryContext)ÚLoaderStrategy)ÚStrategizedProperty)Ú_state_session)ÚInstanceState)ÚLoad)Ú_none_only_set)ÚAliasedClassé   )Úevent)Úinspect)Úlog)Úsql)Úvisitors)ÚLABEL_STYLE_TABLENAME_PLUS_COL)ÚSelect)ÚLiteral)ÚMapper)ÚRelationshipProperty)ÚColumnElementFc	                   s"  g }
|o| j ‰|r"| jr"|
 t¡ | j| jjv rV| jj| j \‰‰|
 ‡‡fdd„¡ |rf|
 tj¡ |rŽ| j	‰ ˆ rŽ| j
rŽ|
 ‡ ‡fdd„¡ |jD ]ˆ}| |j | j¡u r”|j | j¡s”tj|j| jf| ˆ|||oâ| jpâ| jtju ||||| pö| j | jdœ|	¤Ž}|
D ]}||| ƒ �q
q”d S )Nc                   s   t j| |jˆ fi ˆ¤ŽS ©N)Úorm_utilZ_validator_eventsÚkey©ÚdescÚprop)ÚfnÚopts© úX/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/orm/strategies.pyÚ<lambda>c   s   ÿÿz%_register_attribute.<locals>.<lambda>c                   s   t  | ˆ ˆ¡S r2   )r
   Zbackref_listenersr5   )ÚbackrefÚuselistr:   r;   r<   q   s   ÿ)Zparent_tokenr>   Úcompare_functionÚ	useobjectZtrackparentÚtypecallableÚ	callable_Úactive_historyÚ
impl_classZsend_modified_eventsÚdoc)r>   Zsingle_parentÚappendÚsingle_parent_validatorr4   ÚparentZ
validatorsr   Ztrack_cascade_eventsZback_populatesZ_effective_sync_backrefZself_and_descendantsÚ_propsÚgetÚclass_managerZ_attr_has_implr
   Zregister_attribute_implÚclass_Ú	directionr   Z	ONETOMANYZviewonlyrE   )r7   Úmapperr@   r?   rA   rB   Zproxy_propertyrC   rD   ÚkwZlisten_hooksÚmr6   Úhookr:   )r=   r8   r9   r>   r;   Ú_register_attributeM   sZ    


ÿ
ÿ
ÿþþ
ïîrR   )Ú
instrumentÚdeferredc                      s6   e Zd ZdZdZ‡ fdd„Zd
dd„Zdd	„ Z‡  ZS )ÚUninstrumentedColumnLoaderz¶Represent a non-instrumented MapperProperty.

    The polymorphic_on argument of mapper() often results in this,
    if the argument is against the with_polymorphic selectable.

    ©Úcolumnsc                   s   t ƒ  ||¡ | jj| _d S r2   )ÚsuperÚ__init__Úparent_propertyrW   ©ÚselfrH   Ústrategy_key©Ú	__class__r:   r;   rY   ©   s    z#UninstrumentedColumnLoader.__init__Nc           	      K  s*   | j D ]}|r|j | }| ||¡ qd S r2   )rW   Ú_append_dedupe_col_collection)	r\   Úcompile_stateÚquery_entityÚpathÚloadoptÚadapterÚcolumn_collectionÚkwargsÚcr:   r:   r;   Úsetup_query­   s    


z&UninstrumentedColumnLoader.setup_queryc	           	      C  s   d S r2   r:   ©	r\   Úcontextrb   rc   rd   rN   Úresultre   Ú
populatorsr:   r:   r;   Úcreate_row_processor¼   s    z/UninstrumentedColumnLoader.create_row_processor)N)	Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ú	__slots__rY   ri   rn   Ú__classcell__r:   r:   r^   r;   rU   ž   s    ù
rU   Tc                      s>   e Zd ZdZdZ‡ fdd„Zddd„Zdd	„ Zd
d„ Z‡  Z	S )ÚColumnLoaderz8Provide loading behavior for a :class:`.ColumnProperty`.)rW   Úis_compositec                   s*   t ƒ  ||¡ | jj| _t| jdƒ| _d S )NÚcomposite_class)rX   rY   rZ   rW   Úhasattrrv   r[   r^   r:   r;   rY   Ñ   s    
zColumnLoader.__init__Fc	                 K  sv   | j D ]<}
|r6|r,| |
¡}
|
d u r6 d S n
|j |
 }
| |
|¡ q| j d }|rh|j | }|d u rhd S ||| j< d S ©Nr   )rW   Zadapt_check_presentr`   rZ   )r\   ra   rb   rc   rd   re   rf   Úmemoized_populatorsZcheck_for_adaptrg   rh   Úfetchr:   r:   r;   ri   Ö   s    




zColumnLoader.setup_queryc                 C  s`   d| _ | jd j}| jjpD| jd jpD|jd uoD|j |jd ¡| ju }t	| j|d|j
|d� d S )NTr   F)r@   r?   rC   )Úis_class_levelrW   ÚtyperZ   rC   Úprimary_keyZversion_id_colÚ_columntopropertyrJ   rR   Úcompare_values)r\   rN   ZcoltyperC   r:   r:   r;   Úinit_class_attribute÷   s"    
ÿ
ÿû
ûz!ColumnLoader.init_class_attributec	                 C  sZ   | j D ]:}	|r|j |	 }	| |	d¡}
|
r|d  | j|
f¡  qVq|d  | jdf¡ d S ©NFZquickÚexpireT)rW   Ú_getterrF   r4   )r\   rk   rb   rc   rd   rN   rl   re   rm   ÚcolÚgetterr:   r:   r;   rn     s    

z!ColumnLoader.create_row_processor)F)
ro   rp   rq   rr   rs   rY   ri   r�   rn   rt   r:   r:   r^   r;   ru   Ê   s    ÷
!ru   )Zquery_expressionc                      s4   e Zd Z‡ fdd„Zdd„ Zdd„ Zdd„ Z‡  ZS )	ÚExpressionColumnLoaderc                   s<   t ƒ  ||¡ t ¡  d ¡‰ t‡ fdd„| jjD ƒƒ| _d S )Nc                 3  s   | ]}|  ˆ ¡ V  qd S r2   )Úcompare©Ú.0rh   ©Únullr:   r;   Ú	<genexpr>0  s   z2ExpressionColumnLoader.__init__.<locals>.<genexpr>)	rX   rY   r*   rŒ   ÚlabelÚanyrZ   rW   Ú_have_default_expressionr[   r^   r‹   r;   rY   )  s
    ÿzExpressionColumnLoader.__init__c                 K  s„   d }	|r|j r|j }	n| jr$| jj}	|	d u r0d S |	D ]}
|rF|j|
 }
| |
|¡ q4|	d }|rv|j| }|d u rvd S ||| j< d S ry   )Ú_extra_criteriar�   rZ   rW   r`   )r\   ra   rb   rc   rd   re   rf   rz   rg   rW   rh   r{   r:   r:   r;   ri   4  s"    


z"ExpressionColumnLoader.setup_queryc	                 C  sh   |rd|j rd|j }	|	D ]:}
|r&|j|
 }
| |
d¡}|r|d  | j|f¡  qdq|d  | jdf¡ d S r‚   )r‘   rW   r„   rF   r4   )r\   rk   rb   rc   rd   rN   rl   re   rm   rW   r…   r†   r:   r:   r;   rn   Y  s    

z+ExpressionColumnLoader.create_row_processorc                 C  s(   d| _ t| j|d| jd jjdd� d S )NTFr   )r@   r?   Zaccepts_scalar_loader)r|   rR   rZ   rW   r}   r€   ©r\   rN   r:   r:   r;   r�   s  s    ûz+ExpressionColumnLoader.init_class_attribute)ro   rp   rq   rY   ri   rn   r�   rt   r:   r:   r^   r;   r‡   &  s   %r‡   )rT   rS   )rT   rS   Ú	raiseload)Z
do_nothingc                      sN   e Zd ZdZdZ‡ fdd„Zdd„ Zdd„ Zdd
d„Zdd„ Z	dd„ Z
‡  ZS )ÚDeferredColumnLoaderzAProvide loading behavior for a deferred :class:`.ColumnProperty`.)rW   Úgroupr“   c                   sJ   t ƒ  ||¡ t| jdƒr"tdƒ‚| j dd¡| _| jj| _| jj	| _	d S )Nrw   z8Deferred loading for composite types not implemented yetr“   F)
rX   rY   rx   rZ   ÚNotImplementedErrorÚstrategy_optsrJ   r“   rW   r•   r[   r^   r:   r;   rY   Š  s    ÿ
zDeferredColumnLoader.__init__c	           
   
   C  sŽ   |j rB|jjjrB| j|jjjv rB| j d¡ ||||||||¡ nH| jsv| j	rX| jj
}	n| jj}	|d  | j|	f¡ n|d  | jdf¡ d S )N©)rT   F©rS   TÚnewrƒ   F)Úrefresh_stater   Ú_compile_optionsÚ_only_load_propsr4   rZ   Ú_get_strategyrn   r|   r“   Z_raise_column_loaderZ_deferred_column_loaderrF   )
r\   rk   rb   rc   rd   rN   rl   re   rm   Zset_deferred_for_local_stater:   r:   r;   rn   ”  s4    ÿþýÿöÿÿz)DeferredColumnLoader.create_row_processorc                 C  s,   d| _ t| j|d| jd jj| jdd� d S )NTFr   )r@   r?   rB   Zload_on_unexpire)r|   rR   rZ   rW   r}   r€   Ú_load_for_stater’   r:   r:   r;   r�   Ç  s    úz)DeferredColumnLoader.init_class_attributeNc	           
      K  s®   |j jr| jjsT|r(t| jƒ | jj¡sT|rF| j	rF|j
 d| j	 d¡sT|r|| j|v r|| j d¡j|||||||fi |	¤Ž n.| jrŽt|| j< n| js t|| j< n
t|| j< d S )Nzundefer_group_%sFr˜   )Úcompile_optionsZ_render_for_subqueryrZ   Z_renders_in_subqueriesÚsetrW   ÚintersectionrH   Z_should_undefer_in_wildcardr•   Ú
local_optsrJ   r4   rž   ri   r|   r   r“   r   r   )
r\   ra   rb   rc   rd   re   rf   rz   Zonly_load_propsrO   r:   r:   r;   ri   Ó  sP    þýú
ÿùôó
ÿòîîÿ÷
öz DeferredColumnLoader.setup_queryc                   s´   ˆj stjS |tj@ stjS ˆjj}ˆ jr@‡ fdd„|j	D ƒ}nˆ j g}‡fdd„|D ƒ}t
ˆƒ}|d u r„t dt ˆ¡ˆ j f ¡‚ˆ jr˜ˆ  ˆ|d¡ t ˆjˆt|ƒt¡ tjS )Nc                   s4   g | ],}t |tƒrt |jtƒr|jˆ jkr|j‘qS r:   )Ú
isinstancer    Ústrategyr”   r•   r4   )rŠ   Úp©r\   r:   r;   Ú
<listcomp>  s
   
üz8DeferredColumnLoader._load_for_state.<locals>.<listcomp>c                   s   g | ]}|ˆ j v r|‘qS r:   )Z
unmodified)rŠ   Úk)Ústater:   r;   r¨     ó    zfParent instance %s is not bound to a Session; deferred load operation of attribute '%s' cannot proceedÚraise)r4   r   Ú
ATTR_EMPTYr   ÚSQL_OKÚPASSIVE_NO_RESULTÚmanagerrN   r•   Ziterate_propertiesr!   Úorm_excÚDetachedInstanceErrorr3   Ú	state_strr“   Ú_invoke_raise_loadr   Zload_scalar_attributesr¡   r   r   )r\   rª   ÚpassiveÚlocalparentZtoloadr•   Úsessionr:   )r\   rª   r;   rŸ     s0    

þþÿÿz$DeferredColumnLoader._load_for_statec                 C  s   t  d| f ¡‚d S )Nz+'%s' is not available due to raiseload=True©Úsa_excÚInvalidRequestError©r\   rª   rµ   Úlazyr:   r:   r;   r´   .  s    ÿz'DeferredColumnLoader._invoke_raise_load)N)ro   rp   rq   rr   rs   rY   rn   r�   ri   rŸ   r´   rt   r:   r:   r^   r;   r”     s   
3 ÷
3(r”   c                   @  s0   e Zd ZdZddddœdd„Zejfdd	„Zd
S )ÚLoadDeferredColumnsz7serializable loader object used by DeferredColumnLoaderFÚstrÚbool©r4   r“   c                 C  s   || _ || _d S r2   rÀ   )r\   r4   r“   r:   r:   r;   rY   7  s    zLoadDeferredColumns.__init__c                 C  s>   | j }|jj}|j| }| jr$d}nd}| |¡}| ||¡S )N)©rT   Tr™   )r“   T)rÁ   r™   )r4   r°   rN   rI   r“   rž   rŸ   )r\   rª   rµ   r4   r¶   r7   r]   r¥   r:   r:   r;   Ú__call__;  s    

zLoadDeferredColumns.__call__N)F)ro   rp   rq   rr   rY   r
   r   rÂ   r:   r:   r:   r;   r½   4  s   r½   c                      s,   e Zd ZdZdZ‡ fdd„Zdd„ Z‡  ZS )ÚAbstractRelationshipLoaderz0LoaderStratgies which deal with related objects.)rN   Útargetr>   Úentityc                   s:   t ƒ  ||¡ | jj| _| jj| _| jj| _| jj| _d S r2   )rX   rY   rZ   rN   rÅ   rÄ   r>   r[   r^   r:   r;   rY   Q  s
    


z#AbstractRelationshipLoader.__init__c	           	   
   C  s    | j  d¡ ||||||||¡S )N))r¼   Ú	immediate)rZ   rž   rn   rj   r:   r:   r;   Ú#_immediateload_create_row_processorX  s    ÿöz>AbstractRelationshipLoader._immediateload_create_row_processor)ro   rp   rq   rr   rs   rY   rÇ   rt   r:   r:   r^   r;   rÃ   L  s   rÃ   c                   @  s   e Zd ZdZdS )ÚDoNothingLoaderzßRelationship loader that makes no change to the object's state.

    Compared to NoLoader, this loader does not initialize the
    collection/attribute to empty/none; the usual default LazyLoader will
    take effect.

    N)ro   rp   rq   rr   r:   r:   r:   r;   rÈ   q  s   rÈ   Znoload)r¼   c                   @  s$   e Zd ZdZdZdd„ Zdd„ ZdS )ÚNoLoaderzQProvide loading behavior for a :class:`.Relationship`
    with "lazy=None".

    r:   c                 C  s    d| _ t| j|d| jjd� d S )NT)r@   rA   )r|   rR   rZ   Úcollection_classr’   r:   r:   r;   r�   ˆ  s    üzNoLoader.init_class_attributec	           
        s$   ‡ fdd„}	|d   ˆ j|	f¡ d S )Nc                   s&   ˆ j rt | |ˆ j¡ n
d |ˆ j< d S r2   )r>   r
   Úinit_state_collectionr4   ©rª   Údict_Úrowr§   r:   r;   Úinvoke_no_load�  s    z5NoLoader.create_row_processor.<locals>.invoke_no_loadrš   )rF   r4   )
r\   rk   rb   rc   rd   rN   rl   re   rm   rÏ   r:   r§   r;   rn   ’  s    zNoLoader.create_row_processorN)ro   rp   rq   rr   rs   r�   rn   r:   r:   r:   r;   rÉ   }  s   
rÉ   Úselectr¬   Úraise_on_sqlZbaked_selectc                      s®   e Zd ZU dZdZded< ded< ded< ded< d	ed
< d	ddœ‡ fdd„Zdd„ Zdd„ Zdd„ Z	dd„ Z
ddddejfdd„Zdd„ Ze d¡dd„ ƒZd d!„ Z‡  ZS )"Ú
LazyLoaderztProvide loading behavior for a :class:`.Relationship`
    with "lazy=True", that is loads when first accessed.

    )Ú
_lazywhereÚ_rev_lazywhereZ_lazyload_reverse_optionÚ	_order_byÚuse_getÚis_aliased_classÚ_bind_to_colÚ_equated_columnsÚ_rev_bind_to_colÚ_rev_equated_columnsÚ_simple_lazy_clauseÚ_raise_alwaysÚ_raise_on_sqlzColumnElement[bool]rÓ   zDict[str, ColumnElement[Any]]rØ   rÔ   rÚ   zRelationshipProperty[Any]rZ   zTuple[Any, ...])rH   r]   c                   s8  t ƒ  ||¡ | jd dk| _| jd dk| _t| jƒj| _| jj	}| 
¡ \| _| _| _|j
dd�\| _| _| _| jjr”dd„ t | jj¡D ƒ| _nd | _| j d| | j¡ | j oÚ| j oÚ| jjd	 j| jdd
| jjd�| _| j�r4t| jƒD ]4}|| jjv rð| jj| D ]}| j| | j|< �qqð| j d| ¡ d S )Nr¼   r¬   rÑ   T)Zreverse_directionc                 S  s   g | ]}t  |d di¡‘qS )Ú
_orm_adaptT)Úsql_utilÚ_deep_annotate©rŠ   Úelemr:   r:   r;   r¨   â  s   ÿz'LazyLoader.__init__.<locals>.<listcomp>z%s lazy loading clause %sr   F©Zuse_proxiesZcompare_keysÚequivalentsz4%s will use Session.get() to optimize instance loads)rX   rY   r—   rÝ   rÞ   r(   rÅ   r×   rZ   Ú_join_conditionZcreate_lazy_clauserÓ   rØ   rÙ   rÔ   rÚ   rÛ   Úorder_byr   Úto_listrÕ   ÚloggerÚinfor>   Ú_get_clauserˆ   rN   Ú_equivalent_columnsrÖ   Úlist)r\   rH   r]   Zjoin_conditionr…   rh   r^   r:   r;   rY   Ë  sN    ü
üþ

ÿüýÿzLazyLoader.__init__c              	   C  sv   d| _ | jj}| jjr d}d}n4| jjtjus4| jsL|rBd}d}qTd}d}nd }}t| j|d| j	| jj
||d� d S )NTF)r@   rB   rA   rC   Ú_deferred_history)r|   rZ   Ú_legacy_inactive_history_stylerC   rM   r   Ú	MANYTOONErÖ   rR   rŸ   rÊ   )r\   rN   rï   rC   rî   r:   r:   r;   r�     s2    ÿÿþùzLazyLoader.init_class_attributec                   sd   t  | jddi¡}|| j }‰ g ‰dd„ }t |i d|i¡ ‡ ‡fdd„}t |i d|i¡}|ˆfS )Nrß   Tc                 S  s
   d| _ d S )NF)Úunique©Ú	bindparamr:   r:   r;   Úvisit_bindparam2  s    zFLazyLoader._memoized_attr__simple_lazy_clause.<locals>.visit_bindparamró   c                   sF   | j ˆ v r$ˆ | jˆ | j  d f¡ n| jd u rBˆ | jd | jf¡ d S r2   )Z_identifying_keyrF   r4   ÚcallableÚvaluerò   ©Zbind_to_colÚparamsr:   r;   rô   7  s    
ýÿ
)rà   rá   rÓ   rØ   r+   ÚtraverseZcloned_traverse)r\   Z	lazywhereÚ	criterionrô   r:   r÷   r;   Ú"_memoized_attr__simple_lazy_clause)  s    
ÿ
ÿz-LazyLoader._memoized_attr__simple_lazy_clausec                 C  s²   | j \}}|d u r(t |dd„ |D ƒ¡S | jj}| ¡ }t |¡}|tj	@ rV|tj	N }i }|D ]J\}	}
}|
d ur |r�|tj
@ r�| |||
|¡}n| |||
|¡}|||	< q^||fS )Nc                 S  s   g | ]\}}}|‘qS r:   r:   )rŠ   r4   Úidentrö   r:   r:   r;   r¨   N  r«   z4LazyLoader._generate_lazy_clause.<locals>.<listcomp>)rÜ   rà   Zadapt_criterion_to_nullrZ   rH   Úobjr
   Úinstance_dictr   ZINIT_OKÚLOAD_AGAINST_COMMITTEDÚ#_get_committed_state_attr_by_columnÚ_get_state_attr_by_column)r\   rª   rµ   rú   Z
param_keysrN   ÚorÍ   rø   r4   rü   rö   r:   r:   r;   Ú_generate_lazy_clauseI  s,    
ÿ


ÿÿ
z LazyLoader._generate_lazy_clausec                 C  s   t  d| |f ¡‚d S )Nz&'%s' is not available due to lazy='%s'r¸   r»   r:   r:   r;   r´   i  s    
ÿzLazyLoader._invoke_raise_loadNr:   c                 C  s°  |j s | jjs|jr|js tjS |j  }d }	| jo>| p>|j }
|t	j
@ sN|
r\|tj@ sb|rbtjS | jrŽ|t	j@ sŽ|
r€|t	j@ rŽ|  ||d¡ t|ƒ}|sÄ|t	j@ rªtjS t dt |¡| j f ¡‚|
�r–|  |||¡}	tj|	v rètjS tj|	v røtjS | jj�st |	¡�r$d S nt |	¡�r$d S | j |jv �rD|t	j@ �sDtj S |j!| j"|	||d�}|d u�rx|tj#u �rrd S |S n|t	j
@ �r�|t	j@ �s–tjS |  $|||	||||||¡	S )Nr¬   zbParent instance %s is not bound to a Session; lazy load operation of attribute '%s' cannot proceed)rµ   Zlazy_loaded_from)%r4   rZ   Zload_on_pendingZ_load_pendingZ
session_idr   r­   rÖ   r‘   r   r®   r
   ZNON_PERSISTENT_OKr¯   rÝ   ÚNO_RAISEZRELATED_OBJECT_OKr´   r!   r±   r²   r3   r³   Ú_get_ident_for_use_getZ	NEVER_SETrN   Zallow_partial_pksr$   r¢   Ú
issupersetÚdictÚDEFERRED_HISTORY_LOADr   Z_identity_lookuprÅ   ZPASSIVE_CLASS_MISMATCHÚ_emit_lazyload)r\   rª   rµ   rd   Úextra_criteriaÚextra_optionsÚalternate_effective_pathÚexecution_optionsÚpendingÚprimary_key_identityrÖ   r·   Úinstancer:   r:   r;   rŸ   n  sž    
þýûÿÿþüõô
þÿÿ



ÿþü
ÿþ÷zLazyLoader._load_for_statec                   sD   ˆj j}ˆtj@ r|j‰n|j‰ˆj‰ ‡ ‡‡‡‡fdd„ˆjjD ƒS )Nc                   s"   g | ]}ˆˆˆ ˆj | ˆd �‘qS )©rµ   ©rÙ   ©rŠ   Úpk©rÍ   Zget_attrrµ   r\   rª   r:   r;   r¨   ï  s   ÿz5LazyLoader._get_ident_for_use_get.<locals>.<listcomp>)r°   rN   r   rÿ   r   r  r  r~   )r\   r·   rª   rµ   Úinstance_mapperr:   r  r;   r  å  s    
þz!LazyLoader._get_ident_for_use_getzsqlalchemy.orm.strategy_optionsc
                   sº  t jj‰ˆ j ¡ }
tj|
g|
jtt	j
d�}tj}|d|dœ7 }ˆ jjd ur\| ˆ jˆ jj¡}|j }|sr|tj@ r‚t  ddi¡|_ˆ j}|js˜|rè|jrè|d u r®|jˆ j }n
|ˆ j }|j}|rà|jràd}|t ˆ j|¡f7 }||_n$|d u �r|jjˆ j }n
|ˆ j }|�r | j|7  _| jd|i7  _|�rnˆ j�rZ|t j!@ �sZˆ  "||d¡ t#j$|||||	d�S ˆ j%�r~ˆ j%|_&‡ ‡fdd	„}| j'|ˆ jff7  _'ˆ  (||¡\}}|	�rÌt j) *|	d
|i¡}	nd
|i}	ˆ j|j+v �rô|t j,@ �sôt-j.S |�rt  /tj0| 1¡ ¡�r,d S nt  /tj2| 1¡ ¡�r,d S ˆ j�rN|t j!@ �sNˆ  "||d¡ |f|_3|j4|||	d�}| 5¡  6¡  7¡ }ˆ j8�r‚|S t9|ƒ}|�r²|dk�rªt  :dˆ j ¡ |d S d S d S )N)Ú_raw_columnsÚ_propagate_attrsÚ_label_stylerœ   F)Z_invoke_all_eagersÚ_lazy_loaded_fromZ	autoflushÚ_current_pathrÑ   )Úload_optionsr  c                   sR   ˆ j jD ]D}|jtju r|jrt|jtƒsˆj	 
| jj|j ¡ |¡ | ¡ qd S r2   )rZ   Z_reverse_propertyrM   r   rð   Z_use_getr¤   r¥   rÒ   r#   Z_construct_for_existing_pathr    r  rH   ZlazyloadZprocess_compile_state)Úcompile_contextÚrev©r\   Ústrategy_optionsr:   r;   Ú_lazyload_reverseI  s     
ÿþ
ýÿÿüüz4LazyLoader._emit_lazyload.<locals>._lazyload_reverseZ_sa_orm_load_options)r  r	   zKMultiple rows returned with uselist=False for lazily-loaded attribute '%s' r   );r   Z	preloadedZorm_strategy_optionsrÅ   Ú__clause_element__r-   Ú_create_raw_selectr  r,   r   Údefault_compile_optionsr   Zdefault_load_optionsrZ   Z	secondaryÚselect_fromrN   r4   r
   ZNO_AUTOFLUSHÚimmutabledictÚ_execution_optionsrÖ   r  r‘   Z	load_pathr3   ÚLoaderCriteriaOptionÚ_with_optionsÚ_path_registryrœ   rÞ   r   r  r´   r   Zload_on_pk_identityrÕ   Ú_order_by_clausesZ_with_context_optionsr  Ú
EMPTY_DICTÚ
merge_withr  r  r   r   Zhas_intersectionZ	_none_setÚvaluesZ
_never_setZ_where_criteriaÚexecuterñ   ZscalarsÚallr>   ÚlenÚwarn)r\   r·   rª   r  rµ   rd   r
  r  r  r  ZclauseelementÚstmtr  r  rÖ   Úeffective_pathr9   r!  Zlazy_clauserø   rl   Úlr:   r  r;   r	  ô  s¸    
üþ
ÿ

ÿ

ûÿÿþÿ
ÿþÿ
þÿzLazyLoader._emit_lazyloadc	              
     sÀ   | j ‰ |jjr@|jjjr@| j |jjjv r@|  ||||||||¡S | jrP|r�|jr�t	 
|jtˆ | ||jrp| |¡ntƒˆ ¡}	|d  | j |	f¡ n,|jsœ|jr¼‡ fdd„}
|d  | j |
f¡ d S )Nrš   c                   s   |   |ˆ ¡ d S r2   )Z_resetrÌ   ©r4   r:   r;   Úreset_for_lazy_callableÌ  s    	z@LazyLoader.create_row_processor.<locals>.reset_for_lazy_callable)r4   r  Z_is_user_refreshr   rœ   r�   rÇ   r|   r‘   r"   Z"_instance_level_callable_processorrK   ÚLoadLazyAttributeÚ_generate_extra_criteriaÚ_NO_EXTRA_CRITERIArF   Úpopulate_existingZalways_refresh)r\   rk   rb   rc   rd   rN   rl   re   rm   Zset_lazy_callabler7  r:   r6  r;   rn   ’  sF    ÿþýø
ÿÿù
òzLazyLoader.create_row_processor)ro   rp   rq   rr   rs   Ú__annotations__rY   r�   rû   r  r´   r   r,  rŸ   r  Zpreload_moduler	  rn   rt   r:   r:   r^   r;   rÒ   ¦  s.   
	<"  	ø
w
 rÒ   c                   @  s.   e Zd ZdZdd„ Zdd„ Zejfdd„ZdS )	r8  a¦  semi-serializable loader object used by LazyLoader

    Historically, this object would be carried along with instances that
    needed to run lazyloaders, so it had to be serializable to support
    cached instances.

    this is no longer a general requirement, and the case where this object
    is used is exactly the case where we can't really serialize easily,
    which is when extra criteria in the loader option is present.

    We can't reliably serialize that as it refers to mapped entities and
    AliasedClass objects that are local to the current process, which would
    need to be matched up on deserialize e.g. the sqlalchemy.ext.serializer
    approach.

    c                 C  s   || _ |j| _|| _|| _d S r2   ©r4   r]   rd   r
  )r\   r4   Zinitiating_strategyrd   r
  r:   r:   r;   rY   ì  s    zLoadLazyAttribute.__init__c                 C  s(   | j turt d¡ | j| j| jtdœS )NzvCan't reliably serialize a lazyload() option that contains additional criteria; please use eager loading for this caser=  )r
  r:  r   r2  r4   r]   rd   r§   r:   r:   r;   Ú__getstate__ò  s    
ÿüzLoadLazyAttribute.__getstate__c                 C  s:   | j }|jj}|j| }|j| j }|j||| j| jd�S )N)rd   r
  )	r4   r°   rN   rI   Z_strategiesr]   rŸ   rd   r
  )r\   rª   rµ   r4   r  r7   r¥   r:   r:   r;   rÂ      s    
üzLoadLazyAttribute.__call__N)	ro   rp   rq   rr   rY   r>  r
   r   rÂ   r:   r:   r:   r;   r8  Ú  s   r8  c                   @  s   e Zd ZdZdZddd„ZdS )Ú
PostLoaderz;A relationship loader that emits a second SELECT statement.r:   Nc                 C  sN  |j jptjj| }| ¡ }t d|i¡}|rF|j 	dd ¡}|dk}	nd }d}	|d urÂ| j
jsrt d| j
› d�¡‚|j 	dt| ƒ› �|¡}|	s¢|dk r¢|d||fS |	sÂ| dt| ƒ› �|d	 i¡}tj ||| j
¡rà|d||fS || j
 }
|| j
 }|
 |jd
¡�sB|�r(|jd |k�rB|d||fS n| | j¡�rB|d||fS |d||fS )NZsa_top_level_orm_contextÚrecursion_depthéÿÿÿÿFz'recursion_depth option on relationship z0 not valid for non-self-referential relationshipZ_recursion_depth_r   r	   Úloaderr&   T)ra   Úcurrent_pathr3   ÚPathRegistryÚrootZ_get_top_level_contextr   r&  r£   rJ   rZ   Z_is_self_referentialr¹   rº   r  ÚidÚunionr   ÚPostLoadZpath_existsÚcontainsr
   ÚlengthÚcontains_mapperrN   )r\   rk   rc   rd   Ú
join_depthr4  Ztop_level_contextr  r@  Zunlimited_recursionÚpath_w_propZeffective_path_w_propr:   r:   r;   Ú_setup_for_recursion  sl    þÿ
ÿÿÿüÿÿÿ

üüzPostLoader._setup_for_recursion)N)ro   rp   rq   rr   rs   rN  r:   r:   r:   r;   r?    s   r?  rÆ   c                      s8   e Zd ZdZ‡ fdd„Zdd„ Zdd„ Zdd	„ Z‡  ZS )
ÚImmediateLoader©rL  c                   s   t ƒ  ||¡ | jj| _d S r2   ©rX   rY   rZ   rL  r[   r^   r:   r;   rY   ^  s    zImmediateLoader.__init__c                 C  s   | j  d¡ |¡ d S ©N©)r¼   rÐ   ©rZ   rž   r�   r’   r:   r:   r;   r�   b  s
    ÿþz$ImmediateLoader.init_class_attributec	                 C  sl   |j jjsd S |  |||| j¡\}	}
}}|
s:tjtjB }ntj	tjB }t
j ||	| j| j| j||||¡	 d S r2   )ra   r    Ú_enable_eagerloadsrN  rL  r
   ZPASSIVE_NO_FETCH_RELATEDr   r  r   r   rH  Úcallable_for_pathrH   rZ   Ú_load_for_path)r\   rk   rb   rc   rd   rN   rl   re   rm   r4  Ú
run_loaderr  r@  Úflagsr:   r:   r;   rn   g  s,    
û÷z$ImmediateLoader.create_row_processorc	                 C  s¢   |r.t |jjƒ}	|| ¡ f|	_| ¡ }
|	f}n|}
d}| j}| j d¡}|D ]P\}}|j	}|sf||vrL|j
||||
|d�}|ttjfvrL| |¡ |||¡ qLd S )Nr:   rS  )r  r  r  )r#   rc   rÅ   Z_recurserk   Ú_truncate_recursiver4   rZ   rž   r  rŸ   r   r   r¯   Úget_implÚset_committed_value)r\   rk   rc   ÚstatesÚ	load_onlyrd   rY  r@  r  Znew_optr  r  r4   Ú
lazyloaderrª   Ú	overwriterÍ   rö   r:   r:   r;   rW  ‘  s8    þûþ
ÿzImmediateLoader._load_for_path)	ro   rp   rq   rs   rY   r�   rn   rW  rt   r:   r:   r^   r;   rO  Z  s
   *rO  Úsubqueryc                      s†   e Zd ZdZ‡ fdd„Zdd„ Zdd„ Zdd	„ Zd
d„ Zdd„ Z	dd„ Z
dd„ ZG dd„ dƒZdd„ Zdd„ Zdd„ Zdd„ Z‡  ZS )ÚSubqueryLoaderrP  c                   s   t ƒ  ||¡ | jj| _d S r2   rQ  r[   r^   r:   r;   rY   Ã  s    zSubqueryLoader.__init__c                 C  s   | j  d¡ |¡ d S rR  rT  r’   r:   r:   r;   r�   Ç  s
    ÿþz#SubqueryLoader.init_class_attributec                   sÀ   |}|j }t |d ¡}| j |¡rB| j|d u rB| j| j ‰ }n||d  ‰ }|r–|j| jj| ‰t	|ƒt	ˆƒ }|ršˆt
j || d … ¡7 ‰n|‰|j}	‡ ‡fdd„|	D ƒ}
ˆ |
|ˆfS )Nr   r	   c                   s&   g | ]}t ˆjd  jˆ j| jƒ‘qS ©r   )Úgetattrrc   rÅ   r   r4   r‰   ©Úleftmost_mapperZnew_subq_pathr:   r;   r¨   ó  s
   ü

þz0SubqueryLoader._get_leftmost.<locals>.<listcomp>)rc   r3   Z_class_to_mapperrH   ÚisarZ   Ú	_entitiesÚentity_zeror*  r1  r   rD  ZcoerceÚlocal_columns)r\   Úorig_query_entity_indexÚ	subq_pathZcurrent_compile_stateÚis_rootZgiven_subq_pathZsubq_mapperZleftmost_propÚ
additionalZleftmost_colsÚleftmost_attrr:   re  r;   Ú_get_leftmostÌ  s4    
ÿþÿþÿûzSubqueryLoader._get_leftmostc                 C  s0  |  ¡  d ¡}tj tj¡}|j |j¡ |}|js`d|_|j	j
|gdd„ t||d�D ƒ¢R Ž  | dd„ |D ƒ| ¡ ¡}	|	|_|j}
|
du r–d|_n6|
d u rÌdd„ |	D ƒD ]}t|	ƒ |j¡s¬d|_ qÌq¬|jsØd	|_|jdu �r|j�rt |	|j¡}|�r| |	| ¡ | t¡ ¡ }tj||dd
�}|S )NFc                 S  s    h | ]}|d  dur|d  ’qS )rÅ   Nr:   )rŠ   Úentr:   r:   r;   Ú	<setcomp>  s   üz?SubqueryLoader._generate_from_original_query.<locals>.<setcomp>)ra   c                 S  s   g | ]}t j t jj|¡‘qS r:   )r*   Z	coercionsÚexpectZrolesZColumnsClauseRole)rŠ   r  r:   r:   r;   r¨   6  s   ÿz@SubqueryLoader._generate_from_original_query.<locals>.<listcomp>Tc                 S  s   h | ]
}|j ’qS r:   )Útabler‰   r:   r:   r;   rr  E  r«   r:   ©Úuse_mapper_path)Z_cloneZ	correlater   ÚQueryÚ__new__Ú__dict__ÚupdateZ	_from_objZ_enable_assertionsr%  Znon_generativer   Z_adapt_col_listZ_get_current_adapterr  Údistinct_target_keyZ	_distinctr¡   r  r~   Z_has_row_limiting_clauser+  rà   Z expand_column_list_from_order_byZ_set_entitiesZset_label_styler,   ra  r3   r%   )r\   Úorig_compile_stateÚ
orig_queryrf  ro  Úleftmost_relationshipZorig_entityÚqZq2Ztarget_colsr{  ÚtZto_addZembed_qÚ
left_aliasr:   r:   r;   Ú_generate_from_original_queryý  sV    ÿÿþþþûÿÿz,SubqueryLoader._generate_from_original_queryc                   sÎ   g }t | ¡ ƒ}t|ƒD ]N\}\}}|dkrR||d  d j}| |¡rL|n|}	n|}	| |	|jf¡ qt|ƒdk rz|‰ n.t|d d ƒ}
|
j	r˜|
j
‰ ntj|
j
dd�‰ ˆjj}‡ ‡fdd„|D ƒ}||ˆ fS )	Nr   r	   r&   rA  Tru  c                   s    g | ]}t ˆ ˆjj| jƒ‘qS r:   )rd  rH   r   r4   r‰   ©Úparent_aliasr\   r:   r;   r¨   Š  s   ÿz2SubqueryLoader._prep_for_joins.<locals>.<listcomp>)rí   ÚpairsÚ	enumeraterN   rg  rF   r4   r1  r(   r×   rÅ   r3   r%   rZ   rj  )r\   r�  rl  Úto_joinr…  ÚirN   r7   Zprev_mapperZ	to_appendrê   Ú
local_colsÚ
local_attrr:   rƒ  r;   Ú_prep_for_joinsa  s*    ÿþzSubqueryLoader._prep_for_joinsc                 C  s0  t |ƒ}|dkr,t||d d ƒ |¡g}nê|dkrft||d d ƒ |¡t||d d ƒ |¡g}n°|dk�rdd„ |dd… D ƒ}g }|rØ| d¡}	t|	d |	d ƒ}
|rÂ|
 |d d ¡}
n
|
 |¡}
| |
¡ qŠt||d d ƒ |d j¡g| t||d d ƒ |¡g }|D ]}
| |
¡}�q|S )Nr	   r   r&   rA  c                 S  s:   g | ]2}t |d  ƒjs$t |d  ¡n|d  j|d f‘qS )r   r	   )r(   r×   r3   r%   rÅ   )rŠ   Úitemr:   r:   r;   r¨      s   	ûÿúz/SubqueryLoader._apply_joins.<locals>.<listcomp>)r1  rd  Úof_typeÚpoprF   rH   Újoin)r\   r  r‡  r�  r„  Úeffective_entityZltjZmiddleÚinnerrŒ  Úattrr:   r:   r;   Ú_apply_joins�  sD    ÿÿþ
	
÷

ÿÿÿþÿ
zSubqueryLoader._apply_joinsc           	      C  s@   |j }|r(|jr(|t || |¡¡f7 }| |¡}|j|Ž }|S r2   )r)  r‘   r3   r(  r9  Z_with_current_pathÚoptions)	r\   rk   r  rl  Úrewritten_pathr}  r�  rd   Únew_optionsr:   r:   r;   Ú_setup_optionsÆ  s    
þÿ	

zSubqueryLoader._setup_optionsc                   s&   ˆ j jr"‡ fdd„}| |ˆ j ¡}|S )Nc                   s    |  j tt ˆ jj¡ƒ7  _ d S r2   ©Úeager_order_byÚtupler   rè   rZ   rç   ©r  r§   r:   r;   Ú_setup_outermost_orderbyë  s    ÿzISubqueryLoader._setup_outermost_orderby.<locals>._setup_outermost_orderby)rZ   rç   Ú_add_context_option)r\   r  rœ  r:   r§   r;   rœ  è  s    ÿz'SubqueryLoader._setup_outermost_orderbyc                   @  s4   e Zd ZdZdZdd„ Zdd„ Zdd„ Zd	d
„ ZdS )zSubqueryLoader._SubqCollectionsz±Given a :class:`_query.Query` used to emit the "subquery load",
        provide a load interface that executes the query at the
        first moment a value is needed.

        ©r·   r  r  rø   ÚsubqÚ_datac                 C  s4   |j | _ |j| _|j| _|jp i | _|| _d | _d S r2   rž  )r\   rk   rŸ  r:   r:   r;   rY     s    z(SubqueryLoader._SubqCollections.__init__c                 C  s    | j d u r|  ¡  | j  ||¡S r2   )r   Ú_loadrJ   )r\   r4   Údefaultr:   r:   r;   rJ     s    
z#SubqueryLoader._SubqCollections.getc                 C  s„   t  t¡| _| j}|jd u s J ‚| | j¡}| jjr<| 	¡ }t| 
| j
¡ƒ}t |dd„ ¡D ]"\}}| j|  dd„ |D ƒ¡ q\d S )Nc                 S  s   | dd … S )Nr	   r:   ©Úxr:   r:   r;   r<   #  r«   z7SubqueryLoader._SubqCollections._load.<locals>.<lambda>c                 s  s   | ]}|d  V  qdS )r   Nr:   ©rŠ   Úvvr:   r:   r;   r�   $  r«   z8SubqueryLoader._SubqCollections._load.<locals>.<genexpr>)ÚcollectionsÚdefaultdictrí   r   rŸ  r·   Zwith_sessionr  Z_populate_existingr;  rø   Ú	itertoolsÚgroupbyÚextend)r\   r  Úrowsr©   Úvr:   r:   r;   r¡    s    z%SubqueryLoader._SubqCollections._loadc                 C  s   | j d u r|  ¡  d S r2   )r   r¡  )r\   rª   rÍ   rÎ   r:   r:   r;   rB  &  s    
z&SubqueryLoader._SubqCollections.loaderN)	ro   rp   rq   rr   rs   rY   rJ   r¡  rB  r:   r:   r:   r;   Ú_SubqCollectionsö  s   	
r®  c              	   C  s¦  |j }|jjr|jjrd S |j |¡}d|_|| j }| |j	dd ¡}	|	d urT|	}
n| j
}
|jj dtjjtjjf¡\}}|tjju }|| }|| }|jj dtf|j¡}t |d¡}|jrâ|jjd u rÜt d| |f ¡ |j}|j|dd�}|  ||||¡\}}}}|  ||||||¡}t |
¡}|jj |jdtf|d||fi¡|_| d¡}|   ||¡\}}}|j!|Ž }|  "|||||
¡}|  #||||||
|¡}|  $|¡}|S )	NTÚpath_with_polymorphic)Zsubquery_pathsNr}  ÚormzÙsubqueryloader for "%s" must invoke lambda callable at %r in order to produce a new query, decreasing the efficiency of caching for this statement.  Consider using selectinload() for more effective full-lambda cachingF)Úlegacy)%ra   r    rU  Z_for_refresh_staterh  ÚindexZloaders_require_bufferingrZ   rJ   r
   rÅ   r   r'  r3   rD  rE  rb  r   Z_get_plugin_class_for_pluginZ_is_lambda_elementr  r  r   r2  Z	_resolvedZ_create_entities_collectionrp  r‚  rw  r-  r  Z_set_enable_single_critr‹  Zadd_columnsr“  r—  rœ  )r\   rk   rb   rc   rÅ   rd   re   ra   rk  Úwith_poly_entityr�  rl  r•  rm  r}  Zcompile_state_clsr|  rf  ro  r~  r�  r  r‡  rŠ  r„  r:   r:   r;   Ú_setup_query_from_rowproc*  s¨    	ÿþ
ÿþ
ÿÿûÿÿ	üû
ú
þþ
ÿ


ÿù	
z(SubqueryLoader._setup_query_from_rowprocc	              
     s¦  |r&|j jd ur&|j jjr&t dd¡ |jrD|  ||||||ˆ |¡S |  |||| j¡\}	}
}	}	|
sfd S t	|j t
ƒsvd S | jj| j jjs–t d|  ¡‚t|ƒdkr¸t |j| j¡sàd S n(t |d | j¡sà| j |d j¡sàd S |  ||||d |ˆ ¡}|d u �rd S |jd u �sJ ‚|| j }| jj}| |jd¡}|d u �r\|  ||¡}| |jd|¡ ˆ �rt‡ fdd„|D ƒ}| j �r�|  !|||||¡ n|  "|||||¡ d S )	Nz°The subqueryload loader option is not compatible with DML statements such as INSERT, UPDATE.  Only SELECT may be used.This warning will become an exception in a future release.ú2.0úJ'%s' does not support object population - eager loading cannot be applied.r	   rA  r§  c                   s   g | ]}ˆ j | ‘qS r:   rV   r‰   ©re   r:   r;   r¨     r«   z7SubqueryLoader.create_row_processor.<locals>.<listcomp>)#ra   Ú	statementÚis_dmlr   Úwarn_deprecatedr›   rÇ   rN  rL  r¤   r   rH   rK   r4   ÚimplÚsupports_populationr¹   rº   r1  r3   Ú_entity_isari  rg  rN   r´  r·   rZ   rj  rJ   r
   r®  r¡   r>   Ú_create_collection_loaderÚ_create_scalar_loader)r\   rk   rb   rc   rd   rN   rl   re   rm   Ú_rX  rŸ  r‰  r§  r:   r·  r;   rn   ²  sŠ    ÿ
þýüø
ÿÿÿ	
ÿþú	



ÿ
ÿz#SubqueryLoader.create_row_processorc                   sp   |  |¡‰‡ ‡‡fdd„‰‡‡fdd„}|d  ˆjˆf¡ |d  ˆj|f¡ |jrl|d  ˆjˆ jf¡ d S )Nc                   s*   ˆ   ˆ|ƒd¡}|  ˆj¡ | ||¡ d S )Nr:   )rJ   r[  r4   r\  )rª   rÍ   rÎ   Ú
collection©r§  r\   Útuple_getterr:   r;   Úload_collection_from_subq!  s    ÿzKSubqueryLoader._create_collection_loader.<locals>.load_collection_from_subqc                   s   ˆj |vrˆ | ||ƒ d S r2   r6  rÌ   )rÄ  r\   r:   r;   Ú&load_collection_from_subq_existing_row'  s    
zXSubqueryLoader._create_collection_loader.<locals>.load_collection_from_subq_existing_rowrš   ÚexistingÚeager©Z_tuple_getterrF   r4   Úinvoke_all_eagersrB  )r\   rk   rl   r§  r‰  rm   rÅ  r:   )r§  rÄ  r\   rÃ  r;   r¾    s    
ÿz(SubqueryLoader._create_collection_loaderc                   sp   |  |¡‰‡ ‡‡fdd„‰‡‡fdd„}|d  ˆjˆf¡ |d  ˆj|f¡ |jrl|d  ˆjˆ jf¡ d S )Nc                   sL   ˆ   ˆ|ƒd¡}t|ƒdkr*t dˆ ¡ |d }|  ˆj¡ | ||¡ d S )Nr2   r	   úLMultiple rows returned with uselist=False for eagerly-loaded attribute '%s' r   )rJ   r1  r   r2  r[  r4   r\  )rª   rÍ   rÎ   rÁ  ZscalarrÂ  r:   r;   Úload_scalar_from_subq8  s    ÿÿzCSubqueryLoader._create_scalar_loader.<locals>.load_scalar_from_subqc                   s   ˆj |vrˆ | ||ƒ d S r2   r6  rÌ   )rË  r\   r:   r;   Ú"load_scalar_from_subq_existing_rowC  s    
zPSubqueryLoader._create_scalar_loader.<locals>.load_scalar_from_subq_existing_rowrš   rÆ  rÇ  rÈ  )r\   rk   rl   r§  r‰  rm   rÌ  r:   )r§  rË  r\   rÃ  r;   r¿  3  s    
ÿz$SubqueryLoader._create_scalar_loader)ro   rp   rq   rs   rY   r�   rp  r‚  r‹  r“  r—  rœ  r®  r´  rn   r¾  r¿  rt   r:   r:   r^   r;   rb  ¾  s   1d/6"4 	jrb  Zjoinedc                      sˆ   e Zd ZdZdZ‡ fdd„Zdd„ Zd d	d
„Zdd„ Zdd„ Z	dd„ Z
dd„ Zd!dddœdd„Zdd„ Zdd„ Zdd„ Zdd„ Z‡  ZS )"ÚJoinedLoaderz[Provide loading behavior for a :class:`.Relationship`
    using joined eager loading.

    rL  c                   s   t ƒ  ||¡ | jj| _d S r2   rQ  r[   r^   r:   r;   rY   Z  s    zJoinedLoader.__init__c                 C  s   | j  d¡ |¡ d S rR  rT  r’   r:   r:   r;   r�   ^  s
    ÿþz!JoinedLoader.init_class_attributeNFc	                 K  st  |j jsdS |r0|jdur0|jjr0t dd¡ n| jr<d|_|| j }|rZ|  	|||j
¡nd}
|
dur€|  |||||
¡\}}}n`| |j
d¡sº| jrª|jd | jkrºdS n| | j¡rºdS |  ||||||||¡\}}}}d|_| |j
dd¡}|du�rt|ƒj}nd}|| j }tj|| j|||||| j|d	�	 tj |j¡}|�rp|du�r^t d
¡‚ndd„ |jD ƒ|_dS )z@Add a left outer join to the statement that's being constructed.Nz®The joinedload loader option is not compatible with DML statements such as INSERT, UPDATE.  Only SELECT may be used.This warning will become an exception in a future release.rµ  TFrB  r&   r¯  )Úwith_polymorphicÚparentmapperÚchained_from_outerjoinz–Detected unaliased columns when generating joined load.  Make sure to use aliased=True or flat=True when using joined loading with with_polymorphic().c                 S  s   g | ]}|d ur|‘qS r2   r:   r‰   r:   r:   r;   r¨   ß  s   z,JoinedLoader.setup_query.<locals>.<listcomp>)r    rU  r¸  r¹  r   rº  r>   Úmulti_row_eager_loadersrZ   Ú_init_user_defined_eager_procr
   Ú$_setup_query_on_user_defined_adapterrI  rL  rJ  rK  rN   Ú_generate_row_adapterZeager_adding_joinsrJ   r(   Zwith_polymorphic_mappersrÅ   r   Z_setup_entity_queryZNONE_SETr¢   Úsecondary_columnsr¹   rº   )r\   ra   rb   rc   rd   re   rf   rÏ  rÐ  rg   Úuser_defined_adapterÚclausesÚadd_to_collectionr³  rÎ  Z	has_nonesr:   r:   r;   ri   c  sª    ÿþýü
ýÿûûüýøûÿ
ÿ
÷
ÿÿzJoinedLoader.setup_queryc           
      C  sâ   d|j vrdS |jj}| |jdd¡}|dur2|S |j d }|dd … \}}|d urŠt|tƒrj|j |¡}t	j
t	jj|j||jjdd�}nF| |jd¡rÀ| |jd¡}	t	j
t	jj|	|jjd�}n|j |jd ¡}| |d|¡ |S )NZeager_from_aliasFÚ user_defined_eager_row_processoréþÿÿÿ)Ú
selectablerå   Zlimit_on_entityr¯  )rå   )r£   rc   rH   rJ   r
   r¤   r¾   rÄ   Úaliasr3   Ú
ORMAdapterÚ_TraceAdaptRoleZJOINEDLOAD_USER_DEFINED_ALIASrN   rì   rI  Z JOINEDLOAD_PATH_WITH_POLYMORPHICZ_polymorphic_adaptersr¡   )
r\   rd   ra   Ztarget_attributesrc   re   rÜ  Zroot_mapperr7   r³  r:   r:   r;   rÒ  ã  sP    
ÿ

ûÿÿýÿýz*JoinedLoader._init_user_defined_eager_procc                 C  sV   |  |¡}|r.|r.| |¡}| |jd|¡ n|rF|}| |jd|¡ |j}|||fS )NrÙ  )Z_get_entity_clausesÚwrapr¡   r
   Úprimary_columns)r\   rk   rÅ   rc   re   rÖ  rØ  r:   r:   r;   rÓ  	  s"    

ýýz1JoinedLoader._setup_query_on_user_defined_adapterc	                 C  s  |  |jdd ¡}	|	r|	}
nDt| jƒ}|jr2|j}nd }tj| j|d urR|j	dd�nd ddd�}
t|
ƒ}|j
d| ftjtjj|| jjdddd�}|js˜J ‚|d ur²|j  d| jj¡n| jj}|sÂd}|j | j||||||||rä|jnd	f	¡ |j}| |jd
|¡ ||||fS )Nr¯  T)Úflat)rÜ  rá  rv  Zjoinedloader_ormadapterF)rå   Zadapt_requiredZallow_label_resolveZanonymize_labelsÚ	innerjoinr:   Úeager_row_processor)rJ   r
   r(   rÅ   r×   rÛ  r3   r%   rN   Z_anonymous_fromclauseZ_memorÝ  rÞ  ZJOINEDLOAD_MEMOIZED_ADAPTERrì   r£   rZ   râ  Zcreate_eager_joinsrF   Ú_create_eager_joinr‘   rÕ  r¡   )r\   ra   rÅ   rc   rd   re   rf   rÏ  rÐ  r³  Zto_adaptZinspZalt_selectableZto_adapt_inspr×  râ  rØ  r:   r:   r;   rÔ  5	  sd    ÿ
ÿøø
ÿý÷ÿz"JoinedLoader._generate_row_adapterc
              	     sb  |d u r|j }
n|}
|jo|j}d }||jvr~|s~|jr~t |j|j¡}t|ƒdkr^t	 
d¡‚|r~|j|d  }|d | }}|d u r’||j }}|j ||¡}|�rt|ddƒrä|j |
 ˆ j¡rÈ|
nˆ j¡}t|jˆ jˆ jƒ}n ttjˆ j|jdd�ˆ jˆ jƒ}nˆ j}|j�sJ ‚| �p8| �p8|dk�p8|jj}|	}|j d	ˆ j fd
¡}|�rr|t‡ fdd„|D ƒƒ7 }|�r¼tj||j|| �p¦|jj�p¦|�o¦t|tjƒˆ j|ˆ j  |d�}nˆ   ||d ||||¡}||j|< |j|_!|�s0t "ˆ jj#¡D ]4}|
j$j% &|¡�rú|�r|j'| }| (||j)¡ �qúˆ jj*�r^| j+t|j, -t. /ˆ jj*¡¡ƒ7  _+d S )Nr	   z€Can't identify which query entity in which to joined eager load from.   Please use an exact match when specifying the join path.r   r×   FTru  ZunnestedÚadditional_entity_criteriar:   c                 3  s    | ]}|j r| ˆ j¡V  qd S r2   )Zpropagate_to_loadersZ_resolve_where_criteriarN   )rŠ   Zaer§   r:   r;   r�   ì	  s   þz2JoinedLoader._create_eager_join.<locals>.<genexpr>©ÚisouterÚ
_left_memoÚ_right_memor‘   rÚ  )0rN   rÑ  Z_should_nest_selectableZeager_joinsZfrom_clausesrà   Z#find_left_clause_that_matches_givenrÛ  r1  r¹   rº   Ú
setdefaultrd  Úaliased_inspZ_entity_for_mapperrg  rH   rÅ   r4   rZ   r3   r%   r×   ri  Zrepresents_outer_joinZglobal_attributesrJ   rš  Ú_ORMJoinr¤   r*   ZJoinÚ_splice_nested_inner_joinZstop_onZ_find_columnsZprimaryjoinZpersist_selectablerh   Zcontains_columnrW   r`   rà  rç   r™  Ú_target_adapterZcopy_and_processr   rè   )r\   ra   rb   rc   re   rÏ  r×  râ  rÐ  r
  r¶   Zshould_nest_selectableZquery_entity_keyZindexesZclauseZdefault_towrapZtowrapZefmÚonclauseZattach_on_outsideZextra_join_criteriarå  Ú	eagerjoinr…   r:   r§   r;   rä  „	  sÀ    þÿþýÿÿþÿ
ÿý
ÿû	ÿþü
ÿþ
ÿ÷ÿ
ÿ
ÿ
ÿÿzJoinedLoader._create_eager_joinz#Union[Mapper, None, Literal[False]]z$Optional[path_registry.PathRegistry]©Úentity_inside_join_structureÚdetected_existing_pathc	              
   C  s¼  ||d u sJ ‚|du r(t |tjƒs(J ‚t |tjjƒrN|  |||j||||¡S t |tjƒ�rB|j}	| j|||j	||||	d ur†|	d j
nd d�}
|
d urÖ|js®|
js®| |
¡}ntj|j|
|j|j|jd�}|
j|_|S | j|||j||||j|	d�}
|
d u�r&tj|
|j	|j|j|jd�}|
j|_|S |du �r>d�s>J dƒ‚d S | |¡�sRd S |�r˜t|ƒd	k�r˜|d
 |u �sxJ ‚|dd… |jdd… k�r˜d S tj||j|d|||d j
 |d�S )NrÚ  FrA  )rò  )rç  rè  rñ  )rç  ré  z9assertion failed attempting to produce joined eager loadsr&   éýÿÿÿr   ræ  )r¤   r3   rì  r*   rÛ  ZFromGroupingrí  Úelementré  ÚrightrN   rç  Z_splice_into_centerÚleftrï  rè  rî  rg  r1  rc   rë  )r\   rc   Zentity_we_want_to_splice_ontoZjoin_objr×  rï  r
  rò  ró  Zjoin_right_pathZtarget_joinrð  r:   r:   r;   rí  #
  sž    ù	ÿöûø
û
ÿþ$ùz&JoinedLoader._splice_nested_inner_joinc           	      C  s„   |j }|r|  |||j¡nd}|durP|}|jrB|rB| |j¡}qj|jrj|j}n| |jd¡}|d u rjdS | j ||¡r||S dS d S )NFrã  )ra   rÒ  r
   Zcompound_eager_adapterrß  rJ   rN   Z_result_has_identity_key)	r\   rk   rl   re   rc   rd   ra   rÖ  Ú	decoratorr:   r:   r;   Ú_create_eager_adapterÐ
  s.    ýÿû
ÿÿz"JoinedLoader._create_eager_adapterc	              
   C  sÎ   |j jjsd S | jj| j jjs.t 	d|  ¡‚| j
r:d|_|| j }	|  ||||	|¡}
|
durª| j}t || j|||	| j |
¡}| j
s˜|  ||||¡ qÊ|  ||||¡ n | j d¡ ||||||||¡ d S )Nr¶  TFrS  )ra   r    rU  rH   rK   r4   r»  r¼  r¹   rº   r>   Zloaders_require_uniquingrZ   rù  r   Z_instance_processorrN   rÅ   r¿  r¾  rž   rn   )r\   rk   rb   rc   rd   rN   rl   re   rm   Zour_pathZeager_adapterr4   Ú	_instancer:   r:   r;   rn   ô
  sR    
ÿÿ

ÿú	ÿÿöz!JoinedLoader.create_row_processorc                   sr   ‡ ‡‡fdd„}‡ ‡‡fdd„}‡ fdd„}|d   | j|f¡ |d   | j|f¡ ˆjrn|d	   | j|f¡ d S )
Nc                   sF   t  | |ˆ¡}t |d¡}|ˆj | ˆf< ˆ |ƒ}|d urB| |¡ d S ©NZappend_without_event©r
   rË   r   ZUniqueAppenderrF   )rª   rÍ   rÎ   rÁ  Úresult_listÚinst©rú  rk   r4   r:   r;   Ú#load_collection_from_joined_new_row3  s    ÿzSJoinedLoader._create_collection_loader.<locals>.load_collection_from_joined_new_rowc                   sd   | ˆfˆj v rˆj | ˆf }n(t  | |ˆ¡}t |d¡}|ˆj | ˆf< ˆ |ƒ}|d ur`| |¡ d S rû  rü  )rª   rÍ   rÎ   rý  rÁ  rþ  rÿ  r:   r;   Ú(load_collection_from_joined_existing_row@  s    ÿÿzXJoinedLoader._create_collection_loader.<locals>.load_collection_from_joined_existing_rowc                   s   ˆ |ƒ d S r2   r:   rÌ   ©rú  r:   r;   Ú load_collection_from_joined_execS  s    zPJoinedLoader._create_collection_loader.<locals>.load_collection_from_joined_execrš   rÆ  rÇ  ©rF   r4   rÉ  )r\   rk   r4   rú  rm   r   r  r  r:   rÿ  r;   r¾  2  s    ÿÿÿz&JoinedLoader._create_collection_loaderc                   sp   ‡ ‡fdd„}‡ ‡‡fdd„}‡ fdd„}|d   ˆj|f¡ |d   ˆj|f¡ |jrl|d	   ˆj|f¡ d S )
Nc                   s   ˆ |ƒ|ˆ< d S r2   r:   rÌ   )rú  r4   r:   r;   Úload_scalar_from_joined_new_rowb  s    zKJoinedLoader._create_scalar_loader.<locals>.load_scalar_from_joined_new_rowc                   s8   ˆ |ƒ}ˆ|v r,||ˆ ur4t  dˆ ¡ n||ˆ< d S )NrÊ  )r   r2  )rª   rÍ   rÎ   rÆ  ©rú  r4   r\   r:   r;   Ú$load_scalar_from_joined_existing_rowg  s    þÿ	zPJoinedLoader._create_scalar_loader.<locals>.load_scalar_from_joined_existing_rowc                   s   ˆ |ƒ d S r2   r:   rÌ   r  r:   r;   Úload_scalar_from_joined_execz  s    zHJoinedLoader._create_scalar_loader.<locals>.load_scalar_from_joined_execrš   rÆ  rÇ  r  )r\   rk   r4   rú  rm   r  r  r  r:   r  r;   r¿  a  s    ÿÿz"JoinedLoader._create_scalar_loader)NNF)FN)ro   rp   rq   rr   rs   rY   r�   ri   rÒ  rÓ  rÔ  rä  rí  rù  rn   r¾  r¿  rt   r:   r:   r^   r;   rÍ  O  s,      ÷
 9O *  õ .$>/rÍ  Zselectinc                      st   e Zd ZdZe dg d¢¡ZdZ‡ fdd„Zdd„ Z	d	d
„ Z
dd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Z‡  ZS )ÚSelectInLoader)rL  Ú	omit_joinÚ_parent_aliasÚ_query_infoÚ_fallback_query_infoZ	queryinfo)Úload_only_childÚload_with_joinÚin_exprÚpk_colsÚzero_idxÚchild_lookup_colsiô  c                   s´   t ƒ  ||¡ | jj| _| jjtju }| jjd ur>| jj| _n<| j d¡}|rX|j	| _n"| j
jd j|jdd| j
jd�| _| jr¦|rš|  ¡ | _|  ¡ | _q°|  ¡ | _n
|  ¡ | _d S )NrS  r   TFrä   )rX   rY   rZ   rL  rM   r   rð   r
  rž   rÖ   rH   rë   rˆ   rÔ   rì   Ú_init_for_omit_join_m2or  Ú_init_for_joinr  Ú_init_for_omit_join)r\   rH   r]   Zis_m2or_  r^   r:   r;   rY      s,    
ÿ
ü
zSelectInLoader.__init__c                   s‚   t ˆjjjƒ‰ ˆ  ‡ ‡fdd„tˆ ƒD ƒ¡ ‡ fdd„ˆjjD ƒ }}t|ƒdkrbt	j
|Ž }d}n|d }d}ˆ dd|||d ¡S )	Nc                 3  s0   | ](}ˆj j |d ¡D ]}|ˆ | fV  qqdS )r:   N)rH   rì   rJ   )rŠ   r©   Úequiv©Úpk_to_fkr\   r:   r;   r�   Â  s   þz5SelectInLoader._init_for_omit_join.<locals>.<genexpr>c                   s   g | ]}|ˆ v rˆ | ‘qS r:   r:   ©rŠ   r…   )r  r:   r;   r¨   È  s   z6SelectInLoader._init_for_omit_join.<locals>.<listcomp>r	   Fr   T)r  rZ   ræ   Zlocal_remote_pairsrz  rí   rH   r~   r1  r*   Útuple_Ú
query_info)r\   r  Zfk_colsr  r  r:   r  r;   r  ¾  s    ÿþ
ÿ

z"SelectInLoader._init_for_omit_joinc                   sb   | j j}t|ƒdkr$tj|Ž }d}n|d }d}| j d¡‰ ‡ fdd„|D ƒ}|  dd||||¡S )Nr	   Fr   TrS  c                   s   g | ]}ˆ j | ‘qS r:   r  r  ©r_  r:   r;   r¨   Þ  r«   z:SelectInLoader._init_for_omit_join_m2o.<locals>.<listcomp>)rN   r~   r1  r*   r  rZ   rž   r  )r\   r  r  r  Zlookup_colsr:   r  r;   r  Ô  s    
ÿz&SelectInLoader._init_for_omit_join_m2oc                   sj   t | jjƒ| _t| jƒ‰ ‡ fdd„| jjD ƒ}t|ƒdkrJtj|Ž }d}n|d }d}|  	dd|||d ¡S )Nc                   s   g | ]}ˆ   |¡‘qS r:   ©Ú_adapt_elementr  ©Zpa_inspr:   r;   r¨   ç  s   z1SelectInLoader._init_for_join.<locals>.<listcomp>r	   Fr   T)
r%   rH   rL   r  r(   r~   r1  r*   r  r  )r\   r  r  r  r:   r   r;   r  ä  s    

ÿ
zSelectInLoader._init_for_joinc                 C  s   | j  d¡ |¡ d S rR  rT  r’   r:   r:   r;   r�   ò  s
    ÿþz#SelectInLoader.init_class_attributec	                 C  s  |j r|  ||||||||¡S | j|||| jd�\}	}
}}|
sBd S |jjjsPd S | jj| j	 j
jspt d|  ¡‚t|ƒdkr’t |j| j¡sºd S n(t |d | j¡sº| j |d j¡sºd S |	}|| j }| |jdd ¡}|d urêt|ƒ}n| j}tj ||| j| j| j||||¡	 d S )NrP  r¶  r	   rA  r¯  )r›   rÇ   rN  rL  ra   r    rU  rH   rK   r4   r»  r¼  r¹   rº   r1  r3   r½  ri  rg  rN   rZ   rJ   r
   r(   rÅ   r   rH  rV  rW  )r\   rk   rb   rc   rd   rN   rl   re   rm   r4  rX  r  r@  Zselectin_pathrM  r³  r�  r:   r:   r;   rn   ÷  sr    ø
ÿû
ÿÿ	
ÿþ
ÿ
÷z#SelectInLoader.create_row_processorc	                   s¸  |rˆj |vrd S ˆj}	|	jr¤t t¡}
g }ˆj‰|D ]l\‰}ˆj‰t‡‡‡fdd„|	j	D ƒƒ}t
j|v rtˆj}	 q¤d |vr’|
|  ˆˆ|f¡ q6| ˆˆ|f¡ q6|	js¸dd„ |D ƒ}
|	j}|	j}|	jsìˆjrì‡fdd„|D ƒ}ˆ |¡}tjdg|¢R Ž }| ¡ }ˆ ¡ }tj||gttjdˆdœd	�}|	j�s@| ˆ¡}n$| ˆj¡ tˆjˆjj ƒ  ˆ¡¡}| !| "t# $d
¡¡¡}ˆ j%j&}|ˆj }|ˆ j'u �r |j(}n&|j(}ˆ j'j(}‡ fdd„t)||ƒD ƒ}|�rì|j*�rì|t +ˆ| ,ˆ ¡¡f7 }|d u�rþ| -¡ }|j.|Ž }| /d|i¡}ˆ j0�r*|j1dd�}ˆjj2�r„|	j�sjˆjj2}ˆj�r^‡fdd„|D ƒ}|j2|Ž }n‡fdd„}| 3|ˆj¡}|	j�r¢ˆ 4|
||	|ˆ |¡ nˆ 5|
|	|ˆ |¡ d S )Nc                 3  s"   | ]}ˆ j ˆˆ|tjd �V  qdS )r  N)r  r
   ZPASSIVE_NO_FETCH)rŠ   Zlk)rN   rª   Ú
state_dictr:   r;   r�   f  s   úüz0SelectInLoader._load_for_path.<locals>.<genexpr>c                 S  s$   g | ]\}}|j d  ||j|f‘qS )r	   )r4   r  )rŠ   rª   r`  r:   r:   r;   r¨   ƒ  s   ÿz1SelectInLoader._load_for_path.<locals>.<listcomp>c                   s   g | ]}ˆ   |¡‘qS r:   r  r  ©r�  r:   r;   r¨   “  s   r  r°  )Zcompile_state_pluginZplugin_subject)r  r  rœ   r  Úprimary_keysc                   s   g | ]\}}|  ˆ |¡‘qS r:   )Z'_adapt_cached_option_to_uncached_option)rŠ   Zorig_optZuncached_opt)rk   r:   r;   r¨   å  s   ýÿr  T)r;  c                   s   g | ]}ˆ   |¡‘qS r:   r  râ   r"  r:   r;   r¨     s   ÿc                   s    |  j tt ˆ jj¡ƒ7  _ d S r2   r˜  r›  r§   r:   r;   rœ  
  s    ÿz?SelectInLoader._load_for_path.<locals>._setup_outermost_orderby)6r4   r  r  r§  r¨  rí   rH   r  rš  r  r   r¯   r  rF   r  r  r  r×   r  r3   ZBundler"  r-   r#  r,   r   r$  r%  r  r�  rd  rZ   r�  ÚfilterZin_r*   ró   ra   Zselect_statementZuser_passed_queryr)  Úzipr‘   r(  r9  rZ  r”  Z_update_compile_optionsr;  r  rç   r�  Ú_load_via_childÚ_load_via_parent)r\   rk   rc   r]  r^  r�  rd   r@  r  r  Ú
our_statesÚnone_statesr`  Zrelated_identr  r  Z
bundle_entZ
bundle_sqlZ
entity_sqlr  r}  r4  r–  Zcached_optionsZuncached_optionsr™  rœ  r:   )rk   r�  rN   r\   rª   r!  r;   rW  N  sÆ    
ù
ÿþ
ÿ
þü
ÿÿ

ÿü	þÿ



þÿú	
ÿzSelectInLoader._load_for_pathc                   sö   | j }t|ƒ}|r¼|d| j… }	|| jd … }dd„ |jj|d‡ fdd„|	D ƒi|d� ¡ D ƒ}
|	D ]T}|
 |d ¡}|| D ]:\}}}|s–| j|v r–q|| | j¡ 	|||s®|n|g¡ q|qdq|D ]0\}}}|sÚ| j|v rÚqÀ| | j¡ 	||d ¡ qÀd S )Nr   c                 S  s   i | ]\}}||“qS r:   r:   )rŠ   r©   r­  r:   r:   r;   Ú
<dictcomp>1  s   ÿz2SelectInLoader._load_via_child.<locals>.<dictcomp>r#  c                   s   g | ]}ˆ j r|d  n|‘qS rc  ©r  )rŠ   r4   ©r  r:   r;   r¨   6  s   ÿz2SelectInLoader._load_via_child.<locals>.<listcomp>©rø   r  )
r>   ÚsortedÚ
_chunksizer·   r/  rñ   rJ   r4   r[  r\  )r\   r(  r)  r  r  rk   r  r>   Zour_keysÚchunkÚdatar4   Zrelated_objrª   rÍ   r`  r:   r,  r;   r&  !  s:    	þÿøþý
zSelectInLoader._load_via_childc                   s$  | j }|rdnd }|�r |d| j… }|| jd … }‡ fdd„|D ƒ}	t t¡}
t |jj|d|	i|d� 	¡ dd„ ¡D ] \}}|
|  
d	d
„ |D ƒ¡ qv|D ]€\}}}}|s¸| j|v r¸qœ|
 ||¡}|�s|�rt|ƒdkrêt d|  ¡ | | j¡ |||d ¡ qœ| | j¡ |||¡ qœqd S )Nr:   r   c                   s&   g | ]\}}}}ˆ j r|d  n|‘qS rc  r+  )rŠ   r4   rª   r!  r`  r,  r:   r;   r¨   b  s   
ÿz3SelectInLoader._load_via_parent.<locals>.<listcomp>r#  r-  c                 S  s   | d S ry   r:   r£  r:   r:   r;   r<   n  r«   z1SelectInLoader._load_via_parent.<locals>.<lambda>c                 s  s   | ]}|d  V  qdS )r	   Nr:   r¥  r:   r:   r;   r�   p  r«   z2SelectInLoader._load_via_parent.<locals>.<genexpr>r	   rÊ  )r>   r/  r§  r¨  rí   r©  rª  r·   r/  rñ   r«  r4   rJ   r1  r   r2  r[  r\  )r\   r(  r  r  rk   r  r>   Z_empty_resultr0  r#  r1  r©   r­  r4   rª   r!  r`  rÁ  r:   r,  r;   r'  X  sF    
þ
ýúþÿ
ÿÿzSelectInLoader._load_via_parent)ro   rp   rq   rs   r§  Ú
namedtupler  r/  rY   r  r  r  r�   rn   rW  r&  r'  rt   r:   r:   r^   r;   r	  ‡  s    þW T7r	  c                   sT   ‡fdd„‰ ‡ fdd„}‡ fdd„}t j| d|dddd	� t j| d
|dddd	� d S )Nc                   sT   |d urP|j ˆ j krP| t |¡¡}|rP||urPtjdt |¡| jˆ f dd�‚|S )NzsInstance %s is already associated with an instance of %s via its %s attribute, and is only allowed a single parent.Zbbf1)Úcode)	r4   Ú	hasparentr
   Zinstance_stater¹   rº   r3   Zinstance_strrL   )rª   rö   ÚoldvalueÚ	initiatorr4  )r7   r:   r;   Ú	_do_check‹  s    ýûz*single_parent_validator.<locals>._do_checkc                   s   ˆ | |d |ƒS r2   r:   )rª   rö   r6  ©r7  r:   r;   rF   ˜  s    z'single_parent_validator.<locals>.appendc                   s   ˆ | |||ƒS r2   r:   )rª   rö   r5  r6  r8  r:   r;   Úset_›  s    z%single_parent_validator.<locals>.set_rF   T)ÚrawÚretvalrC   r¡   )r'   Úlisten)r6   r7   rF   r9  r:   )r7  r7   r;   rG   Š  s    ÿrG   )NNNNFN)Xrr   Ú
__future__r   r§  r©  Útypingr   r   r   r   r   r   Ú r
   r   r±   r   r   r   r   r   r   r   r   r3   Úbaser   r   r   r   r   r   r   rk   r   r   r   r   r   r    r·   r!   rª   r"   r   r#   r$   r%   r'   r¹   r(   r)   r*   rà   r+   Zsql.selectabler,   r-   Zutil.typingr.   rN   r/   r0   Zsql.elementsr1   r:  rR   ZColumnPropertyZstrategy_forrU   Zclass_loggerru   r‡   r”   r½   rÃ   rÈ   rÉ   ZMemoizedSlotsZ
IdentifiedrÒ   r8  r?  rO  rb  rÍ  r	  rG   r:   r:   r:   r;   Ú<module>
   s         ÷
Q+ZWÿ 0%
&

ÿ    24Lc           ;    