本文整理汇总了Python中mysqlapi.api.models.DatabaseManager.create_database方法的典型用法代码示例。如果您正苦于以下问题：Python DatabaseManager.create_database方法的具体用法？Python DatabaseManager.create_database怎么用？Python DatabaseManager.create_database使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysqlapi.api.models.DatabaseManager的用法示例。
在下文中一共展示了DatabaseManager.create_database方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_drop
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def test_drop(self):
db = DatabaseManager("otherdatabase")
db.create_database()
db.drop_database()
self.cursor.execute("select SCHEMA_NAME from information_schema.SCHEMATA where SCHEMA_NAME = 'otherdatabase'")
row = self.cursor.fetchone()
self.assertFalse(row)示例2: test_create
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def test_create(self):
db = DatabaseManager("newdatabase")
db.create_database()
self.cursor.execute("select SCHEMA_NAME from information_schema.SCHEMATA where SCHEMA_NAME = 'newdatabase'")
row = self.cursor.fetchone()
self.assertEqual("newdatabase", row[0])
db.drop_database()示例3: test_create_database_with_custom_hostname
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def test_create_database_with_custom_hostname(self):
db = DatabaseManager("newdatabase", host="127.0.0.1")
db.create_database()
sql = "select SCHEMA_NAME from information_schema.SCHEMATA " +\
"where SCHEMA_NAME = 'newdatabase'"
self.cursor.execute(sql)
row = self.cursor.fetchone()
self.assertEqual("newdatabase", row[0])
db.drop_database()示例4: test_export
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def test_export(self):
db = DatabaseManager("magneto")
db.create_database()
db.create_user("magneto", "localhost")
self.cursor.execute("create table magneto.foo ( test varchar(255) );")
expected = """/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `foo` (
`test` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
"""
result = db.export()
self.assertEqual(expected, result.replace("InnoDB", "MyISAM"))
db.drop_database()
db.drop_user("magneto", "localhost")示例5: test_drop_database_that_needs_name_canonicalization
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def test_drop_database_that_needs_name_canonicalization(self):
settings.SHARED_SERVER = "127.0.0.1"
canonical_name = canonicalize_db_name("xu-xu")
Instance.objects.create(name=canonical_name, shared=True)
db = DatabaseManager("xu-xu", settings.SHARED_SERVER)
db.create_database()
view = DropDatabase()
request = RequestFactory().delete("/xu-xu")
resp = view.delete(request, "xu-xu")
self.assertEqual(200, resp.status_code)
sql = "select SCHEMA_NAME from information_schema.SCHEMATA " +\
"where SCHEMA_NAME = '{0}'"
self.cursor.execute(sql.format(canonical_name))
row = self.cursor.fetchone()
self.assertIsNone(row)示例6: test_export_from_a_custom_service_host
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def test_export_from_a_custom_service_host(self):
db = DatabaseManager("magneto", host="127.0.0.1")
db.create_database()
db.create_user("magneto", "localhost")
self.cursor.execute("create table magneto.foo ( test varchar(255) );")
expected = """/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `foo` (
`test` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
"""
request = RequestFactory().get("/", {"service_host": "127.0.0.1"})
result = export(request, "magneto")
self.assertEqual(200, result.status_code)
self.assertEqual(expected, result.content.replace("InnoDB", "MyISAM"))
db.drop_database()
db.drop_user("magneto", "localhost")示例7: create_ciclops
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def create_ciclops(self):
Instance.objects.create(name="ciclops")
db = DatabaseManager("ciclops", "127.0.0.1")
db.create_database()示例8: create_fandango_shared
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import create_database [as 别名]
def create_fandango_shared(self):
Instance.objects.create(name="fandango", shared=True)
db = DatabaseManager("fandango", settings.SHARED_SERVER)
db.create_database()