U [¢hã@sÖddlmZGdd„deƒZGdd„deƒZGdd„deƒZGdd „d eƒZGd d „d eƒZGd d „d eƒZGdd„deƒZ Gdd„de ƒZ Gdd„de ƒZ Gdd„deƒZ Gdd„deƒZ Gdd„deee ƒZGdd„deƒZGdd„de ƒZGdd„deeeƒZGd d!„d!eeƒZGd"d#„d#eƒZGd$d%„d%eƒZGd&d'„d'eeƒZGd(d)„d)eƒZGd*d+„d+eƒZGd,d-„d-eƒZGd.d/„d/eƒZGd0d1„d1eƒZGd2d3„d3eƒZGd4d5„d5eeeƒZGd6d7„d7eeƒZGd8d9„d9eƒZGd:d;„d;eƒZGdd?„d?eƒZ!Gd@dA„dAe!e ƒZ"GdBdC„dCe ƒZ#GdDdE„dEeƒZ$GdFdG„dGeeƒZ%GdHdI„dIe!ƒZ&GdJdK„dKeƒZ'GdLdM„dMeƒZ(GdNdO„dOeƒZ)GdPdQ„dQe!ƒZ*GdRdS„dSeƒZ+GdTdU„dUeƒZ,GdVdW„dWe,ƒZ-dXS)Yé)Úutilc@seZdZdZdZdZdS)Ú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__Ú allows_lambdaÚuses_inspection©r r ú8/tmp/pip-unpacked-wheel-joqu7d3y/sqlalchemy/sql/roles.pyr s rc@seZdZdZdZdS)ÚUsesInspectionNT)rrrZ _post_inspectr r r r r r sr c@seZdZdZdS)ÚAllowsLambdaRoleTN)rrrrr r r r r sr c@seZdZdZdS)ÚHasCacheKeyRolezCacheable Core or ORM objectN©rrrÚ _role_namer r r r r#src@seZdZdZdZdS)ÚExecutableOptionRoler z"ExecutionOption Core or ORM objectN)rrrÚ __slots__rr r r r r'src@seZdZdZdS)ÚLiteralValueRolezLiteral Python valueNrr r r r r,src@seZdZdZdS)ÚColumnArgumentRolezColumn expressionNrr r r r r0src@seZdZdZdS)ÚColumnArgumentOrKeyRoleúColumn expression or string keyNrr r r r r4src@seZdZdZdS)ÚStrAsPlainColumnRolerNrr r r r r8src@seZdZdZdS)ÚColumnListRolezCElements suitable for forming comma separated lists of expressions.N)rrrrr r r r r<src@seZdZdZdS)ÚTruncatedLabelRolezString SQL identifierNrr r r r r@src@seZdZdZedd„ƒZdS)ÚColumnsClauseRolez Column expression or FROM clausecCs tƒ‚dS©N©ÚNotImplementedError©Úselfr r r Ú_select_iterableGsz"ColumnsClauseRole._select_iterableN)rrrrÚpropertyr r r r r rDsrc@seZdZdZdS)ÚLimitOffsetRolezLIMIT / OFFSET expressionNrr r r r r"Lsr"c@seZdZdZdS)ÚByOfRolezGROUP BY / OF / etc. expressionNrr r r r r#Psr#c@seZdZdZdS)Ú GroupByRolezGROUP BY expressionNrr r r r r$Tsr$c@seZdZdZdS)Ú OrderByRolezORDER BY expressionNrr r r r r%\sr%c@s eZdZdS)ÚStructuralRoleN©rrrr r r r r&`sr&c@seZdZdZdS)ÚStatementOptionRolez statement sub-expression elementNrr r r r r(dsr(c@seZdZdZdS)Ú OnClauseRolezSQL expression for ON clauseNrr r r r r)hsr)c@seZdZdZdS)ÚWhereHavingRolez$SQL expression for WHERE/HAVING roleNrr r r r r*lsr*c@seZdZdZdS)ÚExpressionElementRolezSQL expression elementNrr r r r r+psr+c@seZdZdZdS)Ú ConstExprRolez#Constant True/False/None expressionNrr r r r r,tsr,c@s eZdZdS)ÚLabeledColumnExprRoleNr'r r r r r-xsr-c@seZdZdZdS)ÚBinaryElementRolez'SQL expression element or literal valueNrr r r r r.|sr.c@seZdZdZdS)Ú InElementRolez?IN expression list, SELECT construct, or bound parameter objectNrr r r r r/€sÿr/c@seZdZdZdS)ÚJoinTargetRolezGJoin target, typically a FROM expression, or ORM relationship attributeNrr r r r r0†sÿr0c@s eZdZdZdZedd„ƒZdS)ÚFromClauseRolez2FROM expression, such as a Table or alias() objectFcCs tƒ‚dSrrrr r r Ú _hide_froms’szFromClauseRole._hide_fromsN)rrrrZ _is_subqueryr!r2r r r r r1sr1c@seZdZedd„ƒZdS)ÚStrictFromClauseRolecCs tƒ‚dSrrrr r r Ú descriptionšsz StrictFromClauseRole.descriptionN)rrrr!r4r r r r r3—sr3c@seZdZddd„ZdS)ÚAnonymizedFromClauseRoleNFcCs tƒ‚dSrr)rÚnameZflatr r r Ú_anonymous_fromclause¢sz.AnonymizedFromClauseRole._anonymous_fromclause)NF)rrrr7r r r r r5Ÿsr5c@seZdZdZdS)ÚReturnsRowsRolezcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNrr r r r r8¦sÿr8c@seZdZdZe ¡ZdS)Ú StatementRolez"Executable SQL or text() constructN)rrrrrZ immutabledictZ_propagate_attrsr r r r r9­sr9c@seZdZdZdd„ZdS)ÚSelectStatementRolez/SELECT construct or equivalent text() constructcCs tdƒ‚dS)NzFAll SelectStatementRole objects should implement a .subquery() method.rrr r r Úsubquery¶sÿzSelectStatementRole.subqueryN)rrrrr;r r r r r:³sr:c@s eZdZdS)Ú HasCTERoleNr'r r r r r<½sr<c@seZdZdZdS)Ú IsCTERolez CTE objectNrr r r r r=Ásr=c@seZdZdZdZdS)ÚCompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.z@SELECT construct for inclusion in a UNION or other set constructN©rrrrrr r r r r>Åsÿr>c@s eZdZdS)ÚDMLRoleNr'r r r r r@Îsr@c@seZdZdZdS)Ú DMLTableRolez-subject table for an INSERT, UPDATE or DELETENrr r r r rAÒsrAc@seZdZdZdS)Ú DMLColumnRolez*SET/VALUES column expression or string keyNrr r r r rBÖsrBc@seZdZdZdZdS)Ú DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTz-SELECT statement or equivalent textual objectNr?r r r r rCÚsrCc@s eZdZdS)ÚDDLRoleNr'r r r r rDàsrDc@seZdZdZdS)ÚDDLExpressionRolez)SQL expression element for DDL constraintNrr r r r rEäsrEc@seZdZdZdS)ÚDDLConstraintColumnRolez:String column name or column expression for DDL constraintNrr r r r rFèsrFc@seZdZdZdS)ÚDDLReferredColumnRolezBString column name or Column object for DDL foreign key constraintNrr r r r rGìsÿrGN).ÚrÚobjectrr r rrrrrrrrrr"r#r$r%r&r(r)r*r+r,r-r.r/r0r1r3r5r8r9r:r<r=r>r@rArBrCrDrErFrGr r r r ÚsV