a
    •˜ëjNŸ  ã                
   @  sÐ  d dl mZ d dlmZ d dl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' ej�r´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m1Z1 dd*l2m3Z3 dd+l(m4Z4 dd,l(m5Z5 dd-l(m6Z6 dd.l(m7Z7 dd/l(m8Z8 dd0l(m9Z9 dd1l(m:Z: dd2l*m;Z; dd3l+m<Z< dd4l+m=Z= dd5l+m>Z> dd6l+m?Z? dd7l+m@Z@ dd8l+mAZA dd9lmBZB ed:ejCd;�ZDed<e	d=ef d;�ZEed>ejFd;�ZGed?ed;�ZHd@dAdBœdCdD„ZIdEdF„ ZJdGdGdGdHdIœdJdK„ZKdGdGdLdMdNœdOdP„ZLedQd@d@dGdRœdSdT„ƒZMed=dUœdVd@dWd@dGdXœdYdT„ƒZMedZd@d@d[dRœd\dT„ƒZMed]d@d@d^dRœd_dT„ƒZMed`d@d@d^dRœdadT„ƒZMedbd@d@dcdRœdddT„ƒZMededfd@dgdRœdhdT„ƒZMedidjd@dkdRœdldT„ƒZMedmd@d@dndRœdodT„ƒZMedpdqd@drdRœdsdT„ƒZMedtdud@dudRœdvdT„ƒZMedwdxd@dxdRœdydT„ƒZMedzd{d@d|dRœd}dT„ƒZMed=d~œdzdxdWd@dd€œd�dT„ƒZMed‚dƒd@d„dRœd…dT„ƒZMed†d‡d@d‡dRœdˆdT„ƒZMed‰d@d@d@dRœdŠdT„ƒZMddd‹d‹dŒœd‰d@d�dŽdAdAd@d@d�œd�dT„ZMdVd@d@dGdRœd‘d’„ZNd`d“d”d•œd–d—„ZOG d˜d™„ d™ƒZPG dšd›„ d›ƒZQG dœd�„ d�ƒZRG dždŸ„ dŸePƒZSG d d¡„ d¡ePƒZTde#jUddfd@dŽd¢dŽd£d¤d¥œd¦d§„ZVG d¨d©„ d©ePƒZWG dªd«„ d«ePƒZXG d¬d­„ d­ePƒZYG d®d¯„ d¯ePƒZZG d°d±„ d±ePƒZ[G d²d³„ d³ePƒZ\G d´dµ„ dµeTePƒZ]G d¶d·„ d·e]ePƒZ^G d¸d¹„ d¹ePƒZ_G dºd»„ d»eTePƒZ`G d¼d½„ d½eXeTePƒZaG d¾d¿„ d¿eXePƒZbG dÀdÁ„ dÁeWePƒZcG dÂdÃ„ dÃeSePƒZdG dÄdÅ„ dÅeXePƒZeG dÆdÇ„ dÇeXeTePejfƒZgG dÈdÉ„ dÉegePƒZhG dÊdË„ dËegePƒZiG dÌdÍ„ dÍeSePƒZjG dÎdÏ„ dÏePƒZkG dÐdÑ„ dÑeRePƒZlG dÒdÓ„ dÓeQeXePƒZmG dÔdÕ„ dÕeQeSePƒZnG dÖd×„ d×enƒZoG dØdÙ„ dÙePƒZpG dÚdÛ„ dÛe]ƒZqG dÜdÝ„ dÝeZeXePƒZrG dÞdß„ dßePƒZsG dàdá„ dáeXePƒZtG dâdã„ dãeWePƒZuG dädå„ dåesƒZvG dædç„ dçePƒZwG dèdé„ déePƒZxG dêdë„ dëeZeWePƒZyG dìdí„ díeyƒZzG dîdï„ dïezƒZ{G dðdñ„ dñeZeWePƒZ|G dòdó„ dóeWePƒZ}G dôdõ„ dõeWePƒZ~i Ze€eƒD ]JZ�e‚ee�ƒZƒe� „dö¡�rNe� …död÷¡Z�e�e†ƒ v �rNe†ƒ e� eƒƒZ‡e‡eeƒ< �qNe�sÌeejˆ Z‰eŠe‹eŒe�fD ]ZŽe‰eejˆeŽ < �q¶dS )øé    )ÚannotationsN)ÚAny)ÚCallable)Úcast)ÚDict)ÚIterable)ÚIterator)ÚList)ÚNoReturn)ÚOptional)Úoverload)ÚSequence)ÚTuple)ÚType)ÚTYPE_CHECKING)ÚTypeVar)ÚUnioné   )Úroles)Úvisitors)Úis_from_clause)ÚExecutableOption)ÚOptions)ÚHasCacheKey)Ú	Visitableé   )Úexc)Ú
inspection)Úutil)ÚLiteral)Úelements)Úlambdas)Úschema)Ú
selectable)Ú_ColumnExpressionArgument)Ú_ColumnsClauseArgument)Ú_DDLColumnArgument)Ú_DMLTableArgument)Ú_FromClauseArgument)Ú_OnlyColumnArgument)Ú_DMLTableElement)ÚBindParameter)ÚClauseElement)ÚColumnClause)ÚColumnElement)ÚNamedColumn)ÚSQLCoreOperations)Ú
TextClause)ÚColumn)Ú_ColumnsClauseElement)Ú_JoinTargetProtocol)Ú
FromClause)ÚHasCTE)Ú
SelectBase)ÚSubquery)Ú_TraverseCallableTypeÚ_SR)ÚboundÚ_F.Ú_StringOnlyRÚ_Tr   Úbool)ÚelementÚreturnc                 C  s   t | ttjfƒ ot| dƒ S )zhReturn whether or not the element is a "literal" in the context
    of a SQL expression construct.

    Ú__clause_element__)Ú
