Lines Matching refs:self
9 def setUp(self):
10 self.cx = sqlite.connect(":memory:")
11 self.cu = self.cx.cursor()
13 def tearDown(self):
14 self.cx.close()
16 def test_table_dump(self):
46 [self.cu.execute(s) for s in expected_sqls]
47 i = self.cx.iterdump()
51 [self.assertEqual(expected_sqls[i], actual_sqls[i])
54 def test_dump_autoincrement(self):
60 self.cu.executescript("".join(expected))
71 actual = [stmt for stmt in self.cx.iterdump()]
72 self.assertEqual(expected, actual)
74 def test_dump_autoincrement_create_new_db(self):
75 self.cu.execute("BEGIN TRANSACTION")
76 self.cu.execute("CREATE TABLE t1 (id integer primary key autoincrement)")
77 self.cu.execute("CREATE TABLE t2 (id integer primary key autoincrement)")
78 self.cu.executemany("INSERT INTO t1 VALUES(?)", ((None,) for _ in range(9)))
79 self.cu.executemany("INSERT INTO t2 VALUES(?)", ((None,) for _ in range(4)))
80 self.cx.commit()
83 query = "".join(self.cx.iterdump())
92 with self.subTest(table=table, seq=seq):
97 self.assertEqual(rows[0][0], seq)
99 def test_unorderable_row(self):
102 def __init__(self, cursor, row):
103 self.row = row
104 def __getitem__(self, index):
105 return self.row[index]
106 self.cx.row_factory = UnorderableRow
115 self.cu.execute(CREATE_BETA)
116 self.cu.execute(CREATE_ALPHA)
117 got = list(self.cx.iterdump())
118 self.assertEqual(expected, got)