*'&h2  UddlmZddlZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lm Z dd lm Z dd lm Z dd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZerddlmZddlmZddlmZddlm Z ddl!m"Z"dd l#m$Z$dd!l%m&Z&dd"l'm(Z(dd#l'm)Z)dd$l'm*Z*dd%l+m,Z,dd&l+m-Z-dd'l.m/Z/dd(l.m0Z0dd)l.m1Z1dd*l.m2Z2dd+l.m3Z3dd,l.m4Z4dd-l5m6Z6dd.lm7Z7dd/l8m9Z9dd0l:m;Z;dd1l:mZ>dd4l:m?Z?dd5l:m@Z@dd6l:mAZAdd7l:mBZBdd8l:mCZCdd9l:mDZDdd:l:mEZEdd;l:mFZFddlJmKZKdd?lLmMZMdd@lLmNZNddAlLmOZOddBlPmQZQddClmRZRedDeEZSedFedGHZTedIdJEZUedKdLEZVGdMdNeeeTZWGdOdPeZXGdQdReZYedSeZe[e\dTdUdVdWdXe]dY Z^edZZ_ed[ej`e_eeeeWeeWeZaee[d\d]eWeSejbeSfZceejdeSej`d^e_eeSeeWeSeWeSfZe eejdeSd^eeSfZfed_eed`fEZgedaeEZhedbeEZiedceEZjeddeEZkedeeEZledfeEZmedgeEZnedheEZoedieEZpedjeEZqed]eWeSd^ejbeSejdeSegd]fdkfZr ereSZsdletdm< eeereSfZuee[ereSfZveeeveevefZw eeefZx eej7eeeeWeeWefZy eeyejzfZ{ eereej|fZ} edndoej~fZ ee[eWeejdpfZ edqeEZe eefZee[drejfZ edsdtdudveeeeWeeWefZeje[efZeedwdwfZedJe dJfZeeZereZdfZee\edxfZedyZer=dd~ZddZddZddZddZddZddZddZddZddZddZddZddZddZddZnejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZddZddZddZddZddZddZe ddĄZe ddDŽZe ddʄZdd̈́Ze dd΄Ze ddτZe ddЄZe dd҄ZddԄZdS)) annotationsN)Any)Callable)Dict)Generic)Iterable)Mapping)NoReturn)Optional)overload)Set)Tuple)Type) TYPE_CHECKING)TypeVar)Union)roles)exc)util) Inspectable)Literal)Protocol) TypeAlias)date)datetime)time) timedelta)Decimal)UUID) Executable)Compiled) DDLCompiler) SQLCompiler) UpdateBase) ValuesBase) ClauseElement) ColumnElement)KeyedColumnElement) quoted_name)SQLCoreOperations) TextClause) LambdaElement)FromClauseRole)Column)Alias)CompoundSelect)CTE) FromClause)Join)NamedFromClause) ReturnsRows)Select) Selectable) SelectBase)Subquery) TableClause)TableValueType) TupleType) TypeEngine) Connection)Dialect)Engine)MockConnection) TypeGuard_T)bound_T_coT)rF covariant_CEzColumnElement[Any]_CLEr(ceZdZdZddZdS)_HasClauseElementz8indicates a class that has a __clause_element__() methodreturn"roles.ExpressionElementRole[_T_co]cdSNselfs Q/var/www/html/reinick/venv/lib/python3.11/site-packages/sqlalchemy/sql/_typing.py__clause_element__z$_HasClauseElement.__clause_element__[N)rMrN)__name__ __module__ __qualname____doc__rUrQrWrTrLrLXs"BBKKKKKKrWrLceZdZdZddZdS)_CoreAdapterProtoz?protocol for the ClauseAdapter/ColumnAdapter.traverse() method.objrIrMcdSrPrQ)rSr^s rT__call__z_CoreAdapterProto.__call__arVrWN)r^rIrMrI)rXrYrZr[r`rQrWrTr]r]^s"II,,,,,,rWr]c*eZdZdZeddZdS) _HasDialectzQprotocol for Engine/Connection-like objects that have dialect attribute. rMrAcdSrPrQrRs rTdialectz_HasDialect.dialectis"%#rWN)rMrA)rXrYrZr[propertyrdrQrWrTrbrbds2%%%X%%%rWrb _NOT_ENTITYrrrrr!r )*r _MAYBE_ENTITYr-zColumnElement[_T]zSQLCoreOperations[_T]_TP._T0_T1_T2_T3_T4_T5_T6_T7_T8_T9r.rColumnExpressionArgumentz Select[_TP]zCompoundSelect[_TP]zSQLCoreOperations[Any]_DMLKeyz Column[Any]r<r5r1r3zTypeEngine[_T])auto ignore_fk)rBr@rCcr#rMTypeGuard[SQLCompiler]cdSrPrQrxs rTis_sql_compilerr|7rVrWTypeGuard[DDLCompiler]cdSrPrQr{s rTis_ddl_compilerr9rVrWtr/TypeGuard[NamedFromClause]cdSrPrQrs rTis_named_from_clauser;s%(SrWTypeGuard[ColumnElement[Any]]cdSrPrQr{s rTis_column_elementr?s(+rW"TypeGuard[KeyedColumnElement[Any]]cdSrPrQr{s rTis_keyed_column_elementrCs-0SrWTypeGuard[TextClause]cdSrPrQr{s rTis_text_clauserGrVrWTypeGuard[FromClause]cdSrPrQr{s rTis_from_clauserIrVrWTypeEngine[Any]TypeGuard[TupleType]cdSrPrQrs rT is_tuple_typerKrVrWTypeGuard[TableValueType]cdSrPrQrs rTis_table_value_typerMs$'CrWrTypeGuard[Selectable]cdSrPrQrs rT is_selectablerQrVrWUnion[Executable, ReturnsRows]TypeGuard[SelectBase]cdSrPrQrs rTis_select_baserSs #rWTypeGuard[Select[Any]]cdSrPrQrs rTis_select_statementrWs!$rWr4TypeGuard[TableClause]cdSrPrQrs rTis_tabler[rVrWTypeGuard[Subquery]cdSrPrQrs rT is_subqueryr]rVrWTypeGuard[UpdateBase]cdSrPrQr{s rTis_dmlr_rVrWis_sqlis_ddlnamed_with_column_is_column_element_is_keyed_column_element_is_text_clause_is_from_clause_is_tuple_type_is_table_valuer_is_select_base_is_select_statement _is_table _is_subqueryrc"t|dS)Nschemahasattrrs rThas_schema_attrrss 1h  rWsstrTypeGuard[quoted_name]c"t|dS)Nquoterrs rTis_quoted_namerws 1g  rWobject!TypeGuard[_HasClauseElement[Any]]c"t|dS)NrUrrs rTis_has_clause_elementr{s 1* + ++rWTypeGuard[ValuesBase]c,|jo |jp|jSrP)r is_insert is_updater{s rTis_insert_updaters 8 43 4rWexc.ArgumentErrorc*tjdS)Nz{Additional keyword arguments are not accepted by this function/method. The presence of **kw is for pep-484 typing purposes)r ArgumentErrorrQrWrT_no_kwrs   P  rWmethnamekwDict[str, Any]r cVt|d}t|d|d)Nrz% got an unexpected keyword argument '')list TypeError)rrks rT_unexpected_kwrs0 R A xJJaJJJ K KKrWval'SQLCoreOperations[_T]'!'SQLCoreOperations[Optional[_T]]'cdSrPrQrs rTNullablers ),rWroles.ExpressionElementRole[_T])roles.ExpressionElementRole[Optional[_T]]cdSrPrQrs rTrrs 14rWType[_T]Type[Optional[_T]]cdSrPrQrs rTrrs363rW_TypedColumnClauseArgument[_T](_TypedColumnClauseArgument[Optional[_T]]c|S)aTypes a column or ORM class as nullable. This can be used in select and other contexts to express that the value of a column can be null, for example due to an outer join:: stmt1 = select(A, Nullable(B)).outerjoin(A.bs) stmt2 = select(A.data, Nullable(B.data)).outerjoin(A.bs) At runtime this method returns the input unchanged. .. versionadded:: 2.0.20 rQrs rTrr  JrWcdSrPrQrs rT NotNullablers "crWcdSrPrQrs rTrrs '*crWcdSrPrQrs rTrr69crWOptional[Type[_T]]cdSrPrQrs rTrrrrWCUnion[_TypedColumnClauseArgument[Optional[_T]], Optional[Type[_T]]]c|S)a~Types a column or ORM class as not nullable. This can be used in select and other contexts to express that the value of a column cannot be null, for example due to a where condition on a nullable column:: stmt = select(NotNullable(A.value)).where(A.value.is_not(None)) At runtime this method returns the input unchanged. .. versionadded:: 2.0.20 rQrs rTrrrrW)rxr#rMry)rxr#rMr})rr/rMr)rxr(rMr)rxr(rMr)rxr(rMr)rxr(rMr)rrrMr)rrrMr)rrrMr)rrrMr)rrrMr)rr4rMr)rr4rMr)rxr(rMr)rr/rMr)rrrMr)rrrMr)rxr(rMr)rMr)rrrrrMr )rrrMr)rrrMr)rrrMr)rrrMr)rrrMr)rrrMr)rrrMr)rrrMr)rrrMr) __future__roperatortypingrrrrrr r r r r rrrrrrrr inspectionr util.typingrrrrrrrdecimalr uuidr!baser"compilerr#r$r%dmlr&r'elementsr(r)r*r+r,r-lambdasr.r/rr0 selectabler1r2r3r4r5r6r7r8r9r:r;r<sqltypesr=r>type_apir?enginer@rArB engine.mockrCrDrErGrIrJrLr]rbintrboolfloatrf _StarOrOneColumnsClauseRolerhExpressionElementRole_TextCoercedExpressionArgumentTypedColumnsClauseRole_ColumnsClauseArgument_TypedColumnClauseArgumentrirjrkrlrmrnrorprqrrrs_ColumnExpressionArgumentrt__annotations__"_ColumnExpressionOrLiteralArgument#_ColumnExpressionOrStrLabelArgument _ByArgument _InfoType_FromClauseArgumentJoinTargetRole_JoinTargetArgument OnClauseRole_OnClauseArgumentCompoundElementRole#_SelectStatementForCompoundArgument DMLColumnRole_DMLColumnArgumentru_DMLColumnKeyMappingDDLConstraintColumnRole_DDLColumnArgument_DMLTableArgument immutabledict_PropagateAttrsType_TypeEngineArgument_EquivalentColumnMap_LimitOffsetType_AutoIncrementType_CreateDropBindr|rrrrrrrrrrrrrr attrgetterrrrrrrrrrQrWrTr*s #"""""" $$$$$$!!!!!!""""""######*(!!!!!!""""""      """"""%%%%%%%%%%%%'''''''''''',,,,,,%%%%%%++++++$$$$$$&&&&&&%%%%%%!!!!!!******&&&&&&      ++++++''''''""""""&&&&&&&&&&&&$$$$$$''''''((((((######$$$$$$######      ,,,,,,'''''' WTsd333ge/000wv_---LLLLL'%.LLL -------- &&&&&(&&&g        V_  I!#&'c  "'b # %"  $ H!"%&b #  $H ge5c?+++ ge3 ge3 ge3 ge3 ge3 ge3 ge3 ge3 ge3 ge3"b #  $ R$ $% 5&?&CCCCC &+30I"0M+M%N"&+C1J21N,N&O# 0 56',. K cN A I!#&'c  /1EEF 3C8%:LLM ', '# Nc   ')#5 6 6 6w|,3 u/LLM    I!#&'c (c2D!124DDE0#6J2KKL7@A;+CCCCCCCC)))),,,,1111GFFFFFFFFFFF((((<;;;$$$$%%%%?>>>>>>>>>>>>*h)(33O)h)(33O.8./BCC++,@AA1h12LMM(X():;;N(X():;;N'H'(899M-(-.?@@'H'88M(X():;;N-(-.DEE"x";//H%(%n55K X  * *F    ,,,,5555LLLL  ,,, ,  444 4  666 6$ """ "  *** *  999 9 999 9rW