isinstancer   r"   ÚSchemaEventTargetÚhasattr)r@   © rF   úW/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/sql/coercions.pyÚ_is_literalO   s    þ
ýrH   c                 C  sr   t | tjƒr2t | tƒs2| D ]}t|ƒs dS qdS t | ttjtt	t
jjfƒ opt| dƒ opt | tƒ ppt| tƒ S )a  Return whether or not the element is a "literal" in the context
    of a SQL expression construct.

    does a deeper more esoteric check than _is_literal.   is used
    for lambda elements that have to distinguish values that would
    be bound vs. not without any context.

    FTrB   )rC   Úcollections_abcr   ÚstrÚ_deep_is_literalr   r"   rD   r   r   r   ZlanghelpersÚsymbolrE   ÚtypeÚ
issubclass)r@   ÚelemrF   rF   rG   rK   [   s*    
ÿûþ

ö
òrK   rJ   zCallable[[_F], _F])Ú	paramnameÚmeth_rstÚ	param_rstrA   c                 C  s   t  | d||f ¡S )NzÆ.. warning:: The %s argument to %s can be passed as a Python string argument, which will be treated as **trusted SQL text** and rendered as given.  **DO NOT PASS UNTRUSTED INPUT TO THIS PARAMETER**.)r   Zadd_parameter_text)rP   rQ   rR   rF   rF   rG   Ú_document_text_coercion�   s    ùþrS   z+Union[Sequence[_T], Sequence[Sequence[_T]]]úSequence[_T])ÚattrnameÚfnnameÚargsrA   c                 C  sb   |rXt |d tttfƒrXt|ƒdkrXt |d tƒrJt d| › d|› d�¡‚td|d ƒS td|ƒS )Nr   r   zThe "z" argument to zt(), when referring to a sequence of items, is now passed as a series of positional elements, rather than as a list. rT   )rC   ÚlistÚsetÚdictÚlenr   ÚArgumentErrorr   )rU   rV   rW   rF   rF   rG   Ú!_expression_collection_was_a_list‘   s    $ÿr]   zType[roles.TruncatedLabelRole])Úroler@   ÚkwrA   c                 K  s   d S ©NrF   ©r^   r@   r_   rF   rF   rG   Úexpect£   s    rb   ©Úas_keyzType[roles.DMLColumnRole]zLiteral[True])r^   r@   rd   r_   rA   c                K  s   d S r`   rF   )r^   r@   rd   r_   rF   rF   rG   rb   «   s    zType[roles.LiteralValueRole]zBindParameter[Any]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   µ   s    z!Type[roles.DDLReferredColumnRole]zUnion[Column[Any], str]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   ½   s    z#Type[roles.DDLConstraintColumnRole]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   Å   s    zType[roles.StatementOptionRole]z%Union[ColumnElement[Any], TextClause]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   Í   s    z&Type[roles.LabeledColumnExprRole[Any]]z=Union[_ColumnExpressionArgument[_T], _OnlyColumnArgument[_T]]zNamedColumn[_T]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   Õ   s    zgUnion[Type[roles.ExpressionElementRole[Any]], Type[roles.LimitOffsetRole], Type[roles.WhereHavingRole]]z_ColumnExpressionArgument[_T]zColumnElement[_T]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   Ý   s    	z¡Union[Type[roles.ExpressionElementRole[Any]], Type[roles.LimitOffsetRole], Type[roles.WhereHavingRole], Type[roles.OnClauseRole], Type[roles.ColumnArgumentRole]]zColumnElement[Any]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   é   s    zType[roles.DMLTableRole]r'   r*   c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   ÷   s    zType[roles.HasCTERole]r6   c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   ÿ   s    zType[roles.SelectStatementRole]r7   c                 K  s   d S r`   rF   ra   rF   rF   rG   rb     s    zType[roles.FromClauseRole]r(   r5   c                 K  s   d S r`   rF   ra   rF   rF   rG   rb     s    )Úexplicit_subqueryr8   )r^   r@   re   r_   rA   c                K  s   d S r`   rF   )r^   r@   re   r_   rF   rF   rG   rb     s    zType[roles.ColumnsClauseRole]z_ColumnsClauseArgument[Any]r3   c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   !  s    zType[roles.JoinTargetRole]r4   c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   )  s    z	Type[_SR]c                 K  s   d S r`   rF   ra   rF   rF   rG   rb   2  s    F)Úapply_propagate_attrsÚargnameÚpost_inspectÚdisable_inspectionzOptional[ClauseElement]úOptional[str])r^   r@   rf   rg   rh   ri   r_   rA   c                K  s  | j r6t|ƒr6t|dƒr6tj|| tjf i |¤Ž|d�S t|  }|}t|tj	t
jt
jtjfƒ�sZd }	|jr||j|fi |¤Ž}	nÜ|}d}
|jr¤t|| ƒr¤t|dƒr¤d}
n(t|dƒrÌd}
t|ddƒsÌ| ¡ }q¤qÌq¤|
�sT|j�r2|�s2tj|dd�}|d u�r2|�r|j z| ¡ }	W n  t�y0   | ||¡ Y n0 |	d u �rX|j|fd|i|¤Ž}	n|}	n$t|tjƒ�rz|jf i |¤Ž}	n|}	|d u�rÂtj�r¤t|	ttfƒ�s¤J ‚|j�sÂt|	d	d ƒ�rÂ|	j|_|j|	j j!v �rö|j"�rò|j"|	f||d
œ|¤Ž}	|	S |j#||	fd|i|¤ŽS d S )NÚ__code__)rf   FrB   TÚis_clause_element)Zraiseerrrg   Ú_propagate_attrs)rg   Úoriginal_element)$Úallows_lambdaÚcallablerE   r!   ZLambdaElementZLambdaOptionsÚ_impl_lookuprC   r    ZCompilerElementr"   Z
SchemaItemZFetchedValueZ	PyWrapperÚ_resolve_literal_onlyÚ_literal_coercionÚ$_skip_clauseelement_for_target_matchÚgetattrrB   Ú_use_inspectionr   ÚinspectZ_post_inspectÚAttributeErrorÚ_raise_for_expectedZ_sa__py_wrapper_literalÚtypingr   r0   r,   rm   Ú_role_classÚ	__class__Ú__mro__Ú_post_coercionÚ_implicit_coercions)r^   r@   rf   rg   rh   ri   r_   Úimplrn   Úresolvedrl   ZinsprF   rF   rG   rb   :  s¬    ÿúù	ü	üþ	ÿþý



ÿÿÿ

ÿÿýüÿÿÿc                 K  s"   |  dd ¡ t| |fddi|¤ŽS )Nrd   T)Úpoprb   ra   rF   rF   rG   Úexpect_as_key®  s    rƒ   zIterable[_DDLColumnArgument]zwIterator[Tuple[Union[str, Column[Any]], Optional[ColumnClause[Any]], Optional[str], Optional[Union[Column[Any], str]]]])r^   ÚexpressionsrA   c           	      c  sˆ   |D ]~}d }d }t | |ƒ}t|tƒr<t|tƒs2J ‚| }}n(g }|j}t |i d|i¡ |rd|d }|d urp|n|}||||fV  qd S )NÚcolumnr   )rb   rC   rJ   Úappendr   Útraverse)	r^   r„   ÚexprZstrnamer…   r�   ÚcolsZ
col_appendZadd_elementrF   rF   rG   Ú expect_col_expression_collectionµ  s    


rŠ   c                   @  sv   e Zd ZU dZdd„ ZdZded< dZdZdd	„ Z	dddd
dddœdd„Z
dddddœdd
dd
d
ddddœdd„ZdS )ÚRoleImpl)r{   Únamerv   c                 K  s
   t ƒ ‚d S r`   )ÚNotImplementedError©Úselfr@   r_   rF   rF   rG   rs   Ö  s    zRoleImpl._literal_coercionNr   r~   Fc                 C  s    || _ |j| _t|tjƒ| _d S r`   )r{   Z
_role_namerŒ   rN   r   ZUsesInspectionrv   )r�   Z
role_classrF   rF   rG   Ú__init__Ý  s    zRoleImpl.__init__rj   ©r@   r�   rg   r_   rA   c                 K  s   |   |||¡ d S r`   ©ry   ©r�   r@   r�   rg   r_   rF   rF   rG   r   â  s    zRoleImpl._implicit_coercions©ÚadviceÚcodeÚerrúOptional[Any]úOptional[Exception]r
   ©r@   rg   r�   r•   r–   r—   r_   rA   c          
      K  sn   |d ur||urd||f }nt |ƒ}|r<d| j||f }	nd| j|f }	|rZ|	d| 7 }	tj|	|d�|‚d S )Nz!%r object resolved from %r objectz$%s expected for argument %r; got %s.z%s expected, got %s.ú )r–   )ÚreprrŒ   r   r\   )
