o E6d1 @sxUddlmZddlZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lm Z dd lm Z dd lm Z dd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZerdddlmZddlmZddlmZddlmZddlm 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;lEmGZGdded?ZKed@dAd?ZLedBdCd?ZMGdDdEdEeZNGdFdGdGeZOedHePeQdIdJdKdLdMeRdN ZSedOej5edPe eeeNeNZTeeQdQdReNejUeKfZVeejWeKej5dSedPe eKeeNeNfZX eejWeKdSe eKfZYedTe edUfd?ZZedVed?Z[edWed?Z\edXed?Z]edYed?Z^edZed?Z_ed[ed?Z`ed\ed?Zaed]ed?Zbed^ed?Zced_ed?ZdedReNdSejUeKegdRfd`fZe eeeKZfdaegdb< eeeeeKfZheeQeeeKfZieeefZj eej6e eeeNeNfZk eekejlfZm eeeeejnfZo edcejpfZq eeQeNejrddfZs edeesd?ZteetefZueeQdfejvfZw edgdhdidje eeeNeNfZxejyeQefZzee dkdkfZ{edAe dAfZ|eePeeePdfZ}ee~edlfZerddqdrZddtduZddydzZdd|d}ZdddZdddZdddZdddZdddZdddZdddZdddZdddZdddZdddZnKedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZdddZdddZdddZdddZdddZdddƄZe ddd˄Ze ddd˄Ze ddd˄Zddd˄Ze dddքZe dddքZe dddքZe dddք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%c@seZdZdZdddZdS)_HasClauseElementz8indicates a class that has a __clause_element__() methodreturnr,cCdSN)selfrFrFmC:\Users\jesus\OneDrive\Desktop\erpjis_fastapi\backend\jisbackend\Lib\site-packages\sqlalchemy/sql/_typing.py__clause_element__Tz$_HasClauseElement.__clause_element__N)rCr,)__name__ __module__ __qualname____doc__rIrFrFrFrHrBQrBc@seZdZdZdddZdS) _CoreAdapterProtoz?protocol for the ClauseAdapter/ColumnAdapter.traverse() method.objr@rCcCrDrErF)rGrQrFrFrH__call__[rJz_CoreAdapterProto.__call__N)rQr@rCr@)rKrLrMrNrRrFrFrFrHrPXrOrP _NOT_ENTITYrrrrrr _MAYBE_ENTITY)*rr*zColumnElement[_T]zSQLCoreOperations[_T]_TP._T0_T1_T2_T3_T4_T5_T6_T7_T8_T9r+rColumnExpressionArgumentr7zSQLCoreOperations[Any]_DMLKeyz Column[Any]r9r2r/r0zTypeEngine[_T])autoZ ignore_fkcr rCTypeGuard[SQLCompiler]cCrDrErFrdrFrFrHis_sql_compilerrJrgTypeGuard[DDLCompiler]cCrDrErFrfrFrFrHis_ddl_compilerrJritr-TypeGuard[NamedFromClause]cCrDrErFrjrFrFrHis_named_from_clause!rJrmTypeGuard[ColumnElement[Any]]cCrDrErFrfrFrFrHis_column_element$rJro"TypeGuard[KeyedColumnElement[Any]]cCrDrErFrfrFrFrHis_keyed_column_element'rqTypeGuard[TextClause]cCrDrErFrfrFrFrHis_text_clause,rJrtTypeGuard[FromClause]cCrDrErFrfrFrFrHis_from_clause/rJrvTypeEngine[Any]TypeGuard[TupleType]cCrDrErFrlrFrFrH is_tuple_type2rJryTypeGuard[TableValueType]cCrDrErFrlrFrFrHis_table_value_type5rJr{rTypeGuard[Selectable]cCrDrErFrlrFrFrH is_selectable8rJr}Union[Executable, ReturnsRows]TypeGuard[SelectBase]cCrDrErFrlrFrFrHis_select_base;rrrTypeGuard[Select[Any]]cCrDrErFrlrFrFrHis_select_statement@rrrr1TypeGuard[TableClause]cCrDrErFrlrFrFrHis_tableErJrTypeGuard[Subquery]cCrDrErFrlrFrFrH is_subqueryHrJrTypeGuard[UpdateBase]cCrDrErFrfrFrFrHis_dmlKrJrZis_sqlZis_ddlZnamed_with_columnZ_is_column_elementZ_is_keyed_column_elementZ_is_text_clauseZ_is_from_clauseZ_is_tuple_typeZ_is_table_valueZ_is_select_baseZ_is_select_statementZ _is_tableZ _is_subquerycC t|dS)NschemahasattrrlrFrFrHhas_schema_attr` rsstrTypeGuard[quoted_name]cCr)NquoterrrFrFrHis_quoted_namedrrobjectTypeGuard[_HasClauseElement]cCr)NrIrrrFrFrHis_has_clause_elementhrrTypeGuard[ValuesBase]cCs|jo|jp|jSrE)rZ is_insertZ is_updaterfrFrFrHis_insert_updatelsrexc.ArgumentErrorcCs tdS)Nz{Additional keyword arguments are not accepted by this function/method. The presence of **kw is for pep-484 typing purposes)r ArgumentErrorrFrFrFrH_no_kwpsrmethnamekwDict[str, Any]rcCs t|d}t|d|d)Nrz% got an unexpected keyword argument '')list TypeError)rrkrFrFrH_unexpected_kwws rval'SQLCoreOperations[_T]'!'SQLCoreOperations[Optional[_T]]'cCrDrErFrrFrFrHNullable|rroles.ExpressionElementRole[_T])roles.ExpressionElementRole[Optional[_T]]cCrDrErFrrFrFrHrrType[_T]Type[Optional[_T]]cCrDrErFrrFrFrHr_TypedColumnClauseArgument[_T](_TypedColumnClauseArgument[Optional[_T]]cC|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 rFrrFrFrHrcCrDrErFrrFrFrH NotNullablerrcCrDrErFrrFrFrHrrcCrDrErFrrFrFrHrrOptional[Type[_T]]cCrDrErFrrFrFrHrrCUnion[_TypedColumnClauseArgument[Optional[_T]], Optional[Type[_T]]]cCr)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 rFrrFrFrHrr)rdr rCre)rdr rCrh)rjr-rCrk)rdr%rCrn)rdr%rCrp)rdr%rCrs)rdr%rCru)rjrwrCrx)rjrwrCrz)rjrrCr|)rjr~rCr)rjr~rCr)rjr1rCr)rjr1rCr)rdr%rCr)rjr-rCr)rrrCr)rrrCr)rdr%rCr)rCr)rrrrrCr)rrrCr)rrrCr)rrrCr)rrrCr)rrrCr)rrrCr)rrrCr)rrrCr)rrrCr) __future__roperatortypingrrrrrrr r r r r rrrrrZ inspectionrZ util.typingrrrrrrrdecimalruuidrbasercompilerr r!r"Zdmlr#r$elementsr%r&r'r(r)r*Zlambdasr+r,r-rr.Z selectabler/r0r1r2r3r4r5r6r7r8r9Zsqltypesr:r;Ztype_apir<r=r>r@rArBrPintrfloatrSrTZExpressionElementRoleZ_TextCoercedExpressionArgumentZTypedColumnsClauseRoleZ_ColumnsClauseArgumentZ_TypedColumnClauseArgumentrVrWrXrYrZr[r\r]r^r_r`Z_ColumnExpressionArgumentra__annotations__Z"_ColumnExpressionOrLiteralArgumentZ#_ColumnExpressionOrStrLabelArgumentZ _InfoTypeZ_FromClauseArgumentZJoinTargetRoleZ_JoinTargetArgumentZ OnClauseRoleZ_OnClauseArgumentZCompoundElementRoleZ#_SelectStatementForCompoundArgumentZ DMLColumnRoleZ_DMLColumnArgumentrbZ_DMLColumnKeyMappingZDDLConstraintColumnRoleZ_DDLColumnArgumentZ_DMLTableArgumentZ immutabledictZ_PropagateAttrsTypeZ_TypeEngineArgumentZ_EquivalentColumnMapZ_LimitOffsetTypeboolZ_AutoIncrementTypergrirmrorqrtrvryr{r}rrrrr attrgetterrrrrrrrrrFrFrFrHs