U
|
¸ý°d a ã @ s U d Z ddlmZ ddlZddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd lm Z dd
|
lm
|
Z
|
d d l m Z d d l m Z ejrÈd dlmZ d dlmZ d dlmZ d dlmZ d dlmZ ejrØded< ndZG dd dZG dd deeZ G dd de Z G dd d e Z G d d d e Z G d d d e Z G d!d" d"e Z!G d#d$ d$e Z"G d%d& d&e Z#G d'd( d(e Z$G d)d* d*e Z%G d+d, d,e%Z&G d-d. d.e Z'G d/d0 d0e Z(G d1d2 d2e(Z)G d3d4 d4e Z*G d5d6 d6e Z+G d7d8 d8e+Z,G d9d: d:e+Z-G d;d< d<e+Z.G d=d> d>e+Z/G d?d@ d@e+e0Z1G dAdB dBe+Z2G dCdD dDe+Z3G dEdF dFe+Z4G dGdH dHe+Z5G dIdJ dJe+Z6G dKdL dLe4Z7G dMdN dNe4Z8G dOdP dPe+Z9G dQdR dRe+Z:G dSdT dTe+Z;G dUdV dVZ<G dWdX dXe Z=G dYdZ dZe=Z>G d[d\ d\e>Z?G d]d^ d^e>Z@G d_d` d`e@ZAG dadb dbe@ZBG dcdd dde@ZCG dedf dfe@ZDG dgdh dhe@ZEG didj dje@ZFG dkdl dleGZHG dmdn dneeIZJG dodp dpeJZKG dqdr dreKZLG dsdt dteKZMG dudv dveNZOG dwdx dxeePZQdS )yz¿Exceptions used with SQLAlchemy.
|
|
The base exception class is :exc:`.SQLAlchemyError`. Exceptions which are
|
raised as a result of DBAPI exceptions are all subclasses of
|
:exc:`.DBAPIError`.
|
|
é )Ú annotationsN)ÚAny)ÚList)ÚOptional)Úoverload)ÚTuple)ÚType)ÚUnioné )Úcompat)Ú preloaded)Ú_AnyExecuteParams)ÚDialect)ÚCompiled)Ú TypeCompiler)Ú ClauseElementÚstrÚ_version_tokenc sZ e Zd ZU dZdZded< ddd fdd Zd Zd
|
d d d Zd
|
d fdd Z Z
|
S )ÚHasDescriptionCodezDhelper which adds 'code' as an attribute and '_code_str' as a methodNú Optional[str]Úcoder )ÚargÚkwc s, | dd ¡}|d k r|| _t j|| d S )Nr )Úpopr ÚsuperÚ__init__)Úselfr r r ©Ú __class__© úEd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/exc.pyr 0 s zHasDescriptionCode.__init__Úerrorr ©Úreturnc C s* | j s
|
dS d| j dt d| j dS d S )NÚ z(Background on this z at: https://sqlalche.me/e/ú/ú))r Ú _what_are_wer ©r r r r Ú _code_str8 s ÿz HasDescriptionCode._code_strc s$ t ¡ }| jr d|| ¡ f }|S ©Nz%s %s)r Ú__str__r r) ©r Úmessager r r r+ A s
|
zHasDescriptionCode.__str__) Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r Ú__annotations__r r' r) r+ Ú __classcell__r r r r r + s
|
r c @ s: e Zd ZdZddddZddddZdddd Zd
|
S ) ÚSQLAlchemyErrorzGeneric error class.r r" c C sJ t | jdkr<| jd }t|tr0t |d¡}nt|}|S t| jS d S )Nr
|
r zutf-8)ÚlenÚargsÚ
|
isinstanceÚbytesr Zdecode_backslashreplacer )r Zarg_textÚtextr r r Ú_messageK s
|
|
zSQLAlchemyError._messagec C s" | ¡ }| jr d|| ¡ f }|S r* )r: r r) r, r r r Ú _sql_messagej s z SQLAlchemyError._sql_messagec C s | ¡ S ©N)r; r( r r r r+ r s zSQLAlchemyError.__str__N)r. r/ r0 r1 r: r; r+ r r r r r4 H s r4 c @ s e Zd ZdZdS )Ú ArgumentErrorzRaised when an invalid or conflicting function argument is supplied.
|
|
This error generally corresponds to construction time state errors.
|
|
N©r. r/ r0 r1 r r r r r= v s r= c @ s e Zd ZdZdS )ÚDuplicateColumnErrorz¥a Column is being added to a Table that would replace another
|
Column, without appropriate parameters to allow this in place.
|
|
.. versionadded:: 2.0.0b4
|
|
Nr> r r r r r? ~ s r? c s4 e Zd ZdZdd fdd Zdddd Z ZS )
|
ÚObjectNotExecutableErrorzVRaised when an object is passed to .execute() that can't be
|
executed as SQL.
|
|
r )Útargetc s t d| ¡ || _d S )Nz Not an executable object: %r)r r rA )r rA r r r r s z!ObjectNotExecutableError.__init__úUnion[str, Tuple[Any, ...]]r" c C s | j | jffS r< )r rA r( r r r Ú
|
__reduce__ s z#ObjectNotExecutableError.__reduce__)r. r/ r0 r1 r rC r3 r r r r r@ s r@ c @ s e Zd ZdZdS )ÚNoSuchModuleErrorzpRaised when a dynamically-loaded module (usually a database dialect)
|
of a particular name cannot be located.Nr> r r r r rD s rD c @ s e Zd ZdZdS )ÚNoForeignKeysErrorzURaised when no foreign keys can be located between two selectables
|
during a join.Nr> r r r r rE s rE c @ s e Zd ZdZdS )ÚAmbiguousForeignKeysErrorzhRaised when more than one foreign key matching can be located
|
between two selectables during a join.Nr> r r r r rF s rF c @ s e Zd ZdZdS )Ú ConstraintColumnNotFoundErrorzraised when a constraint refers to a string column name that
|
is not present in the table being constrained.
|
|
.. versionadded:: 2.0
|
|
Nr> r r r r rG ¤ s rG c @ s6 e Zd ZdZd ddddddddZd d
|
d d ZdS )ÚCircularDependencyErrora Raised by topological sorts when a circular dependency is detected.
|
|
There are two scenarios where this error occurs:
|
|
* In a Session flush operation, if two objects are mutually dependent
|
on each other, they can not be inserted or deleted via INSERT or
|
DELETE statements alone; an UPDATE will be needed to post-associate
|
or pre-deassociate one of the foreign key constrained values.
|
The ``post_update`` flag described at :ref:`post_update` can resolve
|
this cycle.
|
* In a :attr:`_schema.MetaData.sorted_tables` operation, two
|
:class:`_schema.ForeignKey`
|
or :class:`_schema.ForeignKeyConstraint` objects mutually refer to each
|
other. Apply the ``use_alter=True`` flag to one or both,
|
see :ref:`use_alter`.
|
|
Nr r r )r- ÚcyclesÚedgesÚmsgr c C sJ |d kr&|dd dd |D ¡ 7 }n|}tj| ||d || _|| _d S )Nz (%s)z, c s s | ]}t |V qd S r< )Úrepr)Ú.0Úsr r r Ú <genexpr>É s z3CircularDependencyError.__init__.<locals>.<genexpr>©r )Újoinr4 r rI rJ )r r- rI rJ rK r r r r r À s z CircularDependencyError.__init__rB r" c C s2 | j d | j| j| jd f| jd k r,d| jini fS )Nr r )r rI rJ r6 r r( r r r rC Ð s ýz"CircularDependencyError.__reduce__)NN©r. r/ r0 r1 r rC r r r r rH s
|
úrH c @ s e Zd ZdZdS )Ú CompileErrorz2Raised when an error occurs during SQL compilationNr> r r r r rS Ø s rS c s> e Zd ZdZdZddddd fdd Zd
|
d d d Z ZS )ÚUnsupportedCompilationErrorzRaised when an operation is not supported by the given compiler.
|
|
.. seealso::
|
|
:ref:`faq_sql_expression_string`
|
|
:ref:`error_l7de`
|
Zl7deNz Union[Compiled, TypeCompiler]zType[ClauseElement]r )ÚcompilerÚ element_typer- c s8 t d|||rd| ndf ¡ || _|| _|| _d S )Nz-Compiler %r can't render element of type %s%sz: %sr$ )r r rU rV r- )r rU rV r- r r r r è s ÿÿz$UnsupportedCompilationError.__init__rB r" c C s | j | j| j| jffS r< )r rU rV r- r( r r r rC ö s z&UnsupportedCompilationError.__reduce__)N)r. r/ r0 r1 r r rC r3 r r r r rT Ü s
|
ürT c @ s e Zd ZdZdS )ÚIdentifierErrorz;Raised when a schema name is beyond the max character limitNr> r r r r rW ú s rW c @ s e Zd ZU dZdZded< dS )ÚDisconnectionErrora¤ A disconnect is detected on a raw DB-API connection.
|
|
This error is raised and consumed internally by a connection pool. It can
|
be raised by the :meth:`_events.PoolEvents.checkout`
|
event so that the host pool
|
forces a retry; the exception will be caught three times in a row before
|
the pool gives up and raises :class:`~sqlalchemy.exc.InvalidRequestError`
|
regarding the connection attempt.
|
|
FÚboolÚinvalidate_poolN©r. r/ r0 r1 rZ r2 r r r r rX þ s
|
rX c @ s e Zd ZU dZdZded< dS )ÚInvalidatePoolErroraé Raised when the connection pool should invalidate all stale connections.
|
|
A subclass of :class:`_exc.DisconnectionError` that indicates that the
|
disconnect situation encountered on the connection probably means the
|
entire pool should be invalidated, as the database has been restarted.
|
|
This exception will be handled otherwise the same way as
|
:class:`_exc.DisconnectionError`, allowing three attempts to reconnect
|
before giving up.
|
|
.. versionadded:: 1.2
|
|
TrY rZ Nr[ r r r r r\ s
|
r\ c @ s e Zd ZdZdS )Ú TimeoutErrorz@Raised when a connection pool times out on getting a connection.Nr> r r r r r] s r] c @ s e Zd ZdZdS )ÚInvalidRequestErrorzvSQLAlchemy was asked to do something it can't do.
|
|
This error generally corresponds to runtime state errors.
|
|
Nr> r r r r r^ # s r^ c @ s e Zd ZdZdS )ÚIllegalStateChangeErrorzrAn object that tracks state encountered an illegal state change
|
of some kind.
|
|
.. versionadded:: 2.0
|
|
Nr> r r r r r_ + s r_ c @ s e Zd ZdZdS )ÚNoInspectionAvailablezaA subject passed to :func:`sqlalchemy.inspection.inspect` produced
|
no context for inspection.Nr> r r r r r` 4 s r` c @ s e Zd ZdZdS )ÚPendingRollbackErrorzlA transaction has failed and needs to be rolled back before
|
continuing.
|
|
.. versionadded:: 1.4
|
|
Nr> r r r r ra 9 s ra c @ s e Zd ZdZdS )ÚResourceClosedErrorzcAn operation was requested from a connection, cursor, or other
|
object that's in a closed state.Nr> r r r r rb B s rb c @ s e Zd ZdZdS )ÚNoSuchColumnErrorz1A nonexistent column is requested from a ``Row``.Nr> r r r r rc G s rc c @ s e Zd ZdZdS )Ú NoResultFoundzûA database result was required but none was found.
|
|
|
.. versionchanged:: 1.4 This exception is now part of the
|
``sqlalchemy.exc`` module in Core, moved from the ORM. The symbol
|
remains importable from ``sqlalchemy.orm.exc``.
|
|
|
Nr> r r r r rd K s rd c @ s e Zd ZdZdS )ÚMultipleResultsFounda A single database result was required but more than one were found.
|
|
.. versionchanged:: 1.4 This exception is now part of the
|
``sqlalchemy.exc`` module in Core, moved from the ORM. The symbol
|
remains importable from ``sqlalchemy.orm.exc``.
|
|
|
Nr> r r r r re W s re c @ s e Zd ZU dZded< dS )ÚNoReferenceErrorzDRaised by ``ForeignKey`` to indicate a reference cannot be resolved.r Ú
|
table_nameN)r. r/ r0 r1 r2 r r r r rf b s
|
rf c @ s e Zd ZdZdZdS )Ú AwaitRequiredzjError raised by the async greenlet spawn if no async operation
|
was awaited when it required one.
|
|
Zxd1rN©r. r/ r0 r1 r r r r r rh h s rh c @ s e Zd ZdZdZdS )ÚMissingGreenletzkError raised by the async greenlet await\_ if called while not inside
|
the greenlet spawn context.
|
|
Zxd2sNri r r r r rj q s rj c @ s. e Zd ZdZdddddZdddd Zd
|
S ) ÚNoReferencedTableErrorzQRaised by ``ForeignKey`` when the referred ``Table`` cannot be
|
located.
|
|
r )r- Útnamec C s t | |¡ || _d S r< )rf r rg )r r- rl r r r r s z NoReferencedTableError.__init__rB r" c C s | j | jd | jffS ©Nr )r r6 rg r( r r r rC s z!NoReferencedTableError.__reduce__NrR r r r r rk z s rk c @ s0 e Zd ZdZddddddZdddd Zd
|
S ) ÚNoReferencedColumnErrorzRRaised by ``ForeignKey`` when the referred ``Column`` cannot be
|
located.
|
|
r )r- rl Úcnamec C s t | |¡ || _|| _d S r< )rf r rg Ú column_name)r r- rl ro r r r r s z NoReferencedColumnError.__init__rB r" c C s | j | jd | j| jffS rm )r r6 rg rp r( r r r rC s þz"NoReferencedColumnError.__reduce__NrR r r r r rn s rn c @ s e Zd ZdZdS )ÚNoSuchTableErrorz7Table does not exist or is not visible to a connection.Nr> r r r r rq s rq c @ s e Zd ZdZdS )ÚUnreflectableTableErrorzUTable exists but can't be reflected for some reason.
|
|
.. versionadded:: 1.2
|
|
Nr> r r r r rr s rr c @ s e Zd ZdZdS )ÚUnboundExecutionErrorzASQL was attempted without a database connection to execute it on.Nr> r r r r rs ¦ s rs c @ s e Zd ZdZdS )Ú DontWrapMixina8 A mixin class which, when applied to a user-defined Exception class,
|
will not be wrapped inside of :exc:`.StatementError` if the error is
|
emitted within the process of executing a statement.
|
|
E.g.::
|
|
from sqlalchemy.exc import DontWrapMixin
|
|
class MyCustomException(Exception, DontWrapMixin):
|
pass
|
|
class MySpecialType(TypeDecorator):
|
impl = String
|
|
def process_bind_param(self, value, dialect):
|
if value == 'invalid':
|
raise MyCustomException("invalid!")
|
|
Nr> r r r r rt ª s rt c @ s e Zd ZU dZdZded< dZded< dZded< dZd ed
|
< d Z d ed < d ddddd dd dddZ
|
dddddZ ddddZ e d¡dddd ZdS ) ÚStatementErrorav An error occurred during execution of a SQL statement.
|
|
:class:`StatementError` wraps the exception raised
|
during execution, and features :attr:`.statement`
|
and :attr:`.params` attributes which supply context regarding
|
the specifics of the statement which had an issue.
|
|
The wrapped exception object is available in
|
the :attr:`.orig` attribute.
|
|
Nr Ú statementúOptional[_AnyExecuteParams]ÚparamszOptional[BaseException]ÚorigúOptional[bool]ÚismultiFrY Úconnection_invalidatedr )r- rv rx ry Úhide_parametersr r{ c C s8 t j| ||d || _|| _|| _|| _|| _g | _d S )NrP )r4 r rv rx ry r{ r} Údetail)r r- rv rx ry r} r r{ r r r r Ý s
|
zStatementError.__init__ÚNone)rK r# c C s | j |¡ d S r< )r~ Úappend)r rK r r r Ú
|
add_detailï s zStatementError.add_detailrB r" c C s8 | j | jd | j| j| j| j| j d¡| jfd| j ifS )Nr r r~ )
|
r r6 rv rx ry r} Ú__dict__Úgetr{ r~ r( r r r rC ò s
|
ù õzStatementError.__reduce__zsqlalchemy.sql.utilc C s t j}| ¡ g}| jrdd| j }| |¡ | jrd| jrB| d¡ n"|j| jd| jd}| d| ¡ | ¡ }|rz| |¡ d
|
dd | j D | ¡S ) Nz [SQL: %s]z3[SQL parameters hidden due to hide_parameters=True]é
|
)r{ z[parameters: %r]Ú
|
c S s g | ] }d | qS )z(%s)r )rM Zdetr r r Ú
|
<listcomp> s z/StatementError._sql_message.<locals>.<listcomp>) Ú
|
_preloadedZsql_utilr: rv r rx r} Z _repr_paramsr{ r) rQ r~ )r ÚutilÚdetailsZ stmt_detailZ params_reprZcode_strr r r r; s(
|
|
|
ÿ ÿ
|
zStatementError._sql_message)FNN)r. r/ r0 r1 rv r2 rx ry r{ r| r r rC r Zpreload_moduler; r r r r ru À s
|
ø ru c @ sÚ e Zd ZdZdZeed ddddd d d
|
d d d ddZeed ddddd d d
|
d dd ddZeed ddddd d d
|
d dd ddZed ddddd d d
|
d dd ddZddddZd!dddd d dd ddd Z dS )"Ú
|
DBAPIErrora Raised when the execution of a database operation fails.
|
|
Wraps exceptions raised by the DB-API underlying the
|
database operation. Driver-specific implementations of the standard
|
DB-API exception types are wrapped by matching sub-types of SQLAlchemy's
|
:class:`DBAPIError` when possible. DB-API's ``Error`` type maps to
|
:class:`DBAPIError` in SQLAlchemy, otherwise the names are identical. Note
|
that there is no guarantee that different DB-API implementations will
|
raise the same exception type for any given error condition.
|
|
:class:`DBAPIError` features :attr:`~.StatementError.statement`
|
and :attr:`~.StatementError.params` attributes which supply context
|
regarding the specifics of the statement which had an issue, for the
|
typical case when the error was raised within the context of
|
emitting a SQL statement.
|
|
The wrapped exception object is available in the
|
:attr:`~.StatementError.orig` attribute. Its type and properties are
|
DB-API implementation specific.
|
|
ZdbapiFNr rw Ú ExceptionzType[Exception]rY zOptional[Dialect]rz ru ) rv rx ry Údbapi_base_errr} r| Údialectr{ r# c C s d S r< r © Úclsrv rx ry r r} r| r r{ r r r Úinstance2 s zDBAPIError.instancert c C s d S r< r r r r r r A s Ú BaseExceptionc C s d S r< r r r r r r P s z#Union[BaseException, DontWrapMixin]c C s t |trt |tr t |tr"|S |d k rêt |trh|rhtd|jj|jj|j d f |||||j
|
|dS t ||s|rtd|jj|jj|f |||||dS t } |jj D ]>}
|
|
|
j} |rÆ|j | | ¡} | | krªt| | trª| | } qêqª| |||||| j
|
|dS )Nú
|
(%s.%s) %sr )r} r r{ )r} r{ )r| r} r r{ )r7 r r rt r4 ru r r/ r. r6 r ÚglobalsÚ__mro__Z dbapi_exception_translation_mapr Ú
|
issubclassr ) r rv rx ry r r} r| r r{ ÚglobZsuper_Únamer r r r _ sr ÿÿþýÿôýÿõ ÿùrB r" c C s4 | j | j| j| j| j| j| j d¡| jfd| j ifS )Nr r~ )
|
r rv rx ry r} r| r r r{ r~ r( r r r rC ¨ s
|
ù õzDBAPIError.__reduce__)rv rx ry r} r| r r{ c
|
|
C sr z t |}W n. tk
|
r: } zdt | }W 5 d } ~ X Y nX tj| d|jj|jj|f ||||||d || _d S )Nz.Error in str() of DB-API-generated exception: r )r r{ )r r ru r r r/ r. r| )
|
r rv rx ry r} r| r r{ r9 Úer r r r · s"
|
ÿ÷ zDBAPIError.__init__)FFNN)FFNN)FFNN)FFNN)FFNN)
|
r. r/ r0 r1 r r Ú classmethodr rC r r r r r r sF ÷$ ÷$ ÷$ ÷"H ør c @ s e Zd ZdZdZdS )ÚInterfaceErrorz Wraps a DB-API InterfaceError.Zrvf5Nri r r r r r Ó s r c @ s e Zd ZdZdZdS )Ú DatabaseErrorz Wraps a DB-API DatabaseError.Z4xp6Nri r r r r r Ù s r c @ s e Zd ZdZdZdS )Ú DataErrorzWraps a DB-API DataError.Z9h9hNri r r r r r ß s r c @ s e Zd ZdZdZdS )ÚOperationalErrorz Wraps a DB-API OperationalError.Ze3q8Nri r r r r r å s r c @ s e Zd ZdZdZdS )ÚIntegrityErrorz Wraps a DB-API IntegrityError.ZgkpjNri r r r r r ë s r c @ s e Zd ZdZdZdS )Ú InternalErrorz Wraps a DB-API InternalError.Z2j85Nri r r r r r ñ s r c @ s e Zd ZdZdZdS )ÚProgrammingErrorz Wraps a DB-API ProgrammingError.Zf405Nri r r r r r ÷ s r c @ s e Zd ZdZdZdS )ÚNotSupportedErrorz!Wraps a DB-API NotSupportedError.Ztw8gNri r r r r r¡ ý s r¡ c @ s e Zd ZdZdS )ÚSATestSuiteWarningzÀwarning for a condition detected during tests that is non-fatal
|
|
Currently outside of SAWarning so that we can work around tools like
|
Alembic doing the wrong thing with warnings.
|
|
Nr> r r r r r¢ s r¢ c @ s e Zd ZU dZdZded< dS )ÚSADeprecationWarningz$Issued for usage of deprecated APIs.Nr Údeprecated_since©r. r/ r0 r1 r¤ r2 r r r r r£ s
|
r£ c s4 e Zd ZU dZdZded< dd fdd Z ZS ) ÚBase20DeprecationWarningz©Issued for usage of APIs specifically deprecated or legacy in
|
SQLAlchemy 2.0.
|
|
.. seealso::
|
|
:ref:`error_b8d9`.
|
|
:ref:`deprecation_20_mode`
|
|
z1.4r r¤ r r" c s t ¡ d S )Nz> (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9))r r+ r( r r r r+ % s ÿÿz Base20DeprecationWarning.__str__)r. r/ r0 r1 r¤ r2 r+ r3 r r r r r¦ s
|
r¦ c @ s e Zd ZdZdS )ÚLegacyAPIWarningzEindicates an API that is in 'legacy' status, a long term deprecation.Nr> r r r r r§ , s r§ c @ s e Zd ZdZdS )ÚMovedIn20WarningzASubtype of RemovedIn20Warning to indicate an API that moved only.Nr> r r r r r¨ 0 s r¨ c @ s e Zd ZU dZdZded< dS )ÚSAPendingDeprecationWarningz}A similar warning as :class:`_exc.SADeprecationWarning`, this warning
|
is not used in modern versions of SQLAlchemy.
|
|
Nr r¤ r¥ r r r r r© 4 s
|
r© c @ s e Zd ZdZdZdS )Ú SAWarningzIssued at runtime.ÚwarningN)r. r/ r0 r1 r' r r r r rª > s rª )Rr1 Ú
|
__future__r Útypingr r r r r r r r r r r Ú TYPE_CHECKINGZengine.interfacesr r Z sql.compilerr r Z sql.elementsr r2 r r r r4 r= r? r@ rD rE rF rG rH rS rT rW rX r\ r] r^ r_ r` ra rb ÚKeyErrorrc rd re rf rh rj rk rn rq rr rs rt ru r r r r r r r r r¡ ÚWarningr¢ ÚDeprecationWarningr£ r¦ r§ r¨ ÚPendingDeprecationWarningr© ÚRuntimeWarningrª r r r r Ú<module> s
|
. + Y ;
|
