a
    •˜ëjî  ã                   @  s¶  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 eded�Zededd�ZG dd„ dƒZG dd„ dƒZG dd„ dƒZG dd„ deƒZG dd„ deƒZG dd „ d eƒZG d!d"„ d"eƒZG d#d$„ d$eƒZG d%d&„ d&eƒZG d'd(„ d(eƒZG d)d*„ d*eƒZ G d+d,„ d,e eƒZ!G d-d.„ d.eeeƒZ"G d/d0„ d0ee eƒZ#G d1d2„ d2eƒZ$G d3d4„ d4eƒZ%G d5d6„ d6eee%ƒZ&G d7d8„ d8ee%ƒZ'G d9d:„ d:eƒZ(G d;d<„ d<e(ƒZ)G d=d>„ d>ee(ƒZ*G d?d@„ d@e*ƒZ+G dAdB„ dBe#e ƒZ,G dCdD„ dDe,e ƒZ-G dEdF„ dFe,e ƒZ.G dGdH„ dHe,e ƒZ/G dIdJ„ dJeƒZ0G dKdL„ dLeee(ƒZ1G dMdN„ dNe"e1ƒZ2G dOdP„ dPe2ƒZ3G dQdR„ dRe3ƒZ4G dSdT„ dTeƒZ5G dUdV„ dVeƒZ6G dWdX„ dXe6e5ƒZ7G dYdZ„ dZe5ƒZ8G d[d\„ d\eƒZ9G d]d^„ d^eeƒZ:G d_d`„ d`e6ƒZ;G dadb„ dbe2ƒZ<G dcdd„ ddeƒZ=G dedf„ dfeƒZ>G dgdh„ dhe6ƒZ?G didj„ dje(ƒZ@G dkdl„ dleƒZAG dmdn„ dneAƒZBdoS )pé    )Úannotations)ÚAny)ÚGeneric)ÚOptional)ÚTYPE_CHECKING)ÚTypeVaré   )Úutil)ÚLiteralé   )Ú_PropagateAttrsType)ÚLabel)Ú_SelectIterable)Ú
FromClause)ÚSubqueryÚ_T)ÚboundÚ_T_coT)r   Ú	covariantc                   @  s   e Zd ZdZdZdZdZdS )ÚSQLRolezþDefine a "role" within a SQL statement structure.

    Classes within SQL Core participate within SQLRole hierarchies in order
    to more accurately indicate where they may be used within SQL statements
    of all types.

    .. versionadded:: 1.4

    © FN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ú	__slots__Úallows_lambdaÚuses_inspectionr   r   r   úS/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/sql/roles.pyr      s   
