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'))