WdddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd l m Z erd d l m Z d d lmZd d lmZd dlmZd dlmZedeZGddZGddZGddZGddeZGddeZGddeZGddeZGd d!eZGd"d#eZGd$d%eZGd&d'eZGd(d)eeZ Gd*d+eeeZ!Gd,d-eeeZ"Gd.d/eZ#Gd0d1eZ$Gd2d3eee$Z%Gd4d5ee$Z&Gd6d7eZ'Gd8d9e'Z(Gd:d;ee'Z)Gd<d=e)Z*Gd>d?e"eZ+Gd@dAe+eZ,GdBdCe+eZ-GdDdEe+eZ.GdFdGeZ/GdHdIeee'Z0GdJdKe!e0Z1GdLdMe1Z2GdNdOe2Z3GdPdQeZ4GdRdSeZ5GdTdUe5e4Z6GdVdWe4Z7GdXdYeZ8GdZd[eeZ9Gd\d]e5Z:Gd^d_e1Z;Gd`daeZ<GdbdceZ=Gdddee5Z>Gdfdge'Z?GdhdieZ@Gdjdke@ZAdlS)m) annotations)Any)Generic)Optional) TYPE_CHECKING)TypeVar)util)Literal)_PropagateAttrsType)Label)_SelectIterable) FromClause)Subquery_T)boundceZdZdZdZdZdZdS)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_inspectionrP/var/www/html/t/fyr/venv311/lib/python3.11/site-packages/sqlalchemy/sql/roles.pyrrs)IMOOOrrc&eZdZUdZdZded<dZdS)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr"__annotations__rrrrr!r!,s+I#'M''''OOOrr!ceZdZdZdZdS)AllowsLambdaRolerTN)rrrrrrrrr%r%2sIMMMrr%ceZdZdZdZdS)HasCacheKeyRolerzCacheable Core or ORM objectNrrrr _role_namerrrr'r'7sI/JJJrr'ceZdZdZdZdS)ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr(rrrr+r+<sI5JJJrr+ceZdZdZdZdS)LiteralValueRolerzLiteral Python valueNr(rrrr-r-AsI'JJJrr-ceZdZdZdZdS)ColumnArgumentRolerzColumn expressionNr(rrrr/r/FsI$JJJrr/ceZdZdZdZdS)ColumnArgumentOrKeyRolerColumn expression or string keyNr(rrrr1r1KI2JJJrr1ceZdZdZdZdS)StrAsPlainColumnRolerr2Nr(rrrr5r5Pr3rr5ceZdZdZdZdS)ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrrrr7r7UsMMIIIrr7ceZdZdZdZdS) StringRolez/mixin indicating a role that results in stringsrNr8rrrr:r:[s99IIIrr:ceZdZdZdZdS)TruncatedLabelRolerzString SQL identifierNr(rrrr<r<asI(JJJrr<c.eZdZdZdZeddZdS)ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementreturnrctNNotImplementedErrorselfs r_select_iterablez"ColumnsClauseRole._select_iterablels!###rN)r?r)rrrrr)propertyrFrrrr>r>fsAII$$$X$$$rr>ceZdZdZdZdS)TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr8rrrrIrIqs11IIIrrIceZdZdZdZdS)LimitOffsetRolerzLIMIT / OFFSET expressionNr(rrrrKrKwsI,JJJrrKceZdZdZdZdS)ByOfRolerzGROUP BY / OF / etc. expressionNr(rrrrMrM|r3rrMceZdZdZdZdS) GroupByRolerzGROUP BY expressionNr(rrrrOrOsI 'JJJrrOceZdZdZdZdS) OrderByRolerzORDER BY expressionNr(rrrrQrQsI&JJJrrQceZdZdZdS)StructuralRolerNrrrrrrrrSrSIIIrrSceZdZdZdZdS)StatementOptionRolerz statement sub-expression elementNr(rrrrWrWsI3JJJrrWceZdZdZdZdS) OnClauseRolerzCON clause, typically a SQL expression or ORM relationship attributeNr(rrrrYrYsI %JJrrYceZdZdZdZdS)WhereHavingRolerz$SQL expression for WHERE/HAVING roleNr(rrrr[r[sI7JJJrr[ceZdZdZdZd dZdS) ExpressionElementRolerzSQL expression elementname Optional[str]r? Label[_T]ctrArB)rEr^s rlabelzExpressionElementRole.labels!###rN)r^r_r?r`)rrrrr)rbrrrr]r]s4I)J$$$$$$rr]ceZdZdZdZdS) ConstExprRolerz#Constant True/False/None expressionNr(rrrrdrdsI6JJJrrdceZdZdZdS)LabeledColumnExprRolerNrTrrrrfrfrUrrfceZdZdZdZdS)BinaryElementRolerz'SQL expression element or literal valueNr(rrrrhrhsI:JJJrrhceZdZdZdZdS) InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr(rrrrjrjsIIJJrrjceZdZdZdZdS)JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr(rrrrlrlsI !JJrrlc&eZdZUdZdZdZded<dS)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolnamed_with_columnN)rrrrr) _is_subqueryr#rrrrnrns-IEJLrrnceZdZdZdS)StrictFromClauseRolerNrTrrrrsrsrUrrsc*eZdZdZer dddd d ZdSdS) AnonymizedFromClauseRolerNF)r^flatr^r_rvror?rcdSrAr)rEr^rvs r_anonymous_fromclausez.AnonymizedFromClauseRole._anonymous_fromclauses  Cr)r^r_rvror?r)rrrrrrxrrrrurusPI,0e        rruceZdZdZdZdS)ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr(rrrrzrzsI .JJrrzcNeZdZdZdZerejddZdSej ZdS) StatementRolerz"Executable SQL or text() constructr?r cdSrArrDs r_propagate_attrszStatementRole._propagate_attrss CrN)r?r ) rrrrr)rr memoized_propertyr~ EMPTY_DICTrrrr|r|sXI5J+         ?rr|ceZdZdZdZddZdS)SelectStatementRolerz/SELECT construct or equivalent text() constructr?rc td)NzFAll SelectStatementRole objects should implement a .subquery() method.rBrDs rsubqueryzSelectStatementRole.subquerys! "   rN)r?r)rrrrr)rrrrrrs2IBJ      rrceZdZdZdS) HasCTERolerNrTrrrrr rUrrceZdZdZdZdS) IsCTERolerz CTE objectNr(rrrrrsIJJJrrceZdZdZdZdZdS)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrrrrrr)rrrrrs!NNIJJJrrceZdZdZdS)DMLRolerNrTrrrrrrUrrceZdZdZdZdS) DMLTableRolerz-subject table for an INSERT, UPDATE or DELETENr(rrrrr!sI@JJJrrceZdZdZdZdS) DMLColumnRolerz*SET/VALUES column expression or string keyNr(rrrrr&sI=JJJrrceZdZdZdZdZdS) DMLSelectRolez@A SELECT statement embedded in DML, typically INSERT from SELECTrz-SELECT statement or equivalent textual objectNrrrrrr+sJJI@JJJrrceZdZdZdS)DDLRolerNrTrrrrr2rUrrceZdZdZdZdS)DDLExpressionRolerz)SQL expression element for DDL constraintNr(rrrrr6sIrIrKrMrOrQrSrWrYr[r]rdrfrhrjrlrnrsrurzr|rrrrrrrrrrrrrrrrs#""""" !!!!!!%,,,,,,++++++&&&&&&$$$$$$ WT           00000g000 666667666 (((((w((( %%%%%%%% 333330333 33333-333 W  )))))W))) $$$$$(..$$$WR[' -----g--- 33333~333 '''''"NH''''''''"H''' W44444.444 #^88888l888 $ $ $ $ $226 $ $ $77777)"-777 1"5;;;;;-b1;;; G%~~&> 3g + + + + +G + + +     -    *GmAAAAA>AAA >>>>>G>>> AAAAAGAAAm======== NNNNNgNNN 3r