r�   r@   rg   r�   r•   r–   r—   r_   ÚgotÚmsgrF   rF   rG   ry   ë  s    ýzRoleImpl._raise_for_expected)N)NN)Ú__name__Ú
__module__Ú__qualname__Ú	__slots__rs   r~   Ú__annotations__rr   rt   r�   r   ry   rF   rF   rF   rG   r‹   Ó  s   
	 ü  üør‹   c                   @  s   e Zd ZdZdd„ ZdS )Ú_DeannotaterF   c                 K  s   ddl m} ||ƒS )Nr   )Ú_deep_deannotate)r   r¥   )r�   r�   r_   r¥   rF   rF   rG   r~     s    z_Deannotate._post_coercionN©rŸ   r    r¡   r¢   r~   rF   rF   rF   rG   r¤   
  s   r¤   c                   @  s   e Zd ZdZdZdS )Ú_StringOnlyrF   TN)rŸ   r    r¡   r¢   rr   rF   rF   rF   rG   r§     s   r§   c                   @  s"   e Zd ZdZddd„Zdd„ ZdS )Ú_ReturnsStringKeyrF   Nc                 K  s    t |tƒr|S |  |||¡ d S r`   ©rC   rJ   ry   r“   rF   rF   rG   r     s    
z%_ReturnsStringKey._implicit_coercionsc                 K  s   |S r`   rF   rŽ   rF   rF   rG   rs   "  s    z#_ReturnsStringKey._literal_coercion)N©rŸ   r    r¡   r¢   r   rs   rF   rF   rF   rG   r¨     s   
r¨   c                   @  s"   e Zd ZdZdd„ Zddd„ZdS )Ú_ColumnCoercionsrF   c                 C  s   t  d¡ d S )Nz|implicitly coercing SELECT object to scalar subquery; please use the .scalar_subquery() method to produce a scalar subquery.)r   Úwarn)r�   rF   rF   rG   Ú"_warn_for_scalar_subquery_coercion)  s    ÿz3_ColumnCoercions._warn_for_scalar_subquery_coercionNc                 K  s~   |}t |ddƒs |  |||¡ nZ|jr6|  ¡  | ¡ S |jrZt|tjƒrZ|  ¡  |j	 ¡ S | j
jrl|jrl|S |  |||¡ d S )Nrl   F)ru   ry   Ú_is_select_baser­   Úscalar_subqueryÚ_is_from_clauserC   r#   r8   r@   r{   ro   Ú_is_lambda_element)r�   r@   r�   rg   r_   rn   rF   rF   rG   r   0  s    ÿ
z$_ColumnCoercions._implicit_coercions)N)rŸ   r    r¡   r¢   r­   r   rF   rF   rF   rG   r«   &  s   r«   zType[exc.SQLAlchemyError]r™   r
   )r@   rg   Úexc_clsÚextrar—   rA   c                 C  s:   |dt  | ¡|rd|f nd|r(d| nddœ ƒ|‚d S )Nzc%(extra)sTextual SQL expression %(expr)r %(argname)sshould be explicitly declared as text(%(expr)r)úfor argument %sÚ z%s )rˆ   rg   r³   )r   Úellipses_string)r@   rg   r²   r³   r—   rF   rF   rG   Ú_no_text_coercionB  s    ýþÿør·   c                   @  s   e Zd ZdZddœdd„ZdS )Ú_NoTextCoercionrF   N©rg   c                K  s4   t |tƒr$ttj| jƒr$t||ƒ n|  ||¡ d S r`   )rC   rJ   rN   r    r1   r{   r·   ry   ©r�   r@   rg   r_   rF   rF   rG   rs   W  s
    ÿz!_NoTextCoercion._literal_coercion©rŸ   r    r¡   r¢   rs   rF   rF   rF   rG   r¸   T  s   r¸   c                   @  s4   e Zd ZdZdZdZdZd	dd„Zddœdd„ZdS )
