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))