a
    •˜ëjƒ4  ã                   @  sø  U d dl m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 e�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'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*l.m2Z2 dd+l.m3Z3 dd,l.m4Z4 dd-l5m6Z6 dd.lm7Z7 dd/l8m9Z9 dd0l:m;Z; dd1l:m<Z< dd2l:m=Z= dd3l:m>Z> dd4l:m?Z? dd5l:m@Z@ dd6l:mAZA dd7l:mBZB dd8l:mCZC dd9l:mDZD dd:l:mEZE dd;l:mFZF dd<lGmHZH dd=lGmIZI dd>lJmKZK dd?lLmMZM dd@lLmNZN ddAlLmOZO ddBlPmQZQ ddClmRZR edDedE�ZSedFedGdH�ZTedIdJdE�ZUedKdLdE�ZVG dMdN„ dNeeeT ƒZWG dOdP„ dPeƒZXG dQdR„ dReƒZYedSeZe[e\dTdUdVdWdXe]dYƒZ^edZ Z_ed[ej`e_ee eeWe  eWe ƒZaee[d\d]eWeS ejbeS f ZceejdeS ej`d^e_eeS eeWeS  eWeS f ZeeejdeS d^eeS f Zfed_eed`f dE�ZgedaedE�ZhedbedE�ZiedcedE�ZjeddedE�ZkedeedE�ZledfedE�ZmedgedE�ZnedhedE�ZoediedE�ZpedjedE�Zqed]eWeS ejrf Zsed]eWeS d^ejbeS ejdeS eg d]f dkf ZteteS Zudlevdm< eeeteS f Zwee[eteS f Zxeeexe  exe f Zyeeef Zzeej7ejde ee eeWe  eWe f Z{ee{ej|f Z}eete ej~f Zedndoej€f Z�ee[eWe ejrdpf Z‚edqe‚dE�Zƒe	eƒef Z„ee[drej…f Z†edsdtdudvee eeWe  eWe f Z‡ejˆe[ef Z‰eedw dwf ZŠedJedJ f Z‹eeZeteZ df ZŒee\edx f Z�edy ZŽe�rRdzd{d|œd}d~„Z�dzdd|œd€d�„Z�d‚dƒd„œd…d†„Z‘dLd‡d|œdˆd‰„Z’dLdŠd|œd‹dŒ„Z“dLd�d|œdŽd�„Z”dLd�d|œd‘d’„Z•d“d”d„œd•d–„Z–d“d—d„œd˜d™„Z—dšd›d„œdœd�„Z˜dždŸd„œd d¡„Z™džd¢d„œd£d¤„Zšd¥d¦d„œd§d¨„Z›d¥d©d„œdªd«„ZœdLd¬d|œd­d®„Z�n–e žd¯¡Z�e žd°¡Z�e žd±¡Z‘e žd²¡Z’e žd³¡Z“e žd´¡Z”e ždµ¡Z•e žd¶¡Z–e žd·¡Z—e žd�¡Z˜e žd¸¡Z™e žd¹¡Zše ždº¡Z›e žd»¡Zœe žd®¡Z�d‚d¦d„œd¼d½„ZŸd¾d¿dÀœdÁdÂ„Z dÃdÄdÀœdÅdÆ„Z¡dLdÇd|œdÈdÉ„Z¢dÊdËœdÌdÍ„Z£d¾dÎdÏdÐœdÑdÒ„Z¤edÓdÔdÕœdÖd×„ƒZ¥edØdÙdÕœdÚd×„ƒZ¥edÛdÜdÕœdÝd×„ƒZ¥dÞdßdÕœdàd×„Z¥edÔdÓdÕœdádâ„ƒZ¦edÙdØdÕœdãdâ„ƒZ¦edÜdÛdÕœdädâ„ƒZ¦edådÛdÕœdædâ„ƒZ¦dçdÞdÕœdèdâ„Z¦dS )éé    )ÚannotationsN)ÚAny)ÚCallable)ÚDict)ÚGeneric)ÚIterable)ÚMapping)ÚNoReturn)ÚOptional)Úoverload)ÚSet)ÚTuple)ÚType)ÚTYPE_CHECKING)ÚTypeVar)ÚUnioné   )Úrolesé   )Úexc)Úutil)ÚInspectable)ÚLiteral)ÚProtocol)Ú	TypeAlias)Údate)Údatetime)Útime)Ú	timedelta)ÚDecimal)ÚUUID)Ú