Ú_CoerceLiteralsrF   FNc                 C  s
   t ||ƒS r`   ©r·   ©r�   r@   rg   rF   rF   rG   Ú_text_coercionf  s    z_CoerceLiterals._text_coercionr¹   c                K  s¤   t |tƒr:| jr&|dkr&tjddd�S | j||fi |¤ŽS | jrp|d u rPt ¡ S |du r`t ¡ S |du rpt 	¡ S | j
r”t |tjƒr”tjt|ƒdd�S |  ||¡ d S )NÚ*T)Z
is_literalF)rC   rJ   Ú_coerce_starr    r-   r¿   Ú_coerce_constsÚNullÚFalse_ÚTrue_Ú_coerce_numericsÚnumbersÚNumberry   rº   rF   rF   rG   rs   i  s    
z!_CoerceLiterals._literal_coercion)N)	rŸ   r    r¡   r¢   rÂ   rÁ   rÆ   r¿   rs   rF   rF   rF   rG   r¼   `  s   
r¼   c                   @  s*   e Zd ZdZd	dddœdd„Zdd„ ZdS )
ÚLiteralValueImplTNF)Útype_Úliteral_executec                K  s4   t |ƒs | j|f||dœ|¤Ž tjd ||d|d�S )N)r�   rg   T)rÊ   ÚuniquerË   )rH   ry   r    r+   )r�   r@   r�   rg   rÊ   rË   r_   rF   rF   rG   r   �  s    
ÿÿÿûz$LiteralValueImpl._implicit_coercionsc                 K  s   |S r`   rF   rŽ   rF   rF   rG   rs   ˜  s    z"LiteralValueImpl._literal_coercion)N)rŸ   r    r¡   rr   r   rs   rF   rF   rF   rG   rÉ   ~  s    üùrÉ   c                      s@   e Zd ZdZdddddœddddddddd	œ‡ fd
d„Z‡  ZS )Ú_SelectIsNotFromrF   Nr”   r   rj   r˜   r™   r
   rš   c                  sj   |st |tjƒst |tjƒr:d|d ur,|jn|f }d}nd }tƒ j|f|||||dœ|¤Ž dsfJ ‚d S )NzETo create a FROM clause from a %s object, use the .subquery() method.Z89ve)rg   r�   r•   r–   r—   F)rC   r   ZSelectStatementRoler|   Úsuperry   )r�   r@   rg   r�   r•   r–   r—   r_   ©r|   rF   rG   ry   Ÿ  s0    ÿ
