mxi4  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[eje_eeeeWeeWeZaee[d\d]eWeSejeSfZceejeSejd^e_eeSeeWeSeWeSfZe eejeSd^eeSfZfed_eed`fEZgedaeEZhedbeEZiedceEZjeddeEZkedeeEZledfeEZmedgeEZnedheEZoedieEZpedjeEZqed]eWeSejfZs ed]eWeSd^ejeSejeSegd]fdkfZt eteSZudlevdm< eeeteSfZwee[eteSfZxeeexeexefZy eeefZz eejnejeeeeeWeeWefZ{ ee{ejfZ} eeteejfZ edndoejfZ ee[eWeejdpfZ edqeEZe eefZee[drej fZ edsdtdudveeeeWeeWefZeje[efZeedwdwfZedJe dJfZeeZeteZdfZee\edxfZedyZerVddzZdd{Z dd|Z dd}Z dd~ZddZddZddZ ddZddZ ddZ ddZddZddZddZnej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZej<dZddZddZddZddZddZddZe ddZe ddZe ddZ ddZe ddZe ddZe ddZe ddZ ddZy)) 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(ceZdZdZddZy)_HasClauseElementz8indicates a class that has a __clause_element__() methodcyNselfs M/home/htdocs/ttos/venv/lib/python3.12/site-packages/sqlalchemy/sql/_typing.py__clause_element__z$_HasClauseElement.__clause_element__[N)returnz"roles.ExpressionElementRole[_T_co])__name__ __module__ __qualname____doc__rSrOrUrRrLrLXsBKrUrLceZdZdZddZy)_CoreAdapterProtoz?protocol for the ClauseAdapter/ColumnAdapter.traverse() method.cyrNrO)rQobjs rR__call__z_CoreAdapterProto.__call__arTrUN)r^rIrVrI)rWrXrYrZr_rOrUrRr\r\^sI,rUr\c"eZdZdZeddZy) _HasDialectzQprotocol for Engine/Connection-like objects that have dialect attribute. cyrNrOrPs rRdialectz_HasDialect.dialectis"%rUN)rVrA)rWrXrYrZpropertyrcrOrUrRrarads%%rUra _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@rCcyrNrOcs rRis_sql_compilerrzErTrUcyrNrOrxs rRis_ddl_compilerr|GrTrUcyrNrOts rRis_named_from_clauserIs%(rUcyrNrOrxs rRis_column_elementrMs(+rUcyrNrOrxs rRis_keyed_column_elementrQs-0rUcyrNrOrxs rRis_text_clauserUrTrUcyrNrOrxs rRis_from_clauserWrTrUcyrNrOr~s rR is_tuple_typerYrTrUcyrNrOr~s rRis_table_value_typer[s$'rUcyrNrOr~s rR is_selectabler_rTrUcyrNrOr~s rRis_select_baseras #rUcyrNrOr~s rRis_select_statementres!$rUcyrNrOr~s rRis_tablerirTrUcyrNrOr~s rR is_subqueryrkrTrUcyrNrOrxs rRis_dmlrmrTrUis_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_subqueryrct|dS)Nschemahasattrr~s rRhas_schema_attrrs 1h rUct|dS)Nquoterss rRis_quoted_namers 1g rUct|dS)NrSrrs rRis_has_clause_elementrs 1* ++rUcR|jxr|jxs |jSrN)r is_insert is_updaterxs rRis_insert_updaters 88 43 4rUc,tjdS)Nz{Additional keyword arguments are not accepted by this function/method. The presence of **kw is for pep-484 typing purposes)r ArgumentErrorrOrUrR_no_kwrs    P rUc@t|d}t|d|d)Nrz% got an unexpected keyword argument '')list TypeError)methnamekwks rR_unexpected_kwrs( R A xj EaSJ KKrUcyrNrOvals rRNullablers),rUcyrNrOrs rRrrs14rUcyrNrOrs rRrrs36rUc|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 rOrs rRrr  JrUcyrNrOrs rR NotNullablers"rUcyrNrOrs rRrrs'*rUcyrNrOrs rRrr69rUcyrNrOrs rRrrrrUc|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 rOrs rRrrrrU)ryr#rVzTypeGuard[SQLCompiler])ryr#rVzTypeGuard[DDLCompiler])rr/rVzTypeGuard[NamedFromClause])ryr(rVzTypeGuard[ColumnElement[Any]])ryr(rVz"TypeGuard[KeyedColumnElement[Any]])ryr(rVzTypeGuard[TextClause])ryr(rVzTypeGuard[FromClause])rTypeEngine[Any]rVzTypeGuard[TupleType])rrrVzTypeGuard[TableValueType])rrrVzTypeGuard[Selectable])rUnion[Executable, ReturnsRows]rVzTypeGuard[SelectBase])rrrVzTypeGuard[Select[Any]])rr4rVTypeGuard[TableClause])rr4rVzTypeGuard[Subquery])ryr(rVzTypeGuard[UpdateBase])rr/rVr)rstrrVzTypeGuard[quoted_name])robjectrVz!TypeGuard[_HasClauseElement[Any]])ryr(rVzTypeGuard[ValuesBase])rVzexc.ArgumentError)rrrzDict[str, Any]rVr )r'SQLCoreOperations[_T]'rV!'SQLCoreOperations[Optional[_T]]')rroles.ExpressionElementRole[_T]rV)roles.ExpressionElementRole[Optional[_T]])rType[_T]rVType[Optional[_T]])r_TypedColumnClauseArgument[_T]rVz(_TypedColumnClauseArgument[Optional[_T]])rrrVr)rrrVr)rrrVr)rzOptional[Type[_T]]rVr)rzCUnion[_TypedColumnClauseArgument[Optional[_T]], Optional[Type[_T]]]rVr) __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\raintrboolfloatre _StarOrOneColumnsClauseRolergExpressionElementRole_TextCoercedExpressionArgumentTypedColumnsClauseRole_ColumnsClauseArgument_TypedColumnClauseArgumentrhrirjrkrlrmrnrorprqrr DMLColumnRole_OnlyColumnArgument_ColumnExpressionArgumentrs__annotations__"_ColumnExpressionOrLiteralArgument#_ColumnExpressionOrStrLabelArgument _ByArgument _InfoType_FromClauseArgumentJoinTargetRole_JoinTargetArgument OnClauseRole_OnClauseArgumentCompoundElementRole#_SelectStatementForCompoundArgument_DMLColumnArgumentrt_DMLColumnKeyMappingDDLConstraintColumnRole_DDLColumnArgument_DMLTableArgument immutabledict_PropagateAttrsType_TypeEngineArgument_EquivalentColumnMap_LimitOffsetType_AutoIncrementType_CreateDropBindrzr|rrrrrrrrrrrrr attrgetterrrrrrrrrrOrUrRrsp# $!"#!" "%%'',%+$&%!*& +'"&&$'(#$# ,' Tsd3e/0v_-L'%.L -- &(&       V_  I!#&'c  "'b # %"   $ H!"%&b #   $H e5c?+ e3 e3 e3 e3 e3 e3 e3 e3 e3 e3b  "b #   $ R$ $% 5&?&C)C &+30I"0M+M%N"&+C1J21N,N&O# 0 56',. K cN A    %I!#&'c  /1E1EEF 3C8%:L:LLM ', '# Nc   )#5 6w|,3 u/L/LLM    I!#&'c ((c2D!124DDE0#6J2KKL7@ACC) ) #), , &,1 1 +1GFF( ( "(<$ )$ $% )% %?>>*h))(3O)h))(3O.8../BC+++,@A1h112LM(X(():;N(X(():;N'H''(89M-(--.?@'H''8M(X(():;N-(--.DE"x"";/H%(%%n5K X  *F ,5L  , ,&, ,  4 (4.4 4  6 6 '-$ " *"" "  * 2*$* *  9 9 9 9 L#rU