def delete(self, name):
item = ItemModel.find_by_name(name)
if item:
ItemModel.delete_from_db(item)
return {'message':'item deleted'}
else:
return {'message':'item does not exist'}
def delete(self, name):
item = ItemModel.find_by_name(name)
if item:
ItemModel.delete_from_db(item)
return {'message': 'Item name {} has been deleted'.format(name)}
def delete(self, name):
item = ItemModel.find_by_name(name)
if not item:
return {'message': f"An item with name '{name}' does not exist."}, 400
ItemModel.delete_from_db(item)
return {'message': 'Item deleted'}, 200
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
StoreModel('test').save_to_db()
item = ItemModel('test', 19.99, 1)
# Exercise
# Verify
self.assertIsNone(
ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(
item.name))
# Exercise
item.save_to_db()
# Verify
self.assertIsNotNone(ItemModel.find_by_name('test'))
# Exercise
item.delete_from_db()
# Verify
self.assertIsNone(ItemModel.find_by_name('test'))
def delete(self, name):
item = ItemModel.find_by_name(name)
if item:
ItemModel.delete_from_db(name)
return {'message': f'item {name} deleted successfully'}
else:
return {'message': f'item does not exist'}, 400
def test_store_json_with_item(self):
with self.app_context():
store = StoreModel('test')
item = ItemModel('test_item', 19.99, 1)
store.save_to_db()
item.save_to_db()
expected = {
'name': 'test',
'items': [{
'name': 'test_item',
'price': 19.99
}]
}
self.assertDictEqual(store.json(), expected)
with self.app_context():
item = ItemModel('test', 19.99, 1)
self.assertIsNone(
ItemModel.find_by_name('test'),
"Found an item iwth name {}, but expected not to.".format(
item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def delete(self, name):
claims = get_jwt()
if not claims["is_admin"]:
return {"message": "Admin privilege required"},401
item = ItemModel.find_by_name(name)
if item :
ItemModel.delete_from_db()
return {"message": "Item deleted"}
def test_crud(self):
with self.app_context():
item = ItemModel('test', 25.00)
self.assertIsNone(ItemModel.find_by_name('test'))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def delete(self, name):
claims = get_jwt_claims()
if not claims['is_admin']:
return {'message': 'Admin privilege required.'}, 401
item = ItemModel.find_by_name(name)
if item:
ItemModel.delete_from_db()
return {'message': 'Item deleted'}
def test_crud(self):
with self.app_context:
item =ItemModel("seeds", "2.00")
self.assertIsNone(ItemModel.find_by_name("seeds"))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name("seeds"))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name("seeds"))
def test_crud(self):
with self.app_context():
item = ItemModel("Test", 10.99)
self.assertIsNone(ItemModel.find_by_name("Test"))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name("Test"))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name("Test"))
def test_crud(self):
with self.app_context():
StoreModel('test store').save_to_db()
item = ItemModel('test item', 19.99, 1)
self.assertIsNone(
ItemModel.find_by_name('test item'),
f"Found an item with name {item.name}, but expected not to.")
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test item'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test item'))
def delete(self, name):
#connection = sqlite3.connect('data.db')
#cursor = connection.cursor()
#query = "DELETE FROM items WHERE name=?"
#cursor.execute(query, (name,))
#connection.commit()
#connection.close()
#return {"messages": "Item deleted"}
item = ItemModel.find_by_name(name)
if item:
ItemModel.delete_from_db()
return {"message": "Item deleted"}
def test_crud(self):
with self.app_context():
StoreModel('test').save_to_db()
item = ItemModel('Test', 19.99, 1)
self.assertIsNone(ItemModel.find_by_name('Test'))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('Test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('Test'))
def test_crud(self):
with self.app_context():
StoreModel('test').save_to_db()
item = ItemModel('test', 20.00, 1)
self.assertIsNone(ItemModel.find_by_name('test'), "Found an item with name {}, but expected not to.".format('test'))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
StoreModel(
'test').save_to_db() # need to do this for PostgreSQL or MySQL
item = ItemModel('test', 19.99, 1)
self.assertIsNone(
ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(
item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_crud(tc_app_db_env):
tc_app, tc_app_context = tc_app_db_env
with tc_app_context():
StoreModel('test').save_to_db()
item = ItemModel('test name', 99.9, 1)
assert ItemModel.find_by_name('test name') is None, \
f"Found an item with name '{item.name}', but expected not to"
item.save_to_db()
assert ItemModel.find_by_name('test name') is not None, \
f"Item '{item.name}' was not added to the database"
item.delete_from_db()
assert ItemModel.find_by_name('test name') is None, \
f"Item '{item.name}' was not deleted from the database"
def test_crud(self):
with self.app_context():
item = ItemModel('test', 19.99)
self.assertIsNone(ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
StoreModel('Kathmandu').save_to_db() # Save to stores table.
item = ItemModel('Kathmandu', 44.56, 1)
# First make sure the item does not exist in the db before saving.
self.assertIsNone(ItemModel.find_by_name('Kathmandu'),
f"Found an item with name {item.name}, but expected not to.")
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('Kathmandu'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('Kathmandu'))
def test_crud(self):
with self.app_context():
StoreModel("Test1").save_to_db()
item = ItemModel("test", 20.0, 1)
self.assertIsNone(ItemModel.find_by_name("test"))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name("test"))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name("test"))
def test_crud(self):
with self.app_context():
item = ItemModel('test', 42)
self.assertIsNone(
ItemModel.find_by_name('test'),
f'Found an item with name {item.name}, but expected not to.')
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
StoreModel('test').save_to_db() # only needed if connecting to 'sqlite:///data.db'
item = ItemModel('test', 19.99, 1)
self.assertIsNone(ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_item_initialise(self):
with self.app_context():
StoreModel("test").save_to_db()
item = ItemModel("test", 19.99, 1)
self.assertIsNone(ItemModel.find_by_name("test"))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name("test"))
self.assertEqual(item.name, "test")
self.assertEqual(item.price, 19.99)
self.assertEqual(item.store_id, 1)
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name("test"))
def test_crud(self):
with self.app_context():
store = StoreModel('Test Store')
store.save_to_db()
item = ItemModel('test', 19.99, store.id)
self.assertIsNone(ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
store = StoreModel('test')
store.save_to_db()
item = ItemModel('test', 19.99, 1)
self.assertIsNone(ItemModel.find_by_name('test'), "Found an item with name 'test' before save_to_db")
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'),
"Did not find an item with name 'test' after save_to_db")
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'), "Found an item with name 'test' after delete_from_db")
def test_crud(self):
with self.app_context():
item = ItemModel('test', 19.99)
self.assertIsNone(ItemModel.find_by_name('test'),
"Found an item with the name {item.name}, but expected not to.")
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'),
"Did not find item with the name {item.name}")
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'),
"Found an item with the name {item.name}, but expected not to.")
def test_crud(self):
with self.app_context():
item = ItemModel('Test', 30.00)
self.assertIsNone(
ItemModel.find_by_name('Test'),
'Found an item with name {}, but expected not to'.format(
item.name))
item.save_to_db()
self.assertIsNotNone(
ItemModel.find_by_name('Test'),
'Did not found an item with name {}, but expected to'.format(
item.name))
item.delete_from_db()
self.assertIsNone(
ItemModel.find_by_name('Test'),
'Found an item with name {}, but expected not to'.format(
item.name))
def test_crud_SQLlite(self):
with self.app_context():
item_model = ItemModel("Beer", 5.19, 1)
self.assertIsNone(
ItemModel.find_by_name("Beer")
) # make sure it does not exit in db before saving it to db
item_model.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name("Beer"))
item_model.delete_from_db()
# works because in SQLite, store_id is a foreign key, but store object has not been created
self.assertIsNone(ItemModel.find_by_name("Beer"))
def test_crud(self):
with self.app_context():
StoreModel('Test store').save_to_db(
) #for postgres, mysql because of foreign key constrains
item = ItemModel('Test item', 2.15, 1)
self.assertIsNone(
ItemModel.find_by_name('Test item'),
"Found an item with name {}, but expected not to.".format(
item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('Test item'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('Test item'))
def test_crud(self):
with self.app_context():
StoreModel('test').save_to_db(
) ## for foreign key testing (mysql, postgres)
item = ItemModel('test', 19.99, 1)
self.assertIsNone(
ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(
item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
def test_crud(self):
with self.app_context():
"""it helps to store the item in MYSQL or POSTGRES"""
StoreModel("test").save_to_db()
item = ItemModel('test', 19.99, 1)
self.assertIsNone(
ItemModel.find_by_name('test'),
"Found an item with name {}, but expected not to.".format(
item.name))
item.save_to_db()
self.assertIsNotNone(ItemModel.find_by_name('test'))
item.delete_from_db()
self.assertIsNone(ItemModel.find_by_name('test'))