þ
ýþÿÿúù
z$_SelectIsNotFrom._raise_for_expected)NN©rŸ   r    r¡   r¢   ry   Ú__classcell__rF   rF   rÏ   rG   rÍ   œ  s     üørÍ   c                   @  s0   e Zd ZdZd
ddddddœdd„Zdd	„ ZdS )ÚHasCacheKeyImplrF   Nr   rj   r‘   c                 K  s    t |tƒr|S |  |||¡ d S r`   )rC   r   ry   r“   rF   rF   rG   r   È  s    
z#HasCacheKeyImpl._implicit_coercionsc                 K  s   |S r`   rF   rŽ   rF   rF   rG   rs   Ô  s    z!HasCacheKeyImpl._literal_coercion)Nrª   rF   rF   rF   rG   rÒ   Å  s    ürÒ   c                   @  s0   e Zd ZdZd
ddddddœdd„Zdd	„ ZdS )ÚExecutableOptionImplrF   Nr   rj   r‘   c                 K  s    t |tƒr|S |  |||¡ d S r`   )rC   r   ry   r“   rF   rF   rG   r   Û  s    
z(ExecutableOptionImpl._implicit_coercionsc                 K  s   |S r`   rF   rŽ   rF   rF   rG   rs   ç  s    z&ExecutableOptionImpl._literal_coercion)Nrª   rF   rF   rF   rG   rÓ   Ø  s    ürÓ   c                      s4   e Zd ZdZddddœdd„Zd	‡ fdd„	Z‡  ZS )
ÚExpressionElementImplrF   NF)rŒ   rÊ   Úis_crudc             
   K  sr   |d u r"|s"|d u s|j s"t ¡ S ztj|||d|d�W S  tjyl } z| j||d� W Y d }~n
d }~0 0 d S )NT)rÌ   Z_is_crud©r—   )Zshould_evaluate_noner    rÃ   r+   r   r\   ry   )r�   r@   rŒ   rÊ   rÕ   r_   r—   rF   rF   rG   rs   î  s    ÿþýý
ÿz'ExpressionElementImpl._literal_coercionc                   sD   t |tjƒrd}nt |tjƒr$d}nd }tƒ j|f|||dœ|¤ŽS )NzTTo create a column expression from a VALUES clause, use the .scalar_values() method.z`To create a column expression from a FROM clause row as a whole, use the .table_valued() method.©rg   r�   r•   )rC   r#   ÚValuesr   ZAnonymizedFromClauseRolerÎ   ry   ©r�   r@   rg   r�   r_   r•   rÏ   rF   rG   ry     s    ÿÿÿÿÿz)ExpressionElementImpl._raise_for_expected)NN)rŸ   r    r¡   r¢   rs   ry   rÑ   rF   rF   rÏ   rG   rÔ   ë  s   ÿrÔ   c                   @  s.   e Zd ZdZdddœdd„Zddœdd„ZdS )	ÚBinaryElementImplrF   N)Úbindparam_typerg   c             
   K  sL   z|j |||d�W S  tjyF } z| j||d� W Y d }~n
d }~0 0 d S )N)rÊ   rÖ   )Ú_bind_paramr   r\   ry   )r�   r@   rˆ   ÚoperatorrÛ   rg   r_   r—   rF   rF   rG   rs     s    
z#BinaryElementImpl._literal_coercion)rÛ   c                K  s,   |j jr(|j js(| |d ur |n|j ¡}|S r`   )rM   Z_isnullZ_with_binary_element_type)r�   r�   rˆ   rÛ   r_   rF   rF   rG   r~   (  s
    ÿz BinaryElementImpl._post_coercion)rŸ   r    r¡   r¢   rs   r~   rF   rF   rF   rG   rÚ     s
   ùrÚ   c                   @  sJ   e Zd ZdZdddddddœdd„Zdd	„ Ze d
