def create_database(self, databases):
"""Create the list of specified databases."""
with self.local_sql_client(self.mysql_app.get_engine()) as client:
for item in databases:
mydb = models.MySQLSchema.deserialize(item)
mydb.check_create()
cd = sql_query.CreateDatabase(mydb.name, mydb.character_set,
mydb.collate)
t = text(str(cd))
client.execute(t)
def create_database(self, databases):
"""Create the list of specified databases."""
with LocalSqlClient(get_engine()) as client:
for item in databases:
mydb = models.ValidatedMySQLDatabase()
mydb.deserialize(item)
cd = sql_query.CreateDatabase(mydb.name, mydb.character_set,
mydb.collate)
t = text(str(cd))
client.execute(t)
def create_databases(self, databases):
"""Create the list of specified databases."""
with mysql_util.SqlClient(self.mysql_app.get_engine()) as client:
for item in databases:
mydb = models.MySQLSchema.deserialize(item)
mydb.check_create()
cd = sql_query.CreateDatabase(mydb.name, mydb.character_set,
mydb.collate)
t = text(str(cd))
LOG.debug('Creating database, command: %s', str(cd))
client.execute(t)
def test_collate(self):
cd = sql_query.CreateDatabase('foo')
cd.collate = "bar"
self.assertEqual(("CREATE DATABASE IF NOT EXISTS `foo` "
"COLLATE = 'bar';"), str(cd))
def test_charset(self):
cd = sql_query.CreateDatabase('foo')
cd.charset = "foo"
self.assertEqual(("CREATE DATABASE IF NOT EXISTS `foo` "
"CHARACTER SET = 'foo';"), str(cd))
def test_defaults(self):
cd = sql_query.CreateDatabase('foo')
self.assertEqual("CREATE DATABASE IF NOT EXISTS `foo`;", str(cd))
