def test_skip_tables_use_several_values(self): self.engine.execute("CREATE TABLE some_table_1 " "(i INT) ENGINE=MEMORY") self.engine.execute("CREATE TABLE some_table_2 " "(i INT) ENGINE=MEMORY") self.assertEqual([], utils.get_non_innodb_tables( self.engine, skip_tables=('some_table_1', 'some_table_2')))
def test_ndb_disabled(self): self.init_db(False) self.assertFalse(ndb.ndb_status(self.engine)) self.assertIsInstance(self.test_table.c.test1.type, String) self.assertEqual(255, self.test_table.c.test1.type.length) self.assertIsInstance(self.test_table.c.test2.type, String) self.assertEqual(4096, self.test_table.c.test2.type.length) self.assertIsInstance(self.test_table.c.test3.type, String) self.assertEqual(255, self.test_table.c.test3.type.length) self.assertEqual([], utils.get_non_innodb_tables(self.engine))
def test_skip_tables_use_empty_list(self): self.engine.execute("CREATE TABLE some_table_3 " "(i INT) ENGINE=MEMORY") self.assertEqual(['some_table_3'], utils.get_non_innodb_tables( self.engine, skip_tables=()))
def test_skip_tables_use_passed_value(self): self.engine.execute("CREATE TABLE some_table " "(i INT) ENGINE=MEMORY") self.assertEqual([], utils.get_non_innodb_tables( self.engine, skip_tables=('some_table',)))
def test_skip_tables_use_default_value(self): self.engine.execute("CREATE TABLE migrate_version " "(i INT) ENGINE=MEMORY") self.assertEqual([], utils.get_non_innodb_tables(self.engine))
def test_all_tables_use_innodb_false(self): self.engine.execute("CREATE TABLE employee " "(i INT) ENGINE=MEMORY") self.assertEqual(['employee'], utils.get_non_innodb_tables(self.engine))
def test_all_tables_use_innodb(self): self.engine.execute("CREATE TABLE customers " "(a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB") self.assertEqual([], utils.get_non_innodb_tables(self.engine))