rjddlmZddlmZddlmZddlmZddlmZddlmZddlmZdd l m Z erd d l m Z d d l mZd d lmZd dlmZd dlmZedeZededZGddZGddeZGddZGddZGddeZGdd eZGd!d"eZGd#d$eZGd%d&eZGd'd(eZGd)d*eZGd+d,eZ Gd-d.e eZ!Gd/d0eeZ"Gd1d2e"eeeZ#Gd3d4eeeZ$Gd5d6eZ%Gd7d8eZ&Gd9d:eee&Z'Gd;deZ)Gd?d@e)Z*GdAdBee)Z+GdCdDe+Z,GdEdFe$eZ-GdGdHe-eZ.GdIdJe-eZ/GdKdLe-eZ0GdMdNeZ1GdOdPeee)Z2GdQdRe#e2Z3GdSdTe3Z4GdUdVeZ5GdWdXeZ6GdYdZe6e5Z7Gd[d\e5Z8Gd]d^eZ9Gd_d`eeZ:Gdadbe6Z;Gdcdde3Z<GdedfeZ=GdgdheZ>Gdidje6Z?Gdkdle)Z@GdmdneZAGdodpeAZByq)r) annotations)Any)Generic)Literal)Optional) TYPE_CHECKING)TypeVar)util)_PropagateAttrsType)Label)_SelectIterable) FromClause)Subquery_T)bound_T_coT)r covariantceZdZdZdZdZdZy)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_inspectionr_/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/sqlalchemy/sql/roles.pyrrsIMOr rceZdZdZdZy)SyntaxExtensionRolerzSyntax extension constructNrrrr _role_namerr r!r#r#-s I-Jr r#c$eZdZUdZdZded<dZy)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr(__annotations__rrr r!r'r'2sI#'M='Or r'ceZdZdZdZy)AllowsLambdaRolerTN)rrrrrrr r!r+r+8s IMr r+ceZdZdZdZy)HasCacheKeyRolerzCacheable Core or ORM objectNr$rr r!r-r-=s I/Jr r-ceZdZdZdZy)ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr$rr r!r/r/Bs I5Jr r/ceZdZdZdZy)LiteralValueRolerzLiteral Python valueNr$rr r!r1r1Gs I'Jr r1ceZdZdZdZy)ColumnArgumentRolerzColumn expressionNr$rr r!r3r3Ls I$Jr r3ceZdZdZdZy)ColumnArgumentOrKeyRolerColumn expression or string keyNr$rr r!r5r5Q I2Jr r5ceZdZdZdZy)StrAsPlainColumnRolerr6Nr$rr r!r9r9Vr7r r9ceZdZdZdZy)ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrr r!r;r;[s MIr r;ceZdZdZdZy) StringRolez/mixin indicating a role that results in stringsrNr<rr r!r>r>as 9Ir r>ceZdZdZdZy)TruncatedLabelRolerzString SQL identifierNr$rr r!r@r@gs I(Jr r@ceZdZdZdZdZy)TStringElementRolez:Role for elements that can be interpolated into a TString.rzTString interpolatable elementNrrrrrr%rr r!rBrBlsDI1Jr rBc&eZdZdZdZeddZy)ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementctNNotImplementedErrorselfs r!_select_iterablez"ColumnsClauseRole._select_iterable{s !##r N)returnr)rrrrr%propertyrLrr r!rErEss%II$$r rEceZdZdZdZy)TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr<rr r!rPrPs 1Ir rPceZdZdZdZy)LimitOffsetRolerzLIMIT / OFFSET expressionNr$rr r!rRrRs I,Jr rRceZdZdZdZy)ByOfRolerzGROUP BY / OF / etc. expressionNr$rr r!rTrTr7r rTceZdZdZdZy) GroupByRolerzGROUP BY expressionNr$rr r!rVrVsI 'Jr rVceZdZdZdZy) OrderByRolerzORDER BY expressionNr$rr r!rXrXs I&Jr rXceZdZdZy)StructuralRolerNrrrrrr r!rZrZIr rZceZdZdZdZy)StatementOptionRolerz statement sub-expression elementNr$rr r!r^r^s I3Jr r^ceZdZdZdZy) OnClauseRolerzCON clause, typically a SQL expression or ORM relationship attributeNr$rr r!r`r`sI %r r`ceZdZdZdZy)WhereHavingRolerz$SQL expression for WHERE/HAVING roleNr$rr r!rbrbs I7Jr rbceZdZdZdZddZy)ExpressionElementRolerzSQL expression elementctrGrH)rKnames r!labelzExpressionElementRole.labels !##r N)rf Optional[str]rMz Label[_T])rrrrr%rgrr r!rdrdsI)J$r rdceZdZdZdZy) ConstExprRolerz#Constant True/False/None expressionNr$rr r!rjrjs I6Jr rjceZdZdZy)LabeledColumnExprRolerNr[rr r!rlrlr\r rlceZdZdZdZy)BinaryElementRolerz'SQL expression element or literal valueNr$rr r!rnrns I:Jr rnceZdZdZdZy) InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr$rr r!rprpsIIr rpceZdZdZdZy)JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr$rr r!rrrrsI !r rrc$eZdZUdZdZdZded<y)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolnamed_with_columnN)rrrrr% _is_subqueryr)rr r!rtrtsIEJLr rtc0eZdZdZerddd ddZyy)AnonymizedFromClauseRolerNF)rfflatcyrGr)rKrfrzs r!_anonymous_fromclausez.AnonymizedFromClauseRole._anonymous_fromclausesr )rfrhrzrurMr)rrrrrr|rr r!ryrys3I,0e ( 7;   r ryceZdZdZdZy)ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr$rr r!r~r~sI .r r~cXeZdZdZdZerejddZyejZy) StatementRolerz"Executable SQL or text() constructcyrGrrJs r!_propagate_attrszStatementRole._propagate_attrss;>r N)rMr ) rrrrr%rr memoized_propertyr EMPTY_DICTrr r!rrs/I5J  > > ??r rceZdZdZdZddZy)SelectStatementRolerz/SELECT construct or equivalent text() constructctd)NzFAll SelectStatementRole objects should implement a .subquery() method.rHrJs r!subqueryzSelectStatementRole.subquery s! "  r N)rMr)rrrrr%rrr r!rrsIBJ r rceZdZdZy) HasCTERolerNr[rr r!rrr\r rceZdZdZdZy) IsCTERolerz CTE objectNr$rr r!rrs IJr rceZdZdZdZdZy)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrCrr r!rrsNIJr rceZdZdZy)DMLRolerNr[rr r!rr%r\r rceZdZdZdZy) DMLTableRolerz-subject table for an INSERT, UPDATE or DELETENr$rr r!rr)s I@Jr rceZdZdZdZy) DMLColumnRolerz*SET/VALUES column expression or string keyNr$rr r!rr.s I=Jr rceZdZdZdZdZy) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTrz-SELECT statement or equivalent textual objectNrCrr r!rr3sJI@Jr rceZdZdZy)DDLRolerNr[rr r!rr:r\r rceZdZdZdZy)DDLExpressionRolerz)SQL expression element for DDL constraintNr$rr r!rr>s Ir@rBrErPrRrTrVrXrZr^r`rbrdrjrlrnrprrrtryr~rrrrrrrrrrrrrrr r!rs# ,+&$ Tsd3   .'.   0g0 676 (w( %% 303 3-3 W  )W) 22 $(.. $WU^W -g- 3~3 '"NH''"H' W4.4 #^8l8 $259 $7)"-7 1"5;-b1; G%~~&~g +G + -  *GmA>A >G> AGAm== NgN 3r