B ‰KLcã@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 ú3lib/python3.7/site-packages/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 valueN)rrrrr r r r r,src@seZdZdZdS)ÚColumnArgumentRolezColumn expressionN)rrrrr r r r r0src@seZdZdZdS)ÚColumnArgumentOrKeyRolezColumn expression or string keyN)rrrrr r r r r4src@seZdZdZdS)ÚStrAsPlainColumnRolezColumn expression or string keyN)rrrrr r r r r8src@seZdZdZdS)ÚColumnListRolezCElements suitable for forming comma separated lists of expressions.N)rrrrr r r r r<src@seZdZdZdS)ÚTruncatedLabelRolezString SQL identifierN)rrrrr 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Úpropertyrr r r r rDsrc@seZdZdZdS)ÚLimitOffsetRolezLIMIT / OFFSET expressionN)rrrrr r r r rLsrc@seZdZdZdS)ÚByOfRolezGROUP BY / OF / etc. expressionN)rrrrr r r r rPsrc@seZdZdZdS)Ú GroupByRolezGROUP BY expressionN)rrrrr r r r rTsrc@seZdZdZdS)Ú OrderByRolezORDER BY expressionN)rrrrr r r r r \sr c@s eZdZdS)ÚStructuralRoleN)rrrr r r r r!`sr!c@seZdZdZdS)ÚStatementOptionRolez statement sub-expression elementN)rrrrr r r r r"dsr"c@seZdZdZdS)Ú OnClauseRolezSQL expression for ON clauseN)rrrrr r r r r#hsr#c@seZdZdZdS)ÚWhereHavingRolez$SQL expression for WHERE/HAVING roleN)rrrrr r r r r$lsr$c@seZdZdZdS)ÚExpressionElementRolezSQL expression elementN)rrrrr r r r r%psr%c@seZdZdZdS)Ú ConstExprRolez#Constant True/False/None expressionN)rrrrr r r r r&tsr&c@s eZdZdS)ÚLabeledColumnExprRoleN)rrrr r r r r'xsr'c@seZdZdZdS)ÚBinaryElementRolez'SQL expression element or literal valueN)rrrrr r r r r(|sr(c@seZdZdZdS)Ú InElementRolez?IN expression list, SELECT construct, or bound parameter objectN)rrrrr r r r r)€sr)c@seZdZdZdS)ÚJoinTargetRolezGJoin target, typically a FROM expression, or ORM relationship attributeN)rrrrr r r r r*†sr*c@s eZdZdZdZedd„ƒZdS)ÚFromClauseRolez2FROM expression, such as a Table or alias() objectFcCs tƒ‚dS)N)r)rr r r Ú _hide_froms’szFromClauseRole._hide_fromsN)rrrrZ _is_subqueryrr,r r r r r+sr+c@seZdZedd„ƒZdS)ÚStrictFromClauseRolecCs tƒ‚dS)N)r)rr r r Ú descriptionšsz StrictFromClauseRole.descriptionN)rrrrr.r r r r r-—sr-c@seZdZddd„ZdS)ÚAnonymizedFromClauseRoleNFcCs tƒ‚dS)N)r)rÚnameZflatr r r Ú_anonymous_fromclause¢sz.AnonymizedFromClauseRole._anonymous_fromclause)NF)rrrr1r r r r r/Ÿsr/c@seZdZdZdS)ÚReturnsRowsRolezcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGN)rrrrr r r r r2¦sr2c@seZdZdZe ¡ZdS)Ú StatementRolez"Executable SQL or text() constructN)rrrrrZ immutabledictZ_propagate_attrsr r r r r3­sr3c@seZdZdZdd„ZdS)ÚSelectStatementRolez/SELECT construct or equivalent text() constructcCs tdƒ‚dS)NzFAll SelectStatementRole objects should implement a .subquery() method.)r)rr r r Úsubquery¶szSelectStatementRole.subqueryN)rrrrr5r r r r r4³sr4c@s eZdZdS)Ú HasCTERoleN)rrrr r r r r6½sr6c@seZdZdZdS)Ú IsCTERolez CTE objectN)rrrrr r r r r7Ásr7c@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 r8Åsr8c@s eZdZdS)ÚDMLRoleN)rrrr r r r r9Îsr9c@seZdZdZdS)Ú DMLTableRolez-subject table for an INSERT, UPDATE or DELETEN)rrrrr r r r r:Òsr:c@seZdZdZdS)Ú DMLColumnRolez*SET/VALUES column expression or string keyN)rrrrr r r r r;Ösr;c@seZdZdZdZdS)Ú DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTz-SELECT statement or equivalent textual objectN)rrrrrr r r r r<Úsr<c@s eZdZdS)ÚDDLRoleN)rrrr r r r r=àsr=c@seZdZdZdS)ÚDDLExpressionRolez)SQL expression element for DDL constraintN)rrrrr r r r r>äsr>c@seZdZdZdS)ÚDDLConstraintColumnRolez:String column name or column expression for DDL constraintN)rrrrr r r r r?èsr?c@seZdZdZdS)ÚDDLReferredColumnRolezBString column name or Column object for DDL foreign key constraintN)rrrrr r r r r@ìsr@N).ÚrÚobjectrr r rrrrrrrrrrrrr r!r"r#r$r%r&r'r(r)r*r+r-r/r2r3r4r6r7r8r9r:r;r<r=r>r?r@r r r r ÚsV