etjddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd l m Z erd d l m Z d d lmZd d lmZd dlmZd dlmZedeZededZGddZGddZGddZGddeZGddeZGdd eZGd!d"eZGd#d$eZGd%d&eZGd'd(eZGd)d*eZ Gd+d,e eZ!Gd-d.eeeZ"Gd/d0eeeZ#Gd1d2eZ$Gd3d4eZ%Gd5d6eee%Z&Gd7d8ee%Z'Gd9d:eZ(Gd;dee(Z*Gd?d@e*Z+GdAdBe#eZ,GdCdDe,eZ-GdEdFe,eZ.GdGdHe,eZ/GdIdJeZ0GdKdLeee(Z1GdMdNe"e1Z2GdOdPe2Z3GdQdRe3Z4GdSdTeZ5GdUdVeZ6GdWdXe6e5Z7GdYdZe5Z8Gd[d\eZ9Gd]d^eeZ:Gd_d`e6Z;Gdadbe2Z<GdcddeZ=GdedfeZ>Gdgdhe6Z?Gdidje(Z@GdkdleZAGdmdneAZBdoS)p) annotations)Any)Generic)Optional) TYPE_CHECKING)TypeVar)util)Literal)_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_inspectionrR/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/sqlalchemy/sql/roles.pyrrs)IMOOOr rc&eZdZUdZdZded<dZdS)UsesInspectionrNz Literal[None] _post_inspectT)rrrrr$__annotations__rrr r!r#r#-s+I#'M''''OOOr r#ceZdZdZdZdS)AllowsLambdaRolerTN)rrrrrrr r!r'r'3sIMMMr r'ceZdZdZdZdS)HasCacheKeyRolerzCacheable Core or ORM objectNrrrr _role_namerr r!r)r)8sI/JJJr r)ceZdZdZdZdS)ExecutableOptionRolerz"ExecutionOption Core or ORM objectNr*rr r!r-r-=sI5JJJr r-ceZdZdZdZdS)LiteralValueRolerzLiteral Python valueNr*rr r!r/r/BsI'JJJr r/ceZdZdZdZdS)ColumnArgumentRolerzColumn expressionNr*rr r!r1r1GsI$JJJr r1ceZdZdZdZdS)ColumnArgumentOrKeyRolerColumn expression or string keyNr*rr r!r3r3LI2JJJr r3ceZdZdZdZdS)StrAsPlainColumnRolerr4Nr*rr r!r7r7Qr5r r7ceZdZdZdZdS)ColumnListRolezCElements suitable for forming comma separated lists of expressions.rNrrrrrrr r!r9r9VsMMIIIr r9ceZdZdZdZdS) StringRolez/mixin indicating a role that results in stringsrNr:rr r!r<r<\s99IIIr r<ceZdZdZdZdS)TruncatedLabelRolerzString SQL identifierNr*rr r!r>r>bsI(JJJr r>c.eZdZdZdZeddZdS)ColumnsClauseRolerz?Column expression, FROM clause, or other columns clause elementreturnrctNNotImplementedErrorselfs r!_select_iterablez"ColumnsClauseRole._select_iterablems!###r N)rAr)rrrrr+propertyrHrr r!r@r@gsAII$$$X$$$r r@ceZdZdZdZdS)TypedColumnsClauseRolez'element-typed form of ColumnsClauseRolerNr:rr r!rKrKrs11IIIr rKceZdZdZdZdS)LimitOffsetRolerzLIMIT / OFFSET expressionNr*rr r!rMrMxsI,JJJr rMceZdZdZdZdS)ByOfRolerzGROUP BY / OF / etc. expressionNr*rr r!rOrO}r5r rOceZdZdZdZdS) GroupByRolerzGROUP BY expressionNr*rr r!rQrQsI 'JJJr rQceZdZdZdZdS) OrderByRolerzORDER BY expressionNr*rr r!rSrSsI&JJJr rSceZdZdZdS)StructuralRolerNrrrrrr r!rUrUIIIr rUceZdZdZdZdS)StatementOptionRolerz statement sub-expression elementNr*rr r!rYrYsI3JJJr rYceZdZdZdZdS) 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!r]r]sI7JJJr r]ceZdZdZdZd dZdS) ExpressionElementRolerzSQL expression elementname Optional[str]rA Label[_T]ctrCrD)rGr`s r!labelzExpressionElementRole.labels!###r N)r`rarArb)rrrrr+rdrr r!r_r_s4I)J$$$$$$r r_ceZdZdZdZdS) ConstExprRolerz#Constant True/False/None expressionNr*rr r!rfrfsI6JJJr rfceZdZdZdS)LabeledColumnExprRolerNrVrr r!rhrhrWr rhceZdZdZdZdS)BinaryElementRolerz'SQL expression element or literal valueNr*rr r!rjrjsI:JJJr rjceZdZdZdZdS) InElementRolerz?IN expression list, SELECT construct, or bound parameter objectNr*rr r!rlrlsIIJJr rlceZdZdZdZdS)JoinTargetRolerzGJoin target, typically a FROM expression, or ORM relationship attributeNr*rr r!rnrnsI !JJr rnc&eZdZUdZdZdZded<dS)FromClauseRolerz2FROM expression, such as a Table or alias() objectFboolnamed_with_columnN)rrrrr+ _is_subqueryr%rr r!rprps-IEJLr rpceZdZdZdS)StrictFromClauseRolerNrVrr r!rururWr ruc*eZdZdZer dddd d ZdSdS) AnonymizedFromClauseRolerNF)r`flatr`rarxrqrArcdSrCr)rGr`rxs r!_anonymous_fromclausez.AnonymizedFromClauseRole._anonymous_fromclausesr )r`rarxrqrAr)rrrrrrzrr r!rwrwsPI,0e        r rwceZdZdZdZdS)ReturnsRowsRolerzcRow returning expression such as a SELECT, a FROM clause, or an INSERT/UPDATE/DELETE with RETURNINGNr*rr r!r|r|sI .JJr r|cNeZdZdZdZerejddZdSej ZdS) StatementRolerz"Executable SQL or text() constructrAr cdSrCrrFs r!_propagate_attrszStatementRole._propagate_attrss;>3r N)rAr ) rrrrr+rr memoized_propertyr EMPTY_DICTrr r!r~r~sLI5J+ >>> >>> ?r r~ceZdZdZdZddZdS)SelectStatementRolerz/SELECT construct or equivalent text() constructrArc td)NzFAll SelectStatementRole objects should implement a .subquery() method.rDrFs r!subqueryzSelectStatementRole.subquerys! "   r N)rAr)rrrrr+rrr r!rrs2IBJ      r rceZdZdZdS) HasCTERolerNrVrr r!rr rWr rceZdZdZdZdS) IsCTERolerz CTE objectNr*rr r!rr sIJJJr rceZdZdZdZdZdS)CompoundElementRolezDSELECT statements inside a CompoundSelect, e.g. UNION, EXTRACT, etc.rz@SELECT construct for inclusion in a UNION or other set constructNrrrrrr+rr r!rrs!NNIJJJr rceZdZdZdS)DMLRolerNrVrr r!rrrWr 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 objectNrrr r!rr*sJJI@JJJr rceZdZdZdS)DDLRolerNrVrr r!rr1rWr rceZdZdZdZdS)DDLExpressionRolerz)SQL expression element for DDL constraintNr*rr r!rr5sIr@rKrMrOrQrSrUrYr[r]r_rfrhrjrlrnrprurwr|r~rrrrrrrrrrrrrr r!rs#""""" !!!!!!%,,,,,,++++++&&&&&&$$$$$$ WTsd333           00000g000 666667666 (((((w((( %%%%%%%% 333330333 33333-333 W  )))))W))) $$$$$(..$$$WU^W -----g--- 33333~333 '''''"NH''''''''"H''' W44444.444 #^88888l888 $ $ $ $ $259 $ $ $77777)"-777 1"5;;;;;-b1;;; G%~~&> 3g + + + + +G + + +     -    *GmAAAAA>AAA >>>>>G>>> AAAAAGAAAm======== NNNNNgNNN 3r