Executable)ÚCompiled)ÚDDLCompiler)ÚSQLCompiler)Ú
UpdateBase)Ú
ValuesBase)ÚClauseElement)ÚColumnElement)ÚKeyedColumnElement)Úquoted_name)ÚSQLCoreOperations)Ú
TextClause)ÚLambdaElement)ÚFromClauseRole)ÚColumn)ÚAlias)ÚCompoundSelect)ÚCTE)Ú
FromClause)ÚJoin)ÚNamedFromClause)ÚReturnsRows)ÚSelect)Ú
Selectable)Ú
SelectBase)ÚSubquery)ÚTableClause)ÚTableValueType)Ú	TupleType)Ú
TypeEngine)Ú
Connection)ÚDialect)ÚEngine)ÚMockConnection)Ú	TypeGuardÚ_T)ÚboundÚ_T_coT)rE   Ú	covariantÚ_CEzColumnElement[Any]Ú_CLEr'   c                   @  s   e Zd ZdZddœdd„ZdS )Ú_HasClauseElementz8indicates a class that has a __clause_element__() methodz"roles.ExpressionElementRole[_T_co]©Úreturnc                 C  s   d S ©N© ©ÚselfrN   rN   úU/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/sql/_typing.pyÚ__clause_element__[   ó    z$_HasClauseElement.__clause_element__N)Ú__name__Ú
__module__Ú__qualname__Ú__doc__rR   rN   rN   rN   rQ   rJ   X   s   rJ   c                   @  s    e Zd ZdZdddœdd„ZdS )Ú_CoreAdapterProtoz?protocol for the ClauseAdapter/ColumnAdapter.traverse() method.rH   )ÚobjrL   c                 C  s   d S rM   rN   )rP   rY   rN   rN   rQ   Ú__call__a   rS   z_CoreAdapterProto.__call__N)rT   rU   rV   rW   rZ   rN   rN   rN   rQ   rX   ^   s   rX   c                   @  s"   e Zd ZdZeddœdd„ƒZdS )Ú_HasDialectzQprotocol for Engine/Connection-like objects that have dialect
    attribute.
    r@   rK   c                 C  s   d S rM   rN   rO   rN   rN   rQ   Údialecti   s    z_HasDialect.dialectN)rT   rU   rV   rW   Úpropertyr\   rN   rN   rN   rQ   r[   d   s   r[   Ú_NOT_ENTITYr   r   r   r   r    r   )Ú*r   Ú_MAYBE_ENTITYr,   zColumnElement[_T]zSQLCoreOperations[_T]Ú_TP.Ú_T0Ú_T1Ú_T2Ú_T3Ú_T4Ú_T5Ú_T6Ú_T7Ú_T8Ú_T9r-   r   ÚColumnExpressionArgumentzSelect[_TP]zCompoundSelect[_TP]zSQLCoreOperations[Any]Ú_DMLKeyzColumn[Any]r;   r4   r0   r2   zTypeEngine[_T])ÚautoZ	ignore_fk)rA   r?   rB   r"   zTypeGuard[SQLCompiler])ÚcrL   c                 C  s   d S rM   rN   ©ro   rN   rN   rQ   Úis_sql_compilerE  rS   rq   zTypeGuard[DDLCompiler]c                 C  s   d S rM   rN   rp   rN   rN   rQ   Úis_ddl_compilerG  rS   rr   r.   zTypeGuard[NamedFromClause])ÚtrL   c                 C  s   d S rM   rN   ©rs   rN   rN   rQ   Úis_named_from_clauseI  s    ru   zTypeGuard[ColumnElement[Any]]c                 C  s   d S rM   rN   rp   rN   rN   rQ   Úis_column_elementM  s    rv   z"TypeGuard[KeyedColumnElement[Any]]c                 C  s   d S rM   rN   rp   rN   rN   rQ   Úis_keyed_column_elementQ  s    rw   zTypeGuard[TextClause]c                 C  s   d S rM   rN   rp   rN   rN   rQ   Úis_text_clauseU  rS   rx   zTypeGuard[FromClause]c                 C  s   d S rM   rN   rp   rN   rN   rQ   Úis_from_clauseW  rS   ry   zTypeEngine[Any]zTypeGuard[TupleType]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_tuple_typeY  rS   rz   zTypeGuard[TableValueType]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_table_value_type[  s    r{   r   zTypeGuard[Selectable]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_selectable_  rS   r|   zUnion[Executable, ReturnsRows]zTypeGuard[SelectBase]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_select_basea  s    r}   zTypeGuard[Select[Any]]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_select_statemente  s    r~   r3   zTypeGuard[TableClause]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_tablei  rS   r   zTypeGuard[Subquery]c                 C  s   d S rM   rN   rt   rN   rN   rQ   Úis_subqueryk  rS   r€   zTypeGuard[UpdateBase]c                 C  s   d S rM   rN   rp   rN   rN   rQ   Úis_dmlm  rS   r�   Zis_sqlZis_ddlZnamed_with_columnZ_is_column_elementZ_is_keyed_column_elementZ_is_text_clauseZ_is_from_clauseZ_is_tuple_typeZ_is_table_valueZ_is_select_baseZ_is_select_statementZ	_is_tableZ_is_subqueryc                 C  s
   t | dƒS )NÚschema©Úhasattrrt   rN   rN   rQ   Úhas_schema_attr�  s    r…   ÚstrzTypeGuard[quoted_name])ÚsrL   c                 C  s
   t | dƒS )NÚquoterƒ   ©r‡   rN   rN   rQ   Úis_quoted_name…  s    rŠ   Úobjectz!TypeGuard[_HasClauseElement[Any]]c                 C  s
   t | dƒS )NrR   rƒ   r‰   rN   rN   rQ   Úis_has_clause_element‰  s    rŒ   zTypeGuard[ValuesBase]c                 C  s   | j o| jp| jS rM   )r�   Z	is_insertZ	is_updaterp   rN   rN   rQ   Úis_insert_update�  s    r�   zexc.ArgumentErrorrK   c                   C  s
   t  d¡S )Nz{Additional keyword arguments are not accepted by this function/method.  The presence of **kw is for pep-484 typing purposes)r   ÚArgumentErrorrN   rN   rN   rQ   Ú_no_kw‘  s    ÿr�   zDict[str, Any]r	   )ÚmethnameÚkwrL   c                 C  s$   t |ƒd }t| › d|› d�ƒ‚d S )Nr   z% got an unexpected keyword argument 'ú')ÚlistÚ	TypeError)r�   r‘   ÚkrN   rN   rQ   Ú_unexpected_kw˜  s    r–   z'SQLCoreOperations[_T]'z!'SQLCoreOperations[Optional[_T]]')ÚvalrL   c                 C  s   d S rM   rN   ©r—   rN   rN   rQ   ÚNullable�  s    r™   zroles.ExpressionElementRole[_T]z)roles.ExpressionElementRole[Optional[_T]]c                 C  s   d S rM   rN   r˜   rN   rN   rQ   r™   £  s    zType[_T]zType[Optional[_T]]c                 C  s   d S rM   rN   r˜   rN   rN   rQ   r™   ©  s    z_TypedColumnClauseArgument[_T]z(_TypedColumnClauseArgument[Optional[_T]]c                 C  s   | S )aŠ  Types a column or ORM class as nullable.

    This can be used in select and other contexts to express that the value of
    a column can be null, for example due to an outer join::

        stmt1 = select(A, Nullable(B)).outerjoin(A.bs)
        stmt2 = select(A.data, Nullable(B.data)).outerjoin(A.bs)

    At runtime this method returns the input unchanged.

    .. versionadded:: 2.0.20
    rN   r˜   rN   rN   rQ   r™   ­  s    c                 C  s   d S rM   rN   r˜   rN   rN   rQ   ÚNotNullable¿  s    rš   c                 C  s   d S rM   rN   r˜   rN   rN   rQ   rš   Å  s    c                 C  s   d S rM   rN   r˜   rN   rN   rQ   rš   Ë  s    zOptional[Type[_T]]c                 C  s   d S rM   rN   r˜   rN   rN   rQ   rš   Ï  s    zCUnion[_TypedColumnClauseArgument[Optional[_T]], Optional[Type[_T]]]c                 C  s   | S )a~  Types a column or ORM class as not nullable.

    This can be used in select and other contexts to express that the value of
    a column cannot be null, for example due to a where condition on a
    nullable column::

        stmt = select(NotNullable(A.value)).where(A.value.is_not(None))

    At runtime this method returns the input unchanged.

    .. versionadded:: 2.0.20
    rN   r˜   rN   rN   rQ   rš   Ó  s    )§Ú
