Ñò
ÍDÀLc           @   s_   d  d k  Z  d  d k Z d e  i f d „  ƒ  YZ d „  Z d „  Z e d j o e ƒ  n d S(   iÿÿÿÿNt	   DumpTestsc           B   s#   e  Z d  „  Z d „  Z d „  Z RS(   c         C   s(   t  i d ƒ |  _ |  i i ƒ  |  _ d  S(   Ns   :memory:(   t   sqlitet   connectt   cxt   cursort   cu(   t   self(    (    s'   scripts/common/Lib/sqlite3/test/dump.pyt   setUp   s    c         C   s   |  i  i ƒ  d  S(   N(   R   t   close(   R   (    (    s'   scripts/common/Lib/sqlite3/test/dump.pyt   tearDown   s    c         C   sÊ   d d d d d d g } g  } | D] } | |  i  i | ƒ q# ~ |  i i ƒ  } g  } | D] } | | q] ~ } d g | d g } g  } t t | ƒ ƒ D]! } | |  i | | | | ƒ qž ~ d  S(	   Ns‚   CREATE TABLE t1(id integer primary key, s1 text, t1_i1 integer not null, i2 integer, unique (s1), constraint t1_idx1 unique (i2));s'   INSERT INTO "t1" VALUES(1,'foo',10,20);s(   INSERT INTO "t1" VALUES(2,'foo2',30,30);st   CREATE TABLE t2(id integer, t2_i1 integer, t2_i2 integer, primary key (id),foreign key(t2_i1) references t1(t1_i1));sr   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;s;   CREATE VIEW v1 as select * from t1 left join t2 using (id);s   BEGIN TRANSACTION;s   COMMIT;(   R   t   executeR   t   iterdumpt   xranget   lent   assertEqual(   R   t   expected_sqlst   _[1]t   st   it   _[2]t   actual_sqlst   _[3](    (    s'   scripts/common/Lib/sqlite3/test/dump.pyt   CheckTableDump   s    	+!

(   t   __name__t
   __module__R   R	   R   (    (    (    s'   scripts/common/Lib/sqlite3/test/dump.pyR       s   		c           C   s   t  i t  i t d ƒ ƒ S(   Nt   Check(   t   unittestt	   TestSuitet	   makeSuiteR    (    (    (    s'   scripts/common/Lib/sqlite3/test/dump.pyt   suite,   s    c          C   s    t  i ƒ  }  |  i t ƒ  ƒ d  S(   N(   R   t   TextTestRunnert   runR   (   t   runner(    (    s'   scripts/common/Lib/sqlite3/test/dump.pyt   test/   s    t   __main__(   R   t   sqlite3R   t   TestCaseR    R   R!   R   (    (    (    s'   scripts/common/Lib/sqlite3/test/dump.pyt   <module>   s   &		