code: def test_table_dump(self):
      expected_sqls = [
          """CREATE TABLE "index"("index" blob);""",
          """INSERT INTO "index" VALUES(X'01');""",
          """CREATE TABLE "quoted""table"("quoted""field" text);""",
          """INSERT INTO "quoted""table" VALUES('quoted''value');""",
          "CREATE TABLE t1(id integer primary key, s1 text, "
          "t1_i1 integer not null, i2 integer, unique (s1), "
          "constraint t1_idx1 unique (i2), "
          "constraint t1_i1_idx1 unique (t1_i1));",
          "INSERT INTO \"t1\" VALUES(1,'foo',10,20);",
          "INSERT INTO \"t1\" VALUES(2,'foo2',30,30);",
          "CREATE TABLE t2(id integer, t2_i1 integer, "
          "t2_i2 integer, primary key (id),"
          "foreign key(t2_i1) references t1(t1_i1));",
          # Foreign key violation.
          'INSERT INTO "t2" VALUES(1,2,3);',
          "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;",
          "CREATE VIEW v1 as select * from t1 left join t2 "
          "using (id);",
      ]
      [self.cu.execute(s) for s in expected_sqls]
      i = self.cx.iterdump()
      actual_sqls = [s for s in i]
      expected_sqls = [
          "PRAGMA foreign_keys=OFF;",
          "BEGIN TRANSACTION;",
          *expected_sqls,
          "COMMIT;",
      ]
      [
          self.assertEqual(expected_sqls[i], actual_sqls[i])
          for i in range(len(expected_sqls))
      ]
  
file_path: cpython/Lib/test/test_sqlite3/test_dump.py
imports: import unittest
  from .util import memory_database
  from .util import MemoryDatabaseMixin
label_desc: Use image node_id 1 for calling the DumpTests obj's underlying member method code with example usage: obj.test_table_dump() without return types