¡dd„ ƒZdd„ Z	dS )ÚInElementImplrF   Nr   rj   r‘   c                 K  sl   |j rZt|tjƒr8|jjr8|  |¡ | j|jfi |¤ŽS |  |¡ | j| ¡ fi |¤ŽS n|  	|||¡ d S r`   )
r°   rC   r#   ÚAliasr@   r®   Ú_warn_for_implicit_coercionr~   Úselectry   r“   rF   rF   rG   r   3  s    
ÿþ

z!InElementImpl._implicit_coercionsc                 C  s   t  d|jj ¡ d S )Nz_Coercing %s object into a select() for use in IN(); please pass a select() construct explicitly)r   r¬   r|   rŸ   )r�   rO   rF   rF   rG   rà   G  s
    þÿz)InElementImpl._warn_for_implicit_coercionzsqlalchemy.sql.elementsc                  s¦   t  |¡r�i ‰t|ƒ}|D ]B}t|ƒst|t jjjƒsTt|dƒsT| j	|fi |¤Ž q|ˆ|< qˆr~t
j‡ ‡‡fdd„|D ƒŽ S ˆ jˆ|dd�S n| j	|fi |¤Ž d S )NrB   c                   s(   g | ] }|ˆv rˆ| n
ˆ   ˆ|¡‘qS rF   )rÜ   )Ú.0Úo©rˆ   Znon_literal_expressionsrÝ   rF   rG   Ú
<listcomp>b  s   ýÿ
z3InElementImpl._literal_coercion.<locals>.<listcomp>T)Ú	expanding)r   Zis_non_string_iterablerX   rH   rC   Z	preloadedZsql_elementsr.   rE   ry   r    Ú
ClauseListrÜ   )r�   r@   rˆ   rÝ   r_   rã   rF   rä   rG   rs   N  s*    
ý
ÿþ
úÿzInElementImpl._literal_coercionc                K  s|   |j r| ¡ S t|tjƒr8t|jƒdkr,J ‚|j|d�S t|tjƒr`|j	dd�}d|_
||_|S t|tjƒrt| ¡ S |S d S )Nr   )ZagainstT)Zmaintain_key)r®   r¯   rC   r    rç   r[   ZclausesZ
self_groupr+   Z_cloneræ   Z	expand_opr#   rØ   Zscalar_values)r�   r@   rˆ   rÝ   r_   rF   rF   rG   r~   q  s    zInElementImpl._post_coercion)N)
rŸ   r    r¡   r¢   r   rà   r   Zpreload_modulers   r~   rF   rF   rF   rG   rÞ   0  s    ü
"rÞ   c                   @  s*   e Zd ZdZdZdd„ Zddœdd„ZdS )	ÚOnClauseImplrF   Tc                 K  s   |   |¡ d S r`   r’   rŽ   rF   rF   rG   rs   ‹  s    zOnClauseImpl._literal_coercionN)rn   c                K  s   t |tjƒr|S |S r`   )rC   r   ÚJoinTargetRole)r�   r�   rn   r_   rF   rF   rG   r~   Ž  s    zOnClauseImpl._post_coercion)rŸ   r    r¡   r¢   rÂ   rs   r~   rF   rF   rF   rG   rè   †  s   rè   c                   @  s   e Zd ZdZdZddd„ZdS )ÚWhereHavingImplrF   TNc                 C  s
   t ||ƒS r`   r½   r¾   rF   rF   rG   r¿   ž  s    zWhereHavingImpl._text_coercion)N©rŸ   r    r¡   r¢   rÂ   r¿   rF   rF   rF   rG   rê   ™  s   rê   c                   @  s   e Zd ZdZdZddd„ZdS )ÚStatementOptionImplrF   TNc                 C  s
   t  |¡S r`   ©r    r1   r¾   rF   rF   rG   r¿   §  s    z"StatementOptionImpl._text_coercion)Nrë   rF   rF   rF   rG   rì   ¢  s   rì   c                   @  s   e Zd ZdZdS )ÚColumnArgumentImplrF   N©rŸ   r    r¡   r¢   rF   rF   rF   rG   rî   «  s   rî   c                   @  s   e Zd ZdZdS )ÚColumnArgumentOrKeyImplrF   Nrï   rF   rF   rF   rG   rð   ¯  s   rð   c                   @  s   e Zd ZdZddd„ZdS )ÚStrAsPlainColumnImplrF   Nc                 C  s
   t  |¡S r`   )r    r-   r¾   rF   rF   rG   r¿   ¶  s    z#StrAsPlainColumnImpl._text_coercion)N)rŸ   r    r¡   r¢   r¿   rF   rF   rF   rG   rñ   ³  s   rñ   c                   @  s   e Zd ZdZdZddd„ZdS )ÚByOfImplrF   TNc                 C  s
   t  |¡S r`   )r    Z_textual_label_referencer¾   rF   rF   rG   r¿   ¿  s    zByOfImpl._text_coercion)Nrë   rF   rF   rF   rG   rò   º  s   rò   c                   @  s   e Zd ZdZdd„ ZdS )ÚOrderByImplrF   c                 K  s(   t || jƒr |jd ur t |¡S |S d S r`   )rC   r{   Z_order_by_label_elementr    Z_label_reference)r�   r�   r_   rF   rF   rG   r~   Æ  s    
ÿþ
zOrderByImpl._post_coercionNr¦   rF   rF   rF   rG   ró   Ã  s   ró   c                   @  s(   e Zd ZdZdddddddœdd„ZdS )	ÚGroupByImplrF   Nr   rj   r‘   c                 K  s   t |ƒrtj|jŽ S |S d S r`   )r   r    rç   Úcr“   rF   rF   rG   r   Ó  s    zGroupByImpl._implicit_coercions)N©rŸ   r    r¡   r¢   r   rF   rF   rF   rG   rô   Ð  s    ürô   c                   @  s   e Zd ZdZddœdd„ZdS )ÚDMLColumnImplrF   Frc   c                K  s   |r
|j S |S d S r`   )Úkey)r�   r@   rd   r_   rF   rF   rG   r~   ã  s    zDMLColumnImpl._post_coercionNr¦   rF   rF   rF   rG   r÷   à  s   r÷   c                   @  s   e Zd ZdZddœdd„ZdS )ÚConstExprImplrF   Nr¹   c                K  s@   |d u rt  ¡ S |du r t  ¡ S |du r0t  ¡ S |  ||¡ d S )NFT)r    rÃ   rÄ   rÅ   ry   rº   rF   rF   rG   rs   í  s    zConstExprImpl._literal_coercionr»   rF   rF   rF   rG   rù   ê  s   rù   c                   @  s0   e Zd ZdZd
ddddddœdd„Zdd	„ ZdS )ÚTruncatedLabelImplrF   Nr   rj   r‘   c                 K  s    t |tƒr|S |  |||¡ d S r`   r©   r“   rF   rF   rG   r   û  s    
z&TruncatedLabelImpl._implicit_coercionsc                 K  s   t |tjƒr|S t |¡S dS )z¸coerce the given value to :class:`._truncated_label`.

        Existing :class:`._truncated_label` and
        :class:`._anonymous_label` objects are passed
        unchanged.
        N)rC   r    Z_truncated_labelrŽ   rF   rF   rG   rs     s    z$TruncatedLabelImpl._literal_coercion)Nrª   rF   rF   rF   rG   rú   ø  s    ürú   c                   @  s   e Zd ZdZdZddd„ZdS )ÚDDLExpressionImplrF   TNc                 C  s
   t  |¡S r`   rí   r¾   rF   rF   rG   r¿     s    z DDLExpressionImpl._text_coercion)Nrë   rF   rF   rF   rG   rû     s   rû   c                   @  s   e Zd ZdZdS )ÚDDLConstraintColumnImplrF   Nrï   rF   rF   rF   rG   rü   "  s   rü   c                   @  s   e Zd ZdZdS )ÚDDLReferredColumnImplrF   Nrï   rF   rF   rF   rG   rý   &  s   rý   c                   @  s0   e Zd ZdZd
ddddddœdd„Zdd	„ ZdS )ÚLimitOffsetImplrF   Nr   rj   r‘   c                 K  s   |d u rd S |   |||¡ d S r`   r’   r“   rF   rF   rG   r   -  s    z#LimitOffsetImpl._implicit_coercionsc                K  s,   |d u rd S t  |¡}tj|||dd�S d S )NT)rÊ   rÌ   )r   Zasintr#   Z_OffsetLimitParam)r�   r@   rŒ   rÊ   r_   ÚvaluerF   rF   rG   rs   9  s    
ÿz!LimitOffsetImpl._literal_coercion)Nrª   rF   rF   rF   rG   rþ   *  s    ürþ   c                      s0   e Zd ZdZdddddddœ‡ fdd„Z‡  ZS )	ÚLabeledColumnExprImplrF   Nr   rj   r‘   c                   sX   t |tjƒr| d ¡S tƒ j||fd|i|¤Ž}t |tjƒrF| d ¡S |  |||¡ d S ©Nrg   )rC   r   ÚExpressionElementRoleÚlabelrÎ   r   ry   )r�   r@   r�   rg   r_   ÚnewrÏ   rF   rG   r   H  s    
ÿÿÿ
z)LabeledColumnExprImpl._implicit_coercions)N)rŸ   r    r¡   r¢   r   rÑ   rF   rF   rÏ   rG   r   E  s    ür   c                      sL   e Zd ZdZdZdZdZe dej	¡Z
d
ddœ‡ fdd„Zddd	„Z‡  ZS )ÚColumnsClauseImplrF   Tz^\w\S*$N)r•   c                  sF   |s*t |tƒr*dd dd„ |D ƒ¡› d�}tƒ j|f|||dœ|¤ŽS )NzDid you mean to say select(z, c                 s  s   | ]}t |ƒV  qd S r`   )rœ   )râ   ÚerF   rF   rG   Ú	<genexpr>j  ó    z8ColumnsClauseImpl._raise_for_expected.<locals>.<genexpr>z)?r×   )rC   rX   ÚjoinrÎ   ry   )r�   r@   rg   r�   r•   r_   rÏ   rF   rG   ry   d  s    ÿÿÿÿÿz%ColumnsClauseImpl._raise_for_expectedc                 C  sL   t |ƒ}| j |¡ }t dt |¡|r2d|f nd|r<dnddœ ¡‚d S )NzŸTextual column expression %(column)r %(argname)sshould be explicitly declared with text(%(column)r), or use %(literal_column)s(%(column)r) for more specificityr´   rµ   Úliteral_columnr…   )r…   rg   r
  )rJ   Ú_guess_straight_columnÚmatchr   r\   r   r¶   )r�   r@   rg   Zguess_is_literalrF   rF   rG   r¿   q  s    
üüÿz ColumnsClauseImpl._text_coercion)NN)N)rŸ   r    r¡   r¢   rÂ   rÆ   rÁ   ÚreÚcompileÚIr  ry   r¿   rÑ   rF   rF   rÏ   rG   r  [  s    ÿÿr  c                   @  s   e Zd ZdZdS )ÚReturnsRowsImplrF   Nrï   rF   rF   rF   rG   r  „  s   r  c                      s>   e Zd ZdZddœdd„Zdddddddœ‡ fd	d
„Z‡  ZS )ÚStatementImplrF   Nr¹   c                K  sD   ||ur@t |tƒs@z
|j W n" ty>   t d| d¡ Y n0 |S )Na  Object %r should not be used directly in a SQL statement context, such as passing to methods such as session.execute().  This usage will be disallowed in a future release.  Please use Core select() / update() / delete() etc. with Session.execute() and other statement execution methods.ú1.4)rC   rJ   Z_execute_on_connectionrx   r   Úwarn_deprecated)r�   r�   rn   rg   r_   rF   rF   rG   r~   ‹  s    
ÿ
úø
zStatementImpl._post_coercionr   rj   r‘   c                   s(   |j r
|S tƒ j||fd|i|¤ŽS d S r  )r±   rÎ   r   r“   rÏ   rF   rG   r   £  s    ÿÿÿz!StatementImpl._implicit_coercions)N)rŸ   r    r¡   r¢   r~   r   rÑ   rF   rF   rÏ   rG   r  ˆ  s
   ÿ ür  c                   @  s(   e Zd ZdZdddddddœdd„ZdS )	ÚSelectStatementImplrF   Nr   rj   r‘   c                 K  s    |j r| ¡ S |  |||¡ d S r`   )Ú_is_text_clauseÚcolumnsry   r“   rF   rF   rG   r   µ  s    z'SelectStatementImpl._implicit_coercions)Nrö   rF   rF   rF   rG   r  ²  s    ür  c                   @  s   e Zd ZdZdS )Ú
