本文整理汇总了Python中mysqlapi.api.models.DatabaseManager.drop_database方法的典型用法代码示例。如果您正苦于以下问题：Python DatabaseManager.drop_database方法的具体用法？Python DatabaseManager.drop_database怎么用？Python DatabaseManager.drop_database使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysqlapi.api.models.DatabaseManager的用法示例。
在下文中一共展示了DatabaseManager.drop_database方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_drop
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import drop_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 drop_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 drop_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: delete
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import drop_database [as 别名]
def delete(self, request, name, *args, **kwargs):
try:
instance = Instance.objects.get(name=name)
except Instance.DoesNotExist:
return HttpResponse("Can't drop database 'doesnotexists'; database doesn't exist", status=500)
self._client.terminate(instance)
instance.delete()
host = _get_service_host(request.GET)
db = DatabaseManager(name, host)
try:
db.drop_database()
except Exception, e:
return HttpResponse(e[1], status=500)示例5: test_create_database
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import drop_database [as 别名]
def test_create_database(self):
try:
request = RequestFactory().post("/", {"name": "ciclops"})
view = CreateDatabase()
view._client = mocks.FakeEC2Client()
response = view.post(request)
self.assertEqual(201, response.status_code)
self.assertEqual("ok", response.content)
time.sleep(0.5)
self.cursor.execute("select SCHEMA_NAME from information_schema.SCHEMATA where SCHEMA_NAME = 'ciclops'")
row = self.cursor.fetchone()
self.assertEqual("ciclops", row[0])
finally:
db = DatabaseManager("ciclops")
db.drop_database()示例6: test_export
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import drop_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")示例7: test_export_from_a_custom_service_host
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import drop_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")示例8: test_create_database_ec2
# 需要导入模块: from mysqlapi.api.models import DatabaseManager [as 别名]
# 或者: from mysqlapi.api.models.DatabaseManager import drop_database [as 别名]
def test_create_database_ec2(self):
try:
client = mocks.FakeEC2Client()
t = start_creator(DatabaseManager, client)
request = RequestFactory().post("/", {"name": "ciclops"})
view = CreateDatabase()
view._client = client
response = view.post(request)
self.assertEqual(201, response.status_code)
self.assertEqual("", response.content)
t.stop()
sql = "select SCHEMA_NAME from information_schema.SCHEMATA " + \
"where SCHEMA_NAME = 'ciclops'"
self.cursor.execute(sql)
row = self.cursor.fetchone()
self.assertEqual("ciclops", row[0])
finally:
db = DatabaseManager("ciclops")
db.drop_database()