def test_mysql_innodb_tables(self):
    test_utils.db_sync(engine=self.engine)
    total = self.engine.execute(("SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='%s'" % self.engine.url.database))
    self.assertGreater(total.scalar(), 0, 'No tables found. Wrong schema?')
    noninnodb = self.engine.execute(("SELECT count(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='%s' AND ENGINE!='InnoDB' AND TABLE_NAME!='migrate_version'" % self.engine.url.database))
    count = noninnodb.scalar()
    self.assertEqual(0, count, ('%d non InnoDB tables created' % count))
def test_mysql_innodb_tables(self):
    test_utils.db_sync(engine=self.engine)
    total = self.engine.execute(("SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='%s'" % self.engine.url.database))
    self.assertGreater(total.scalar(), 0, 'No tables found. Wrong schema?')
    noninnodb = self.engine.execute(("SELECT count(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA='%s' AND ENGINE!='InnoDB' AND TABLE_NAME!='migrate_version'" % self.engine.url.database))
    count = noninnodb.scalar()
    self.assertEqual(0, count, ('%d non InnoDB tables created' % count))