HasCTEImplrF   Nrï   rF   rF   rF   rG   r  Â  s   r  c                   @  s   e Zd ZdZdS )Ú	IsCTEImplrF   Nrï   rF   rF   rF   rG   r  Æ  s   r  c                	   @  sB   e Zd ZdZdZddœdd„Zdddœd	d	d
dd	d	dœdd„ZdS )ÚJoinTargetImplrF   TNr¹   c                K  s   |   ||¡ d S r`   r’   rº   rF   rF   rG   rs   Ï  s    z JoinTargetImpl._literal_coercionF)Úlegacyr   rj   r?   )r@   r�   rg   r  r_   rA   c                K  s>   t |tjƒr|S |r,|jr,tjddd� |S |  |||¡ d S ©NzÀImplicit coercion of SELECT and textual SELECT constructs into FROM clauses is deprecated; please call .subquery() on any Core select or ORM Query object in order to produce a subquery object.r  )Úversion)rC   r   ré   r®   r   r  ry   )r�   r@   r�   rg   r  r_   rF   rF   rG   r   Ò  s    	
ûz"JoinTargetImpl._implicit_coercions)N)rŸ   r    r¡   r¢   rt   rs   r   rF   rF   rF   rG   r  Ê  s    üúr  c                
   @  sB   e Zd ZdZddddœdddddddd	œd
d„Zddœdd„ZdS )ÚFromClauseImplrF   NFT)re   Úallow_selectr   rj   r?   )r@   r�   rg   re   r  r_   rA   c                K  sH   |j r,|r| ¡ S |rDtjddd� |jS n|jr6|S |  |||¡ d S r  )r®   Zsubqueryr   r  Ú_implicit_subqueryr  ry   )r�   r@   r�   rg   re   r  r_   rF   rF   rG   r   ô  s    
ûz"FromClauseImpl._implicit_coercions)Ú
deannotatec                K  s   |r|  ¡ S |S d S r`   )Z_deannotate)r�   r@   r   r_   rF   rF   rG   r~     s    zFromClauseImpl._post_coercion)N)rŸ   r    r¡   r¢   r   r~   rF   rF   rF   rG   r  ñ  s    üùr  c                	   @  s0   e Zd ZdZdddœdddddddœd	d
„ZdS )ÚStrictFromClauseImplrF   NF)r  r   rj   r?   )r@   r�   rg   r  r_   rA   c                K  s0   |j r|rtjddd� |jS |  |||¡ d S r  )r®   r   r  r  ry   )r�   r@   r�   rg   r  r_   rF   rF   rG   r     s    	
ûz(StrictFromClauseImpl._implicit_coercions)Nrö   rF   rF   rF   rG   r!    s
    üúr!  c                   @  s    e Zd ZdZdddœdd„ZdS )ÚAnonymizedFromClauseImplrF   FN)ÚflatrŒ   c                K  s   |d u sJ ‚|j |d�S )N)r#  )Z_anonymous_fromclause)r�   r@   r#  rŒ   r_   rF   rF   rG   r~   2  s    z'AnonymizedFromClauseImpl._post_coercionr¦   rF   rF   rF   rG   r"  /  s   r"  c                   @  s   e Zd ZdZdd„ ZdS )ÚDMLTableImplrF   c                 K  s   d|j v r|j d S |S d S )NZ	dml_table)Z_annotationsrŽ   rF   rF   rG   r~   ;  s    

