codekingpro/portable-devtools
115k
1�
2 ��j1 � �� � S SK Jr S SKJr S SKJr S SKJr S SKJr S SKJr SSKJ r SS K3J r \( a S4S K J
r
S5S KJr S6S
KJr S7SKJr S8SKJr \" S\S9r\" S\SS9r " S S5 r " S S5 r " S S5 r " S S \5 r " S S \5 r " S S \5 r " S! S"\5 r " S# S$\ 5 r " S% S&\ 5 r " S' S(\5 r " S) S*\5 r " S+ S,\ \5 r! " S- S.\\\ 5 r" " S/ S0\\ \5 r# " S1 S2\5 r$ " S3 S4\ 5 r% " S5 S6\\\%5 r& " S7 S8\\%5 r' " S9 S:\5 r( " S; S<\(5 r) " S= S>\\(5 r* " S? S@\*5 r+ " SA SB\#\ 5 r, " SC SD\,\ 5 r- " SE SF\,\ 5 r. " SG SH\,\ 5 r/ " SI SJ\5 r0 " SK SL\\\(5 r1 " SM SN\"\15 r2 " SO SP\25 r3 " SQ SR\35 r4 " SS ST\5 r5 " SU SV\5 r6 " SW SX\6\55 r7 " SY SZ\55 r8 " S[ S\\5 r9 " S] S^\\5 r: " S_ S`\65 r; " Sa Sb\25 r< " Sc Sd\5 r= " Se Sf\5 r> " Sg Sh\65 r? " Si Sj\(5 r@ " Sk Sl\5 rA " Sm Sn\A5 rBgo)p� )� annotations)�Any)�Generic)�Optional)�
TYPE_CHECKING)�TypeVar� )�util)�Literal� )�_PropagateAttrsType)�Label)�_SelectIterable)�9FromClause)�Subquery�_T)�bound�_T_coT)r � covariantc �$ � \ rS rSrSrSrSrSrSrg)�SQLRole� z�Define a "role" within a SQL statement structure.10 11Classes within SQL Core participate within SQLRole hierarchies in order12to more accurately indicate where they may be used within SQL statements13of all types.14 15.. versionadded:: 1.416 17� FN) �__name__�18__module__� __qualname__�__firstlineno__�__doc__� __slots__�
allows_lambda�uses_inspection�__static_attributes__r � �ZD:\code\apps\devtools\python\user_packages\Python313\site-packages\sqlalchemy/sql/roles.pyr r s � �� �I��M��Or# r c �, � \ rS rSr% SrSrS\S' SrSrg)�UsesInspection�- r Nz
Literal[None]�
_post_inspectT) r r r r r r( �__annotations__r! r" r r# r$ r& r& - s � ��I�#'�M�=�'��Or# r& c � � \ rS rSrSrSrSrg)�AllowsLambdaRole�3 r TN)r r r r r r r" r r# r$ r+ r+ 3 s � ��I��Mr# r+ c � � \ rS rSrSrSrSrg)�HasCacheKeyRole�8 r z Cacheable Core or ORM objectN�r r r r r �19_role_namer" r r# r$ r. r. 8 s � ��I�/�Jr# r. c � � \ rS rSrSrSrSrg)�ExecutableOptionRole�= r z"ExecutionOption Core or ORM objectNr0 r r# r$ r3 r3 = s � ��I�5�Jr# r3 c � � \ rS rSrSrSrSrg)�LiteralValueRole�B r zLiteral Python valueNr0 r r# r$ r6 r6 B s � ��I�'�Jr# r6 c � � \ rS rSrSrSrSrg)�ColumnArgumentRole�G r zColumn expressionNr0 r r# r$ r9 r9 G s � ��I�$�Jr# r9 c � � \ rS rSrSrSrSrg)�ColumnArgumentOrKeyRole�L r � Column expression or string keyNr0 r r# r$ r< r< L � � ��I�2�Jr# r< c � � \ rS rSrSrSrSrg)�StrAsPlainColumnRole�Q r r> Nr0 r r# r$ rA rA Q r? r# rA c � � \ rS rSrSrSrSrg)�ColumnListRole�V zCElements suitable for forming comma separated lists of expressions.r N�r r r r r r r" r r# r$ rD rD V s20 � �M��Ir# rD c � � \ rS rSrSrSrSrg)�21StringRole�\ z/mixin indicating a role that results in stringsr NrF r r# r$ rH rH \ s22 � �9��Ir# rH c � � \ rS rSrSrSrSrg)�TruncatedLabelRole�b r zString SQL identifierNr0 r r# r$ rK rK b s � ��I�(�Jr# rK c �0 � \ rS rSrSrSr\SS j5 rSrg)�ColumnsClauseRole�g r z?Column expression, FROM clause, or other columns clause elementc � � [ 5 e�N��NotImplementedError��selfs r$ �_select_iterable�"ColumnsClauseRole._select_iterablem s � �!�#�#r# N)�returnr ) r r r r r r1 �propertyrV r" r r# r$ rN rN g s# � ��I�I� � �$� �$r# rN c � � \ rS rSrSrSrSrg)�TypedColumnsClauseRole�r z'element-typed form of ColumnsClauseRoler NrF r r# r$ r[ r[ r s23 � �1��Ir# r[ c � � \ rS rSrSrSrSrg)�LimitOffsetRole�x r zLIMIT / OFFSET expressionNr0 r r# r$ r^ r^ x s � ��I�,�Jr# r^ c � � \ rS rSrSrSrSrg)�ByOfRole�} r z GROUP BY / OF / etc. expressionNr0 r r# r$ ra ra } r? r# ra c � � \ rS rSrSrSrSrg)� GroupByRole� r zGROUP BY expressionNr0 r r# r$ rd rd � s � ��I�24 '�Jr# rd c � � \ rS rSrSrSrSrg)� OrderByRole� r zORDER BY expressionNr0 r r# r$ rg rg � s � ��I�&�Jr# rg c � � \ rS rSrSrSrg)�StructuralRole� r N�r r r r r r" r r# r$ rj rj � � � ��Ir# rj c � � \ rS rSrSrSrSrg)�StatementOptionRole� r z statement sub-expression elementNr0 r r# r$ ro ro � s � ��I�3�Jr# ro c � � \ rS rSrSrSrSrg)� OnClauseRole� r zCON clause, typically a SQL expression or ORM relationship attributeNr0 r r# r$ rr rr � s � ��I� %� r# rr c � � \ rS rSrSrSrSrg)�WhereHavingRole� r z$SQL expression for WHERE/HAVING roleNr0 r r# r$ ru ru � s � ��I�7�Jr# ru c �& � \ rS rSrSrSrSS jrSrg)�ExpressionElementRole� r zSQL expression elementc � � [ 5 erQ rR )rU �names r$ �label�ExpressionElementRole.label� s � �!�#�#r# N)r{ �
Optional[str]rX z Label[_T])r r r r r r1 r| r" r r# r$ rx rx � s � � �I�)�J�$r# rx c � � \ rS rSrSrSrSrg)�
ConstExprRole� r z#Constant True/False/None expressionNr0 r r# r$ r� r� � s � ��I�6�Jr# r� c � � \ rS rSrSrSrg)�LabeledColumnExprRole� r Nrl r r# r$ r� r� � rm r# r� c � � \ rS rSrSrSrSrg)�BinaryElementRole� r z'SQL expression element or literal valueNr0 r r# r$ r� r� � s � ��I�:�Jr# r� c � � \ rS rSrSrSrSrg)�
InElementRole�� r z?IN expression list, SELECT construct, or bound parameter objectNr0 r r# r$ r� r� � s � ��I�I� r# r� c � � \ rS rSrSrSrSrg)�JoinTargetRole�� r zGJoin target, typically a FROM expression, or ORM relationship attributeNr0 r r# r$ r� r� � s � ��I� !� r# r� c �, � \ rS rSr% SrSrSrS\S' Srg)�FromClauseRole�� r z2FROM expression, such as a Table or alias() objectF�bool�named_with_columnN) r r r r r r1 � _is_subqueryr) r" r r# r$ r� r� � s � ��I�E�J��L��r# r� c � � \ rS rSrSrSrg)�StrictFromClauseRole�� r Nrl r r# r$ r� r� � rm r# r� c �J � \ rS rSrSr\( a SSS. SS jjrSrgSrg)�AnonymizedFromClauseRole�� r NF)r{ �flatc � � g rQ r )rU r{ r� s r$ �_anonymous_fromclause�.AnonymizedFromClauseRole._anonymous_fromclause� s � � r# )r{ r~ r� r� rX r )r r r r r r r� r" r r# r$ r� r� � s8 � ��I�� ,0�e� �(� �7;� �
� � � r# r� c � � \ rS rSrSrSrSrg)�ReturnsRowsRole�� r zcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr0 r r# r$ r� r� � s � ��I� .� r# r� c �p � \ rS rSrSrSr\( a \R SS j5 r Sr g\R r Sr g)�
StatementRole�� r z"Executable SQL or text() constructc � � g rQ r rT s r$ �_propagate_attrs� StatementRole._propagate_attrs� s � �;>r# N)rX r
) r r r r r r1 r r25 �memoized_propertyr� �26EMPTY_DICTr" r r# r$ r� r� � s/ � ��I�5�J��
� � �>� 27 �>� �?�?�r# r� c �& � \ rS rSrSrSrSS jrSrg)�SelectStatementRole�� r z/SELECT construct or equivalent text() constructc � � [ S5 e)NzFAll SelectStatementRole objects should implement a .subquery() method.rR rT s r$ �subquery� SelectStatementRole.subquery s � �!�
"�28� 29r# N)rX r )r r r r r r1 r� r" r r# r$ r� r� � s � ��I�B�J�30r# r� c � � \ rS rSrSrSrg)�31HasCTERolei r Nrl r r# r$ r� r� rm r# r� c � � \ rS rSrSrSrSrg)� IsCTERolei
r z32CTE objectNr0 r r# r$ r� r�
s � ��I� �Jr# r� c � � \ rS rSrSrSrSrSrg)�CompoundElementRolei zDSELECT 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 r1 r" r r# r$ r� r� s � �N��I�J� r# r� c � � \ rS rSrSrSrg)�DMLRolei r Nrl r r# r$ r� r� rm r# r� c � � \ rS rSrSrSrSrg)� DMLTableRolei r z-subject table for an INSERT, UPDATE or DELETENr0 r r# r$ r� r� s � ��I�@�Jr# r� c � � \ rS rSrSrSrSrg)�
DMLColumnRolei% r z*SET/VALUES column expression or string keyNr0 r r# r$ r� r� % s � ��I�=�Jr# r� c � � \ rS rSrSrSrSrSrg)�
DMLSelectRolei* z@A SELECT statement embedded in DML, typically INSERT from SELECTr z-SELECT statement or equivalent textual objectNr� r r# r$ r� r� * s � �J��I�@�Jr# r� c � � \ rS rSrSrSrg)�DDLRolei1 r Nrl r r# r$ r� r� 1 rm r# r� c � � \ rS rSrSrSrSrg)�DDLExpressionRolei5 r z)SQL expression element for DDL constraintNr0 r r# r$ r� r� 5 s � ��I�<�Jr# r� c � � \ rS rSrSrSrSrg)�DDLConstraintColumnRolei: r z:String column name or column expression for DDL constraintNr0 r r# r$ r� r� : s � ��I�M�Jr# r� c � � \ rS rSrSrSrSrg)�DDLReferredColumnRolei? r zBString column name or Column object for DDL foreign key constraintNr0 r r# r$ r� r� ? s � ��I�L� r# r� N)C�33__future__r �typingr r r r r � r34 � util.typingr �_typingr
�elementsr �35selectabler r r r r r r& r+ r. r3 r6 r9 r< rA rD rH rK rN r[ r^ ra rd rg rj ro rr ru rx r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r# r$ �<module>r� s� �� #� � � � � � � !��,� �+�&�$� �T�� ����s�d�3��
�
� � � � �360�g� 0�376�7� 6�38(�w� (�39%�� %�403� 0� 3�413�-� 3�42�W� � �� � )��W� )�43$�(�.�.� $��W�U�^�W� � -�g� -�443�~� 3�45'�"�N�H� '�'�"�H� '�46�W� �4�.� 4�47�#�^� �8�l� 8�48 $� 2�5� 9� $� 7�)�"�-� 7�49� 1�"� 5� �;�-�b�1� ;�50�G� ��%�~�~� � �&�� ��>� �51 � 3� ��g� �52+�G� 53+�54�-� � 55�� � � �� �56�*�G� ��m� �A�>� A�57>�G� >�58A�G� A��m� �=�� =�59N�g� N�60� 3� r#