r   c                   @  s"   e Zd ZU dZdZded< dZdS )ÚUsesInspectionr   NzLiteral[None]Ú_post_inspectT)r   r   r   r   r    Ú__annotations__r   r   r   r   r   r   -   s   
r   c                   @  s   e Zd ZdZdZdS )ÚAllowsLambdaRoler   TN)r   r   r   r   r   r   r   r   r   r"   3   s   r"   c                   @  s   e Zd ZdZdZdS )ÚHasCacheKeyRoler   zCacheable Core or ORM objectN©r   r   r   r   Ú
_role_namer   r   r   r   r#   8   s   r#   c                   @  s   e Zd ZdZdZdS )ÚExecutableOptionRoler   z"ExecutionOption Core or ORM objectNr$   r   r   r   r   r&   =   s   r&   c                   @  s   e Zd ZdZdZdS )ÚLiteralValueRoler   zLiteral Python valueNr$   r   r   r   r   r'   B   s   r'   c                   @  s   e Zd ZdZdZdS )ÚColumnArgumentRoler   zColumn expressionNr$   r   r   r   r   r(   G   s   r(   c                   @  s   e Zd ZdZdZdS )ÚColumnArgumentOrKeyRoler   úColumn expression or string keyNr$   r   r   r   r   r)   L   s   r)   c                   @  s   e Zd ZdZdZdS )ÚStrAsPlainColumnRoler   r*   Nr$   r   r   r   r   r+   Q   s   r+   c                   @  s   e Zd ZdZdZdS )ÚColumnListRolezCElements suitable for forming comma separated lists of expressions.r   N©r   r   r   r   r   r   r   r   r   r,   V   s   r,   c                   @  s   e Zd ZdZdZdS )Ú
StringRolez/mixin indicating a role that results in stringsr   Nr-   r   r   r   r   r.   \   s   r.   c                   @  s   e Zd ZdZdZdS )ÚTruncatedLabelRoler   zString SQL identifierNr$   r   r   r   r   r/   b   s   r/   c                   @  s&   e Zd ZdZdZeddœdd„ƒZdS )ÚColumnsClauseRoler   z?Column expression, FROM clause, or other columns clause elementr   ©Úreturnc                 C  s
   t ƒ ‚d S ©N©ÚNotImplementedError©Úselfr   r   r   Ú_select_iterablem   s    z"ColumnsClauseRole._select_iterableN)r   r   r   r   r%   Úpropertyr8   r   r   r   r   r0   g   s
   ÿr0   c                   @  s   e Zd ZdZdZdS )ÚTypedColumnsClauseRolez'element-typed form of ColumnsClauseRoler   Nr-   r   r   r   r   r:   r   s   r:   c                   @  s   e Zd ZdZdZdS )ÚLimitOffsetRoler   zLIMIT / OFFSET expressionNr$   r   r   r   r   r;   x   s   r;   c                   @  s   e Zd ZdZdZdS )ÚByOfRoler   zGROUP BY / OF / etc. expressionNr$   r   r   r   r   r<   }   s   r<   c                   @  s   e Zd ZdZdZdS )ÚGroupByRoler   zGROUP BY expressionNr$   r   r   r   r   r=   ‚   s   r=   c                   @  s   e Zd ZdZdZdS )ÚOrderByRoler   zORDER BY expressionNr$   r   r   r   r   r>   ‹   s   r>   c                   @  s   e Zd ZdZdS )ÚStructuralRoler   N©r   r   r   r   r   r   r   r   r?   �   s   r?   c                   @  s   e Zd ZdZdZdS )ÚStatementOptionRoler   z statement sub-expression elementNr$   r   r   r   r   rA   ”   s   rA   c                   @  s   e Zd ZdZdZdS )ÚOnClauseRoler   zCON clause, typically a SQL expression or ORM relationship attributeNr$   r   r   r   r   rB   ™   s   ÿrB   c                   @  s   e Zd ZdZdZdS )ÚWhereHavingRoler   z$SQL expression for WHERE/HAVING roleNr$   r   r   r   r   rC   ¡   s   rC   c                   @  s$   e Zd ZdZdZdddœdd„ZdS )	ÚExpressionElementRoler   zSQL expression elementúOptional[str]z	Label[_T])Únamer2   c                 C  s
   t ƒ ‚d S r3   r4   )r7   rF   r   r   r   Úlabel°   s    zExpressionElementRole.labelN)r   r   r   r   r%   rG   r   r   r   r   rD   ¦   s   rD   c                   @  s   e Zd ZdZdZdS )ÚConstExprRoler   z#Constant True/False/None expressionNr$   r   r   r   r   rH   ´   s   rH   c                   @  s   e Zd ZdZdS )ÚLabeledColumnExprRoler   Nr@   r   r   r   r   rI   ¹   s   rI   c                   @  s   e Zd ZdZdZdS )ÚBinaryElementRoler   z'SQL expression element or literal valueNr$   r   r   r   r   rJ   ½   s   rJ   c                   @  s   e Zd ZdZdZdS )ÚInElementRoler   z?IN expression list, SELECT construct, or bound parameter objectNr$   r   r   r   r   rK   Â   s   ÿrK   c                   @  s   e Zd ZdZdZdS )ÚJoinTargetRoler   zGJoin target, typically a FROM expression, or ORM relationship attributeNr$   r   r   r   r   rL   É   s   ÿrL   c                   @  s"   e Zd ZU dZdZdZded< dS )ÚFromClauseRoler   z2FROM expression, such as a Table or alias() objectFÚboolZnamed_with_columnN)r   r   r   r   r%   Z_is_subqueryr!   r   r   r   r   rM   Ñ   s   
