+hddlmZGddeZGddeZGddeZGdd eZGd d eZGd d eZGddeZ Gdde Z Gdde Z GddeZ GddeZ Gddeee ZGddeZGdde ZGddeeeZGd d!eeZGd"d#eZGd$d%eZGd&d'eeZGd(d)eZGd*d+eZGd,d-eZGd.d/eZGd0d1eZGd2d3eZGd4d5eeeZGd6d7eeZGd8d9eZGd:d;eZGd<d=eZ Gd>d?eZ!Gd@dAe!e Z"GdBdCe Z#GdDdEeZ$GdFdGeeZ%GdHdIe!Z&GdJdKeZ'GdLdMeZ(GdNdOeZ)GdPdQe!Z*GdRdSeZ+GdTdUeZ,GdVdWe,Z-yX)Y)utilceZdZdZdZdZy)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__ allows_lambdauses_inspectionG/var/www/html/venv/lib/python3.12/site-packages/sqlalchemy/sql/roles.pyrr sMOr rceZdZdZdZy)UsesInspectionNT)rrr _post_inspectr r r rrrs MOr rceZdZdZy)AllowsLambdaRoleTN)rrrr r r rrrsMr rceZdZdZy)HasCacheKeyRolezCacheable Core or ORM objectNrrr _role_namer r rrr#/Jr rceZdZdZdZy)ExecutableOptionRoler z"ExecutionOption Core or ORM objectN)rrr __slots__rr r rrr's I5Jr rceZdZdZy)LiteralValueRolezLiteral Python valueNrr r rrr,s'Jr rceZdZdZy)ColumnArgumentRolezColumn expressionNrr r rrr0s$Jr rceZdZdZy)ColumnArgumentOrKeyRoleColumn expression or string keyNrr r rr!r!42Jr r!ceZdZdZy)StrAsPlainColumnRoler"Nrr r rr%r%8r#r r%ceZdZdZy)ColumnListRolezCElements suitable for forming comma separated lists of expressions.N)rrrr r r rr'r'<sMr r'ceZdZdZy)TruncatedLabelRolezString SQL identifierNrr r rr)r)@s(Jr r)c eZdZdZedZy)ColumnsClauseRolez Column expression or FROM clausectNNotImplementedErrorselfs r_select_iterablez"ColumnsClauseRole._select_iterableG !##r N)rrrrpropertyr2r r rr+r+Ds3J $$r r+ceZdZdZy)LimitOffsetRolezLIMIT / OFFSET expressionNrr r rr6r6Ls,Jr r6ceZdZdZy)ByOfRolezGROUP BY / OF / etc. expressionNrr r rr8r8Pr#r r8ceZdZdZy) GroupByRolezGROUP BY expressionNrr r rr:r:Ts 'Jr r:ceZdZdZy) OrderByRolezORDER BY expressionNrr r rr<r<\s&Jr r<c eZdZy)StructuralRoleNrrrr r rr>r>`r r>ceZdZdZy)StatementOptionRolez statement sub-expression elementNrr r rrBrBds3Jr rBceZdZdZy) OnClauseRolezSQL expression for ON clauseNrr r rrDrDhrr rDceZdZdZy)WhereHavingRolez$SQL expression for WHERE/HAVING roleNrr r rrFrFls7Jr rFceZdZdZy)ExpressionElementRolezSQL expression elementNrr r rrHrHps)Jr rHceZdZdZy) ConstExprRolez#Constant True/False/None expressionNrr r rrJrJts6Jr rJc eZdZy)LabeledColumnExprRoleNr?r r rrLrLxr@r rLceZdZdZy)BinaryElementRolez'SQL expression element or literal valueNrr r rrNrN|s:Jr rNceZdZdZy) InElementRolez?IN expression list, SELECT construct, or bound parameter objectNrr r rrPrPs Ir rPceZdZdZy)JoinTargetRolezGJoin target, typically a FROM expression, or ORM relationship attributeNrr r rrRrRs  !r rRc$eZdZdZdZedZy)FromClauseRolez2FROM expression, such as a Table or alias() objectFctr-r.r0s r _hide_fromszFromClauseRole._hide_fromsr3r N)rrrr _is_subqueryr4rVr r rrTrTsEJL $$r rTceZdZedZy)StrictFromClauseRolectr-r.r0s r descriptionz StrictFromClauseRole.descriptionr3r N)rrrr4r[r r rrYrYs$$r rYceZdZddZy)AnonymizedFromClauseRoleNctr-r.)r1nameflats r_anonymous_fromclausez.AnonymizedFromClauseRole._anonymous_fromclauses !##r )NF)rrrrar r rr]r]s$r r]ceZdZdZy)ReturnsRowsRolezcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNrr r rrcrcs  .r rcc2eZdZdZej Zy) StatementRolez"Executable SQL or text() constructN)rrrrr immutabledict_propagate_attrsr r rreres5J)t))+r receZdZdZdZy)SelectStatementRolez/SELECT construct or equivalent text() constructctd)NzFAll SelectStatementRole objects should implement a .subquery() method.r.r0s rsubqueryzSelectStatementRole.subquerys! "  r N)rrrrrkr r rriris BJ r ric eZdZy) HasCTERoleNr?r r rrmrmr@r rmceZdZdZy) IsCTERolez CTE objectNrr r rrorosJr roceZdZdZdZy)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.z@SELECT construct for inclusion in a UNION or other set constructNrrrr rr r rrqrqsN Kr rqc eZdZy)DMLRoleNr?r r rrtrtr@r rtceZdZdZy) DMLTableRolez-subject table for an INSERT, UPDATE or DELETENrr r rrvrvs@Jr rvceZdZdZy) DMLColumnRolez*SET/VALUES column expression or string keyNrr r rrxrxs=Jr rxceZdZdZdZy) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTz-SELECT statement or equivalent textual objectNrrr r rrzrzs J@Jr rzc eZdZy)DDLRoleNr?r r rr|r|r@r r|ceZdZdZy)DDLExpressionRolez)SQL expression element for DDL constraintNrr r rr~r~srBrDrFrHrJrLrNrPrRrTrYr]rcrerirmrorqrtrvrxrzr|r~rrr r rrs: f V v0g0676 (w(%%3033-3NWN))$(..$-g-3~3'"NH''"H' W 4.40#^08l8*G*7)7 1 ;-;G %~~$&$$>$$3$g,G,  -   *G m A>A>G>AGA  m ==NgN3r