'Test that table creation on mysql only builds InnoDB tables.'

def test_mysql_innodb(self):

    migration.db_sync(engine=self.migrate_engine)
    total = self.migrate_engine.execute("SELECT    count(*)    from    information_schema.TABLES    where    TABLE_SCHEMA='{0}'".format(self.migrate_engine.url.database))
    self.assertGreater(total.scalar(), 0, msg='No    tables    found.    Wrong    schema?')
    noninnodb = self.migrate_engine.execute("SELECT    count(*)    from    information_schema.TABLES    where    TABLE_SCHEMA='openstack_citest'    and    ENGINE!='InnoDB'    and    TABLE_NAME!='migrate_version'")
    count = noninnodb.scalar()
    self.assertEqual(count, 0, ('%d    non    InnoDB    tables    created' % count))
