o uvXj5 @sDdZddlZddlmZddlmZddlmZddlm Z ddl m Z zddl Z Wney;ZzededZ[wwddlmZmZdd lmZd d lmZd d lmZd d lmZd dlmZd dlmZd dlm Z d dl!m"Z"e j#Z$e$dkrede j%ieej&ej'iZ(e)dZ*GdddZ+Gddde Z,dS)za MySQL database backend for Django. Requires mysqlclient: https://pypi.org/project/mysqlclient/ N)ImproperlyConfigured)utils)BaseDatabaseWrapper)cached_propertyz:Error loading MySQLdb module. Did you install mysqlclient?)CLIENT FIELD_TYPE) conversions)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)DatabaseValidation)r  z5mysqlclient 1.3.13 or newer is required; you have %s.z(\d{1,2})\.(\d{1,2})\.(\d{1,2})c@s>eZdZdZdZddZdddZdd Zd d Zd d Z 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(). )iicCs ||_dSN)cursorselfrrZ/var/www/html/myproject/venv/lib/python3.10/site-packages/django/db/backends/mysql/base.py__init__A zCursorWrapper.__init__Nc CNz|j||WStjy&}z|jd|jvr!tjt|jd}~wwNr) rexecuteDatabaseOperationalErrorargscodes_for_integrityerrorrIntegrityErrortuplerqueryr!errrrDszCursorWrapper.executec Crr) r executemanyrr r!r"rr#r$r%rrrr(OszCursorWrapper.executemanycCs t|j|Sr)getattrr)rattrrrr __getattr__Ys zCursorWrapper.__getattr__cCs t|jSr)iterrrrrr__iter__\rzCursorWrapper.__iter__r) __name__ __module__ __qualname____doc__r"rrr(r+r.rrrrr4s   rc @sleZdZdZdZiddddddd d d d d ddddddddd dd ddddddddddd d dd!d"d d#d$d%d&d'Zd(Zd)d*d+d*d,d-d.d/d+d+d*d*d0 Zd1Zd2d3d4d5d6d7d8Z hd9Z e Z e Z eZeZeZeZeZeZd:d;Zdd?ZdUdAdBZdCdDZdEdFZdGdHZ dIdJZ!dUdKdLZ"dMdNZ#e$dOdPZ%e$dQdRZ&e$dSdTZ'd@S)VDatabaseWrappermysqlMySQL 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)NullBooleanFieldzinteger UNSIGNEDzsmallint UNSIGNEDsmallintlongtextztime(6)zchar(32)) OneToOneFieldPositiveIntegerFieldPositiveSmallIntegerField SlugFieldSmallIntegerField TextField TimeField UUIDField) tinyblobblob mediumblobr9tinytexttext mediumtextrMjsonz= %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('%%', {}))r_r`rergrfrh>repeatable readread uncommitted serializableread committedcCstdd}|j}|dr|d|d<|dr|d|d<|dr&|d|d<|d d r4|d |d <n |d r>|d |d <|d rJt|d |d<tj|d<|d}|dd}|ry|}||j vryt d|d ddt |j Df||_ |||S)Nutf8)convcharsetUSERuserNAMEdbPASSWORDpasswdHOST/ unix_sockethostPORTport client_flagOPTIONSisolation_levelrlzKInvalid transaction isolation level '%s' specified. Use one of %s, or None.z, css|]}d|VqdS)z'%s'Nr).0srrr z8DatabaseWrapper.get_connection_params..)django_conversions settings_dictreintr FOUND_ROWScopypoplowerisolation_levelsrjoinsortedr~update)rkwargsroptionsr~rrrget_connection_paramss@         z%DatabaseWrapper.get_connection_paramscCstjdi|S)Nr)rconnect)r conn_paramsrrrget_new_connectionsz"DatabaseWrapper.get_new_connectioncCsvg}|jjr |d|jr|d|j|r9|}|d|WddS1s2wYdSdS)NzSET SQL_AUTO_IS_NULL = 0z*SET SESSION TRANSACTION ISOLATION LEVEL %sz; )featuresis_sql_auto_is_null_enabledappendr~upperrrr)r assignmentsrrrrinit_connection_states  "z%DatabaseWrapper.init_connection_stateNcCs|j}t|Sr) connectionrr)rnamerrrr create_cursors zDatabaseWrapper.create_cursorcCs(zt|WdStjyYdSwr)r _rollbackrNotSupportedErrorr-rrrrs zDatabaseWrapper._rollbackcCs8|j|j|WddS1swYdSr)wrap_database_errorsr autocommit)rrrrr_set_autocommits"zDatabaseWrapper._set_autocommitcCs|ddS)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=0T)rrr-rrrdisable_constraint_checkingsz+DatabaseWrapper.disable_constraint_checkingcCs2d|j|_}z |dW||_dS||_w)zM Re-enable foreign key checks after they have been disabled. FzSET foreign_key_checks=1N)needs_rollbackrr)rrrrrenable_constraint_checking sz*DatabaseWrapper.enable_constraint_checkingc Cs|X}|dur|j|}|D]B}|j||}|sq|j||}|D],\}}}|d||||||||f|D]} td|| d||| d||fq&qWddS1s_wYdS)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. Na0 SELECT REFERRING.`%s`, REFERRING.`%s` FROM `%s` as REFERRING LEFT JOIN `%s` as REFERRED ON (REFERRING.`%s` = REFERRED.`%s`) WHERE REFERRING.`%s` IS NOT NULL AND REFERRED.`%s` IS NULL zThe row in table '%s' with primary key '%s' has an invalid foreign key: %s.%s contains a value '%s' that does not have a corresponding value in %s.%s.rr ) r introspection table_namesget_primary_key_columnget_key_columnsrfetchallrr#) rrr table_nameprimary_key_column_name key_columns column_namereferenced_table_namereferenced_column_namebad_rowrrrcheck_constraintss:     "z!DatabaseWrapper.check_constraintscCs(z|jWdStjyYdSw)NFT)rpingrErrorr-rrr is_usable@s  zDatabaseWrapper.is_usablecCsB|}|d|dWdS1swYdS)NzSELECT VERSION()r)temporary_connectionrfetchonerrrrmysql_server_infoHs   $z!DatabaseWrapper.mysql_server_infocCs4t|j}|std|jtdd|DS)Nz8Unable to determine MySQL version from version string %rcss|]}t|VqdSr)r)rxrrrrSrz0DatabaseWrapper.mysql_version..)server_version_rematchr Exceptionr$groups)rrrrr mysql_versionNs zDatabaseWrapper.mysql_versioncCsd|jvS)Nmariadb)rrr-rrrmysql_is_mariadbUsz DatabaseWrapper.mysql_is_mariadbr)(r/r0r1vendor display_name data_types_limited_data_types operators pattern_esc pattern_opsrrrSchemaEditorClassr client_classr creation_classr features_classr introspection_classr ops_classrvalidation_classrrrrrrrrrrrrrrrrrrr3`s      %  (  r3)-r2redjango.core.exceptionsr django.dbrdjango.db.backends backend_utilsdjango.db.backends.base.baserdjango.utils.functionalrMySQLdbr ImportErrorerrMySQLdb.constantsrrMySQLdb.convertersrclientr creationr rr rr operationsrschemar validationr version_infoversion __version__TIME typecast_timercompilerrr3rrrrsJ                ,