o E6d@sddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd l m Z erPd 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_inspectionrrrkC:\Users\jesus\OneDrive\Desktop\erpjis_fastapi\backend\jisbackend\Lib\site-packages\sqlalchemy/sql/roles.pyrs  rc@s"eZdZUdZdZded<dZdS)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr__annotations__rrrrrr,s  rc@eZdZdZdZdS)AllowsLambdaRolerTN)rrrrrrrrrr!2r!c@r )HasCacheKeyRolerzCacheable Core or ORM objectNrrrr _role_namerrrrr#7r"r#c@r )ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr$rrrrr&<r"r&c@r )LiteralValueRolerzLiteral Python valueNr$rrrrr'Ar"r'c@r )ColumnArgumentRolerzColumn expressionNr$rrrrr(Fr"r(c@r )ColumnArgumentOrKeyRolerColumn expression or string keyNr$rrrrr)Kr"r)c@r )StrAsPlainColumnRolerr*Nr$rrrrr+Pr"r+c@r )ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrrrrr,Ur,c@r ) StringRolez/mixin indicating a role that results in stringsrNr-rrrrr/[r.r/c@r )TruncatedLabelRolerzString SQL identifierNr$rrrrr0ar"r0c@s"eZdZdZdZedddZdS) ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementreturnrcCtNNotImplementedErrorselfrrr_select_iterablelsz"ColumnsClauseRole._select_iterableN)r2r)rrrrr%propertyr9rrrrr1fs r1c@r )TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr-rrrrr;qr.r;c@r )LimitOffsetRolerzLIMIT / OFFSET expressionNr$rrrrr<wr"r<c@r )ByOfRolerzGROUP BY / OF / etc. expressionNr$rrrrr=|r"r=c@r ) GroupByRolerzGROUP BY expressionNr$rrrrr>sr>c@r ) OrderByRolerzORDER BY expressionNr$rrrrr?r"r?c@eZdZdZdS)StructuralRolerNrrrrrrrrrArAc@r )StatementOptionRolerz statement sub-expression elementNr$rrrrrDr"rDc@r ) OnClauseRolerzCON clause, typically a SQL expression or ORM relationship attributeNr$rrrrrErEc@r )WhereHavingRolerz$SQL expression for WHERE/HAVING roleNr$rrrrrGr"rGc@seZdZdZdZd ddZd S) ExpressionElementRolerzSQL expression elementname Optional[str]r2 Label[_T]cCr3r4r5)r8rIrrrlabelszExpressionElementRole.labelN)rIrJr2rK)rrrrr%rLrrrrrHsrHc@r ) ConstExprRolerz#Constant True/False/None expressionNr$rrrrrMr"rMc@r@)LabeledColumnExprRolerNrBrrrrrNrCrNc@r )BinaryElementRolerz'SQL expression element or literal valueNr$rrrrrOr"rOc@r ) InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr$rrrrrPrFrPc@r )JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr$rrrrrQrFrQc@s"eZdZUdZdZdZded<dS)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolZnamed_with_columnN)rrrrr%Z _is_subqueryrrrrrrRs  rRc@r@)StrictFromClauseRolerNrBrrrrrTrCrTc@s*eZdZdZerdddd d d ZdSdS)AnonymizedFromClauseRolerNF)rIflatrIrJrVrSr2rcCdSr4r)r8rIrVrrr_anonymous_fromclausesz.AnonymizedFromClauseRole._anonymous_fromclause)rIrJrVrSr2r)rrrrrrXrrrrrUs rUc@r )ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr$rrrrrYrFrYc@s2eZdZdZdZerejdddZdSej ZdS) StatementRolerz"Executable SQL or text() constructr2r cCrWr4rr7rrr_propagate_attrsszStatementRole._propagate_attrsN)r2r ) rrrrr%rr Zmemoized_propertyr[ EMPTY_DICTrrrrrZs rZc@seZdZdZdZdddZdS) SelectStatementRolerz/SELECT construct or equivalent text() constructr2rcCstd)NzFAll SelectStatementRole objects should implement a .subquery() method.r5r7rrrsubqueryszSelectStatementRole.subqueryN)r2r)rrrrr%r^rrrrr]sr]c@r@) HasCTERolerNrBrrrrr_ rCr_c@r ) IsCTERolerz CTE objectNr$rrrrr`r"r`c@eZdZdZdZdZdS)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrrrrrr%rrrrrbs rbc@r@)DMLRolerNrBrrrrrdrCrdc@r ) DMLTableRolerz-subject table for an INSERT, UPDATE or DELETENr$rrrrre!r"rec@r ) DMLColumnRolerz*SET/VALUES column expression or string keyNr$rrrrrf&r"rfc@ra) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTrz-SELECT statement or equivalent textual objectNrcrrrrrg+srgc@r@)DDLRolerNrBrrrrrh2rCrhc@r )DDLExpressionRolerz)SQL expression element for DDL constraintNr$rrrrri6r"ric@r )DDLConstraintColumnRolerz:String column name or column expression for DDL constraintNr$rrrrrj;r"rjc@r )DDLReferredColumnRolerzBString column name or Column object for DDL foreign key constraintNr$rrrrrk@rFrkN)B __future__rtypingrrrrrr Z util.typingr Z_typingr elementsr Z selectablerrrrrrr!r#r&r'r(r)r+r,r/r0r1r;r<r=r>r?rArDrErGrHrMrNrOrPrQrRrTrUrYrZr]r_r`rbrdrerfrgrhrirjrkrrrrsx