def delete(self, name):
store = StoreModel.find_by_name(name)
if store:
StoreModel.delete_from_db(store)
return {'message': 'Store deleted'}
def delete(self, name):
store = StoreModel.find_by_name(name)
if not store:
return {'message': f"A store with name '{name}' does not exist."}, 400
StoreModel.delete_from_db(store)
return {'message': 'Store deleted'}, 200
def delete(self, name):
store = StoreModel.find_by_name(name)
if store:
StoreModel.delete_from_db(store)
return {"message": "store has been deleted successfully"}
else:
return {"message": "Store not found in the database"}
def delete(self, name):
store = StoreModel(name).find_by_name()
if store:
store.delete_from_db()
return {"message": "Store deleted"}
else:
return {"message": "Store doesn't exist"}
def test_crud(self):
"""
CRUD: Create, Read, Update and Delete.
These are the four major and basic functions of persistent storage.
"""
with self.app_context():
# Setup
store = StoreModel('test')
# Exercise
# Verify
self.assertIsNone(StoreModel.find_by_name('test'))
# Exercise
store.save_to_db()
# Verify
self.assertIsNotNone(StoreModel.find_by_name('test'))
# Exercise
store.delete_from_db()
# Verify
self.assertIsNone(StoreModel.find_by_name('test'))
def delete(self, name):
store = StoreModel.find_by_name(name)
if store:
StoreModel.delete_from_db(name)
return {'message': f'store {name} deleted successfully'}
else:
return {'message': f'store does not exist'}, 400
def test_db_func(self):
with self.app_context():
store = StoreModel('coat_store')
self.assertIsNone(store.find_by_name('coat_store'))
store.save_to_db()
self.assertIsNotNone(store.find_by_name('coat_store'))
store.delete_from_db()
self.assertIsNone(store.find_by_name('coat_store'))
def test_crud(self):
with self.app_context():
store = StoreModel("test")
self.assertIsNone(StoreModel.find_by_name("test"))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name("test"))
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name("test"))
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test')) # NONE
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test')) # NOT NONE
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test')) # NONE AGAIN
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'))
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'))
def test_crud(tc_app_db_env):
tc_app, tc_app_context = tc_app_db_env
with tc_app_context():
store = StoreModel('test_store')
assert StoreModel.find_by_name('test_store') is None, "Store Table is not empty after creating"
store.save_to_db()
assert StoreModel.find_by_name('test_store') is not None, "Store Table is empty after adding object"
store.delete_from_db()
assert StoreModel.find_by_name('test_store') is None, "Store Table is not empty after deleting object"
def delete(self, name):
store = StoreModel.find_store_by_name(name)
if store:
try:
StoreModel.delete_from_db(store)
except:
return {
'message': 'error occurred while deleting the store'
}, 500
return {'message': 'store deleted successfully'}
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'),
"Bespoke msg test_crud condition")
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'),
"Bespoke msg test_crud condition")
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'),
"Bespoke msg test_crud condition")
def test_crud(self):
with self.app_context():
store1 = StoreModel.find_by_name("Macys")
self.assertIsNone(store1)
store1 = StoreModel("Macys")
store1.save_to_db()
store2 = StoreModel.find_by_name("Macys")
self.assertIsNotNone(store2)
store1.delete_from_db()
store2 = StoreModel.find_by_name("Macys")
self.assertIsNone(store2)
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'),
"Test store found even though it was not saved in database.")
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'),
"Test store not found after saving in database.")
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'),
"Test store found after deleting from database.")
def delete(self, name):
if StoreModel.find_by_name(name):
store = StoreModel(name)
try:
store.delete_from_db()
except:
return {
'message': "An error occurred when deleting the store"
}, 500
return {'message': f"Store {name} deleted!"}, 201
return {'message': f"Store {name} doesn't exists!"}, 404
def test_crud(self):
"""
Tests the delete_from_db and save_to_db methods of StoreModel
:return: None
"""
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'))
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'))
class TestStore(IntegrationBaseTest):
def setUp(self):
self.store = StoreModel('Test name')
return super(TestStore, self).setUp()
def test_items_is_empty_on_creation(self):
self.assertListEqual(self.store.items.all(), [])
def test_save_to_db(self):
with self.app_context():
self.assertIsNone(StoreModel.find_by_name('Test name'))
self.store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('Test name'))
def test_delete_from_db(self):
with self.app_context():
self.assertIsNone(StoreModel.find_by_name('Test name'))
self.store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('Test name'))
self.store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('Test name'))
def test_store_relationship(self):
with self.app_context():
self.store.save_to_db()
item = ItemModel('Test item', 19.99, self.store.id)
item.save_to_db()
self.assertEqual(self.store.items.count(), 1)
self.assertEqual(self.store.items.first().name, 'Test item')
def test_store_json(self):
expected = {
'name': 'Test name',
'items': [],
}
self.assertDictEqual(self.store.json(), expected)
def test_store_json_with_item(self):
expected = {
'name': 'Test name',
'items': [{
'name': 'Test item',
'price': 19.99
}],
}
with self.app_context():
self.store.save_to_db()
item = ItemModel('Test item', 19.99, self.store.id)
item.save_to_db()
self.assertDictEqual(self.store.json(), expected)
def delete(self, name):
store = StoreModel.find_by_name(name)
if store:
store = StoreModel(name)
store.delete_from_db()
return {"Message", "Store Deleted"}, 201
else:
return {"Message": "Store Not found"}, 400
def test_crud(self): # Test create, read, update, delete
with self.app_context():
store = StoreModel('testName')
self.assertIsNone(StoreModel.find_by_name('testName'))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('testName'))
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('testName'))
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'), "Found an store with name 'test' before save_to_db")
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'),
"Did not find an store with name 'test' after save_to_db")
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'), "Found an store with name 'test' after delete_from_db")
def test_crud(self):
with self.app_context(): # This comes from BaseTest
store = StoreModel('test')
# First check that 'test' doesn't exist
self.assertIsNone(StoreModel.find_by_name('test'))
store.save_to_db()
# Check that it exists, so should not return None
self.assertIsNotNone(StoreModel.find_by_name('test'))
store.delete_from_db()
# Check it doesn't exist
self.assertIsNone(StoreModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
store = StoreModel('lahudky')
self.assertIsNone(StoreModel.find_by_name('lahudky'))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('lahudky'),
'store has not found in DB')
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('lahudky'))
def test_crud_SQLlite(self):
with self.app_context():
store_item = StoreModel("Store_1")
self.assertIsNone(StoreModel.find_by_name("Store_1"))
store_item.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name("Store_1"))
store_item.delete_from_db()
self.assertIsNone(StoreModel.find_by_name("Store_1"))
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'), "Found an store with name 'test' before save_to_db")
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'),
"Did not find an store with name 'test' after save_to_db")
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'), "Found an store with name 'test' after delete_from_db")
def test_crud(self):
with self.app_context():
store = StoreModel('test')
#Check for no store in data base
self.assertIsNone(StoreModel.find_by_name('test'))
#Create database
store.save_to_db()
#Check if store is in data base
self.assertIsNotNone(StoreModel.find_by_name('test'))
#Delete store from db
store.delete_from_db()
#Check if no store is in data base
self.assertIsNone(StoreModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
store_name = 'Test Store'
store = StoreModel(store_name)
self.assertIsNone(StoreModel.find_by_name(store_name),
'Store model should be empty upon creation')
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name(store_name),
f'Did not find {store_name}')
store.delete_from_db()
self.assertIsNone(
StoreModel.find_by_name(store_name),
f'The store named "{store_name}" is still present when it should have been deleted'
)
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(
StoreModel.find_by_name('test'),
"Found a store with name {}, but expected not to.".format(
store.name))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'))
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'))
store.delete_from_db()
self.assertIsNone(
StoreModel.find_by_name('test'),
"Expected sole item to be delted but an item existed.")
def test_crud(self):
"""
This will test adding and removing Store object into db
"""
with self.app_context():
store = StoreModel('test_store_1')
self.assertIsNone(StoreModel.find_by_name('test_store_1'))
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test_store_1'))
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test_store_1'))
def test_create_items(self):
with app.app_context():
store = StoreModel('test')
self.assertIsNone(StoreModel.find_by_name('test'), f'Found a store with name {store.name},'
f' even it was not saved in the database')
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('test'), f'the store with name {store.name} was not found')
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('test'), f'Found a store with name {store.name},'
f' even it was deleted from the database')
def test_crud(self):
with self.app_context():
store = StoreModel('tests')
self.assertIsNone(StoreModel.find_by_name('tests'),
"Found a store named 'tests' even though no store was created.")
store.save_to_db()
self.assertIsNotNone(StoreModel.find_by_name('tests'),
"Did not find expected store named 'tests'.")
store.delete_from_db()
self.assertIsNone(StoreModel.find_by_name('tests'),
"Found a store named 'tests' even though all records in list were deleted")
