|
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 : /usr/lib/python2.7/site-packages/south/tests/ |
Upload File : |
�
�x�Rc @ s� d d l Z d d l m Z d d l m Z m Z d d l m Z m Z m Z
d d l m Z m
Z
m Z d d l m Z m Z g Z y! d d l m Z e j e � Wn e k
r� n Xe e � Z y d d l m Z e
e f Z Wn e k
r e
Z n Xy d d l m Z Wn e k
r.e Z n Xd
e j f d � � YZ d e j f d
� � YZ e r�d e f d � � YZ n d S( i����N( t filterwarnings( t dbt generic( t
connectiont modelst IntegrityError( t unittestt skipIft
skipUnless( t text_typet with_metaclass( t ProgrammingError( R ( t mysqlt TestOperationsc B s e Z d Z d � Z d � Z d � Z e e j d � d � � Z d � Z
d � Z d � Z e e j
d � 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 e j k d � d � � Z e d e j k d � d � � Z d � Z d � Z e e j! d � d � � Z" e e j d k d � d! � � Z# d" � Z$ d# � Z% d$ � Z& d% � Z' d& � Z( e e j d � d' � � Z) d( � Z* e e j! d � d) � � Z+ d* � Z, d+ � Z- d, � Z. d- � Z/ d. � Z0 RS(/ ss
Tests if the various DB abstraction calls work.
Can only test a limited amount due to DB differences.
c C sX t t _ y d d l } Wn t k
r, n Xt d d | j �t j � t j � d S( Ni����t ignoret category( t FalseR t debugt MySQLdbt ImportErrorR t Warningt clear_deferred_sqlt start_transaction( t selfR ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt setUp' s
c C s t j � d S( N( R t rollback_transaction( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt tearDown2 s c C s� t j � } | j t t j � | j t t j d � t j d d t j d t � f g � | j d � y | j d � Wn n X| j
d � d S( s*
Test creation of tables.
t test1t email_confirmedt defaults SELECT * FROM test1s SELECT * FROM nottheretest1s% Non-existent table could be selected!N( R t cursort assertRaisest TypeErrorR t create_tableR t BooleanFieldR t executet fail( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_create5 s %
s8 This database does not raise errors on missing defaults.c C sZ t j d d t j � f d t j d d � f g � t j � } | j t | j d � d S( sZ
Test creation of tables, make sure defaults are not left in the database
t test_create_defaultt at bR i s. INSERT INTO test_create_default(a) VALUES (17)N( R R! R t IntegerFieldR R R R R# ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR& I s c C sj t j � } t j d d t j d t � f g � t j d � y | j d � Wn n X| j d � d S( s*
Test deletion of tables.
t
test_deltableR R s SELECT * FROM test_deltables% Just-deleted table could be selected!N(
R R R R! R R" R t delete_tableR# R$ ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_deleteS s %
c C s, y t j d � Wn n X| j d � d S( s6
Test deletion of nonexistent tables.
t test_nonexistdeltables$ Non-existent table could be deleted!N( R R+ R$ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_nonexistent_deleteb s
c
C s� t j d d d d d d d d d t j d
g � } t j d d t j d d d t d
t � f g � t j d d t j d d d t d
t � f d t j | � f g � t j � d S( sL
Tests foreign key creation, especially uppercase (see #61)
t
model_namet Testt db_tablet test5at
db_tablespacet t
pk_field_namet IDt
pk_field_typet
pk_field_argst verbose_namet primary_keyt auto_createdt test5bt idt UNIQUEN( R t
mock_modelR t AutoFieldR! t Truet
ForeignKeyt execute_deferred_sql( R R0 ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_foreign_keysm s 1 !s> Foreign keys can only be deleted on engines that support them.c
C s� t j d d d d d d d d d t j d
g � } t j d d t j d t d t � f d
t j | � f g � t j � t j d d � d S( sT
Test that recursive foreign keys are deleted correctly (see #1065)
R/ R0 R1 t test_rec_fk_delR3 R4 R5 R= R7 R8 R: R; t fkt fk_idN( R R? R R@ R! RA RB RC t delete_foreign_key( R R0 ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt! test_recursive_foreign_key_delete{ s
c C s� t j � } t j d d t j d t � f g � | j d � t j d d d � | j d � t j � t j
� y | j d � Wn n X| j d � t j � t j
d � t j
� d S( s&
Test column renaming
t test_rnt spamR s SELECT spam FROM test_rnt eggss SELECT eggs FROM test_rns& Just-renamed column could be selected!N( R R R R! R R" R R# t
rename_columnt commit_transactionR R$ R R+ ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_rename� s %
c C s� t j � } t j d d t j d t � f g � | j d � t t _ t j
d d d � t t _ | j d � t j � t j � y | j d � Wn n X| j
d � t j � t j d � t j � d S( sn
Test column renaming while --dry-run is turned on (should do nothing)
See ticket #65
t test_drnRK R s SELECT spam FROM test_drnRL s SELECT eggs FROM test_drns) Dry-renamed new column could be selected!N( R R R R! R R" R R# RA t dry_runRM RN R R$ R R+ ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_dry_rename� s" %
c C s� t j � } t j d d t j d t � f g � | j d � t j d d � | j d � t j � t j
� y | j d � Wn n X| j d � t j � t j
d � t j
� d S( s&
Test column renaming
t testtrRK R s SELECT spam FROM testtrt testtr2s SELECT spam FROM testtr2s& Just-renamed column could be selected!N( R R R R! R R" R R# t rename_tableRN R R$ R R+ ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_table_rename� s %
c C sa y/ t j d d t j d d d d � f g � Wn t k
rO | j d � n Xt j d � d S( s>
Test that % in a default gets escaped to %%.
t testpindt cft
max_lengthi� R s It should be 2%!s) % was not properly escaped in column SQL.N( R R! R t CharFieldt
IndexErrorR$ R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_percents_in_defaults� s
/
c C s� t j d d t j d t � f d t j d t � f g � t j � t j d d g � t j d d d g � t j d d g � t j d d d g � t j
d k r� t j d d g � n t j d � d S( s+
Test the index operations
t test3t SELECTR RL t uniquet sqlite3N(
R R! R R" R R) RA RC t create_indext delete_indext backend_namet
delete_uniqueR+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt
test_index� s
c C s� t j d d t j d t � f d t j � f d t j d t � f g � t j � t j d � t j d d � t j d � t j d � t j d � d S(
s1
Test the primary key operations
t test_pkR= R: t new_pkeyRL R_ s9 INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)s9 INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)N(
R R! R R) RA RC t delete_primary_keyt create_primary_keyR# R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_primary_key� s
c C s� t j d d t j d t � f d t j � f d t j d t � f g � t j � t j d d t j � � t j d d t j d t � � t j d � t j d � t j d � d S(
sC
Tests that changing primary key implicitly fails.
t test_pkiR= R: Rg RL R_ s: INSERT INTO test_pki (id, new_pkey, eggs) VALUES (1, 2, 3)s: INSERT INTO test_pki (id, new_pkey, eggs) VALUES (2, 2, 4)N( R R! R R) RA RC t alter_columnR# R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_primary_key_implicit s
c C sH t j d d t j d t � f d t j � f g � t j d d t j d d � � t j d d d d
d d d
d d t j d g d i � } t j d t g � t j d d t j
| d t �� t j � t j d � d d } | j
| d � t j d d � t j d d t j d d d t d d � � t j � t j d � d S( s%
Test adding columns
t test_addcRK R RL t add1i R/ t UserR1 t auth_userR3 R4 R5 R= R7 R8 t pk_field_kwargss: INSERT INTO test_addc (spam, eggs, add1) VALUES (%s, 1, 2)t usert nulls SELECT user_id FROM test_addci t add2RY i t db_indext piN( R R! R R" R R) t
add_columnR? R@ R# RB RA RC t assertEqualst Nonet
delete_columnRZ R+ ( R Rp t val( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_add_columns s 9"
+
c C sT t j d d t j d t � f d t j d t d t � f g � t j d d � d S( s'
Test deleting columns
t test_delcRK R RL Rv R_ N( R R! R R" R R) RA R{ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_delete_columns/ s "c C s� t j d d t j d t � f d t j � f g � t j d d t j � � t j d d t j d t � � t j d t g � t j d � d d d
!\ } } } | j
| d � | j
| d � | j | t � t j d � d
S( s1
Test adding NullBoolean columns
t test_addnbcRK R RL Ro Ru s3 INSERT INTO test_addnbc (spam, eggs) VALUES (%s, 1)s& SELECT spam,add1,add2 FROM test_addnbci i s: Null boolean field with no value inserted returns non-nullsO Null boolean field (added with default) with no value inserted returns non-nullN(
R R! R R" R R) Rx t NullBooleanFieldRA R# t assertIsNoneRy R+ ( R t falset null1t null2( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_add_nullbool_column9 s #c C s| t j d d t j d t � f d t j � f g � t j � t j d d t j � � t j � t j d � t j � d S( s'
Test altering columns
t test_altercRK R RL N(
R R! R R" R R) RC Rl t
FloatFieldR+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_alter_columnsN s
c
C s+ t j d d t j d d � f d t j � f g � t j d d t j d d d d d t � � t j d � t j d
� d d } | j | d � t j d d t j d d d d d t � � d
t j
k rt j d � t j d � t j d
� d d } | j | d � n | j t t j d � d S( s@
Test altering column defaults with char fields
t test_altercdRK RY i RL R t loofRt s+ INSERT INTO test_altercd (eggs) values (12)s SELECT spam FROM test_altercdi s2 Default for char field was installed into databaset oracles DELETE FROM test_altercdN(
R R! R RZ R) Rl RA R# t assertFalseR Rc R R ( R Rt ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_alter_char_default] s +
+
R� s4 Oracle does not differentiate empty trings from nullc C s� t j d d t j d d d d � f d t j d d � f g � t j d � t j d d t j d d d d � � t j d
� d d } | j | d d � d
S( s@
Test altering column defaults with char fields
t
test_cd_emptyRK RY i R R4 RL s7 INSERT INTO test_cd_empty (spam, eggs) values ('1','2')t hams SELECT ham FROM test_cd_emptyi s/ Empty Default for char field isn't empty stringN( R R! R RZ R# Rx Ry ( R t empty( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_default_empty_string{ s
%c C s� t j d d t j d d d t � f d t j d d � f g � t j d d t j d d � � t j d d t j d d d t � � t j d � d S(
s�
Test that under Oracle, CherFields are created as null even when specified not-null,
because otherwise they would not be able to hold empty strings (which Oracle equates
with nulls).
Verify fix of #1269.
t test_ora_char_nullsRK RY i Rt RL R� s9 INSERT INTO test_ora_char_nulls VALUES (NULL, NULL, NULL)N( R R! R RZ RA Rx Rl R R# ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_oracle_strings_null� s %c C sd t j d d t j d t � f d t j � f g � t j d d t j d t � � t j d � d S( s@
Test MySQL default handling for BLOB and TEXT.
t
test_altermydRK R RL Rt N( R R! R R" R t TextFieldRl RA R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_mysql_defaults� s
c C s0 t j d d t j d t � f d t j d t � f d t j d t � f d t j d t � f g � t j d d t j d d t �� t j d d t j d t � � t j d d t j d t � � t j d k r t j
d � t j d d t j d
t � � t j
d � d d s t � n t j d � d
S( s�
Tests altering columns with multiple words in Postgres types (issue #125)
e.g. 'datetime with time zone', look at django/db/backends/postgresql/creation.py
t test_multiwordt col_datetimeRt t col_integert col_smallintt col_floatt floatt postgressK INSERT INTO test_multiword (col_datetime) VALUES ('2009-04-24 14:20:55+02')t auto_nowsB SELECT col_datetime = '2009-04-24 14:20:55+02' FROM test_multiwordi N(
R R! R t
DateTimeFieldRA t PositiveIntegerFieldt PositiveSmallIntegerFieldR� Rl Rc R# t AssertionErrorR+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt$ test_alter_column_postgres_multiword� s "
s9 Only applies to databases that support CHECK constraints.c C s� t j d d t j � f g � t j � t j d � t j d � t j � t j � y t j d � Wn t j � n X| j d � t j
d d t j � � t j � t j d � t j d � t j � d S( s~
Tests that going from a PostiveIntegerField to an IntegerField drops
the constraint on the database.
R� t nums( INSERT INTO test_alterc (num) VALUES (1)s( INSERT INTO test_alterc (num) VALUES (2)s) INSERT INTO test_alterc (num) VALUES (-3)s< Could insert a negative integer into a PositiveIntegerField.N(
R R! R R� RC R# RN R R R$ Rl R) R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_alter_constraints� s"
R` s( SQLite backend doesn't support this yet.c C s� t j d d t j d t � f g � t j d d t j d t � f d t j � f d t j t j d d � � f g � t j
� t j d d g � t j
� t t _ t j
d d g � t t _ t j
d d g � t j d d g � t j d
k rt j d � n t j d � t j d
� t j � t j � t f } t f } t j d | � t j d | � y t j d | � Wn t j � n X| j d � t j
d d g � t j d � t j d d g � t j � t j d | � t j d | � y t j d | � Wn t j � n X| j d � t j
d d g � t j d � t j d d d d g � t j � t j d | � t j d | � y t j d | � Wn t j � n X| j d � t j
d d d d g � t j � d S( s=
Tests creating/deleting unique constraints.
t test_unique2R= R: t test_uniqueRK R RL R� t Unique2t pyodbcs$ SET IDENTITY_INSERT test_unique2 ON;s( INSERT INTO test_unique2 (id) VALUES (1)s( INSERT INTO test_unique2 (id) VALUES (2)s> INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 0, 1)s> INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 1, 2)s> INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 2, 1)s Could insert non-unique item.s DELETE FROM test_uniques> INSERT INTO test_unique (spam, eggs, ham_id) VALUES (%s, 1, 1)t ham_ids Could insert non-unique pair.N( R R! R R@ RA R" R R) RB R? RC t
create_uniqueRQ Rd Rc R# RN R R R$ ( R t TRUEt FALSE( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� � sj %
c C s t j d d t j � f d t j d t � f g � t j � t j d � t j � t j � y t j d � Wn n X| j d � t j
� t j d d t j � � t j � y t j d � Wn n X| j d � t j
� t j d k r t j
d d g � n t j d � t j � t j d
d t j � f d t j � f g � t j d
d � t j � t j d � t j � t j � y t j d � Wn | j d
� n Xt j
� t j � y t j d � Wn | j d
� n Xt j
� t j � y t j d � Wn n X| j d � t j
� t j d
d t j � � t j � y t j d � Wn | j d � n Xt j
� t j � y t j d � Wn | j d � n Xt j
� t j � y t j d � Wn n X| j d � t j
� t j d
� t j � d S( s�
Tests that unique constraints are not affected when
altering columns (that's handled by create_/delete_unique)
t test_alter_uniqueRK RL R_ s9 INSERT INTO test_alter_unique (spam, eggs) VALUES (0, 42)s9 INSERT INTO test_alter_unique (spam, eggs) VALUES (1, 42)s8 Could insert the same integer twice into a unique field.s] Could insert the same integer twice into a unique field after alter_column with unique=False.R` t test_alter_unique2s: INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 42)s: INSERT INTO test_alter_unique2 (spam, eggs) VALUES (1, 42)sC Looks like multi-field unique constraint applied to only one field.s: INSERT INTO test_alter_unique2 (spam, eggs) VALUES (0, 43)s= Could insert the same pair twice into unique-together fields.s: Altering one column broken multi-column unique constraint.sb Could insert the same pair twice into unique-together fields after alter_column with unique=False.N( s spams eggs( R R! R R) RA RC R# RN R R$ R Rl Rc Rd R+ R� R� ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� 4 s�
c C sB t j d d t j d t � f g � t j d d t j � � d S( sT
Under PostgreSQL at least, capitalised constraints must be quoted.
t
test_capconstt SOMECOLR: N( R R! R R� RA Rl R) ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_capitalised_constraints� s c C s) t j d d t j d t � f g � d S( sC
MySQL cannot have blank defaults on TEXT columns.
t test_textdeft textcolt blankN( R R! R R� RA ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_text_default� s c C s� d } t j d d t j � f g � t j � t j d | g � t j d d t j d d � � t j � t j d � d d } | j | | d | | f � d
S( s[
On Oracle, you can't simply ALTER TABLE MODIFY a textfield to a charfield
t kawabangat test_text_to_charR� s) INSERT INTO test_text_to_char VALUES (%s)RY id s select * from test_text_to_chari s3 Change from text to char altered value [ %r != %r ]N( R R! R R� RC R# Rl RZ t assertEqual( R t valuet after( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� � s
c C s� d } t j d d t j d d � f g � t j � t j d | g � t j d d t j � � t j � t j d � d d } t | � } | j | | d | | f � d
S( sb
On Oracle, you can't simply ALTER TABLE MODIFY a charfield to a textfield either
t agnabawakt test_char_to_textR� RY id s) INSERT INTO test_char_to_text VALUES (%s)s select * from test_char_to_texti s3 Change from char to text altered value [ %r != %r ]N(
R R! R RZ RC R# Rl R� R R� ( R R� R� ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� � s
c C s� t j d d d d d d � } y d d l m } Wn t k
rE n; Xd d l m } t | d t � r� | j d
| j � } n t
j d d t j
d
t � f d t j d | � f d t j d
t � f g � t
j � t
j d | g � t
j d d t j d | � � t
j d d t j d | � � t
j � t
j � t
j � t
j d � d } | j t | � d � x | D] } | j | | � qxWt
j � xQ d d g D]C } t
j � d | } | j t t
j | | | g � t
j � q�Wt
j � d S( sS
Test that defaults are correctly not created for datetime columns
i� i i i i i����( t timezone( t settingst USE_TZt tzinfot test_datetime_deft col0Rt t col1R t col2sF INSERT INTO test_datetime_def (col0, col1, col2) values (null,%s,null)t col3s, select col1,col2,col3 from test_datetime_defi s col1,col2s col2,col3s= insert into test_datetime_def (col0,%s) values (null,%%s,%%s)N( t datetimet django.utilsR� R t django.confR� t getattrR t replacet utcR R! R R) RA R� RC R# Rl Rx RN R t failUnlessEqualt lenR R R ( R t end_of_worldR� R� t endst et colst statement( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_datetime_default� s@
c C s� t j d d t j d t � f g � t j d d t j t j d d � d t d t �� t j d d t j t j d d � d t �� t j
� t j d � d
S( sN
Test adding a ForeignKey with unique=True or a OneToOneField
t test_add_unique_fkRK R t mock1Rp Rq Rt R_ t mock2N( R R! R R" R Rx RB R? RA t
OneToOneFieldRC R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� � s 4.
c C s& t j d d t j � f g � t j � t j � t j � y t j d � Wn n X| j d � t j � t j
d d t j � � t j � t j d � t j d � t j
d d t j � � t j � t j � y t j d � Wn n X| j d � t j � t j d � t j � d S( st
Tests that the value constraint of PositiveIntegerField is enforced on
the database level.
t test_column_constraintRK s/ INSERT INTO test_column_constraint VALUES (-42)s: Could insert a negative value into a PositiveIntegerField.s" DELETE FROM test_column_constraintsW Could insert a negative value after changing an IntegerField to a PositiveIntegerField.N(
R R! R R� RC RN R R# R$ R Rl R) R+ ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� s4
c s� d t t j t j � f � f d � � Y� t j r: d p= d } t j d d � d f t j d t � d | f t j d d � d
f � d d d d
d g � d f f } xO | D]G \ } } t j d d | � } | | k r� | j
d | | f � q� q� Wd S( s�
Test that sql default value is correct for non-string field types.
Datetimes are handled in test_datetime_default.
t CustomFieldc s/ e Z d Z � f d � Z d � Z d � Z RS( R� c s? | j � r, t | j � r% | j � S| j St � | � j � S( N( t has_defaultt callableR t supert get_default( R ( R� ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� 9 s
c S s | s
| Sd j t t | � � S( Nt ,( t joint mapt str( R R� ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt get_prep_value? s c S s6 | s t | t � r | St t t | j d � � � S( NR� ( t
isinstancet listR� t intt split( R R� ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt to_pythonC s ( t __name__t
__module__t descriptionR� R� R� ( ( R� ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR� 7 s R t 0R t sukasukas DEFAULT 'sukasukas
DEFAULT %si* s
DEFAULT 42i� i� i� i� s DEFAULT '2012,2018,2021,2036t fisht YAAAAAAZsE default sql value was not properly generated for field %r.
Sql was %sN( R
R t SubfieldBaseRZ R t has_booleansR" R R) t
column_sqlR$ ( R t false_valuet defaultst fieldt sql_test_strt sql( ( R� s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_sql_defaults1 s +$ c C s� t j d d d d d d d d d t j d
g d i � } t j d d
t j � f g � t j � t j d d t j | d t �� t j � t j
d d t j | � � t j � d S( NR/ Rp R1 Rq R3 R4 R5 R= R7 R8 Rr t test_fkRL t foreikRt t foreik_id( R R? R R@ R! R) RC Rx RB RA Rl ( R Rp ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt$ test_make_added_foreign_key_not_nullT s 9
"
c C s� t j d d d d d d d d d t j d
g d i � } t j d d
t j � f d t j | � f g � t j � t j d d t j | d t �� t j � d S( NR/ Rp R1 Rq R3 R4 R5 R= R7 R8 Rr t test_make_fk_nullRL R� R� Rt (
R R? R R@ R! R) RB RC Rl RA ( R Rp ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_make_foreign_key_nulle s 9
"c C sr t j d d d d d d d d d t j d
g d i � } t j d d
t j d t � f g � t j d d d d d d d d
d t j d
g d i � } t j d d t j | d t �f g � t j � t j d d t j | d t �� t j � y t j
d � d d d } Wn t t f k
r3d } n Xt j
d | g � t j
d | g � t j
� t j � d S( NR/ Rp R1 Rq R3 R4 R5 R= R7 R8 Rr t test_fk_changed_targetRL R: t Eggt test_fk_changingt eggRt t egg_ids SELECT MAX(id) FROM auth_useri i i s5 INSERT INTO test_fk_changed_target (eggs) VALUES (%s)s1 INSERT INTO test_fk_changing (egg_id) VALUES (%s)( R R? R R@ R! R) RA RB RC Rl R# R R[ RN R ( R Rp R t non_user_id( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_change_foreign_key_targets s" 9 9
"
c C s� t j d d d d d d d d d t j d
g d i � } t j d d
t j � f d t j | � f g � t j d d
d g � t j � t j d d t j | d t
�� t j � d S( NR/ Rp R1 Rq R3 R4 R5 R= R7 R8 Rr t
test_2indexedRL R� R� Rt ( R R? R R@ R! R) RB R� RC Rl RA ( R Rp ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_alter_double_indexed_column� s 9
"(1 R� R� t __doc__R R R% R R t raises_default_errorsR& R, R. RD t supports_foreign_keysRI RO RR RV R\ Re Rj Rm R} R R� R� R� R Rc R� R� R� R� t has_check_constraintsR� R� R� R� R� R� R� R� R� R� R� R� R� R R ( ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR
sP
!! !!N a
/ . # t TestCacheGenericc B s5 e Z e j Z d � Z d � Z d � Z d � Z RS( c C s& d | j f d � � Y} | | _ d S( Nt CacheOpsc B st e Z d � Z d � Z e j d � � Z e j d � � Z e j d � � Z
e j e j d � � � Z d � Z RS( c S s& i | _ d | _ i d d 6| _ d S( Ni R t NAME( t _constraint_cachet cache_filledR� ( R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt __init__� s c S s= | j d 7_ | j j | i � | j | j | i � d S( Ni ( R R t
setdefault( R R t table( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt _fill_constraint_cache� s c S s d S( N( ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt clear_con� s c S s d S( N( ( R R t
column_oldt
column_new( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt cp_column� s c S s d S( N( ( R R t column( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt rm_column� s c S s d S( N( ( R R R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt mv_column� s c S s | j | S( N( R� ( R t attr( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt _get_setting� s (
R� R� R R R t invalidate_table_constraintsR t copy_column_constraintsR t delete_column_constraintsR R R ( ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR � s ( t base_ops_clsR ( R R ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR � s c C sP | j � } | j d | j � | j | j d d � � | j d | j � | j | j d d � � | j d | j � | j d � | j d | j � | j | j d d � � | j d | j � | j | j d d d � � | j d | j � | j } d | d d d <| j d | j d d d � � | j d g | j d d � � | j d | j � | j d � | j d | j d d d � � | j d | j � | j | j d d � � | j d | j � d | d d d <| j d | j d d d � � | j d d � | j g | j d d d � � | j g | j d d d
� � d | d d d <| j d | j d d d � � | j d d d � | j d | j d d d � � | j d | j d d d � � d | d d d <| j d | j d d d � � | j d d d � | j d | j d d d � � | j g | j d d d � � d S(
Ni R R i i R t
constraintt new_tablei t noexist_columnR ( s columnR# (
R R� R R� t lookup_constraintR R R R R ( R t opst cache( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt
test_cache� sJ
c C s | j � } | j | j d d � � | j | j d d � � | j d � | j | j d d � � | j d d � | j | j d d � � | j d d � | j | j d d � � | j d d d � | j | j d d � � | j d � | j | j d d � � d S( NR R R ( R R� t _is_valid_cacheR R R& t
assertTrue( R R' ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt
test_valid� s
c C s | j � } | j | j d d � � | j | j d d � � | j d d � | j | j d d � � | j | j d d � � | j d d � | j | j d d � � | j | j d d � � | j d � | j | j d d � � | j | j d d � � d S( NR R t other_table( R R� R* R& R+ R ( R R' ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt test_valid_implementation s
( R� R� R t DatabaseOperationsR" R R) R, R. ( ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR
� s
! 1 t TestCacheMysqlc B s e Z e j Z d � Z RS( c C s | j � } | j | j d d � � | j | j d d � � | j d d � | j | j d d � � | j | j d d � � | j d d � | j | j d d � � | j | j d d � � | j d � | j | j d d � � | j | j d d � � d S( NR R R- ( R R� R* R& R+ R ( R R' ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR. s
( R� R� R R/ R" R. ( ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyR0 s ( R� t warningsR t south.dbR R t django.dbR R R t DjangoIntegrityErrort south.testsR R R t south.utils.py3R R
t errorst psycopg2R t appendR t tuplet sql_server.pyodbc.baset SQLServerIntegrityErrorR Rz t TestCaseR
R
R0 ( ( ( s2 /usr/lib/python2.7/site-packages/south/tests/db.pyt <module> s8
� � � �u