__future__r   ÚoperatorÚtypingr   r   r   r   r   r   r	   r
   r   r   r   r   r   r   r   Ú r   r   r   Z
inspectionr   Zutil.typingr   r   r   r   r   r   r   Údecimalr   Úuuidr    Úbaser!   Úcompilerr"   r#   r$   Zdmlr%   r&   Úelementsr'   r(   r)   r*   r+   r,   Zlambdasr-   r.   r‚   r/   Z
selectabler0   r1   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   Zsqltypesr<   r=   Ztype_apir>   Zenginer?   r@   rA   Zengine.mockrB   rC   rD   rF   rH   rI   rJ   rX   r[   Úintr†   ÚboolÚfloatr^   Z
_StarOrOneZColumnsClauseRoler`   ZExpressionElementRoleZ_TextCoercedExpressionArgumentZTypedColumnsClauseRoleZ_ColumnsClauseArgumentZ_TypedColumnClauseArgumentra   rb   rc   rd   re   rf   rg   rh   ri   rj   rk   ZDMLColumnRoleZ_OnlyColumnArgumentZ_ColumnExpressionArgumentrl   Ú__annotations__Z"_ColumnExpressionOrLiteralArgumentZ#_ColumnExpressionOrStrLabelArgumentZ_ByArgumentZ	_InfoTypeZ_FromClauseArgumentZJoinTargetRoleZ_JoinTargetArgumentZOnClauseRoleZ_OnClauseArgumentZCompoundElementRoleZ#_SelectStatementForCompoundArgumentZ_DMLColumnArgumentrm   Z_DMLColumnKeyMappingZDDLConstraintColumnRoleZ_DDLColumnArgumentZ_DMLTableArgumentZimmutabledictZ_PropagateAttrsTypeZ_TypeEngineArgumentZ_EquivalentColumnMapZ_LimitOffsetTypeZ_AutoIncrementTypeZ_CreateDropBindrq   rr   ru   rv   rw   rx   ry   rz   r{   r|   r}   r~   r   r€   r�   Ú
attrgetterr…   rŠ   rŒ   r�   r�   r–   r™   rš   rN   rN   rN   rQ   Ú<module>   sò  
õ
úüÿ
úÿþÿþÿ
úÿ
ÿÿ
üÿþÿýÿ
úÿ