rM   c                   @  s   e Zd ZdZdS )ÚStrictFromClauseRoler   Nr@   r   r   r   r   rO   Ú   s   rO   c                   @  s.   e Zd ZdZer*dddœddddœd	d
„ZdS )ÚAnonymizedFromClauseRoler   NF)rF   ÚflatrE   rN   r   )rF   rQ   r2   c                C  s   d S r3   r   )r7   rF   rQ   r   r   r   Ú_anonymous_fromclauseä   s    z.AnonymizedFromClauseRole._anonymous_fromclause)r   r   r   r   r   rR   r   r   r   r   rP   ß   s   ÿrP   c                   @  s   e Zd ZdZdZdS )ÚReturnsRowsRoler   zcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr$   r   r   r   r   rS   é   s   ÿrS   c                   @  s4   e Zd ZdZdZer*ejddœdd„ƒZnej	ZdS )ÚStatementRoler   z"Executable SQL or text() constructr   r1   c                 C  s   d S r3   r   r6   r   r   r   Ú_propagate_attrs÷   s    zStatementRole._propagate_attrsN)
r   r   r   r   r%   r   r	   Zmemoized_propertyrU   Ú
EMPTY_DICTr   r   r   r   rT   ñ   s   rT   c                   @  s"   e Zd ZdZdZddœdd„ZdS )ÚSelectStatementRoler   z/SELECT construct or equivalent text() constructr   r1   c                 C  s   t dƒ‚d S )NzFAll SelectStatementRole objects should implement a .subquery() method.r4   r6   r   r   r   Úsubquery  s    ÿzSelectStatementRole.subqueryN)r   r   r   r   r%   rX   r   r   r   r   rW   þ   s   rW   c                   @  s   e Zd ZdZdS )Ú
HasCTERoler   Nr@   r   r   r   r   rY   	  s   rY   c                   @  s   e Zd ZdZdZdS )Ú	IsCTERoler   z
CTE objectNr$   r   r   r   r   rZ     s   rZ   c                   @  s   e Zd ZdZdZdZdS )ÚCompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.r   z@SELECT construct for inclusion in a UNION or other set constructN©r   r   r   r   r   r%   r   r   r   r   r[     s   ÿr[   c                   @  s   e Zd ZdZdS )ÚDMLRoler   Nr@   r   r   r   r   r]     s   r]   c                   @  s   e Zd ZdZdZdS )ÚDMLTableRoler   z-subject table for an INSERT, UPDATE or DELETENr$   r   r   r   r   r^      s   r^   c                   @  s   e Zd ZdZdZdS )ÚDMLColumnRoler   z*SET/VALUES column expression or string keyNr$   r   r   r   r   r_   %  s   r_   c                   @  s   e Zd ZdZdZdZdS )ÚDMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTr   z-SELECT statement or equivalent textual objectNr\   r   r   r   r   r`   *  s   r`   c                   @  s   e Zd ZdZdS )ÚDDLRoler   Nr@   r   r   r   r   ra   1  s   ra   c                   @  s   e Zd ZdZdZdS )ÚDDLExpressionRoler   z)SQL expression element for DDL constraintNr$   r   r   r   r   rb   5  s   rb   c                   @  s   e Zd ZdZdZdS )ÚDDLConstraintColumnRoler   z:String column name or column expression for DDL constraintNr$   r   r   r   r   rc   :  s   rc   c                   @  s   e Zd ZdZdZdS )ÚDDLReferredColumnRoler   zBString column name or Column object for DDL foreign key constraintNr$   r   r   r   r   rd   ?  s   ÿrd   N)CÚ
__future__r   Útypingr   r   r   r   r   Ú r	   Zutil.typingr
   Ú_typingr   Úelementsr   Z
selectabler   r   r   r   r   r   r   r"   r#   r&   r'   r(   r)   r+   r,   r.   r/   r0   r:   r;   r<   r=   r>   r?   rA   rB   rC   rD   rH   rI   rJ   rK   rL   rM   rO   rP   rS   rT   rW   rY   rZ   r[   r]   r^   r_   r`   ra   rb   rc   rd   r   r   r   r   Ú<module>   sx   		

