|
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 : |
�
xx�Rc @ s� d d l m Z d d l Z d d l Z d d l m Z d d l m Z m Z d d l m
Z
d d l m Z d d l
m Z d d l m Z d d l m Z d d
l m Z d d l m Z y d d l m Z Wn' e k
r� d
e f d � � YZ n Xd d l m Z d d l m Z m Z d � Z d � Z! d � Z" d � Z# d e$ f d � � YZ% d e& f d � � YZ' d e f d � � YZ( d � Z) d S( i����( t print_functionN( t no_style( t transactiont models( t
DatabaseError( t
truncate_name( t BaseDatabaseCreation( t NOT_PROVIDED( t
dispatcher( t settings( t
SortedDict( t cached_propertyR c B s e Z d Z d � Z d � Z RS( s�
Decorator that creates converts a method with a single
self argument into a property cached on the instance.
c C s
| | _ d S( N( t func( t selfR ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt __init__ s c C s$ | j | � } | j | j j <| S( N( R t __dict__t __name__( R
t instancet typet res( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt __get__ s ( R t
__module__t __doc__R R ( ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR s ( t
get_logger( t string_typest text_typec s � f d � } | S( s�
Returns a function which calls 'attrname' - for function aliasing.
We can't just use foo = bar, as this breaks subclassing.
c s t | � � | | � S( N( t getattr( R
t argst kwds( t attrname( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR ' s ( ( R R ( ( R s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt alias" s c s � f d � } | S( Nc s& | j | d t �� | | | | � S( Nt value( t
_set_cachet INVALID( R
t tableR t opts( R ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _cache_clear- s ( ( R R$ ( ( R s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt invalidate_table_constraints, s c s � f d � } | S( Nc s, | j | | d g �� | | | | | � S( NR ( R ( R
R" t columnR R# ( R ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
_column_rm4 s ( ( R R' ( ( R s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt delete_column_constraints3 s c s � f d � } | S( Nc sM | j d � } | j | | d | j | | | � �� | | | | | | � S( Nt NAMER ( t _get_settingR t lookup_constraint( R
R" t
column_oldt
column_newR R# t db_name( R ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
_column_cp; s %( ( R R/ ( ( R s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt copy_column_constraints: s R! c B s e Z d � Z RS( c C s d S( NR! ( ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt __repr__C s ( R R R1 ( ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR! B s t DryRunErrorc B s e Z RS( ( R R ( ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR2 G 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 d Z d Z d
Z dY Z d Z e Z e Z e Z e Z e Z e d � � Z d � Z dY d � Z dY e d � Z d � Z! d � Z" d � Z# d � Z$ d � Z% d � Z& d � Z' d � Z( d � Z) g d � Z* g e d � Z+ d d d � Z, d! � Z- d" � Z. d# � Z/ dY d$ � Z0 d% � Z1 e2 d& � � Z3 e4 d' � Z5 e2 d( � � Z6 e2 e d) � � Z7 e4 d* � Z8 e2 d+ � � Z9 e2 e d, � � Z: d- � Z; d. � Z< d/ � Z= d0 � Z> e2 e e? d1 � � Z@ d2 � ZA d3 d4 � ZB e2 d5 � � ZC e2 d6 � � ZD d7 e e? d8 � ZE d9 � ZF d: � ZG d; � ZH e2 d< � � ZI e4 d= � ZJ dY d> � ZK d? � ZL d@ � ZM d7 dA � ZN e? d7 dB � ZO e2 e? d7 dC � � ZP e2 d7 dD � � ZQ e4 dE � ZR eS dF � � ZT e4 dG � ZU dH � ZV e2 dI � � ZW e4 dJ � ZX e2 dK � � ZY dL � ZZ dM � Z[ dN � Z\ dO � Z] dP � Z^ dQ � Z_ dR e? dS � Z` dR e? dT � Za d7 dU eb jc g i dV � Zd dW � Ze dX � Zf RS(Z sr
Generic SQL implementation of the DatabaseOperations.
Some of this code comes from Django Evolution.
s% ALTER COLUMN %(column)s TYPE %(type)ss% ALTER COLUMN %(column)s DROP NOT NULLs$ ALTER COLUMN %(column)s SET NOT NULLs4 ALTER TABLE %(table)s DROP CONSTRAINT %(constraint)ss ALTER TABLE %s ADD COLUMN %s;s! ALTER TABLE %s DROP CONSTRAINT %ss$ CREATE TABLE %(table)s (%(columns)s)i? s DROP INDEX %(index_name)ss& ALTER TABLE %s DROP COLUMN %s CASCADE;sM ALTER TABLE %(table)s ADD CONSTRAINT %(constraint)s PRIMARY KEY (%(columns)s)s/ ADD CONSTRAINT %(constraint)s CHECK (%(check)s)s ALTER TABLE %s RENAME TO %s;t publicc C s | j � | j � } t | j d � rE | j j rE | j j � n t f } y! d d l m } | | f 7} Wn t k
r� n Xt
| j d t � r| j � } | j
� | j d � | j � z. y | j d � Wn | k
r� t SXt SWd | j d � Xn t Sd S( sp
Tests the database using feature detection to see if it has
transactional DDL support.
t confirmi����( t OperationalErrort supports_transactionss) CREATE TABLE DDL_TRANSACTION_TEST (X INT)Ns DROP TABLE DDL_TRANSACTION_TEST( t _possibly_initialiset _get_connectiont hasattrt featurest
_confirmedR5 R t MySQLdbR6 t ImportErrorR t Truet cursort start_transactiont executet rollback_transactiont False( R
t
connectiont
exceptionsR6 R@ ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt has_ddl_transactionsj s.
c C sL t | _ g | _ t | _ d | _ g | _ | | _ i | _ t | _ d S( Ni ( RD t debugt deferred_sqlt dry_runt pending_transactionst pending_create_signalst db_aliast _constraint_cachet _initialised( R
RM ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR � s c s� � � � � f d � } y | � } | SWne t k
rZ � j � � =� j � � � n7 t k
r� � j � � � r} g S� j � � � n X� j � � � � S( sB return a set() of constraints for db_name.table_name.column_name c sN � j � � } | t k r& t � n$ � d k rB t | j � � S| � Sd S( N( RN R! t Nonet listt items( R" ( t column_nameR. R
t
table_name( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _lookup� s ( R! RN t _fill_constraint_cachet KeyErrort _is_valid_cacheR+ ( R
R. RT RS RU t ret( ( RS R. R
RT s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR+ � s
c C sf | j d � } y9 | d k r6 | | j | | | <n | | j | | <Wn t t f k
ra n Xd S( NR) ( R* RP RN t LookupErrort TypeError( R
RT RS R R. ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR � s c C s2 y | j | | t k SWn t k
r- t SXd S( N( RN R! RW RD ( R
R. RT ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRX � s
c C s5 y d d l m } | Wn t k
r, t SXt Sd S( Ni����( t connections( t django.dbR\ R> RD R? ( R
R\ ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _is_multidb� s
c C s? | j � r' d d l m } | | j Sd d l m } | Sd S( sB
Returns a django connection for a given DB Alias
i����( R\ ( RE N( R^ R] R\ RM RE ( R
R\ RE ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR9 � s
c C sD | j � } | j � } | j � r/ | j | St t d | � Sd S( sR
Allows code to get a setting (like, for example, STORAGE_ENGINE)
s DATABASE_%sN( t upperR9 R^ t
settings_dictR R ( R
t setting_nameRE ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR* � s
c C s4 y | j | � Wn t t f k
r+ t SXt Sd S( s=
Existence-checking version of _get_setting.
N( R* RW t AttributeErrorRD R? ( R
Ra ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _has_setting� s
c C s3 y | j d � SWn t t f k
r. | j SXd S( Nt schema( R* RW Rb t default_schema_name( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _get_schema_name� s c C s# | j s | j � t | _ n d S( N( RO t connection_initR? ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR8 � s
c C s 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.
N( ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRg � s c C s | j � j j | � S( sQ
Uses the database backend to quote the given table/column name.
( R9 t opst
quote_name( R
t name( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRi � s c C s2 t d | d t j �t d | d t j �d S( Ns0 FATAL ERROR - The following SQL query failed: %st files The error was: %s( t printt syst stderr( R
t et sqlt params( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _print_sql_error s c C s� | j � | j � j � } | j r9 t d | | � n | j rF g St � j t d | | f � � y | j | | � Wn2 t k
r� } | r� | j
| | | � n � n Xy | j � SWn g SXd S( s�
Executes the given SQL statement, with optional parameters.
If the instance's debug attribute is True, prints out what it executes.
s = %ss execute "%s" with params "%s"N( R8 R9 R@ RH Rl RJ R R RB R Rr t fetchall( R
Rp Rq t print_all_errorsR@ Ro ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRB s"
s! (?mx) ([^';]* (?:'[^']*'[^';]*)*)s (?mx) (?:^\s*$)|(?:--.*$)c C s� d j g t j | | � D]* } | j � r | j � j d d � ^ q � } x8 t j | | � d d d d � D] } | j | � qp Wd S( s�
Takes a SQL file and executes it as many separate statements.
(Some backends, such as Postgres, don't work otherwise.)
s
t %s %%i Ni ( t joint ret splitt stript replaceRB ( R
Rp t regext
comment_regext xt st( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt execute_many% s L*c C s | j j | � d S( s�
Add a SQL statement to the deferred list, that won't be executed until
this instance's execute_deferred_sql method is run.
N( RI t append( R
Rp ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt add_deferred_sql2 s c C s. x | j D] } | j | � q
Wg | _ d S( sL
Executes all deferred SQL, resetting the deferred_sql list
N( RI RB ( R
Rp ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt execute_deferred_sql9 s c C s
g | _ d S( s8
Resets the deferred_sql list to empty.
N( RI ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt clear_deferred_sqlB s c C s | j � | p g | _ d S( s�
Resets variables to how they should be before a run. Used for dry runs.
If you want, pass in an old panding_creates to reset to.
N( R� RL ( R
t pending_creates( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt clear_run_dataH s
c C s | j S( N( RL ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt get_pending_createsP s c C s� t | � d k r t d � n x | D] \ } } t | _ q& Wg | D]! \ } } | j | | | � ^ qF } | j | j i | j | � d 6d j g | D] } | r� | ^ q� � d 6� d S( s�
Creates the table 'table_name'. 'fields' is a tuple of fields,
each repsented by a 2-part tuple of field name and a
django.db.models.fields.Field object
i? so ! WARNING: You have a table name longer than 63 characters; this will not fully work on PostgreSQL or MySQL.R" s , t columnsN( t lenRl R? t _suppress_defaultt
column_sqlRB t create_table_sqlRi Rv ( R
RT t fieldst
field_namet fieldR� t col( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt create_tableS s
+R� c C sY | | k r d S| j | � | j | � f } | j | j | � | j | d t �d S( sE
Renames the table 'old_table_name' to 'table_name'.
NR ( Ri RB t rename_table_sqlR R! ( R
t old_table_nameRT Rq ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt rename_tablen s
c C sA | j | � f } | r, | j d | � n | j d | � d S( s1
Deletes the table 'table_name'.
s DROP TABLE %s CASCADE;s DROP TABLE %s;N( Ri RB ( R
RT t cascadeRq ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt delete_table{ s R� c C s' | j | � f } | j d | � d S( s5
Deletes all rows from 'table_name'.
s DELETE FROM %s;N( Ri RB ( R
RT Rq ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt clear_table� s c C s� | j | | | � } | r� | j | � | f } | j | } | j | � | j d k r� t | _ | j | | | d t d t �q� n d S( sX
Adds the column 'name' to the table 'table_name'.
Uses the 'field' paramater, a django.db.models.fields.Field instance,
to generate the necessary sql
@param table_name: The name of the table to add the column to
@param name: The name of the column to add
@param field: The field to use
t
explicit_namet ignore_constraintsN(
R� Ri t add_column_stringRB t defaultRP R t alter_columnRD R? ( R
RT Rj R� t keep_defaultRp Rq ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
add_column� s
c C s9 y | j d | j � � SWn t k
r4 | j � SXd S( s�
Returns a field's type suitable for ALTER COLUMN.
By default it just returns field.db_type().
To be overriden by backend specific subclasses
@param field: The field to generate type for
RE N( t db_typeR9 R[ ( R
R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _db_type_for_alter_column� s
c C s d S( s�
Subcommand of alter_column that modifies column definitions beyond
the type string -- e.g. adding constraints where they cannot be specified
as part of the type (overrideable)
N( ( R
R� Rj Rq t sqls( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _alter_add_column_mods� s c C s' | j d | j | � f g f � d S( sB Subcommand of alter_column that sets default values (overrideable)s ALTER COLUMN %s DROP DEFAULTN( R� Ri ( R
R� Rj Rq R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _alter_set_defaults� s c C s< | j | j � d | j � �} | j d | | g � d S( sM Subcommand of alter_column that updates nulls to default value (overrideable)RE sA UPDATE %(table_name)s SET %(column)s=%%s WHERE %(column)s IS NULLN( t get_db_prep_savet get_defaultR9 RB ( R
Rq R� R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _update_nulls_to_default� s !c
C s* | j r# | j r t d � n d St | d � r? | j � n | j | � | s^ | j } n | | _ | s| j r� | j | | g d � } xE | D]: } | j | j
i | j | � d 6| j | � d 6� q� Wn y | j | | � Wqt
k
r� qXn i | j | � d 6| j | � d 6| j | � d 6} g } | d d k rj| j | j | g f � n | j | | | | � | j s�| j � r�| j | j | g f � n | j | j | g f � | j | | | | � | j r2t | � \ } }
| j d
| j | � d j | � f t |
� � n: x7 | D]/ \ } }
| j d
| j | � | f |
� q9W| j r�| j � r�| j | | � | j d
| j | � | j | f g � n | s&| j r&| j r&| j | j | | j | j j j! j" | j j j! j# | j j$ � j � � q&n d S( s�
Alters the given column name so it will match the given field.
Note that conversion between the two by the database must be possible.
Will not automatically add _id by default; to have this behavour, pass
explicit_name=False.
@param table_name: The name of the table to add the column to
@param name: The name of the column to alter
@param field: The new field definition to use
sC - no dry run output for alter_column() due to dynamic DDL, sorryNt
south_initt CHECKR" t
constraintR& R RT s ALTER TABLE %s %s;s , (% RJ RH Rl R: R� t set_attributes_from_nameR& t has_check_constraintst _constraints_affecting_columnsRB t delete_check_sqlRi t delete_foreign_keyt
ValueErrorR� RP R� t alter_string_set_typeR� t nullt has_defaultt alter_string_set_nullt alter_string_drop_nullR� t allows_combined_alterst zipRv t flattenR� t relt supports_foreign_keyst foreign_key_sqlt tot _metat db_tablet get_fieldR� ( R
RT Rj R� R� R� t check_constraintsR� Rq R� t valuesRp ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� � sf
'-c
C s� | j � } d d g } | j j | i � i | j | | <x� | D]| } | j d | | | g � } xW | D]O \ } } } | j | | j | t � � | j | | | j | | f � ql WqC Wd S( Nt constraint_column_usaget key_column_usages�
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.%s AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %%s AND
kc.table_name = %%s
( Rf RN t
setdefaultRB t sett add(
R
R. RT Rd t ifsc_tablest
ifsc_tablet rowsR� R& t kind( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRV / s
*t UNIQUEc c s | j r t d � � n | d k r? t t d � | � � } n | j d � } i } xp | j | | � D]\ \ } } xM | D]E \ } } | | k rz | j | t � � | | j | j � � qz qz Wqg Wx: | j
� D], \ } }
|
| k s� | d k r� | Vq� q� Wd S( s�
Gets the names of the constraints affecting the given columns.
If columns is None, returns all constraints of the type on the table.
s# Cannot get constraints for columns.c S s
| j � S( N( t lower( t s( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt <lambda>Q s R) N( RJ R2 RP R� t mapR* R+ R� R� R� RR ( R
RT R� R R. t cnamesR� t constraintsR� t cnamet cols( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� H s "c C s� t | t t f � s! | g } n | j | | d d �} d j t | j | � � } | j d | j | � | j | � | f � | S( sP
Creates a UNIQUE constraint on the columns on the given table.
t suffixt _uniqs , s, ALTER TABLE %s ADD CONSTRAINT %s UNIQUE (%s)( t
isinstanceRQ t tuplet create_index_nameRv R� Ri RB ( R
RT R� Rj R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
create_unique` s c C s� t | t t f � s! | g } n | j rD | j r@ t d � n d St | j | | � � } | s{ t d | | f � � n x: | D]2 } | j | j | j
| � | j
| � f � q� Wd S( sZ
Deletes a UNIQUE constraint on precisely the columns on the given table.
sK - no dry run output for delete_unique_column() due to dynamic DDL, sorryNs7 Cannot find a UNIQUE constraint on table %s, columns %r( R� RQ R� RJ RH Rl R� R� RB t delete_unique_sqlRi ( R
RT R� R� R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
delete_uniques s
t c
C s� | s | j | � n t | d � r2 | j � n | j | � } y | j d | j � � } Wn t k
r| | j � } n X| r| r� | j | j � | g } n | g } | j d | j
r� d p� d � | j r� | j d � n | j r | j d � n | j
p | } | rat | j � j d t � ra| j ra| j | j � j j | d t �� n d
j | � } d } t | d t � s�| j � rP| j � }
|
d k r�t |
� r�|
� }
n | j |
d | j � �}
| j |
� }
t |
t � rd |
j d
d � }
n t |
t � r:|
j d d � }
n | d 7} |
} q�q�| j
rc| j su| j � d k r�| j r�| j � j j r�| d 7} q�q�n | j! r| j" r| j# | j$ | | j | j! j% j& j' | j! j% j& j( | j! j) � j � � qn t | d � rCx- | j* t+ � | � D] } | j# | � q)Wn t | j � j, d � r�| j- d | � } x9 | j � j, j. | | t+ � � D] } | j# | � q�Wn | r�| | Sd Sd S( sY
Creates the SQL snippet for a column. Used by add_column and add_table.
R� RE s %sNULLs NOT R� s PRIMARY KEYR� t supports_tablespacest inlinet R� s '%s't 's ''Ru s %%s DEFAULT %ss DEFAULT ''t post_create_sqlt sql_indexes_for_fieldt FakeModelForGISCreationN( (/ R� R: R� t
_field_sanityR� R9 R[ Ri R& R� R� t primary_keyt uniquet
db_tablespaceR R; RD Rh t tablespace_sqlR? Rv R� R� RP t callableR� t _default_value_workaroundR� R Rz t blankt empty_strings_allowedt! interprets_empty_strings_as_nullsR� R� R� R� R� R� R� R� R� R� R t creationt
mock_modelR� (
R
RT R� R� t
tablespacet with_namet field_preparedRp t field_outputt sqlparamsR� t stmtt model( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� � sr
! *(
%+ (c C s | S( s�
Placeholder for DBMS-specific field alterations (some combos aren't valid,
e.g. DEFAULT and TEXT on MySQL)
( ( R
R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� � s c C s+ t | t � r# | j r# t | � S| Sd S( s}
DBMS-specific value alterations (this really works around
missing functionality in Django backends)
N( R� t boolt has_booleanst int( R
R ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� � s
c C s~ d | | | j | | � f } d | j | � | j | j | � � | j | � | j | � | j | � | j � j j � f S( sP
Generates a full SQL statement to add a foreign key constraint
s
%s_refs_%s_%ssG ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s (%s)%s;( t _digestRi t shorten_nameR9 Rh t deferrable_sql( R
t from_table_namet from_column_namet
to_table_namet to_column_namet constraint_name( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� s c C s� | j r# | j r t d � n d S| j | | � } | sT t d | | f � � n xB | D]: } | j | j i | j | � d 6| j | � d 6� q[ Wd S( s/
Drop a foreign key constraint
sI - no dry run output for delete_foreign_key() due to dynamic DDL, sorryNs; Cannot find a FOREIGN KEY constraint on table %s, column %sR" R� ( RJ RH Rl t _find_foreign_constraintsR� RB t delete_foreign_key_sqlRi ( R
RT R& R� R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� s
R� c C s� | j | | g d � } | j | � } t | � d k rC t | � S| j | � t | j | | d � � } t | j | � � Sd S( Ns FOREIGN KEYi ( R� t _find_primary_key_columnsR� RQ R� R� t union( R
RT RS R� t primary_key_columnst recursive_constraints( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR # s
c G s7 t | d � s' t | j � � | _ n | j j | � S( s�
Use django.db.backends.creation.BaseDatabaseCreation._digest
to create index name in Django style. An evil hack :(
t _django_db_creation( R: R R9 R R� ( R
R ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� 2 s c C s t | | j � j j � � S( N( R R9 Rh t max_name_length( R
Rj ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� ; s c C s: t | � d k rq | rq y | j | d g � } Wn$ t k
rY | j | d � } n X| j d | | f � S| j d d � j d d � } d t t | d j | � f � � } d
| | d | | f j d d � j d d � } t | � | j k r6d | d | | f } d | | j t | � | f } n | S(
s6
Generate a unique name for the index
i i s %s_%st "R� t .t _s _%xt ,s %s_%s%s%ss _%s%s%ss %s%s( R� R� R[ R� Rz t abst hashRv t max_index_name_length( R
RT t column_namesR� t _hasht index_unique_namet
index_namet part( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� > s
%2$c C s� | s t d � d S| j � } | rK | j j rK d | j j | � } n d } | j | | � } d | rr d pu d | j | � | j | � d j g | D] } | j | � ^ q� � | f S( sa
Generates a create index statement on 'table_name' for a list of 'column_names'
s4 No column names supplied on which to create an indexR� R� s CREATE %sINDEX %s ON %s (%s)%s;s UNIQUE R ( Rl R9 R; R� Rh R� R� Ri Rv ( R
RT R R� R� RE R� R R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt create_index_sqlZ s
(c C s) | j | | | | � } | j | � d S( s# Executes a create index statement N( R RB ( R
RT R R� R� Rp ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt create_indexq s c C sk t | t � r | g } n | j | | � } | j i | j | � d 6| j | � d 6} | j | � d S( s�
Deletes an index created with create_index.
This is possible using only columns due to the deterministic
index naming function which relies on column names.
R RT N( R� R R� t drop_index_stringRi RB ( R
RT R R� Rj Rp ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt delete_indexw s R c C s9 | j | � | j | � f } | j | j | g � d S( sO
Deletes the column 'column_name' from the table 'table_name'.
N( Ri RB t delete_column_string( R
RT Rj Rq ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
delete_column� s R c C s t d � � d S( sP
Renames the column 'old' from the table 'table_name' to 'new'.
s' rename_column has no generic SQL syntaxN( t NotImplementedError( R
RT t oldt new( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt
rename_column� s c C s� | j r# | j r t d � n d St | j | d d d �� } | s] t d | f � � n xB | D]: } | j | j i | j | � d 6| j | � d 6� qd Wd S( s,
Drops the old primary key.
sI - no dry run output for delete_primary_key() due to dynamic DDL, sorryNR s PRIMARY KEYs0 Cannot find a PRIMARY KEY constraint on table %sR" R� (
RJ RH Rl RQ R� RP R� RB t delete_primary_key_sqlRi ( R
RT R� R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt delete_primary_key� s
R c C sy t | t t f � s! | g } n | j | j i | j | � d 6| j | d � d 6d j t | j | � � d 6� d S( sE
Creates a new primary key on the specified columns.
R" t _pkeyR� s , R� N( R� RQ R� RB t create_primary_key_stringRi Rv R� ( R
RT R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt create_primary_key� s c C sx | j d � } t � } xY | j | | � D]E \ } } x6 | D]. \ } } | d k r> | j | j � � q> q> Wq+ W| S( sL
Find all columns of the primary key of the specified table
R) s PRIMARY KEY( R* R� R+ R� R� ( R
RT R. R R� R� R� R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR � s c C s[ | j r | j d 7_ n t j d | j � t j d | j � t j t d | j �d S( s�
Makes sure the following commands are inside a transaction.
Must be followed by a (commit|rollback)_transaction call.
i t usingN( RJ RK R t commit_unless_managedRM t enter_transaction_managementt managedR? ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRA � s
c C s7 | j r
d St j d | j � t j d | j � d S( sh
Commits the current transaction.
Must be preceded by a start_transaction call.
NR# ( RJ R t commitRM t leave_transaction_management( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt commit_transaction� s c C sE | j r | j d 8_ n t j d | j � t j d | j � d S( sk
Rolls back the current transaction.
Must be preceded by a start_transaction call.
i R# N( RJ RK R t rollbackRM R( ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRC � s c C s\ | j s
d Sx | j d k r, | j � q Wt j d | j � rX t j d | j � n d S( sJ
Rolls back all pending_transactions during this dry run.
Ni R# ( RJ RK RC R t is_dirtyRM R( ( R
( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt rollback_transactions_dry_run� s c C s | j j | | f � d S( N( RL R� ( R
t app_labelt model_names( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt send_create_signal� s i c C s� t � } xP | j D]E \ } } y | | j | � Wq t k
rW t | � | | <q Xq WxB | j � D]4 \ } } | j | t t | � � d | d | �qi Wg | _ d S( Nt verbosityt interactive( R
RL t extendRW RQ RR t really_send_create_signalR� ( R
R0 R1 t signalsR- R. ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt send_pending_create_signals� s
c
C s? | j r t d | | f � n t j | � } | s9 d Sg } x6 | D]. } t j | | � } | rF | j | � qF qF W| r;t t d � r� t j d t j j
d | d | d | d | d | � q;| j � r
t j j
j d | d | d | d | d | d
| j � q;t j j
j d | d | d | d | d | � n d S( s�
Sends a post_syncdb signal for the model specified.
If the model is not found (perhaps it's been deleted?),
no signal is sent.
TODO: The behavior of django.contrib.* apps seems flawed in that
they don't respect created_models. Rather, they blindly execute
over all models within the app sending the signal. This is a
patch we should push Django to make For now, this should work.
s( - Sending post_syncdb signal for %s: %sNt sendt signalt sendert appt created_modelsR0 R1 t db(
RH Rl R t get_appt get_modelR� R: R R6 R4 t post_syncdbR^ RM ( R
R- R. R0 R1 R9 R: t
model_nameR� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR3 s:
t idc
s` d t f � � � � � � � f d � � Y} d t f d � � Y} | � | _ | | j _ | S( sT
Generates a MockModel class that provides enough information
to be used by a foreign key/many-to-many relationship.
Migrations should prefer to use these rather than actual models
as models could get deleted over time, but these can remain in
migration files forever.
Depreciated.
t MockOptionsc s; e Z � � � � � � � f d � Z d � Z d � Z RS( c s~ � | _ � p t j | _ � | _ � j � | _ � t j k rO t � d <n � � � � | _
| j
j � � t | _
d S( NR� ( R� R t DEFAULT_TABLESPACER� t object_nameR� t module_nameR t AutoFieldR? t pkR� RD t abstract( R
( R� R� R? t
pk_field_argst pk_field_kwargst
pk_field_namet
pk_field_type( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR N s
c S s | j | j t t f S( N( RF R� R? RD ( R
R� ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt get_field_by_name[ s c S s | j S( N( RF ( R
Rj ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� _ s ( R R R RL R� ( ( R� R� R? RH RI RJ RK ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRA M s !
t MockModelc B s e Z d Z RS( N( R R RP R� ( ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyRM c s ( t objectR� R� (
R
R? R� R� RJ RK RH RI RA RM ( ( R� R� R? RH RI RJ RK s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� @ s
. c C sK t | | � j | � } t | t j t j f � rG | j d d � d S| S( s`
A helper for subclasses overriding _db_type_for_alter_column:
Remove the check constraint from the type string for PositiveInteger
and PositiveSmallInteger fields.
@param klass: The type of the child (required to allow this to be used when it is subclassed)
@param field: The field to generate type for
R� i i ( t superR� R� R t PositiveSmallIntegerFieldt PositiveIntegerFieldRx ( R
t klassR� t super_result( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt" _db_positive_type_for_alter_columnk s c C s� t | | � j | | | | � t | t j t j f � r� t t t | j � � � � } t
d d | t | � d f d d | j | � � } | j
| j | g f � n d S( s�
A helper for subclasses overriding _alter_add_column_mods:
Add a check constraint verifying positivity to PositiveInteger and
PositiveSmallInteger fields.
R� s
CK_%s_PSTV_%si t checks %s >= 0N( RO R� R� R RP RQ R R
R� R� t dictt hexRi R� t add_check_constraint_fragment( R
RR R� Rj Rq R� t uniq_hasht d( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt _alter_add_positive_checkx s N(g R R R R� R� R� R� R� R� R R� R R R R! R RX R� RP t backend_nameRe R? R� R� R� R� t raises_default_errorsR RG R R+ R! R RX R^ R9 R* Rc Rf R8 Rg Ri Rr RB R R� R� R� R� R� R% R� R t add_tableR� R� t
drop_tableR� R� R� R� R� R� RD R� RV R� R� R� R� R� R� R� R� t drop_foreign_keyR R� R� R� R R R t
drop_indexR( R t drop_columnR R t drop_primary_keyR" R RA R) RC R, R/ R5 R3 R RE R� RT R[ ( ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR3 K s� #
d e
6 )
c C s% g } x | D] } | | 7} q
W| S( N( ( t lst nlt l( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyR� � s
(* t
__future__R Rw Rm t django.core.management.colorR R] R R t django.db.utilsR t django.db.backends.utilR t django.db.backends.creationR t django.db.models.fieldsR t django.dispatchR t django.confR t django.utils.datastructuresR
t django.utils.functionalR R> RN t south.loggerR t south.utils.py3R R R R% R( R0 t ExceptionR! R� R2 R3 R� ( ( ( s4 /usr/lib/python2.7/site-packages/south/db/generic.pyt <module> s:
� � � � A