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( ( sY /tmp/ndk-User/buildhost/install/prebuilt/darwin-x86_64/lib/python2.7/sqlite3/test/dump.pyt CheckTableDump s$ #
|
