jBdZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZ dd lZn#e$rZed ed Z[wwxYwdd lmZmZdd lmZd dlmZd dlmZd dlmZd dlm Z d dl!m"Z"d dl#m$Z$d dl%m&Z&ej'Z(e(dkredej)zieej*ej+iZ,edZ-GddZ.Gdde Z/d S)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)r z4mysqlclient 1.4.3 or newer is required; you have %s.z(\d{1,2})\.(\d{1,2})\.(\d{1,2})c6eZdZdZdZdZd dZdZdZdZ dS) CursorWrappera6 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||_dSN)cursorselfrs l/var/www/finuniver-perm.ru/html/portfolio/venv/lib/python3.11/site-packages/django/db/backends/mysql/base.py__init__zCursorWrapper.__init__Fs  Nc |j||S#tj$r5}|jd|jvrt t|jd}~wwxYwNr)rexecuteDatabaseOperationalErrorargscodes_for_integrityerrorrtuplerqueryr&es rr#zCursorWrapper.executeIsm ;&&ud33 3(   vayD999$eAFmm44   A!0AA!c |j||S#tj$r5}|jd|jvrt t|jd}~wwxYwr")r executemanyr$r%r&r'rr(r)s rr.zCursorWrapper.executemanyTsm ;**5$77 7(   vayD999$eAFmm44   r,c,t|j|Sr)getattrr)rattrs r __getattr__zCursorWrapper.__getattr__^st{D)))r c*t|jSr)iterrrs r__iter__zCursorWrapper.__iter__asDK   r r) __name__ __module__ __qualname____doc__r'rr#r.r2r6r rrr6sv     ***!!!!!r rc eZdZdZidddddddd d d d d dddddddd dd dddddddddddd dd!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@ZedPdBZ dCZ!dDZ"dEZ#dFZ$dPdGZ%dHZ&edIZ'edJZ(edKZ)edLZ*edMZ+edNZ,edOZ-xZ.S)QDatabaseWrappermysql 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)) OneToOneFieldPositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerField SlugFieldSmallAutoFieldSmallIntegerField TextField TimeField UUIDFieldcZ|j}|jjrd|d<|S)Nuuidra) _data_typescopyfeatureshas_native_uuid_field)rrds r data_typeszDatabaseWrapper.data_typess3&++-- = . .'-K $r ) tinyblobblob mediumblobrBtinytexttext mediumtextrWrUz= %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('%%', {}))rqrrrwryrxrz>repeatable readread uncommitted serializableread committedc|jSr) mysql_versionr5s rget_database_versionz$DatabaseWrapper.get_database_versions !!r c tdd}|j}|dr |d|d<|dr |d|d<|dr |d|d<|d d r |d |d <n|d r |d |d <|d rt|d |d<tj|d<|d}|dd}|rb|}||j vrEtd|dd dt|j Dd||_ |||S)Nutf8)convcharsetUSERuserNAMEdatabasePASSWORDpasswordHOST/ unix_sockethostPORTport client_flagOPTIONSisolation_levelr~z%Invalid transaction isolation level 'z' specified. Use one of z, c3 K|] }d|zV dS)z'%s'Nr;).0ss r z8DatabaseWrapper.get_connection_params..s&!T!T&1*!T!T!T!T!T!Tr z , or None.)django_conversions settings_dictrwintr FOUND_ROWSrepoplowerisolation_levelsrjoinsortedrupdate)rkwargsroptionsrs rget_connection_paramsz%DatabaseWrapper.get_connection_paramss&  *   3*62F6N   7!.v!6F:   $ ;!.z!:F:   + +C 0 0 3$1&$9F= ! ! 6 " 3*62F6N   8 v!677F6N!' 1} *//11!++&79IJJ  -3355Od&;;;**( !T!TfT=R6S6S!T!T!TTTTT  / g r ctjdi|}|jttur|jt|S)Nr;)r$connectencodersgetbytesr)r conn_params connections rget_new_connectionz"DatabaseWrapper.get_new_connectionsS%44 44   " "5 ) )U 2 2   # #E * * *r ctg}|jjr|d|jr/|d|jz|rW|5}|d |ddddS#1swxYwYdSdS)NzSET SQL_AUTO_IS_NULL = 0z*SET SESSION TRANSACTION ISOLATION LEVEL %sz; ) superinit_connection_staterfis_sql_auto_is_null_enabledappendrupperrr#r)r assignmentsr __class__s rrz%DatabaseWrapper.init_connection_state s  %%''' = 4 ;   9 : : :      <&,,../     7 7&tyy55666 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7s)CC C NcR|j}t|Sr)rrr)rnamers r create_cursorzDatabaseWrapper.create_cursors#''))V$$$r c\ tj|dS#tj$rYdSwxYwr)r _rollbackr$NotSupportedErrorr5s rrzDatabaseWrapper._rollback"sC   )$ / / / / /)    DD s ++cz|j5|j|ddddS#1swxYwYdSr)wrap_database_errorsr autocommit)rrs r_set_autocommitzDatabaseWrapper._set_autocommit(s  & 3 3 O & &z 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3s 044c|5}|ddddn #1swxYwYdS)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,s| [[]] 7f NN5 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7ts 7;;cd|jc|_} |5}|ddddn #1swxYwY||_dS#||_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_checking6s /4T5H+^ 1 ;&9::: ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;#1D   .D  0 0 0 0s-AA AA  AA A A$c:|5}||j|}|D]}|j||}|s |j||}|D]}\}\}}|d|d|d|d|d|d|d|d |d |D]2} td |d | d d|d|d| dd|d|d~ ddddS#1swxYwYdS)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_constraintsCs[[]]. f""0<yyw>r c\|jjrdddd}|jr|jdkrd|d<|SiS)Nz`%(column)s` >= 0)rYrZr[) rrzJSON_VALID(`%(column)s`)rT)rf!supports_column_check_constraintsrr)rrs rdata_type_check_constraintsz+DatabaseWrapper.data_type_check_constraintssY = : %+>(;-@!!  $ L);j)H)H2L!+.$ $ r c T|5}|d|}dddn #1swxYwY|d|d|dt|dt|dt|ddS) 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 rr)versionsql_modedefault_storage_enginesql_auto_is_nulllower_case_table_nameshas_zoneinfo_database)temporary_connectionr#fetchonerD)rrrows rmysql_server_dataz!DatabaseWrapper.mysql_server_datas  & & ( ( $F NN   //##C $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1vA&)!f $SV &*3q6ll%)#a&\\    s*A  AAc|jdS)Nr)rr5s rmysql_server_infoz!DatabaseWrapper.mysql_server_infos%i00r ct|j}|std|jzt d|DS)Nz8Unable to determine MySQL version from version string %rc34K|]}t|VdSr)r)rxs rrz0DatabaseWrapper.mysql_version..s(44SVV444444r )server_version_rematchr Exceptionr(groups)rrs rrzDatabaseWrapper.mysql_versionsg!''(>?? J() 44U\\^^444444r c8d|jvS)Nmariadb)rrr5s rrz DatabaseWrapper.mysql_is_mariadbsD288::::r ch|jd}t|r|dndS)Nr,r;)rsetsplit)rrs rrzDatabaseWrapper.sql_modes3)*5(:8>>#&&&;;;r r)/r7r8r9vendorrdrrh_limited_data_types operators pattern_esc pattern_opsrr$rSchemaEditorClassr client_classrcreation_classrfeatures_classrintrospection_classr ops_classrvalidation_classrrrrrrrrrrrrrrrrrrr __classcell__)rs@rr=r=ess F -/ z   .  V   E  . 2 (   8 * !" V#$##4 2%8.3'7K<_ $&$   I.YK824.2, KH,!L%N%N/"I)"""%%%N\77777(%%%\% 333 1 1 16666p??_?  _   _ 211_155_5;;_;<<_<<<<r!sZ 877777$$$$$$555555<<<<<<------333333666666  E    10000000******#"""""&&&&&&&&&&&&000000******((((((******   Y  >AUU   34%$%GHH,!,!,!,!,!,!,!,!^`<`<`<`<`<)`<`<`<`<`