U d@sddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd l m Z erd d l m Z d d lmZd d lmZd dlmZd dlmZededZGdddZGdddZGdddZGdddeZGdddeZGdddeZGdddeZGd d!d!eZGd"d#d#eZGd$d%d%eZGd&d'd'eZGd(d)d)eeZ Gd*d+d+eeeZ!Gd,d-d-eeeZ"Gd.d/d/eZ#Gd0d1d1eZ$Gd2d3d3eee$Z%Gd4d5d5ee$Z&Gd6d7d7eZ'Gd8d9d9e'Z(Gd:d;d;ee'Z)Gdd?d?e"eZ+Gd@dAdAe+eZ,GdBdCdCe+eZ-GdDdEdEe+eZ.GdFdGdGeZ/GdHdIdIeee'Z0GdJdKdKe!e0Z1GdLdMdMe1Z2GdNdOdOe2Z3GdPdQdQeZ4GdRdSdSeZ5GdTdUdUe5e4Z6GdVdWdWe4Z7GdXdYdYeZ8GdZd[d[eeZ9Gd\d]d]e5Z:Gd^d_d_e1Z;Gd`dadaeZGdfdgdge'Z?GdhdidieZ@Gdjdkdke@ZAdlS)m) annotations)Any)Generic)Optional) TYPE_CHECKING)TypeVar)util)Literal)_PropagateAttrsType)Label)_SelectIterable) FromClause)Subquery_T)boundc@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_inspectionrrr8/tmp/pip-unpacked-wheel-wbr0uges/sqlalchemy/sql/roles.pyrs rc@s"eZdZUdZdZded<dZdS)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr__annotations__rrrrrr,s  rc@seZdZdZdZdS)AllowsLambdaRolerTN)rrrrrrrrrr 2sr c@seZdZdZdZdS)HasCacheKeyRolerzCacheable Core or ORM objectNrrrr _role_namerrrrr!7sr!c@seZdZdZdZdS)ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr"rrrrr$<sr$c@seZdZdZdZdS)LiteralValueRolerzLiteral Python valueNr"rrrrr%Asr%c@seZdZdZdZdS)ColumnArgumentRolerzColumn expressionNr"rrrrr&Fsr&c@seZdZdZdZdS)ColumnArgumentOrKeyRolerColumn expression or string keyNr"rrrrr'Ksr'c@seZdZdZdZdS)StrAsPlainColumnRolerr(Nr"rrrrr)Psr)c@seZdZdZdZdS)ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrrrrr*Usr*c@seZdZdZdZdS) StringRolez/mixin indicating a role that results in stringsrNr+rrrrr,[sr,c@seZdZdZdZdS)TruncatedLabelRolerzString SQL identifierNr"rrrrr-asr-c@s&eZdZdZdZeddddZdS)ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementrreturncCs tdSNNotImplementedErrorselfrrr_select_iterablelsz"ColumnsClauseRole._select_iterableN)rrrrr#propertyr6rrrrr.fs r.c@seZdZdZdZdS)TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr+rrrrr8qsr8c@seZdZdZdZdS)LimitOffsetRolerzLIMIT / OFFSET expressionNr"rrrrr9wsr9c@seZdZdZdZdS)ByOfRolerzGROUP BY / OF / etc. expressionNr"rrrrr:|sr:c@seZdZdZdZdS) GroupByRolerzGROUP BY expressionNr"rrrrr;sr;c@seZdZdZdZdS) OrderByRolerzORDER BY expressionNr"rrrrr<sr<c@seZdZdZdS)StructuralRolerNrrrrrrrrr=sr=c@seZdZdZdZdS)StatementOptionRolerz statement sub-expression elementNr"rrrrr?sr?c@seZdZdZdZdS) OnClauseRolerzCON clause, typically a SQL expression or ORM relationship attributeNr"rrrrr@sr@c@seZdZdZdZdS)WhereHavingRolerz$SQL expression for WHERE/HAVING roleNr"rrrrrAsrAc@s$eZdZdZdZdddddZdS) ExpressionElementRolerzSQL expression element Optional[str]z Label[_T])namer0cCs tdSr1r2)r5rDrrrlabelszExpressionElementRole.labelN)rrrrr#rErrrrrBsrBc@seZdZdZdZdS) ConstExprRolerz#Constant True/False/None expressionNr"rrrrrFsrFc@seZdZdZdS)LabeledColumnExprRolerNr>rrrrrGsrGc@seZdZdZdZdS)BinaryElementRolerz'SQL expression element or literal valueNr"rrrrrHsrHc@seZdZdZdZdS) InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr"rrrrrIsrIc@seZdZdZdZdS)JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr"rrrrrJsrJc@s"eZdZUdZdZdZded<dS)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolZnamed_with_columnN)rrrrr#Z _is_subqueryrrrrrrKs rKc@seZdZdZdS)StrictFromClauseRolerNr>rrrrrMsrMc@s.eZdZdZer*dddddddd d ZdS) AnonymizedFromClauseRolerNF)rDflatrCrLr)rDrOr0cCsdSr1r)r5rDrOrrr_anonymous_fromclausesz.AnonymizedFromClauseRole._anonymous_fromclause)rrrrrrPrrrrrNs rNc@seZdZdZdZdS)ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr"rrrrrQsrQc@s4eZdZdZdZer*ejddddZnej ZdS) StatementRolerz"Executable SQL or text() constructr r/cCsdSr1rr4rrr_propagate_attrsszStatementRole._propagate_attrsN) rrrrr#rr Zmemoized_propertyrS EMPTY_DICTrrrrrRs rRc@s"eZdZdZdZddddZdS)SelectStatementRolerz/SELECT construct or equivalent text() constructrr/cCs tddS)NzFAll SelectStatementRole objects should implement a .subquery() method.r2r4rrrsubqueryszSelectStatementRole.subqueryN)rrrrr#rVrrrrrUsrUc@seZdZdZdS) HasCTERolerNr>rrrrrW srWc@seZdZdZdZdS) IsCTERolerz CTE objectNr"rrrrrXsrXc@seZdZdZdZdZdS)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrrrrrr#rrrrrYsrYc@seZdZdZdS)DMLRolerNr>rrrrr[sr[c@seZdZdZdZdS) DMLTableRolerz-subject table for an INSERT, UPDATE or DELETENr"rrrrr\!sr\c@seZdZdZdZdS) DMLColumnRolerz*SET/VALUES column expression or string keyNr"rrrrr]&sr]c@seZdZdZdZdZdS) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTrz-SELECT statement or equivalent textual objectNrZrrrrr^+sr^c@seZdZdZdS)DDLRolerNr>rrrrr_2sr_c@seZdZdZdZdS)DDLExpressionRolerz)SQL expression element for DDL constraintNr"rrrrr`6sr`c@seZdZdZdZdS)DDLConstraintColumnRolerz:String column name or column expression for DDL constraintNr"rrrrra;srac@seZdZdZdZdS)DDLReferredColumnRolerzBString column name or Column object for DDL foreign key constraintNr"rrrrrb@srbN)B __future__rtypingrrrrrr Z util.typingr _typingr elementsr Z selectablerrrrrrr r!r$r%r&r'r)r*r,r-r.r8r9r:r;r<r=r?r@rArBrFrGrHrIrJrKrMrNrQrRrUrWrXrYr[r\r]r^r_r`rarbrrrrsv