Esempio n. 1
0
 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')))
Esempio n. 2
0
 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')))
Esempio n. 3
0
 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))
Esempio n. 4
0
 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))
Esempio n. 5
0
 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=()))
Esempio n. 6
0
 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',)))
Esempio n. 7
0
 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))
Esempio n. 8
0
 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))
Esempio n. 9
0
 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))
Esempio n. 10
0
 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=()))
Esempio n. 11
0
 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',)))
Esempio n. 12
0
 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))
Esempio n. 13
0
 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))
Esempio n. 14
0
 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))