@g/  UddlmZddlZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lm Z dd lm Z dd lm Z dd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZerddlmZddlmZddlmZddlmZddlm Z ddl!m"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+l3m4Z4dd,lm5Z5dd-lm6Z6dd.l7m8Z8dd/l9m:Z:dd0l9m;Z;dd1l9mZ>dd4l9m?Z?dd5l9m@Z@dd6l9mAZAdd7l9mBZBdd8l9mCZCdd9l9mDZDdd:lEmFZFdd;lEmGZGdde?ZKed@dA?ZLedBdC?ZMGdDdEeZNGdFdGeZOedHePeQdIdJdKdLdMeRdN ZSedOej5edPe eeeNeNZTeeQdQdReNejUeKfZVeejWeKej5dSedPe eKeeNeNfZX eejWeKdSe eKfZYedTe edUf?ZZedVe?Z[edWe?Z\edXe?Z]edYe?Z^edZe?Z_ed[e?Z`ed\e?Zaed]e?Zbed^e?Zced_e?ZdedReNdSejUeKegdRfd`fZe eeeKZfdaegdb< eeeeeKfZheeQeeeKfZieeefZj eej6e eeeNeNfZk eekejlfZm eeeeejnfZo edcejpfZq eeQeNejrddfZs edees?ZteetefZueeQdfejvfZw edgdhdidje eeeNeNfZxejyeQefZzee dkdkfZ{edAe dAfZ|eePeeePdfZ}ee~edlfZer=ddqZddsZddwZddyZdd{Zdd}ZddZddZddZddZddZddZddZddZddZnejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZejdZddZddZddZddZddZddZe ddZe ddZe ddZddZe ddZe dd„Ze ddÄZe ddńZddDŽZdS)) annotationsN)Any)Callable)Dict)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)ColumnsClauseRole)FromClauseRole)Column)Alias)CTE) FromClause)Join)NamedFromClause) ReturnsRows)Select) Selectable) SelectBase)Subquery) TableClause)TableValueType) TupleType) TypeEngine) TypeGuard_T)bound_CEzColumnElement[Any]_CLEr&ceZdZdZddZdS)_HasClauseElementz8indicates a class that has a __clause_element__() methodreturnr-cdSN)selfs J/var/www/piapp/venv/lib/python3.11/site-packages/sqlalchemy/sql/_typing.py__clause_element__z$_HasClauseElement.__clause_element__T N)rEr-)__name__ __module__ __qualname____doc__rKrHrMrJrDrDQs.BB      rMrDceZdZdZddZdS)_CoreAdapterProtoz?protocol for the ClauseAdapter/ColumnAdapter.traverse() method.objrArEcdSrGrH)rIrTs rJ__call__z_CoreAdapterProto.__call__[rLrMN)rTrArErA)rNrOrPrQrVrHrMrJrSrSXs.II      rMrS _NOT_ENTITYrrrrrr _MAYBE_ENTITY)*rr+zColumnElement[_T]zSQLCoreOperations[_T]_TP._T0_T1_T2_T3_T4_T5_T6_T7_T8_T9r,rColumnExpressionArgumentr8zSQLCoreOperations[Any]_DMLKeyz Column[Any]r:r3r0r1zTypeEngine[_T])auto ignore_fkcr!rETypeGuard[SQLCompiler]cdSrGrHris rJis_sql_compilerrmrLrMTypeGuard[DDLCompiler]cdSrGrHrls rJis_ddl_compilerrprLrMtr.TypeGuard[NamedFromClause]cdSrGrHrqs rJis_named_from_clauseru!rLrMTypeGuard[ColumnElement[Any]]cdSrGrHrls rJis_column_elementrx$rLrM"TypeGuard[KeyedColumnElement[Any]]cdSrGrHrls rJis_keyed_column_elementr{'  rMTypeGuard[TextClause]cdSrGrHrls rJis_text_clauser,rLrMTypeGuard[FromClause]cdSrGrHrls rJis_from_clauser/rLrMTypeEngine[Any]TypeGuard[TupleType]cdSrGrHrts rJ is_tuple_typer2rLrMTypeGuard[TableValueType]cdSrGrHrts rJis_table_value_typer5rLrMrTypeGuard[Selectable]cdSrGrHrts rJ is_selectabler8rLrMUnion[Executable, ReturnsRows]TypeGuard[SelectBase]cdSrGrHrts rJis_select_baser;r|rMTypeGuard[Select[Any]]cdSrGrHrts rJis_select_statementr@r|rMr2TypeGuard[TableClause]cdSrGrHrts rJis_tablerErLrMTypeGuard[Subquery]cdSrGrHrts rJ is_subqueryrHrLrMTypeGuard[UpdateBase]cdSrGrHrls rJis_dmlrKrLrMis_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)Nschemahasattrrts rJhas_schema_attrr`s 1h  rMsstrTypeGuard[quoted_name]c"t|dS)Nquoterrs rJis_quoted_namerds 1g  rMobjectTypeGuard[_HasClauseElement]c"t|dS)NrKrrs rJis_has_clause_elementrhs 1* + ++rMTypeGuard[ValuesBase]c,|jo |jp|jSrG)r is_insert is_updaterls rJis_insert_updaterls 8 43 4rMexc.ArgumentErrorc*tjdS)Nz{Additional keyword arguments are not accepted by this function/method. The presence of **kw is for pep-484 typing purposes)r ArgumentErrorrHrMrJ_no_kwrps   P  rMmethnamekwDict[str, Any]rcVt|d}t|d|d)Nrz% got an unexpected keyword argument '')list TypeError)rrks rJ_unexpected_kwrws0 R A xJJaJJJ K KKrMval'SQLCoreOperations[_T]'!'SQLCoreOperations[Optional[_T]]'cdSrGrHrs rJNullabler| CrMroles.ExpressionElementRole[_T])roles.ExpressionElementRole[Optional[_T]]cdSrGrHrs rJrrrrMType[_T]Type[Optional[_T]]cdSrGrHrs rJrrCrM_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 rHrs rJrr  JrMcdSrGrHrs rJ NotNullablerrrMcdSrGrHrs rJrrrrMcdSrGrHrs rJrrrrMOptional[Type[_T]]cdSrGrHrs rJrrrrMCUnion[_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 rHrs rJrrrrM)rir!rErj)rir!rErn)rqr.rErr)rir&rErv)rir&rEry)rir&rEr})rir&rEr)rqrrEr)rqrrEr)rqrrEr)rqrrEr)rqrrEr)rqr2rEr)rqr2rEr)rir&rEr)rqr.rEr)rrrEr)rrrEr)rir&rEr)rEr)rrrrrEr)rrrEr)rrrEr)rrrEr)rrrEr)rrrEr)rrrEr)rrrEr)rrrEr)rrrEr) __future__roperatortypingrrrrrr r r r r rrrrrr inspectionr util.typingrrrrrrrdecimalruuidrbaser compilerr!r"r#dmlr$r%elementsr&r'r(r)r*r+lambdasr,r-r.rr/ selectabler0r1r2r3r4r5r6r7r8r9r:sqltypesr;r<type_apir=r>r?rArBrDrSintrfloatrWrXExpressionElementRole_TextCoercedExpressionArgumentTypedColumnsClauseRole_ColumnsClauseArgument_TypedColumnClauseArgumentrZr[r\r]r^r_r`rarbrcrd_ColumnExpressionArgumentre__annotations__"_ColumnExpressionOrLiteralArgument#_ColumnExpressionOrStrLabelArgument _InfoType_FromClauseArgumentJoinTargetRole_JoinTargetArgument OnClauseRole_OnClauseArgumentCompoundElementRole#_SelectStatementForCompoundArgument DMLColumnRole_DMLColumnArgumentrf_DMLColumnKeyMappingDDLConstraintColumnRole_DDLColumnArgument_DMLTableArgument immutabledict_PropagateAttrsType_TypeEngineArgument_EquivalentColumnMap_LimitOffsetTypebool_AutoIncrementTypermrprurxr{rrrrrrrrrr attrgetterrrrrrrrrrHrMrJrs #"""""" $$$$$$!!!!!!""""""######&(!!!!!!""""""      """"""%%%%%%%%%%%%'''''''''''',,,,,,%%%%%%++++++$$$$$$&&&&&&((((((%%%%%%!!!!!!&&&&&&      ++++++''''''""""""&&&&&&&&&&&&$$$$$$''''''((((((######$$$$$$'''''' WTge/000wv_---                g          FOI!"  "' # %"  $  FOH!" #  $H ge5c?+++ ge3 ge3 ge3 ge3 ge3 ge3 ge3 ge3 ge3 ge3" # R$ $% 5&?&CCCCC &+30I"0M+M%N"&+C1J21N,N&O# cN A I!"  /1EEF 3C8%:LLM ',%++'#N   ')#5 6 6 6w|,3 u/LLM    I!" (c2D!124DDE0#6J2KKL7D+                                                             *h)(33O)h)(33O.8./BCC++,@AA1h12LMM(X():;;N(X():;;N'H'(899M-(-.?@@'H'88M(X():;;N-(-.DEE"x";//H%(%n55K X  * *F    ,,,,5555LLLL         $          rM