U
|
¸ý°d ã @ s¨ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ ddlm Z dd l
|
m Z er d
|
d l m Z d
|
d lmZ d
|
d lmZ d
|
dlmZ d
|
dlmZ ededZG dd dZG dd dZG dd dZG dd deZG dd deZG d d d eZG d d d eZG d d! d!eZ G d"d# d#eZ G d$d% d%eZ G d&d' d'eZ G d(d) d)e eZ G d*d+ d+eee Z!G d,d- d-ee eZ"G d.d/ d/eZ#G d0d1 d1e Z$G d2d3 d3eee$Z%G d4d5 d5ee$Z&G d6d7 d7eZ'G d8d9 d9e'Z(G d:d; d;ee'Z)G d<d= d=e)Z*G d>d? d?e"e Z+G d@dA dAe+e Z,G dBdC dCe+e Z-G dDdE dEe+e Z.G dFdG dGeZ/G dHdI dIeee'Z0G dJdK dKe!e0Z1G dLdM dMe1Z2G dNdO dOe2Z3G dPdQ dQeZ4G dRdS dSeZ5G dTdU dUe5e4Z6G dVdW dWe4Z7G dXdY dYeZ8G dZd[ d[eeZ9G d\d] d]e5Z:G d^d_ d_e1Z;G d`da daeZ<G dbdc dceZ=G ddde dee5Z>G dfdg dge'Z?G dhdi dieZ@G djdk dke@ZAdlS )mé )Ú annotations)ÚAny)ÚGeneric)ÚOptional)Ú TYPE_CHECKING)ÚTypeVaré )Úutil)ÚLiteralé )Ú_PropagateAttrsType)ÚLabel)Ú_SelectIterable)Ú
|
FromClause)ÚSubqueryÚ_T)Úboundc @ s e Zd ZdZdZdZdZdS )Ú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 úKd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/sql/roles.pyr s
|
r c @ s" e Zd ZU dZdZded< dZdS )ÚUsesInspectionr Nz Literal[None]Ú _post_inspectT)r r r r r Ú__annotations__r r r r r r , s
|
r c @ s e Zd ZdZdZdS )ÚAllowsLambdaRoler TN)r r r r r r r r r r 2 s r c @ s e Zd ZdZdZdS )ÚHasCacheKeyRoler z Cacheable Core or ORM objectN©r r r r Ú
|
_role_namer r r r r! 7 s r! c @ s e Zd ZdZdZdS )ÚExecutableOptionRoler z"ExecutionOption Core or ORM objectNr" r r r r r$ < s r$ c @ s e Zd ZdZdZdS )ÚLiteralValueRoler zLiteral Python valueNr" r r r r r% A s r% c @ s e Zd ZdZdZdS )ÚColumnArgumentRoler zColumn expressionNr" r r r r r& F s r& c @ s e Zd ZdZdZdS )ÚColumnArgumentOrKeyRoler ú Column expression or string keyNr" r r r r r' K s r' c @ s e Zd ZdZdZdS )ÚStrAsPlainColumnRoler r( Nr" r r r r r) P s r) c @ s e Zd ZdZdZdS )ÚColumnListRolezCElements suitable for forming comma separated lists of expressions.r N©r r r r r r r r r r* U s r* c @ s e Zd ZdZdZdS )Ú
|
StringRolez/mixin indicating a role that results in stringsr Nr+ r r r r r, [ s r, c @ s e Zd ZdZdZdS )ÚTruncatedLabelRoler zString SQL identifierNr" r r r r r- a s r- c @ s& e Zd ZdZdZeddddZdS )ÚColumnsClauseRoler z?Column expression, FROM clause, or other columns clause elementr ©Úreturnc C s
|
t d S ©N©ÚNotImplementedError©Úselfr r r Ú_select_iterablel s z"ColumnsClauseRole._select_iterableN)r r r r r# Úpropertyr6 r r r r r. f s
|
ÿr. c @ s e Zd ZdZdZdS )ÚTypedColumnsClauseRolez'element-typed form of ColumnsClauseRoler Nr+ r r r r r8 q s r8 c @ s e Zd ZdZdZdS )ÚLimitOffsetRoler zLIMIT / OFFSET expressionNr" r r r r r9 w s r9 c @ s e Zd ZdZdZdS )ÚByOfRoler z GROUP BY / OF / etc. expressionNr" r r r r r: | s r: c @ s e Zd ZdZdZdS )Ú GroupByRoler zGROUP BY expressionNr" r r r r r; s r; c @ s e Zd ZdZdZdS )Ú OrderByRoler zORDER BY expressionNr" r r r r r< s r< c @ s e Zd ZdZdS )ÚStructuralRoler N©r r r r r r r r r= s r= c @ s e Zd ZdZdZdS )ÚStatementOptionRoler z statement sub-expression elementNr" r r r r r? s r? c @ s e Zd ZdZdZdS )Ú OnClauseRoler zCON clause, typically a SQL expression or ORM relationship attributeNr" r r r r r@ s ÿr@ c @ s e Zd ZdZdZdS )ÚWhereHavingRoler z$SQL expression for WHERE/HAVING roleNr" r r r r rA s rA c @ s$ e Zd ZdZdZdddddZdS ) ÚExpressionElementRoler zSQL expression elementú Optional[str]z Label[_T])Únamer0 c C s
|
t d S r1 r2 )r5 rD r r r Úlabel¯ s zExpressionElementRole.labelN)r r r r r# rE r r r r rB ¥ s rB c @ s e Zd ZdZdZdS )Ú ConstExprRoler z#Constant True/False/None expressionNr" r r r r rF ³ s rF c @ s e Zd ZdZdS )ÚLabeledColumnExprRoler Nr> r r r r rG ¸ s rG c @ s e Zd ZdZdZdS )ÚBinaryElementRoler z'SQL expression element or literal valueNr" r r r r rH ¼ s rH c @ s e Zd ZdZdZdS )Ú InElementRoler z?IN expression list, SELECT construct, or bound parameter objectNr" r r r r rI Á s ÿrI c @ s e Zd ZdZdZdS )ÚJoinTargetRoler zGJoin target, typically a FROM expression, or ORM relationship attributeNr" r r r r rJ È s ÿrJ c @ s" e Zd ZU dZdZdZded< dS )ÚFromClauseRoler z2FROM expression, such as a Table or alias() objectFÚboolZnamed_with_columnN)r r r r r# Z _is_subqueryr r r r r rK Ð s
|
rK c @ s e Zd ZdZdS )ÚStrictFromClauseRoler Nr> r r r r rM Ù s rM c @ s. e Zd ZdZer*dddddddd d
|
ZdS ) ÚAnonymizedFromClauseRoler NF)rD ÚflatrC rL r )rD rO r0 c C s d S r1 r )r5 rD rO r r r Ú_anonymous_fromclauseã s z.AnonymizedFromClauseRole._anonymous_fromclause)r r r r r rP r r r r rN Þ s
|
ÿrN c @ s e Zd ZdZdZdS )ÚReturnsRowsRoler zcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr" r r r r rQ é s ÿrQ c @ s4 e Zd ZdZdZer*ejddddZnej ZdS )Ú StatementRoler z"Executable SQL or text() constructr r/ c C s d S r1 r r4 r r r Ú_propagate_attrs÷ s z StatementRole._propagate_attrsN)
|
r r r r r# r r Zmemoized_propertyrS Ú
|
EMPTY_DICTr r r r rR ñ s rR c @ s" e Zd ZdZdZddddZdS )ÚSelectStatementRoler z/SELECT construct or equivalent text() constructr r/ c C s t dd S )NzFAll SelectStatementRole objects should implement a .subquery() method.r2 r4 r r r Úsubquery s ÿz SelectStatementRole.subqueryN)r r r r r# rV r r r r rU ÿ s rU c @ s e Zd ZdZdS )Ú
|
HasCTERoler Nr> r r r r rW
|
s rW c @ s e Zd ZdZdZdS )Ú IsCTERoler z
|
CTE objectNr" r r r r rX s rX c @ s e Zd ZdZdZdZdS )Ú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 rY s ÿrY c @ s e Zd ZdZdS )ÚDMLRoler Nr> r r r r r[ s r[ c @ s e Zd ZdZdZdS )Ú DMLTableRoler z-subject table for an INSERT, UPDATE or DELETENr" r r r r r\ ! s r\ c @ s e Zd ZdZdZdS )Ú DMLColumnRoler z*SET/VALUES column expression or string keyNr" r r r r r] & s r] c @ s e Zd ZdZdZdZdS )Ú DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTr z-SELECT statement or equivalent textual objectNrZ r r r r r^ + s r^ c @ s e Zd ZdZdS )ÚDDLRoler Nr> r r r r r_ 2 s r_ c @ s e Zd ZdZdZdS )ÚDDLExpressionRoler z)SQL expression element for DDL constraintNr" r r r r r` 6 s r` c @ s e Zd ZdZdZdS )ÚDDLConstraintColumnRoler z:String column name or column expression for DDL constraintNr" r r r r ra ; s ra c @ s e Zd ZdZdZdS )ÚDDLReferredColumnRoler zBString column name or Column object for DDL foreign key constraintNr" r r r r rb @ s ÿrb N)BÚ
|
__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. r8 r9 r: r; r< r= r? r@ rA rB rF rG rH rI rJ rK rM rN rQ rR rU rW rX rY r[ r\ r] r^ r_ r` ra rb r r r r Ú<module> sv
|
|
