j8ddlmZddlmZddlmZddlmZddlmZddlmZddlmZdd 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@GdmdneZAGdodpeAZBdqS)r) annotations)Any)Generic)Literal)Optional) TYPE_CHECKING)TypeVar)util)_PropagateAttrsType)Label)_SelectIterable) FromClause)Subquery_T)bound_T_coT)r covariantceZdZdZdZdZdZdS)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_inspectionry/home/lighthouse/badge-speaker-benchmark/.benchmark-venv-community/lib64/python3.11/site-packages/sqlalchemy/sql/roles.pyrrs)IMOOOr rceZdZdZdZdS)SyntaxExtensionRolerzSyntax extension constructNrrrr _role_namerr r!r#r#-sI-JJJr r#c&eZdZUdZdZded<dZdS)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr(__annotations__rrr r!r'r'2s+I#'M''''OOOr r'ceZdZdZdZdS)AllowsLambdaRolerTN)rrrrrrr r!r+r+8sIMMMr r+ceZdZdZdZdS)HasCacheKeyRolerzCacheable Core or ORM objectNr$rr r!r-r-=sI/JJJr r-ceZdZdZdZdS)ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr$rr r!r/r/BsI5JJJr r/ceZdZdZdZdS)LiteralValueRolerzLiteral Python valueNr$rr r!r1r1GsI'JJJr r1ceZdZdZdZdS)ColumnArgumentRolerzColumn expressionNr$rr r!r3r3LsI$JJJr r3ceZdZdZdZdS)ColumnArgumentOrKeyRolerColumn expression or string keyNr$rr r!r5r5QI2JJJr r5ceZdZdZdZdS)StrAsPlainColumnRolerr6Nr$rr r!r9r9Vr7r r9ceZdZdZdZdS)ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrr r!r;r;[sMMIIIr r;ceZdZdZdZdS) StringRolez/mixin indicating a role that results in stringsrNr<rr r!r>r>as99IIIr r>ceZdZdZdZdS)TruncatedLabelRolerzString SQL identifierNr$rr r!r@r@gsI(JJJr r@ceZdZdZdZdZdS)TStringElementRolez:Role for elements that can be interpolated into a TString.rzTString interpolatable elementNrrrrrr%rr r!rBrBlsDDI1JJJr rBc.eZdZdZdZeddZdS)ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementreturnrctNNotImplementedErrorselfs r!_select_iterablez"ColumnsClauseRole._select_iterable{s!###r N)rFr)rrrrr%propertyrMrr r!rErEssCII$$$X$$$r rEceZdZdZdZdS)TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr<rr r!rPrPs11IIIr rPceZdZdZdZdS)LimitOffsetRolerzLIMIT / OFFSET expressionNr$rr r!rRrRsI,JJJr rRceZdZdZdZdS)ByOfRolerzGROUP BY / OF / etc. expressionNr$rr r!rTrTr7r rTceZdZdZdZdS) GroupByRolerzGROUP BY expressionNr$rr r!rVrVsI 'JJJr rVceZdZdZdZdS) OrderByRolerzORDER BY expressionNr$rr r!rXrXsI&JJJr rXceZdZdZdS)StructuralRolerNrrrrrr r!rZrZIIIr rZceZdZdZdZdS)StatementOptionRolerz statement sub-expression elementNr$rr r!r^r^sI3JJJr r^ceZdZdZdZdS) OnClauseRolerzCON clause, typically a SQL expression or ORM relationship attributeNr$rr r!r`r`sI %JJr r`ceZdZdZdZdS)WhereHavingRolerz$SQL expression for WHERE/HAVING roleNr$rr r!rbrbsI7JJJr rbceZdZdZdZd dZdS) ExpressionElementRolerzSQL expression elementname Optional[str]rF Label[_T]ctrHrI)rLres r!labelzExpressionElementRole.labels!###r N)rerfrFrg)rrrrr%rirr r!rdrds4I)J$$$$$$r rdceZdZdZdZdS) ConstExprRolerz#Constant True/False/None expressionNr$rr r!rkrksI6JJJr rkceZdZdZdS)LabeledColumnExprRolerNr[rr r!rmrmr\r rmceZdZdZdZdS)BinaryElementRolerz'SQL expression element or literal valueNr$rr r!rorosI:JJJr roceZdZdZdZdS) InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr$rr r!rqrqsIIJJr rqceZdZdZdZdS)JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr$rr r!rsrssI !JJr rsc&eZdZUdZdZdZded<dS)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolnamed_with_columnN)rrrrr% _is_subqueryr)rr r!rurus-IEJLr ruc*eZdZdZer dddd d ZdSdS) AnonymizedFromClauseRolerNF)reflatrerfr{rvrFrcdSrHr)rLrer{s r!_anonymous_fromclausez.AnonymizedFromClauseRole._anonymous_fromclausesr )rerfr{rvrFr)rrrrrr}rr r!rzrzsPI,0e        r rzceZdZdZdZdS)ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr$rr r!rrsI .JJr rcNeZdZdZdZerejddZdSej ZdS) StatementRolerz"Executable SQL or text() constructrFr cdSrHrrKs r!_propagate_attrszStatementRole._propagate_attrss;>3r N)rFr ) rrrrr%rr memoized_propertyr EMPTY_DICTrr r!rrsLI5J+ >>> >>> ?r rceZdZdZdZddZdS)SelectStatementRolerz/SELECT construct or equivalent text() constructrFrc td)NzFAll SelectStatementRole objects should implement a .subquery() method.rIrKs r!subqueryzSelectStatementRole.subquery s! "   r N)rFr)rrrrr%rrr r!rrs2IBJ      r rceZdZdZdS) HasCTERolerNr[rr r!rrr\r rceZdZdZdZdS) IsCTERolerz CTE objectNr$rr r!rrsIJJJr rceZdZdZdZdZdS)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrCrr r!rrs!NNIJJJr rceZdZdZdS)DMLRolerNr[rr r!rr%r\r rceZdZdZdZdS) DMLTableRolerz-subject table for an INSERT, UPDATE or DELETENr$rr r!rr)sI@JJJr rceZdZdZdZdS) DMLColumnRolerz*SET/VALUES column expression or string keyNr$rr r!rr.sI=JJJr rceZdZdZdZdZdS) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTrz-SELECT statement or equivalent textual objectNrCrr r!rr3sJJI@JJJr rceZdZdZdS)DDLRolerNr[rr r!rr:r\r rceZdZdZdZdS)DDLExpressionRolerz)SQL expression element for DDL constraintNr$rr r!rr>sIr@rBrErPrRrTrVrXrZr^r`rbrdrkrmrorqrsrurzrrrrrrrrrrrrrrrr r!rs #""""" %,,,,,,++++++&&&&&&$$$$$$ WTsd333         .....'...   00000g000 666667666 (((((w((( %%%%%%%% 333330333 33333-333 W  )))))W))) 22222222 $ $ $ $ $(.. $ $ $WU^W -----g--- 33333~333 '''''"NH''''''''"H''' W44444.444 #^88888l888 $ $ $ $ $259 $ $ $77777)"-777 1"5;;;;;-b1;;; G%~~&~g + + + + +G + + +     -    *GmAAAAA>AAA >>>>>G>>> AAAAAGAAAm======== NNNNNgNNN 3r