zDMLTableImpl._post_coercionNr¦   rF   rF   rF   rG   r$  8  s   r$  c                   @  s(   e Zd ZdZdddddddœdd„ZdS )	ÚDMLSelectImplrF   Nr   rj   r‘   c                 K  s<   |j r*t|tjƒr |jjr |jS | ¡ S n|  |||¡ d S r`   )r°   rC   r#   rß   r@   r®   rá   ry   r“   rF   rF   rG   r   E  s    
ÿþ
z!DMLSelectImpl._implicit_coercions)Nrö   rF   rF   rF   rG   r%  B  s    ür%  c                      s"   e Zd ZdZd‡ fdd„	Z‡  ZS )ÚCompoundElementImplrF   Nc                   s>   t |tjƒr|jrd}q"d}nd }tƒ j|f|||dœ|¤ŽS )NzFUse the plain select() object without calling .subquery() or .alias().z9To SELECT from any FROM clause, use the .select() method.r×   )rC   r   ZFromClauseRoleZ_is_subqueryrÎ   ry   rÙ   rÏ   rF   rG   ry   [  s    ÿÿÿÿÿz'CompoundElementImpl._raise_for_expected)NNrÐ   rF   rF   rÏ   rG   r&  X  s   r&  ZRoleZImpl)�Ú
__future__r   Úcollections.abcÚabcrI   rÇ   r  rz   r   r   r   r   r   r   r	   r
   r   r   r   r   r   r   r   r   rµ   r   r   Ú_typingr   Úbaser   r   Ú	cache_keyr   r   r   r   r   Zutil.typingr   r    r!   r"   r#   r$   r%   r&   r'   r(   r)   Zdmlr*   r+   r,   r-   r.   r/   r0   r1   r2   r3   r4   r5   r6   r7   r8   r9   ZSQLRoler:   r<   Z
StringRoler=   r>   rH   rK   rS   r]   rb   rƒ   rŠ   r‹   r¤   r§   r¨   r«   r\   r·   r¸   r¼   rÉ   rÍ   rÒ   rÓ   rÔ   rÚ   rÞ   rè   rê   rì   rî   rð   rñ   ZByOfRolerò   ró   rô   r÷   rù   rú   rû   rü   rý   rþ   r   r  r  r  r  r  r  r  r  r!  r"  r$  r%  r&  rq   ÚdirrŒ   ru   ÚclsÚendswithÚreplaceÚglobalsr€   r  Zee_implÚintr?   rJ   ÚfloatZpy_typerF   rF   rF   rG   Ú<module>	   sT  &ü	ü	ù t7	û)+V			
)*'%	


