Original file line numberDiff line numberDiff line change@@ -20,7 +20,8 @@ def test_table_dump(self):
2020 ,
2121"CREATE TABLE t1(id integer primary key, s1 text, " \
2222"t1_i1 integer not null, i2 integer, unique (s1), " \
23-"constraint t1_idx1 unique (i2));"
23+"constraint t1_idx1 unique (i2), " \
24+"constraint t1_i1_idx1 unique (t1_i1));"
2425 ,
2526"INSERT INTO \"t1\" VALUES(1,'foo',10,20);"
2627 ,
@@ -30,6 +31,9 @@ def test_table_dump(self):
3031"t2_i2 integer, primary key (id)," \
3132"foreign key(t2_i1) references t1(t1_i1));"
3233 ,
34+# Foreign key violation.
35+"INSERT INTO \"t2\" VALUES(1,2,3);"
36+ ,
3337"CREATE TRIGGER trigger_1 update of t1_i1 on t1 " \
3438"begin " \
3539"update t2 set t2_i1 = new.t1_i1 where t2_i1 = old.t1_i1; " \
@@ -41,8 +45,12 @@ def test_table_dump(self):
4145 [self.cu.execute(s) forsinexpected_sqls]
4246i=self.cx.iterdump()
4347actual_sqls= [sforsini]
44-expected_sqls= ['BEGIN TRANSACTION;'] +expected_sqls+ \
45- ['COMMIT;']
48+expected_sqls= [
49+"PRAGMA foreign_keys=OFF;",
50+"BEGIN TRANSACTION;",
51+*expected_sqls,
52+"COMMIT;",
53+ ]
4654 [self.assertEqual(expected_sqls[i], actual_sqls[i])
4755foriinrange(len(expected_sqls))]
4856