|
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 : /lib/python2.7/site-packages/south/db/ |
Upload File : |
�
m�Rc @ sn d d l m Z d d l m Z m Z d d l m Z d � Z d � Z d � Z d e j
f d � � YZ
d S(
i����( t generic( t DryRunErrort INVALID( t
get_loggerc s � f d � } | S( s
Decorates column operation functions for MySQL.
Deletes the constraints from the database and clears local cache.
c s� y | j | | � Wn t k
r' n Xy@ | j | | � } x' | D] \ } } } | j | | � qD WWn t k
r{ n X� | | | | | � S( N( t delete_foreign_keyt
ValueErrort _lookup_reverse_constraintR ( t selft
table_namet column_namet argst optst reverset cnamet rtablet rcolumn( t func( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt
_column_rm s
( ( R R ( ( R s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt delete_column_constraints
s c s � f d � } | S( s}
Decorates column operation functions for MySQL.
Determines existing constraints and copies them to a new column
c s5 y� | j | | � d } | j | | � } | d k r� | \ } } | r� | r� | j | | | | � }
t � j d |
� | j |
� q� n Wn! t k
r� n t k
r� n XyU | j | | � } x< | D]4 \ } }
} | j |
| | | � }
| j |
� q� WWn t k
rn X� | | | | | | � S( Ni s Foreign key SQL: (
t _find_foreign_constraintst _lookup_constraint_referencest Nonet foreign_key_sqlR t debugt add_deferred_sqlt
IndexErrorR R ( R R t
column_oldt
column_newR
R t
constraintt refst ftablet fcolumnt fk_sqlR R
R R ( R ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt
_column_cp% s0
( ( R R! ( ( R s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt copy_column_constraints s c s � f d � } | S( s�
For MySQL we grab all table constraints simultaneously, so this is
effective.
It further solves the issues of invalidating referred table constraints.
c sv | j d � } | | j k r+ | j | =n | | j k rG | j | =n | | j k rc | j | =n � | | | | � S( Nt NAME( t _get_settingt _constraint_cachet _reverse_cachet _constraint_references( R t tableR
R t db_name( R ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt _cache_clearI s
( ( R R* ( ( R s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt invalidate_table_constraintsC 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 e Z
e Z e Z d
d d d
g Z d d g Z d � Z d � Z d � Z d � Z d � Z e e e d � � � � Z e d � � Z e d � � Z e d � � Z d � Z d d � Z d � Z! d � Z" RS( s�
MySQL implementation of database operations.
MySQL has no DDL transaction support This can confuse people when they ask
how to roll back - hence the dry runs, etc., found in the migration code.
t mysqlt s MODIFY %(column)s %(type)s NULL;s$ MODIFY %(column)s %(type)s NOT NULL;s+ DROP INDEX %(index_name)s ON %(table_name)ss& ALTER TABLE %(table)s DROP PRIMARY KEYs5 ALTER TABLE %(table)s DROP FOREIGN KEY %(constraint)ss ALTER TABLE %s DROP INDEX %ss RENAME TABLE %s TO %s;t geometryt pointt
linestringt polygont textt blobc C sj i | _ i | _ t t | � j | � | j d � rf | j d � rf | j d | j d � | _ n d S( Nt STORAGE_ENGINEs
ENGINE=%s( R' R& t superR, t __init__t _has_settingR$ t create_table_sql( R t db_alias( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyR7 n s
c C s/ | j } | | k o. | | j | d � t k S( N( R% t getR R ( R R) R t cache( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt _is_valid_cacheu s c C sK i | j | <i | j | | <i | j | <i | j | <d } | j | | g � } | s] d Si } xV | D]N \ } } } } }
| | f } | j | t � � | | j | | |
f � qj Wd } | j | | g � } xm| D]e\ } } }
| | f } | j | j | i � y | | } Wn t k
r:t � } n Xx| D]� } | \ } } }
| j | | j | t � � |
d k r | j | | | j |
| f � | |
f | j | | | f <| j | j | i � | j | | j |
t � � | j | | |
j | | | f � qB| j | | | j |
| f � qBWq� Wd S( Ns
SELECT kc.`constraint_name`, kc.`column_name`, kc.`table_name`,
kc.`referenced_table_name`, kc.`referenced_column_name`
FROM information_schema.key_column_usage AS kc
WHERE
kc.table_schema = %s
s�
SELECT c.constraint_name, c.table_name, c.constraint_type
FROM information_schema.table_constraints AS c
WHERE
c.table_schema = %s
s FOREIGN KEY( R% R& R' t executet
setdefaultt sett addt KeyError( R R) R t
name_queryt rowst cnamesR t columnR( t ref_tablet
ref_columnt keyt
type_queryt kindt colst
column_set( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt _fill_constraint_cachez sH
c C su | j � j � } | j d � r* d } n d } | j d � rq | j d � rq | j d | | j d � f � n d S( s�
Run before any SQL to let database-specific config be sent as a command,
e.g. which storage engine (MySQL) or transaction serialisability level.
s< SHOW variables WHERE Variable_Name='default_storage_engine';t default_storage_enginet storage_engineR5 s
SET %s=%s;N( t _get_connectiont cursorR> R8 R$ ( R RR t
engine_var( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt connection_init� s c C s$ t t | � j � | j d � d S( Ns SET FOREIGN_KEY_CHECKS=0;( R6 R, t start_transactionR> ( R ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyRU � s c C sR | | k s | j r g Sg | j d | j | � f � D] } | d | k r9 | ^ q9 } | sz t d | | f � � n | j | � | j | � | j | � | d d | d d d k r� d p� d | d d r� d
p� d | d d r� d p� d | d d
pd f } d | } | d d rA| j | | d d f � n
| j | � d S( Ns DESCRIBE %si s No column '%s' in '%s'.i i t YESt NULLs NOT NULLi s DEFAULT R. s %si s2 ALTER TABLE %s CHANGE COLUMN %s %s %s %s %s %s %s;( t dry_runR> t
quote_nameR ( R R t oldt newt xRD t paramst sql( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt
rename_column� s" B
c C s t t | � j | | � d S( N( R6 R, t
delete_column( R R t name( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyR` � s c C s t t | � j | | � d S( N( R6 R, t rename_table( R t old_table_nameR ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyRb � s c C s t t | � j | � d S( N( R6 R, t delete_table( R R ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyRd � s c C sA | j d � } y | j | | | f SWn t k
r< d SXd S( sm
Provided an existing table and constraint, returns tuple of (foreign
table, column)
R# N( R$ R' RB R ( R R R
R) ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyR � s
c C s� | j d � } | j r' t d � � n | j | | � sL | j | | � n y^ | j | | } | d k r� g | j � D] \ } } | t | � f ^ qy St | | � SWn t k
r� g SXd S( s6 Look for the column referenced by a foreign constraintR# s# Cannot get constraints for columns.N(
R$ RX R R= t lookup_constraintR& R t itemst tupleRB ( R R R R) R( R\ t y( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyR � s /
c C s� | j | � j � } t g | j D] } | j | � d k ^ q" k } t g | j D] } | j | � d k ^ qS k } | s� | r� t | _ n | S( s[
This particular override stops us sending DEFAULTs for BLOB/TEXT columns.
i����( t _db_type_for_alter_columnt lowert Truet
geom_typest findt
text_typest _suppress_default( R t fieldt typet tt is_geomt is_text( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt
_field_sanity s 11 c C s� | d } t g | j D] } | j | � d k ^ q k } t g | j D] } | j | � d k ^ qH k } | r� | r� t t | � j | | | | � n d S( sJ
MySQL does not support defaults on text or blob columns.
Rq i����N( Rk Rl Rm Rn R6 R, t _alter_set_defaults( R Rp Ra R] t sqlsRq Rr Rs Rt ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyRv s
11N(# t __name__t
__module__t __doc__t backend_namet alter_string_set_typet alter_string_set_nullt alter_string_drop_nullt drop_index_stringt delete_primary_key_sqlt delete_foreign_key_sqlt delete_unique_sqlt rename_table_sqlt Falset allows_combined_alterst has_check_constraintst raises_default_errorsRl Rn R7 R= RN RT RU R" R R+ R_ R` Rb Rd R R R Ru Rv ( ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyR, U s< 8
N( t south.dbR t south.db.genericR R t south.loggerR R R" R+ R, ( ( ( s2 /usr/lib/python2.7/site-packages/south/db/mysql.pyt <module> s #