#ij"@dZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZ dd lZdd lmZmZdd lmZd dlmZd dlmZd dlmZd dlm Z d dl!m"Z"d dl#m$Z$d dl%m&Z&ejNZ(e(dkredejRzieejTejViZ,edZ-GddZ.Gdde Z/y #e$rZed ed Z[wwxYw)za MySQL database backend for Django. Requires mysqlclient: https://pypi.org/project/mysqlclient/ )ImproperlyConfigured)IntegrityError)utils)BaseDatabaseWrapper) async_unsafe)cached_property)_lazy_re_compileNz:Error loading MySQLdb module. Did you install mysqlclient?)CLIENT FIELD_TYPE) conversions)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)DatabaseValidation)rr z4mysqlclient 2.2.1 or newer is required; you have %s.z(\d{1,2})\.(\d{1,2})\.(\d{1,2})c4eZdZdZdZdZd dZdZdZdZ y) CursorWrappera: A thin wrapper around MySQLdb's normal cursor class that catches particular exception instances and reraises them with the correct types. Implemented as a wrapper, rather than a subclass, so that it isn't stuck to the particular underlying representation returned by Connection.cursor(). )iiiic||_yN)cursorselfrs W/var/www/html/office/venv/lib/python3.12/site-packages/django/db/backends/mysql/base.py__init__zCursorWrapper.__init__Hs  Nc |jj||S#tj$r<}|jd|j vrt t|jd}~wwxYwNr)rexecuteDatabaseOperationalErrorargscodes_for_integrityerrorrtuplerqueryr%es rr"zCursorWrapper.executeKsb ;;&&ud3 3(( vvayD999$eAFFm44   A-7A((A-c |jj||S#tj$r<}|jd|j vrt t|jd}~wwxYwr!)r executemanyr#r$r%r&rr'r(s rr-zCursorWrapper.executemanyVsb ;;**5$7 7(( vvayD999$eAFFm44   r+c.t|j|Sr)getattrr)rattrs r __getattr__zCursorWrapper.__getattr__`st{{D))rc,t|jSr)iterrrs r__iter__zCursorWrapper.__iter__csDKK  rr) __name__ __module__ __qualname____doc__r&rr"r-r1r5rrrr7s(  *!rrc eZdZdZidddddddd d d d d dddddddd dd dddddddddddd d!d"d#d d$d%d&d'd(d) Zed*Zd+Zd,d-d.d-d/d0d1d2d.d.d-d-d3 Zd4Z d5d6d7d8d9d:d;Z hd<Z e Z e ZeZeZeZeZeZeZd=Zd>Zed?Zfd@ZedOdAZ dBZ!dCZ"dDZ#dEZ$dOdFZ%dGZ&edHZ'edIZ(edJZ)edKZ*edLZ+edMZ,edNZ-xZ.S)PDatabaseWrappermysql AutoFieldzinteger AUTO_INCREMENT BigAutoFieldzbigint AUTO_INCREMENT BinaryFieldlongblob BooleanFieldbool CharFieldzvarchar(%(max_length)s) DateFielddate DateTimeFieldz datetime(6) DecimalFieldz+numeric(%(max_digits)s, %(decimal_places)s) DurationFieldbigint FileField FilePathField FloatFieldzdouble precision IntegerFieldintegerBigIntegerFieldIPAddressFieldzchar(15)GenericIPAddressFieldzchar(39) JSONFieldjsonzbigint UNSIGNEDzinteger UNSIGNEDzsmallint UNSIGNEDzsmallint AUTO_INCREMENTsmallintlongtextztime(6)zchar(32)) PositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerField SlugFieldSmallAutoFieldSmallIntegerField TextField TimeField UUIDFieldcp|jj}|jjrd|d<|S)Nuuidr_) _data_typescopyfeatureshas_native_uuid_field)rrbs r data_typeszDatabaseWrapper.data_typess3&&++- == . .'-K $r) tinyblobblob mediumblobrAtinytexttext mediumtextrVrTz= %szLIKE %szLIKE BINARY %sz> %sz>= %sz< %sz<= %s) exactiexactcontains icontainsgtgteltlte startswithendswith istartswith iendswithzCREPLACE(REPLACE(REPLACE({}, '\\', '\\\\'), '%%', '\%%'), '_', '\_')z"LIKE BINARY CONCAT('%%', {}, '%%')zLIKE CONCAT('%%', {}, '%%')zLIKE BINARY CONCAT({}, '%%')zLIKE CONCAT({}, '%%')zLIKE BINARY CONCAT('%%', {})zLIKE CONCAT('%%', {}))rorprurwrvrx>repeatable readread uncommitted serializableread committedc|jSr) mysql_versionr4s rget_database_versionz$DatabaseWrapper.get_database_versions!!!rc Ttdd}|j}|dr|d|d<|dr|d|d<|dr|d|d<|d jd r |d |d <n |d r|d |d <|d rt|d |d<tj |d<|dj }|jdd}|rY|j}||jvr;td|ddjdt|jDd||_ |j||S)Nutf8mb4)convcharsetUSERuserNAMEdatabasePASSWORDpasswordHOST/ unix_sockethostPORTport client_flagOPTIONSisolation_levelr|z%Invalid transaction isolation level 'z' specified. Use one of z, c3&K|] }d|z yw)z'%s'Nr:).0ss r z8DatabaseWrapper.get_connection_params..s!T&1*!Tsz , or None.)django_conversions settings_dictruintr FOUND_ROWSrcpoplowerisolation_levelsrjoinsortedrupdate)rkwargsroptionsrs rget_connection_paramsz%DatabaseWrapper.get_connection_paramssX&  **  *62F6N  !.v!6F:   $!.z!:F:   + +C 0$1&$9F= ! 6 "*62F6N   v!67F6N!' 1 1} *//1!++&79IJ -335Od&;&;;*( !TfT=R=R6S!TT  / g rc0tjdi|}|S)Nr:)r#connect)r conn_params connections rget_new_connectionz"DatabaseWrapper.get_new_connections%%4 4 rctt|g}|jjr|j d|j r,|j d|j j z|r:|j5}|jdj|dddyy#1swYyxYw)NzSET SQL_AUTO_IS_NULL = 0z*SET SESSION TRANSACTION ISOLATION LEVEL %sz; ) superinit_connection_staterdis_sql_auto_is_null_enabledappendrupperrr"r)r assignmentsr __class__s rrz%DatabaseWrapper.init_connection_states %' == 4 4   9 :      <&&,,./   7&tyy56 7 7  7 7s !B..B7cL|jj}t|Sr)rrr)rnamers r create_cursorzDatabaseWrapper.create_cursors'')V$$rcb tj|y#tj$rYywxYwr)r _rollbackr#NotSupportedErrorr4s rrzDatabaseWrapper._rollbacks-   ) )$ /))   s ..c||j5|jj|dddy#1swYyxYwr)wrap_database_errorsr autocommit)rrs r_set_autocommitzDatabaseWrapper._set_autocommit$s2  & & 3 OO & &z 2 3 3 3s2;cp|j5}|jddddy#1swYyxYw)z Disable foreign key checks, primarily for use in adding rows with forward references. Always return True to indicate constraint checks need to be re-enabled. zSET foreign_key_checks=0NT)rr"rs rdisable_constraint_checkingz+DatabaseWrapper.disable_constraint_checking(s2 [[] 7f NN5 6 7 7s,5cd|jc|_} |j5}|jdddd||_y#1swYxYw#||_wxYw)zM Re-enable foreign key checks after they have been disabled. FzSET foreign_key_checks=1N)needs_rollbackrr")rrrs renable_constraint_checkingz*DatabaseWrapper.enable_constraint_checking2s` /4T5H5H+^ 1 ;&9: ;#1D  ; ;#1D s!AAAA A Ac|j5}||jj|}|D]}|jj||}|s"|jj ||}|j D]m\}\}}|j d|d|d|d|d|d|d|d |d |jD](} td |d | d d|d|d| dd|d|do dddy#1swYyxYw)a] Check each table name in `table_names` for rows with invalid foreign key references. This method is intended to be used in conjunction with `disable_constraint_checking()` and `enable_constraint_checking()`, to determine if rows with invalid references were entered while constraint checks were off. Nz+ SELECT REFERRING.`z`, REFERRING.`z` FROM `z2` as REFERRING LEFT JOIN `z5` as REFERRED ON (REFERRING.`z` = REFERRED.`z,`) WHERE REFERRING.`z` IS NOT NULL AND REFERRED.`z"` IS NULL zThe row in table 'z' with primary key 'rz' has an invalid foreign key: .z contains a value 'r z.' that does not have a corresponding value in ) r introspection table_namesget_primary_key_column get_relationsitemsr"fetchallr) rrr table_nameprimary_key_column_name relations column_namereferenced_column_namereferenced_table_namebad_rows rcheck_constraintsz!DatabaseWrapper.check_constraints?s'[[]. f""00<w>rcB|jjrdddd}|SiS)Nz`%(column)s` >= 0)rWrXrY)rd!supports_column_check_constraints)rrs rdata_type_check_constraintsz+DatabaseWrapper.data_type_check_constraintss- == : :+>(;-@!  % $ rc |j5}|jd|j}dddd|d|dt|dt|dt|ddS#1swY?xYw) Na2 SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL rr r)versionsql_modedefault_storage_enginesql_auto_is_nulllower_case_table_nameshas_zoneinfo_database)temporary_connectionr"fetchonerC)rrrows rmysql_server_dataz!DatabaseWrapper.mysql_server_datas  & & ( $F NN //#C $1vA&)!f $SV &*3q6l%)#a&\    $ $s "A11A:c |jdS)Nr)rr4s rmysql_server_infoz!DatabaseWrapper.mysql_server_infos%%i00rctj|j}|std|jzt d|j DS)Nz8Unable to determine MySQL version from version string %rc32K|]}t|ywr)r)rxs rrz0DatabaseWrapper.mysql_version..s4SV4s)server_version_rematchr Exceptionr'groups)rrs rr~zDatabaseWrapper.mysql_versionsR!''(>(>?J(() 4U\\^444rc:d|jjvS)Nmariadb)rrr4s rrz DatabaseWrapper.mysql_is_mariadbsD2288:::rcd|jd}t|r|jdSdS)Nr,r:)rsetsplit)rrs rrzDatabaseWrapper.sql_modes0))*5(8>>#&;;;;rr)/r6r7r8vendorrbrrf_limited_data_types operators pattern_esc pattern_opsrr#rSchemaEditorClassr client_classrcreation_classrfeatures_classrintrospection_classr ops_classrvalidation_classrrrrrrrrrrrrrrrrr~rr __classcell__)rs@rr<r<gs F-/ z   .  V   E  . 2 (   8 * !" V#$$5 2%8.3'5K: $&$  I.YK824.2, KH,!L%N%N/"I)"%N7(%% 3 16p??  .1155;;<rs 8$5<-36 1*#&&0*(*    Y >AUAUU  334%%GH-!-!`T<)T