;
Οβ"Ic               @   s\   d  d l  Z  d  d l Z Gd   d e  j  Z d   Z d   Z e d k o e   n d S(   i    Nc             B   s)   |  Ee  Z d    Z d   Z d   Z d S(   c             C   s(   t  j d  |  _ |  j j   |  _ d  S(   Nu   :memory:(   u   sqliteu   connectu   cxu   cursoru   cu(   u   self(    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu   setUp   s    c             C   s   |  j  j   d  S(   N(   u   cxu   close(   u   self(    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu   tearDown   s    c                s   d d d d d d g    f d    D   j  j   } d   | D  d	 g  d
 g      f d   t t    D d  S(   Nu   CREATE TABLE t1(id integer primary key, s1 text, t1_i1 integer not null, i2 integer, unique (s1), constraint t1_idx1 unique (i2));u'   INSERT INTO "t1" VALUES(1,'foo',10,20);u(   INSERT INTO "t1" VALUES(2,'foo2',30,30);ut   CREATE TABLE t2(id integer, t2_i1 integer, t2_i2 integer, primary key (id),foreign key(t2_i1) references t1(t1_i1));ur   CREATE TRIGGER trigger_1 update of t1_i1 on t1 begin update t2 set t2_i1 = new.t1_i1 where t2_i1 = old.t1_i1; end;u;   CREATE VIEW v1 as select * from t1 left join t2 using (id);c                s'   g  } |  ] } |   j  j |  q
 S(    (   u   cuu   execute(   u   .0u   _[1]u   s(   u   self(    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu
   <listcomp>$   s    c             S   s   g  } |  ] } | | q
 S(    (    (   u   .0u   _[1]u   s(    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu
   <listcomp>&   s    u   BEGIN TRANSACTION;u   COMMIT;c                s/   g  } |  ]! } |   j   |  |  q
 S(    (   u   assertEqual(   u   .0u   _[1]u   i(   u   selfu   actual_sqlsu   expected_sqls(    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu
   <listcomp>)   s   (   u   cxu   iterdumpu   rangeu   len(   u   selfu   i(    (   u   selfu   actual_sqlsu   expected_sqlsu.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu   CheckTableDump   s    	

N(   u   __name__u
   __module__u   setUpu   tearDownu   CheckTableDump(   u
   __locals__(    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu	   DumpTests   s   
		u	   DumpTestsc               C   s   t  j t  j t d   S(   Nu   Check(   u   unittestu	   TestSuiteu	   makeSuiteu	   DumpTests(    (    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu   suite,   s    c              C   s    t  j   }  |  j t    d  S(   N(   u   unittestu   TextTestRunneru   runu   suite(   u   runner(    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu   test/   s    u   __main__(   u   unittestu   sqlite3u   sqliteu   TestCaseu	   DumpTestsu   suiteu   testu   __name__(    (    (    u.   /mit/python/lib/python3.0/sqlite3/test/dump.pyu   <module>   s   &		