def test_drop(self):
self.create_ciclops()
request = RequestFactory().delete("/ciclops")
self.fake = mocks.FakeEC2Client()
view = DropDatabase()
view._client = self.fake
response = view.delete(request, "ciclops")
self.assertEqual(200, response.status_code)
with self.assertRaises(Instance.DoesNotExist):
Instance.objects.get(name="ciclops")
def test_should_unauthorize_ec2_instance_before_terminate_it(self):
self.create_ciclops()
fake = mocks.FakeEC2Client()
view = DropDatabase()
view._client = fake
request = RequestFactory().delete("/ciclops")
resp = view.delete(request, "ciclops")
self.assertEqual(200, resp.status_code)
actions = [u"unauthorize instance ciclops",
u"terminate instance ciclops"]
self.assertEqual(actions, fake.actions)
def test_drop_database_with_shared_server(self):
settings.SHARED_SERVER = "127.0.0.1"
self.create_fandango_shared()
view = DropDatabase()
request = RequestFactory().delete("/fandango")
resp = view.delete(request, "fandango")
self.assertEqual(200, resp.status_code)
sql = "select SCHEMA_NAME from information_schema.SCHEMATA " +\
"where SCHEMA_NAME = 'fandango'"
self.cursor.execute(sql)
row = self.cursor.fetchone()
self.assertIsNone(row)
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)
def test_drop_database_from_pool(self):
instance = Instance(name="presto")
pi = ProvisionedInstance.objects.create(host="127.0.0.1",
port=3306,
admin_user="******")
self.addCleanup(pi.delete)
pi.alloc(instance)
self.addCleanup(instance.delete)
view = DropDatabase()
request = RequestFactory().delete("/presto")
resp = view.delete(request, "presto")
self.assertEqual(200, resp.status_code)
sql = "select SCHEMA_NAME from information_schema.SCHEMATA " +\
"where SCHEMA_NAME = 'presto'"
self.cursor.execute(sql)
row = self.cursor.fetchone()
self.assertIsNone(row)
pi = ProvisionedInstance.objects.get(pk=pi.pk)
self.assertEqual(None, pi.instance)
def test_drop_returns_404_and_error_msg_when_instance_does_not_exist(self):
request = RequestFactory().delete("/")
response = DropDatabase().delete(request, name="doesnotexists")
self.assertEqual(404, response.status_code)
msg = "Can't drop database 'doesnotexists'; database doesn't exist"
self.assertEqual(msg, response.content)
