o g@sddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd l m Z erPd d l m Z d d lmZd d lmZd dlmZd dlmZededZededdZGdddZGdddZGdddZGdddeZGdddeZGdd d eZGd!d"d"eZGd#d$d$eZGd%d&d&eZGd'd(d(eZGd)d*d*eZ Gd+d,d,e eZ!Gd-d.d.eeeZ"Gd/d0d0eeeZ#Gd1d2d2eZ$Gd3d4d4eZ%Gd5d6d6eee%Z&Gd7d8d8ee%Z'Gd9d:d:eZ(Gd;d<dd>ee(Z*Gd?d@d@e*Z+GdAdBdBe#eZ,GdCdDdDe,eZ-GdEdFdFe,eZ.GdGdHdHe,eZ/GdIdJdJeZ0GdKdLdLeee(Z1GdMdNdNe"e1Z2GdOdPdPe2Z3GdQdRdRe3Z4GdSdTdTeZ5GdUdVdVeZ6GdWdXdXe6e5Z7GdYdZdZe5Z8Gd[d\d\eZ9Gd]d^d^eeZ:Gd_d`d`e6Z;Gdadbdbe2ZGdgdhdhe6Z?Gdidjdje(Z@GdkdldleZAGdmdndneAZBdoS)p) annotations)Any)Generic)Optional) TYPE_CHECKING)TypeVar)util)Literal)_PropagateAttrsType)Label)_SelectIterable) FromClause)Subquery_T)bound_T_coT)r covariantc@seZdZdZdZdZdZdS)SQLRolezDefine 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_lambdauses_inspectionrrrP/var/www/html/flaskapp/venv/lib/python3.10/site-packages/sqlalchemy/sql/roles.pyrs  rc@s"eZdZUdZdZded<dZdS)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr __annotations__rrrrrr-s  rc@eZdZdZdZdS)AllowsLambdaRolerTN)rrrrrrrrrr#3r#c@r")HasCacheKeyRolerzCacheable Core or ORM objectNrrrr _role_namerrrrr%8r$r%c@r")ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr&rrrrr(=r$r(c@r")LiteralValueRolerzLiteral Python valueNr&rrrrr)Br$r)c@r")ColumnArgumentRolerzColumn expressionNr&rrrrr*Gr$r*c@r")ColumnArgumentOrKeyRolerColumn expression or string keyNr&rrrrr+Lr$r+c@r")StrAsPlainColumnRolerr,Nr&rrrrr-Qr$r-c@r")ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrrrrr.Vr.c@r") StringRolez/mixin indicating a role that results in stringsrNr/rrrrr1\r0r1c@r")TruncatedLabelRolerzString SQL identifierNr&rrrrr2br$r2c@s"eZdZdZdZedddZdS) ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementreturnrcCtNNotImplementedErrorselfrrr_select_iterablemsz"ColumnsClauseRole._select_iterableN)r4r)rrrrr'propertyr;rrrrr3gs r3c@r")TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr/rrrrr=rr0r=c@r")LimitOffsetRolerzLIMIT / OFFSET expressionNr&rrrrr>xr$r>c@r")ByOfRolerzGROUP BY / OF / etc. expressionNr&rrrrr?}r$r?c@r") GroupByRolerzGROUP BY expressionNr&rrrrr@sr@c@r") OrderByRolerzORDER BY expressionNr&rrrrrAr$rAc@eZdZdZdS)StructuralRolerNrrrrrrrrrCrCc@r")StatementOptionRolerz statement sub-expression elementNr&rrrrrFr$rFc@r") OnClauseRolerzCON clause, typically a SQL expression or ORM relationship attributeNr&rrrrrGrGc@r")WhereHavingRolerz$SQL expression for WHERE/HAVING roleNr&rrrrrIr$rIc@seZdZdZdZd ddZd S) ExpressionElementRolerzSQL expression elementname Optional[str]r4 Label[_T]cCr5r6r7)r:rKrrrlabelszExpressionElementRole.labelN)rKrLr4rM)rrrrr'rNrrrrrJsrJc@r") ConstExprRolerz#Constant True/False/None expressionNr&rrrrrOr$rOc@rB)LabeledColumnExprRolerNrDrrrrrPrErPc@r")BinaryElementRolerz'SQL expression element or literal valueNr&rrrrrQr$rQc@r") InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr&rrrrrRrHrRc@r")JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr&rrrrrSrHrSc@s"eZdZUdZdZdZded<dS)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolnamed_with_columnN)rrrrr' _is_subqueryr!rrrrrTs  rTc@rB)StrictFromClauseRolerNrDrrrrrXrErXc@s*eZdZdZerdddd d d ZdSdS)AnonymizedFromClauseRolerNF)rKflatrKrLrZrUr4rcCdSr6r)r:rKrZrrr_anonymous_fromclausesz.AnonymizedFromClauseRole._anonymous_fromclause)rKrLrZrUr4r)rrrrrr\rrrrrYs rYc@r")ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr&rrrrr]rHr]c@s2eZdZdZdZerejdddZdSej ZdS) StatementRolerz"Executable SQL or text() constructr4r cCr[r6rr9rrr_propagate_attrsszStatementRole._propagate_attrsN)r4r ) rrrrr'rr memoized_propertyr_ EMPTY_DICTrrrrr^s r^c@seZdZdZdZdddZdS) SelectStatementRolerz/SELECT construct or equivalent text() constructr4rcCstd)NzFAll SelectStatementRole objects should implement a .subquery() method.r7r9rrrsubqueryszSelectStatementRole.subqueryN)r4r)rrrrr'rcrrrrrbsrbc@rB) HasCTERolerNrDrrrrrd rErdc@r") IsCTERolerz CTE objectNr&rrrrre r$rec@eZdZdZdZdZdS)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrrrrrr'rrrrrgs rgc@rB)DMLRolerNrDrrrrrirEric@r") DMLTableRolerz-subject table for an INSERT, UPDATE or DELETENr&rrrrrj r$rjc@r") DMLColumnRolerz*SET/VALUES column expression or string keyNr&rrrrrk%r$rkc@rf) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTrz-SELECT statement or equivalent textual objectNrhrrrrrl*srlc@rB)DDLRolerNrDrrrrrm1rErmc@r")DDLExpressionRolerz)SQL expression element for DDL constraintNr&rrrrrn5r$rnc@r")DDLConstraintColumnRolerz:String column name or column expression for DDL constraintNr&rrrrro:r$roc@r")DDLReferredColumnRolerzBString column name or Column object for DDL foreign key constraintNr&rrrrrp?rHrpN)C __future__rtypingrrrrrr util.typingr _typingr elementsr selectablerrrrrrrr#r%r(r)r*r+r-r.r1r2r3r=r>r?r@rArCrFrGrIrJrOrPrQrRrSrTrXrYr]r^rbrdrergrirjrkrlrmrnrorprrrrsz