|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /lib64/python2.7/site-packages/django/db/backends/mysql/ |
Upload File : |
�
r�\c @ s7 d Z d d l m Z d d l Z d d l Z d d l Z d d l Z y d d l Z Wn3 e k
r� Z
d d l m Z e d e
� � n Xd d l
m Z e j Z e d( k s� e d d) k re e � d
k s� e d d k s� e d d k rd d l m Z e d
e j � � n d d l m Z m Z d d l m Z m Z y d d l Z Wn e k
rnd Z n Xd d l m Z d d l m Z d d l Td d l m! Z! d d l" m# Z# d d l$ m% Z% d d l& m' Z' d d l( m) Z) m* Z* d d l+ m, Z, m- Z- d d l. m/ Z/ d d l. m0 Z0 e j1 rGe j2 d d e j3 �n e j4 Z4 e j5 Z5 e e j6 Z7 d � Z8 d � Z9 e j: � Z; e; j< i e= j> e j? 6e= j@ e jA 6e= j@ e jB 6e8 e j6 6e9 e j 6� e jC d � ZD d eE f d! � � YZF d" eG f d# � � YZH d$ eI f d% � � YZJ d& eK f d' � � YZL d S(* ud
MySQL database backend for Django.
Requires MySQLdb: http://sourceforge.net/projects/mysql-python
i����( t unicode_literalsN( t ImproperlyConfiguredu Error loading MySQLdb module: %s( t cached_propertyi i i i u finali u1 MySQLdb-1.2.1p2 or newer is required; you have %s( t conversionst
Thing2Literal( t
FIELD_TYPEt CLIENT( t settings( t utils( t *( t DatabaseClient( t DatabaseCreation( t DatabaseIntrospection( t DatabaseValidation( t force_strt
force_text( t SafeBytest SafeText( t six( t timezoneu errort categoryc C sL t | � } | d k rH t j rH t j | � rH | j d t j � } n | S( Nt tzinfo( t parse_datetimet NoneR t USE_TZR t is_naivet replacet utc( t valuet dt( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt$ parse_datetime_with_timezone_support< s $c C s� t j rn t j | � rM t j d | t � t j � } t j | | � } n | j t j
� j d d � } n t
| j d � | � S( NuG MySQL received a naive datetime (%s) while time zone support is active.R u %Y-%m-%d %H:%M:%S( R R R R t warningst warnt RuntimeWarningt get_default_timezonet
make_awaret
astimezoneR R R R t strftime( R t convt default_timezone( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt$ adapt_datetime_with_timezone_supportC s !u (\d{1,2})\.(\d{1,2})\.(\d{1,2})t
CursorWrapperc B sD e Z d Z d Z d � Z d d � Z d � Z d � Z d � Z RS( u<
A thin wrapper around MySQLdb's normal cursor class so that we can catch
particular exception instances and reraise them with the right types.
Implemented as a wrapper, rather than a subclass, so that we aren't stuck
to the particular underlying representation returned by Connection.cursor().
i c C s
| | _ d S( N( t cursor( t selfR* ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt __init__v s c C s� y | j j | | � SWnd t j k
r} } | j d | j k rw t j t j t j t
| j � � t j � d � n � n Xd S( Ni i (
R* t executet Databaset OperationalErrort argst codes_for_integrityerrorR t reraiseR t IntegrityErrort tuplet syst exc_info( R+ t queryR0 t e( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR- y s 5c C s� y | j j | | � SWnd t j k
r} } | j d | j k rw t j t j t j t
| j � � t j � d � n � n Xd S( Ni i (
R* t executemanyR. R/ R0 R1 R R2 R R3 R4 R5 R6 ( R+ R7 R0 R8 ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR9 � s 5c C s. | | j k r | j | St | j | � Sd S( N( t __dict__t getattrR* ( R+ t attr( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt __getattr__� s c C s
t | j � S( N( t iterR* ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt __iter__� s ( i N(
t __name__t
__module__t __doc__R1 R, R R- R9 R= R? ( ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR) l s
t DatabaseFeaturesc B s� e Z d Z e Z e Z e Z e Z e Z e Z
e Z e Z e Z
e Z e Z e Z e Z e Z e Z e Z e Z d � Z e d � � Z e d � � Z e d � � Z RS( c C s t t | � j | � d S( N( t superRC R, ( R+ t
connection( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR, � s c C sJ | j j � } | j d � | j d � | j � } | j d � | d S( uG Internal method used in Django tests. Don't rely on this from your codeu$ CREATE TABLE INTROSPECT_TEST (X INT)u. SHOW TABLE STATUS WHERE Name='INTROSPECT_TEST'u DROP TABLE INTROSPECT_TESTi ( RE R* R- t fetchone( R+ R* t result( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt _mysql_storage_engine� s
c C s
| j d k S( u- Confirm support for introspected foreign keysu MyISAM( RH ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt can_introspect_foreign_keys� s c C s< t d k r t S| j j � } | j d � | j � d k S( Nu% SELECT 1 FROM mysql.time_zone LIMIT 1( t pytzR t FalseRE R* R- RF ( R+ R* ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt has_zoneinfo_database� s
( ( R@ RA t empty_fetchmany_valueRK t update_can_self_selectt Truet allows_group_by_pkt related_fields_match_typet allow_sliced_subqueriest has_bulk_insertt has_select_for_updatet has_select_for_update_nowaitt supports_forward_referencest supports_long_model_namest supports_microsecond_precisiont supports_regex_backreferencingt! supports_date_lookup_using_stringt supports_timezonest- requires_explicit_null_ordering_when_groupingt allows_primary_key_0t uses_savepointst atomic_transactionsR, R RH RI RL ( ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyRC � s, t DatabaseOperationsc B s� e Z d Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z
d � Z d
� Z d � Z
d � Z e d
� Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( u! django.db.backends.mysql.compilerc C s, | d k r d | Sd | j � | f Sd S( Nu week_dayu
DAYOFWEEK(%s)u EXTRACT(%s FROM %s)( t upper( R+ t lookup_typet
field_name( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt date_extract_sql� s c
C s� d d d d d d g } d } d } y | j | � d } Wn t k
rT | } nR Xd j g | | D] } | ^ qf g | | D] } | ^ q� � } d | | f } | S( Nu yearu monthu dayu houru minuteu secondu %%Y-u %%mu -%%du %%H:u %%iu :%%su 0000-u 01u -01u 00:u 00u :00i u u' CAST(DATE_FORMAT(%s, '%s') AS DATETIME)( u %%Y-u %%mu -%%du %%H:u %%iu :%%s( u 0000-u 01u -01u 00:u 00u :00( t indext
ValueErrort join(
R+ Rb Rc t fieldst formatt
format_deft it sqlt ft
format_str( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt date_trunc_sql� s
Ac C s^ t j r d | } | g } n g } | d k r> d | } n d | j � | f } | | f S( Nu CONVERT_TZ(%s, 'UTC', %%s)u week_dayu
DAYOFWEEK(%s)u EXTRACT(%s FROM %s)( R R Ra ( R+ Rb Rc t tznamet paramsRl ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt datetime_extract_sql� s
c C s� t j r d | } | g } n g } d d d d d d g } d } d } y | j | � d } Wn t k
ry | } nR Xd j g | | D] }
|
^ q� g | | D] }
|
^ q� � } d | | f } | | f S( Nu CONVERT_TZ(%s, 'UTC', %%s)u yearu monthu dayu houru minuteu secondu %%Y-u %%mu -%%du %%H:u %%iu :%%su 0000-u 01u -01u 00:u 00u :00i u u' CAST(DATE_FORMAT(%s, '%s') AS DATETIME)( u %%Y-u %%mu -%%du %%H:u %%iu :%%s( u 0000-u 01u -01u 00:u 00u :00( R R Re Rf Rg ( R+ Rb Rc Rp Rq Rh Ri Rj Rk Rl Rm Rn ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt datetime_trunc_sql� s
Ac C s d | | | j | j | j f S( Nu/ (%s %s INTERVAL '%d 0:0:%d:%d' DAY_MICROSECOND)( t dayst secondst microseconds( R+ Rl t connectort timedelta( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt date_interval_sql
s c C s d S( Nu DROP FOREIGN KEY( ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt drop_foreignkey_sql s c C s d g S( u�
"ORDER BY NULL" prevents MySQL from implicitly ordering by grouped
columns. If no ordering would otherwise be applied, we don't want any
implicit sorting going on.
u NULL( ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt force_no_ordering s c C s d | S( Nu( MATCH (%s) AGAINST (%%s IN BOOLEAN MODE)( ( R+ Rc ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt fulltext_search_sql s c C s t t | d d � d d �S( Nu _last_executedt errorsu replace( R R; R ( R+ R* Rl Rq ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt last_executed_query s c C s d S( Nl ���� ( ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt no_limit_value" s c C s* | j d � r" | j d � r" | Sd | S( Nu `u `%s`( t
startswitht endswith( R+ t name( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt
quote_name& s c C s d S( Nu RAND()( ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt random_function_sql+ s c C s� | r| d g } x@ | D]8 } | j d | j d � | j | j | � � f � q W| j d � | j | j | | � � | Sg Sd S( Nu SET FOREIGN_KEY_CHECKS = 0;u %s %s;u TRUNCATEu SET FOREIGN_KEY_CHECKS = 1;( t appendt SQL_KEYWORDt SQL_FIELDR� t extendt sequence_reset_by_name_sql( R+ t stylet tablest sequencest
allow_cascadeRl t table( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt sql_flush. s
!
c C s~ | j j d
k rv g | D]Y } d | j d � | j d � | j | j | d � � | j d � | j d � f ^ q Sg Sd S( Ni i i
u %s %s %s %s %s;u ALTERu TABLEu tableu AUTO_INCREMENTu = 1( i i i
( RE t
mysql_versionR� t SQL_TABLER� R� ( R+ R� R� t sequence( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR� ? s ac C s | d k r t d � � n | S( Ni u@ The database backend does not accept 0 as a value for AutoField.( Rf ( R+ R ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt validate_autopk_valueM s c C sq | d k r d St j | � rX t j rI | j t j � j d d � } qX t d � � n t j
| j d d � � S( NR uM MySQL backend does not support timezone-aware datetimes when USE_TZ is False.t microsecondi ( R R t is_awareR R R$ R R Rf R t text_type( R+ R ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt value_to_db_datetimeT s !c C sG | d k r d St j | � r. t d � � n t j | j d d � � S( Nu4 MySQL backend does not support timezone-aware times.R� i ( R R R� Rf R R� R ( R+ R ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt value_to_db_timeb s
c C s@ t t | � j | � \ } } | j d d � | j d d � g S( NR� i ( RD R` t% year_lookup_bounds_for_datetime_fieldR ( R+ R t firstt second( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR� m s c C s d S( Ni@ ( ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt max_name_lengthr s c C s8 d d j d g t | � � } d d j | g | � S( Nu (%s)u , u %su VALUES ( Rg t len( R+ Rh t
num_valuest items_sql( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt bulk_insert_sqlu s ( R@ RA t compiler_moduleRd Ro Rr Rs Ry Rz R{ R| R~ R R� R� RK R� R� R� R� R� R� R� R� ( ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR` � s*
t DatabaseWrapperc B s� e Z d Z i d d 6d d 6d d 6d d 6d d 6d
d 6d d
6d d 6d d 6d d 6d d 6d d 6d d 6d d 6Z e Z d � Z d � Z d � Z d � Z d � Z d � Z
d � Z d � Z d � Z
d$ d! � Z d" � Z e d# � � Z RS(% u mysqlu = %su exactu LIKE %su iexactu LIKE BINARY %su containsu icontainsu REGEXP BINARY %su regexu REGEXP %su iregexu > %su gtu >= %su gteu < %su ltu <= %su lteu
startswithu endswithu istartswithu iendswithc O sw t t | � j | | � t | � | _ t | � | _ t | � | _ t | � | _
t | � | _ t
| � | _ d S( N( RD R� R, RC t featuresR` t opsR
t clientR t creationR t
introspectionR
t
validation( R+ R0 t kwargs( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR, � s c C s i t d 6d d 6} t j r* t | d <n | j } | d rN | d | d <n | d ri | d | d <n | d r� t | d � | d
<n | d j d � r� | d | d
<n | d r� | d | d <n | d r� t | d � | d <n t j | d <| j
| d � | S( Nu convu utf8u charsetu use_unicodeu USERu useru NAMEu dbu PASSWORDu passwdu HOSTu /u unix_socketu hostu PORTu portu client_flagu OPTIONS( t django_conversionsR t PY2RO t
settings_dictR R� t intR t
FOUND_ROWSt update( R+ R� R� ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt get_connection_params� s*
c C s> t j | � } | j t j | j t <| j t | j t <| S( N( R. t connectt encodersR R� R t bytesR ( R+ t conn_paramst conn( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt get_new_connection� s c C s* | j j � } | j d � | j � d S( Nu SET SQL_AUTO_IS_NULL = 0( RE R* R- t close( R+ R* ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt init_connection_state� s
c C s | j j � } t | � S( N( RE R* R) ( R+ R* ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt
create_cursor� s c C s, y t j | � Wn t j k
r' n Xd S( N( t BaseDatabaseWrappert _rollbackR. t NotSupportedError( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR� � s c C s$ | j � | j j | � Wd QXd S( N( t wrap_database_errorsRE t
autocommit( R+ R� ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt _set_autocommit� s
c C s | j � j d � t S( u�
Disables foreign key checks, primarily for use in adding rows with forward references. Always returns True,
to indicate constraint checks need to be re-enabled.
u SET foreign_key_checks=0( R* R- RO ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt disable_constraint_checking� s c C s; t | j | _ } z | j � j d � Wd | | _ Xd S( uM
Re-enable foreign key checks after they have been disabled.
u SET foreign_key_checks=1N( RK t needs_rollbackR* R- ( R+ R� ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt enable_constraint_checking� s c
C s | j � } | d k r- | j j | � } n x� | D]� } | j j | | � } | s[ q4 n | j j | | � } x� | D] \ } } } | j d | | | | | | | | f � xD | j � D]6 } t j d | | d | | | d | | f � � q� Wqw Wq4 Wd S( u�
Checks 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.
Raises an IntegrityError on the first invalid foreign key reference encountered (if any) and provides
detailed information about the invalid reference in the error message.
Backends can override this method if they can more directly apply constraint checking (e.g. via "SET CONSTRAINTS
ALL IMMEDIATE")
u
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 NULLu� The 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.i i N(
R* R R� t table_namest get_primary_key_columnt get_key_columnsR- t fetchallR R3 (
R+ R� R* t
table_namet primary_key_column_namet key_columnst column_namet referenced_table_namet referenced_column_namet bad_row( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt check_constraints� s$
c C s1 y | j j � Wn t j k
r( t SXt Sd S( N( RE t pingR. t ErrorRK RO ( R+ ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt is_usable s
c C ss | j � � | j j � } Wd QXt j | � } | sJ t d | � � n t g | j � D] } t | � ^ qZ � S( Nu8 Unable to determine MySQL version from version string %r( t temporary_connectionRE t get_server_infot server_version_ret matcht ExceptionR4 t groupsR� ( R+ t server_infoR� t x( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR� s
N( R@ RA t vendort operatorsR. R, R� R� R� R� R� R� R� R� R R� R� R R� ( ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyR� y s:
# ( i i i ( i i i (M RB t
__future__R t datetimet reR5 R t MySQLdbR. t ImportErrorR8 t django.core.exceptionsR t django.utils.functionalR t version_infot versionR� t __version__t MySQLdb.convertersR R t MySQLdb.constantsR R RJ R t django.confR t django.dbR t django.db.backendst django.db.backends.mysql.clientR
t! django.db.backends.mysql.creationR t& django.db.backends.mysql.introspectionR t# django.db.backends.mysql.validationR
t django.utils.encodingR R t django.utils.safestringR R t django.utilsR R t DEBUGt filterwarningst Warningt
DatabaseErrorR3 t DATETIMER R R( t copyR� R� t utilt
typecast_timet TIMEt typecast_decimalt DECIMALt
NEWDECIMALt compileR� t objectR) t BaseDatabaseFeaturesRC t BaseDatabaseOperationsR` R� R� ( ( ( s? /tmp/pip-install-XxeQeY/django/django/db/backends/mysql/base.pyt <module> sh 2
+9