ó
¦xxTc           @   s]   d  d l  Z  d  d l Z d e  j f d „  ƒ  YZ d „  Z d „  Z e d k rY e ƒ  n  d S(   iÿÿÿÿNt	   DumpTestsc           B   s,   e  Z d  „  Z d „  Z d „  Z d „  Z RS(   c         C   s(   t  j d ƒ |  _ |  j j ƒ  |  _ d  S(   Ns   :memory:(   t   sqlitet   connectt   cxt   cursort   cu(   t   self(    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   setUp   s    c         C   s   |  j  j ƒ  d  S(   N(   R   t   close(   R   (    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   tearDown   s    c         C   sÁ   d d d d d d d d d	 d
 d g } g  | D] } |  j  j | ƒ ^ q. |  j j ƒ  } g  | D] } | ^ q` } d g | d g } g  t t | ƒ ƒ D]  } |  j | | | | ƒ ^ q™ d  S(   Ns#   CREATE TABLE "index"("index" blob);s"   INSERT INTO "index" VALUES(X'01');s3   CREATE TABLE "quoted""table"("quoted""field" text);s4   INSERT INTO "quoted""table" VALUES('quoted''value');s‚   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);u)   INSERT INTO "t1" VALUES(3,'fÃƒÂ¶',40,10);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   st   it   actual_sqls(    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   CheckTableDump   s$    	#

c         C   s†   d d d „  ƒ  Y} | |  j  _ d } d } d | | d g } |  j j | ƒ |  j j | ƒ t |  j  j ƒ  ƒ } |  j | | ƒ d  S(   Nt   UnorderableRowc           B   s   e  Z d  „  Z d „  Z RS(   c         S   s   | |  _  d  S(   N(   t   row(   R   R   R   (    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   __init__9   s    c         S   s   |  j  | S(   N(   R   (   R   t   index(    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   __getitem__;   s    (   t   __name__t
   __module__R   R   (    (    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyR   8   s   	s   CREATE TABLE "alpha" ("one");s   CREATE TABLE "beta" ("two");s   BEGIN TRANSACTION;s   COMMIT;(    (   R   t   row_factoryR   R
   t   listR   R   (   R   R   t   CREATE_ALPHAt   CREATE_BETAt   expectedt   got(    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   CheckUnorderableRow6   s    	(   R   R   R   R	   R   R!   (    (    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyR       s   			(c           C   s   t  j t  j t d ƒ ƒ S(   Nt   Check(   t   unittestt	   TestSuitet	   makeSuiteR    (    (    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   suiteK   s    c          C   s    t  j ƒ  }  |  j t ƒ  ƒ d  S(   N(   R#   t   TextTestRunnert   runR&   (   t   runner(    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   testN   s    t   __main__(   R#   t   sqlite3R   t   TestCaseR    R&   R*   R   (    (    (    s=   /opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/dump.pyt   <module>   s   E		