Ytj,UdZddlmZddlmZmZmZmZmZddl m Z ddl m Z m Z mZddlmZmZddlmZmZdd lmZmZmZmZerdd lmZmZeeeed zfzd zZ d e!d <iZ"de!d<e GddZ#dWdZ$Gdde%Z&Gdde%Z'Gdde'Z(Gdde'Z)Gdde)Z*Gd d!e)Z+Gd"d#e)Z,Gd$d%e)Z-Gd&d'e)Z.Gd(d)e)Z/Gd*d+e+Z0Gd,d-e+Z1Gd.d/e+Z2Gd0d1Z3dXd3Z4dYd7Z5dZd[d<Z6d\d>Z7dYd?Z8dYd@Z9idAe+dBe/dCe.dDe.dEe.dFe*dGe,dHe-dIe-dJe.dKe+dLe+dMe-dNe-dOe+dPe.dQe+idRe+dSe+dTe.dUe.dVe+dWe.dXe.dYe+dZe+d[e+d\e+d]e+d^e+d_e+d`e.dae-Z:Gdbdce)dddefZ;Gdgdhe)didjfZ<Gdkdle)dmdnfZ=Gdodpe+dqdrfZ>Gdsdte+dudvfZ?Gdwdxe+dydzfZ@Gd{d|e+d}d~fZAGdde+ddfZBGdde+ddfZCGdde+ddfZDGdde)ddfZEGdde/ddfZFGdde)ddfZGGdde)ddfZHGdde)ddfZIGdde)ddfZJGdde)ddfZKGdde)ddfZLGdde)ddfZMGdde)ddfZNGdde.ddfZOGdde.ddfZPGdde.ddfZQGdde*dd¬fZRGdÄde*ddƬfZSGdDŽde*ddʬfZTGd˄de*ddάfZUGdτde*ddҬfZVGdӄde*dd֬fZWGdׄde*ddڬfZXGdۄde*ddެfZYGd߄de*ddfZZGdde*ddfZ[Gdde*ddfZ\Gdde*ddfZ]Gdde*ddfZ^Gdde*ddfZ_Gdde*ddfZ`Gdde*ddfZaGdde*ddfZbGdde*ddfZcGdde*d d fZdGd d e*d dfZeGdde*ddfZfGdde*ddfZgGdde*ddfZhGdde*ddfZiGdd e*d!d"fZjGd#d$e*d%d&fZkGd'd(e*d)d*fZlGd+d,e*d-d.fZmGd/d0e*d1d2fZnGd3d4e*d5d6fZoGd7d8e*d9d:fZpGd;dfZqGd?d@e*dAdBfZrGdCdDe*dEdFfZsGdGdHe*dIdJfZtGdKdLe*dMdNfZuGdOdPe*dQdRfZvGdSdTe*dUdVfZwGdWdXe*dYdZfZxGd[d\e*d]d^fZyGd_d`e*dadbfZzGdcdde*dedffZ{Gdgdhe*didjfZ|Gdkdle*dmdnfZ}Gdodpe*dqdrfZ~Gdsdte*dudvfZGdwdxe*dydzfZGd{d|e*d}d~fZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*ddfZGdde*dd¬fZGdÄde*dŐdƬfZGdDŽde*dɐdʬfZGd˄de*d͐dάfZGdτde,dѐdҬfZGdӄde,dՐd֬fZGdׄde,dِdڬfZGdۄde,dݐdެfZGd߄de,ddfZGdde,ddfZGdde,ddfZGdde-ddfZGdde-ddfZGdde-ddfZGdde-ddfZGdde-ddfZGdde-ddfZGdde-ddfZGdde-d d fZGd d e-d dfZGdde-ddfZGdde-ddfZGdde-ddfZGdde-ddfZGdd e-d!d"fZGd#d$e.d%d&fZGd'd(e+d)d*fZGd+d,e+d-d.fZGd/d0e+d1d2fZGd3d4e-d5d6fZGd7d8e-d9d:fZGd;dfZGd?d@e+dAdBfZGdCdDe+dEdFfZGdGdHe+dIdJfZGdKdLe+dMdNfZGdOdPe+dQdRfZGdSdTe.dUdVfZGdWdXe+dYdZfZGd[d\e+d]d^fZGd_d`e+dadFfZGdbdce+dddJfZGdedfe+dgdNfZGdhdie+djdkfZGdldme+dndofZGdpdqe+drdҬfZGdsdte+dudvfZGdwdxe+dydzfZGd{d|e+d}d~fZGdde+ddfZGdde+ddfZGdde.ddfZGdde.ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.dd¬fZGdÄde.dŐdƬfZGdDŽde.dɐdʬfZGd˄de.d͐dάfZGdτde.dѐdҬfZGdӄde.dՐd֬fZGdׄde.dِdڬfZGdۄde.dݐdެfZGd߄de.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.d d fZGd d e.d dfZGdde.ddfZGdde.ddfZGdde.ddfZGdde.ddfZGdd e.d!d"fZGd#d$e.d%d&fZGd'd(e.d)d*fZGd+d,e.d-d.fZGd/d0e.d1d2fZGd3d4e.d5d6fZGd7d8e.d9d:fZGd;dfZGd?d@e.dAdBfZGdCdDe.dEdFfZGdGdHe.dIdJfZGdKdLe.dMdNfZGdOdPe.dQdRfZGdSdTe.dUdVfZGdWdXe+dYdZfZGd[d\e+d]d^fZGd_d`e+dadbfZGdcdde+dedffZGdgdhe+didjfZGdkdle+dmdnfZGdodpe+dqdrfZGdsdte+dudvfZGdwdxe+dydzfZGd{d|e+d}d~fZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZ Gdde+ddfZ Gdde+ddfZ Gdde+ddfZ Gdde+ddfZ Gdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde)dd¬fZGdÄde+dŐdƬfZGdDŽde+dɐdʬfZGd˄de+d͐dάfZGdτde+dѐdҬfZGdӄde+dՐd֬fZGdׄde+dِdڬfZGdۄde+dݐdެfZGd߄de+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZGdde+ddfZ Gdde+ddfZ!Gdde+ddfZ"Gdde+ddfZ#Gdde+ddfZ$Gdde+d d fZ%Gd d e+d dfZ&Gdde+ddfZ'Gdde+ddfZ(Gdde+ddfZ)Gdde+ddfZ*Gdd e+d!d"fZ+Gd#d$e+d%d&fZ,Gd'd(e+d)d*fZ-Gd+d,e+d-d.fZ.Gd/d0e+d1d2fZ/Gd3d4e+d5d6fZ0Gd7d8e.d9d:fZ1Gd;dfZ2Gd?d@e.dAdBfZ3GdCdDe.dEdFfZ4GdGdHe.dIdJfZ5GdKdLe-dMdNfZ6GdOdPe-dQdRfZ7GdSdTe-dUdVfZ8e'e9e fZ:d S(]a] psycopg exceptions DBAPI-defined Exceptions are defined in the following hierarchy:: Exceptions |__Warning |__Error |__InterfaceError |__DatabaseError |__DataError |__OperationalError |__IntegrityError |__InternalError |__ProgrammingError |__NotSupportedError ) annotations) TYPE_CHECKINGAnyNoReturn TypeAlias TypeGuard)CancelledError) dataclassfieldfields)CallableSequence)PGconnPGresult) ConnStatusDiagnosticFieldPipelineStatusTransactionStatus)ConninfoOptionPGnotifyNr ErrorInfozdict[str, type[Error]] _sqlcodesceZdZUdZeeZded<dZded<dZ ded<dZ ded <dZ ded <dZ ded <dZ ded <dZded <dZded<ejjZded<ejjZded<ejjZded<dZded<dZded<dZded<dZded<dZded<dZded<dZ ded<dZ!ded<dZ"ded <dZ#ded!<dZ$ded"<d#Z%d$ed%<d#Z&d&ed'<e'dbd*Z(e)dcd-Z*e)dcd.Z+dbd/Z,ddd1Z-dbd2Z.dedfd5Z/dbd6Z0dbd7Z1e)dcd8Z2dcd9Z3e4dbd:Z5dcd;Z6dgd<Z7dcd=Z8dcd>Z9dcd?Z:dcd@Z;dcdAZdcdDZ?dcdEZ@dcdFZAdcdGZBdcdHZCdcdIZDdcdJZEdbdKZFdbdLZGdbdMZHdbdNZIdbdOZJdhdQZKdbdRZLdbdSZMdbdTZNdcdUZOdcdVZPdcdWZQdcdXZRdcdYZSdbdZZTdcd[ZUdcd\ZVdcd]ZWdbd^ZXdbd_ZYdbd`ZZdbdaZ[d#S)iFinishedPGconnzFinished libpq connection. Attributes are set from a real `~psycopg.pq.PGconn` but any operations will raise an `~psycopg.OperationalError`. )default_factoryzlist[ConninfoOption]infobytesdbuserpasswordhosthostaddrportttyoptionsintstatustransaction_statuspipeline_status error_messageutf-8str _encodingrprotocol_versionfull_protocol_versionserver_version backend_pidFboolneeds_password used_password used_gssapi ssl_in_use nonblockingNz!Callable[[PGresult], None] | Nonenotice_handlerz!Callable[[PGnotify], None] | Nonenotify_handlerreturnrc tdNzthe connection is closed)OperationalErrorrL/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/psycopg/errors.py_raisezFinishedPGconn._raiseNs9:::rargsrc&t|dNz is unusable TypeErrorclsrCs rAconnectzFinishedPGconn.connectR3,,,---rc&t|drErFrHs rA connect_startzFinishedPGconn.connect_startVrKrc.|dSNrBselfs rA connect_pollzFinishedPGconn.connect_pollZ rNonecdSrOr@rQs rAfinishzFinishedPGconn.finish]s rc.|dSrOrPrQs rAresetzFinishedPGconn.reset`rTrencodingcdSr>r@)rRr[s rAget_error_messagez FinishedPGconn.get_error_messagecs))rc.|dSrOrPrQs rA reset_startzFinishedPGconn.reset_startfrTrc.|dSrOrPrQs rA reset_pollzFinishedPGconn.reset_pollirTrc&t|drErFrHs rApingzFinishedPGconn.pinglrKrc.|dSrOrPrRrCs rAparameter_statuszFinishedPGconn.parameter_statusprTrc.|dSrOrPrQs rAsocketzFinishedPGconn.socketss rc.|dSrOrPres rAexec_zFinishedPGconn.exec_wrTrc.|dSrOrPres rA send_queryzFinishedPGconn.send_queryzrTrc.|dSrOrPres rA exec_paramszFinishedPGconn.exec_params}rTrc.|dSrOrPres rAsend_query_paramsz FinishedPGconn.send_query_paramsrTrc.|dSrOrPres rA send_preparezFinishedPGconn.send_preparerTrc.|dSrOrPres rAsend_query_preparedz"FinishedPGconn.send_query_preparedrTrc.|dSrOrPres rApreparezFinishedPGconn.preparerTrc.|dSrOrPres rA exec_preparedzFinishedPGconn.exec_preparedrTrc.|dSrOrPres rAdescribe_preparedz FinishedPGconn.describe_preparedrTrc.|dSrOrPres rAsend_describe_preparedz%FinishedPGconn.send_describe_preparedrTrc.|dSrOrPres rAdescribe_portalzFinishedPGconn.describe_portalrTrc.|dSrOrPres rAsend_describe_portalz#FinishedPGconn.send_describe_portalrTrc.|dSrOrPres rAclose_preparedzFinishedPGconn.close_preparedrTrc.|dSrOrPres rAsend_close_preparedz"FinishedPGconn.send_close_preparedrTrc.|dSrOrPres rA close_portalzFinishedPGconn.close_portalrTrc.|dSrOrPres rAsend_close_portalz FinishedPGconn.send_close_portalrTrc.|dSrOrPrQs rA get_resultzFinishedPGconn.get_resultrTrc.|dSrOrPrQs rA consume_inputzFinishedPGconn.consume_inputrTrc.|dSrOrPrQs rAis_busyzFinishedPGconn.is_busyrTrc.|dSrOrPrQs rAflushzFinishedPGconn.flushrTrc.|dSrOrPrQs rAset_single_row_modez"FinishedPGconn.set_single_row_moderTrsizec.|dSrOrP)rRrs rAset_chunked_rows_modez$FinishedPGconn.set_chunked_rows_moderTrc.|dSrOrPrQs rA cancel_connzFinishedPGconn.cancel_connrTrc.|dSrOrPrQs rA get_cancelzFinishedPGconn.get_cancelrTrc.|dSrOrPrQs rAnotifieszFinishedPGconn.notifiesrTrc.|dSrOrPres rA put_copy_datazFinishedPGconn.put_copy_datarTrc.|dSrOrPres rA put_copy_endzFinishedPGconn.put_copy_endrTrc.|dSrOrPres rA get_copy_datazFinishedPGconn.get_copy_datarTrc.|dSrOrPres rAtracezFinishedPGconn.tracerTrc.|dSrOrPres rAset_trace_flagszFinishedPGconn.set_trace_flagsrTrc.|dSrOrPrQs rAuntracezFinishedPGconn.untracerTrc.|dSrOrPres rAencrypt_passwordzFinishedPGconn.encrypt_passwordrTrc.|dSrOrPres rAchange_passwordzFinishedPGconn.change_passwordrTrc.|dSrOrPres rAmake_empty_resultz FinishedPGconn.make_empty_resultrTrc.|dSrOrPrQs rAenter_pipeline_modez"FinishedPGconn.enter_pipeline_moderTrc.|dSrOrPrQs rAexit_pipeline_modez!FinishedPGconn.exit_pipeline_moderTrc.|dSrOrPrQs rA pipeline_synczFinishedPGconn.pipeline_syncrTrc.|dSrOrPrQs rAsend_flush_requestz!FinishedPGconn.send_flush_requestrTr)r<r)rCrr<r)r<rU)rZ)r[r.r<r.)rCrr<rU)rr(r<r)\__name__ __module__ __qualname____doc__r listr__annotations__r r!r"r#r$r%r&r'rBADvaluer)rUNKNOWNr*rOFFr+r,r/r0r1r2r3r5r6r7r8r9r:r; staticmethodrB classmethodrJrMrSrWrYr]r_rarcrfpropertyrhrjrlrnrprrrtrvrxrzr|r~rrrrrrrrrrrrrrrrrrrrrrrrrrrr@rrArr's "'t!>>>rstr | tuple[Any, ...]ct}t|tr;t |dkr(t |j|dd<d|dd<|S)Nrrr __reduce__ isinstancetuplelen _info_to_dictrrRresrs rArzError.__reduce__4sbgg  "" c5 ! ! %c#hh!mm+DJ77CF7O $CF9  r)rCrrrr[r.rr)r<r)r<r)r<rr<r) rrrrrrrrrrrr __classcell__rs@rArrsJH  $ //////// 666X6@@@X@???X? rrceZdZdZdZdS)InterfaceErrorzU An error related to the database interface rather than the database itself. rNrr@rrArr>JJJrrc eZdZdZdZdd dZdS) DatabaseErrorzG Exception raised for errors that are related to the database. rNcoderrcH|r|t|<||_|r |t|<dSdSrO)rr)rIrrs rA__init_subclass__zDatabaseError.__init_subclass__Ms9  !IdOCL  "!IdOOO " "r)NN)rrrr)rrrrrr@rrArrFs>J"""""""rrceZdZdZdZdS) DataErrorz An error caused by problems with the processed data. Examples may be division by zero, numeric value out of range, etc. rNrr@rrArrUrrrceZdZdZdZdS)r?a8 An error related to the database's operation. These errors are not necessarily under the control of the programmer, e.g. an unexpected disconnect occurs, the data source name is not found, a transaction could not be processed, a memory allocation error occurred during processing, etc. rNrr@rrAr?r?_sJJJrr?ceZdZdZdZdS)IntegrityErrorz An error caused when the relational integrity of the database is affected. An example may be a foreign key check failed. rNrr@rrArrlrrrceZdZdZdZdS) InternalErrorz An error generated when the database encounters an internal error, Examples could be the cursor is not valid anymore, the transaction is out of sync, etc. rNrr@rrArrvJJJrrceZdZdZdZdS)ProgrammingErrorz Exception raised for programming errors Examples may be table not found or already exists, syntax error in the SQL statement, wrong number of parameters specified, etc. rNrr@rrArrrrrceZdZdZdZdS)NotSupportedErrorzS A method or database API was used which is not supported by the database. rNrr@rrArrrrrceZdZdZdS)ConnectionTimeoutz Exception raised on timeout of the `~psycopg.Connection.connect()` method. The error is raised if the ``connect_timeout`` is specified and a connection is not obtained in useful time. Subclass of `~psycopg.OperationalError`. Nrr@rrArrsrrceZdZdZdS)CancellationTimeoutz Exception raised on timeout of connection's `~psycopg.Connection.cancel_safe()` method. Subclass of `~psycopg.OperationalError`. Nrr@rrAr r srr ceZdZdZdS)PipelineAbortedz Raised when a operation fails because the current pipeline is in aborted state. Subclass of `~psycopg.OperationalError`. Nrr@rrAr r srr ceZdZdZd!d"dZed#d Zed#d Zed#d Zed#d Z ed#dZ ed#dZ ed#dZ ed#dZ ed#dZed#dZed#dZed#dZed#dZed#dZed#dZed#dZed#dZed#dZd$dZd%fd ZxZS)&rz%Details from a database error report.r-rrr[r.c"||_||_dSrO)rr/)rRrr[s rArzDiagnostic.__init__s !rr<rc@|tjSrO)_error_messagerSEVERITYrQs rAseverityzDiagnostic.severity""?#;<<???rc@|tjSrO)rr TABLE_NAMErQs rA table_namezDiagnostic.table_names""?#=>>>rc@|tjSrO)rr COLUMN_NAMErQs rA column_namezDiagnostic.column_namer2rc@|tjSrO)rr DATATYPE_NAMErQs rA datatype_namezDiagnostic.datatype_names""?#@AAArc@|tjSrO)rrCONSTRAINT_NAMErQs rAconstraint_namezDiagnostic.constraint_namerrc@|tjSrO)rr SOURCE_FILErQs rA source_filezDiagnostic.source_filer2rc@|tjSrO)rr SOURCE_LINErQs rA source_linezDiagnostic.source_liner2rc@|tjSrO)rrSOURCE_FUNCTIONrQs rAsource_functionzDiagnostic.source_functionrrr rc|jrlt|jtr|j|}n|j|}|||jdSdS)Nreplace)rrdictget error_fielddecoder/)rRr vals rArzDiagnostic._error_messagesj : =$*d++ 4jnnU++j,,U33zz$.)<<<trrct}t|tr0t |dkrt |j|dd<|S)Nrrrrrs rArzDiagnostic.__reduce__ sTgg  "" c5 ! ! 8c#hh!mm+DJ77CF7O rr-)rrr[r.)r<r)r rr<rr)rrrrrrrrrrrr"r%r(r+r.r1r5r8r;r>rArDrGrrrrs@rArrs//"""""===X=JJJXJ===X=DDDXDCCCXCAAAXAGGGXGFFFXFCCCXC<<<X<@@@X@???X?@@@X@BBBXBDDDXD@@@X@@@@X@DDDXD    rrrcLtrfdtDSS)zH Convert a PGresult to a dictionary to make the info picklable. c<i|]}||Sr@)rL).0vrs rA z!_info_to_dict..s)@@@14##A&&@@@r)rrrs`rArrs4 D@@@@@@@@ rrr. type[Error]c@t|S)zLookup an error code or `constant name`__ and return its exception class. Raise `!KeyError` if the code is not found. .. __: https://www.postgresql.org/docs/current/errcodes-appendix.html #ERRCODES-TABLE )rupperrs rAlookupr[s X^^%% &&rr-resultrr[c|tjpd}t|dd}|||||S)Nrr-rI)rr[)rLrr_class_for_staterMr])r\r[staterIs rAerror_from_resultr`)s]   7 8 8 ?CE 5<<;; < rs=;(#"""""EEEEEEEEEEEEEE""""""0000000000........$$$$$$$$UUUUUUUUUUUU211111111$sEDL'8"99D@ @@@@$& &&&&  D""""i<<<<<I<<<~U " " " " "E " " "      }   ]M} (*&````````F''''SSSSS (((( ,,,," " " "  "   "  ) " ." -" -" " " " -" -" "  !"" #""$ %"& '"( )"* +", -". /"0 1"2 3"4 5"6 7"8 9": ;"< ="> ?"@ A"BC"" Z     ] y         M C          7         * -         .> D         - 2         4D J         ( +         #3 7         ( +         } 3         + .         = 7         } *         - 6         ] (         M 0         } 3         = .         ] L         / 4         # '         + .         I '         5         I :         Y 3         ) /         ,         I 0         I 0         y =         i 2         ) 8          -         5         y 4         Y :         y ,          -         ,         ,         i ;         Y :         Y (         Y )         i <         i <         I 0          @         9 9         Y 1         y 3         ) 7         i <         I C         9 :         ) B         y 4         +         I 0         ) .         I 0         y 4         |         ) .         y 3          5         ) 8         H         i *         i 3         Y 4         I )         I 2          9         9 9         9 1         I 2         I 2         I 2         y 5         y 5         I 1         ) D         Y 1         4         ) 6         -         i 1         i <         > 7          +         ~ +         . .         n )         ^ (          ,          -         m 2         = /         ] :         - I         m M          I         ] 2         } G         = B         ] 2         ] 2         m <          ,         . 3         #3 8         (8 <         & )         m D          6         M 8         * .         #3 9         &6 ;         !1 7         (8 >         ( ,         / 3         0 5         &6 9         )9 ;         $4 7         )9 >         . 2         - /         . 2         * .         #3 8         ) ,         $4 8         ) -         ( ,         * -         + .         .> C         !1 5         ' *         '7 >         , /         " ~         " ~         . 2         "          & )         & )         & )         & )         & )         % (         ( +         ( +         $ '         ' *         & *         ( ,         #          ( +         & )         #          % (         ) ,         & )         ( +         !1 5         & )         % (         ) ,         % (         - 1         . 2         0 4         0 4         )9 >         . 2         - 1         . 2         , /         ' *         % (         ( +         - 0         / 4         , /          {         "          ) -         !1 5         + /         * .         % )         ' +         #3 9         "          - 2         ' +         . 4         + .         $ '         $ '         $ '         ' +         & )         ) -         " ~          z         $ '         $ '         & +         ] )         & *         % )          {         % *         %5 ;         ) .         , 2         $4 :         + 0         - 2         !1 8         - 2         ' +         , 1         + 0         , 2         % )         !1 7         - 3         %5 ;         # '         ( -         ' ,         / 4         ( -         +; @         / 4         +; C         *: @         #          % (         "          "          $ '         ] '         M '         ] (    )>: r