def test_delete_a_item(self): """ Delete a Item """ item = Item(0, "fido", "dog") item.save() self.assertEqual(len(Item.all()), 1) # delete the item and make sure it isn't in the database item.delete() self.assertEqual(len(Item.all()), 0)
def test_delete_an_item(self): """ Delete an Item """ item = Item(order_id=1, product_id=1, name="wrench", quantity=1, price=10.50) item.save() self.assertEqual(len(Item.all()), 1) item.delete() self.assertEqual(len(Item.all()), 0)
def test_delete_an_item(self): """ Delete an Item """ item = Item(sku="ID111", count=3, price=2.00, name="test_item", link="test.com", brand_name="gucci", is_available=True) item.save() self.assertEqual(len(Item.all()), 1) # delete the item and make sure it isn't in the database item.delete() self.assertEqual(len(Item.all()), 0)
def test_add_an_item(self): """ Create an Item and add it to the database """ items = Item.all() self.assertEqual(items, []) item = Item(order_id=1, product_id=1, name="wrench", quantity=1, price=10.50) self.assertEqual(item.id, None) item.save() self.assertEqual(item.id, 1) items = Item.all() self.assertEqual(len(items), 1)
def test_add_a_item(self): """ Create a item and add it to the database """ items = Item.all() self.assertEqual(items, []) item = Item(0, "fido", "dog", True) self.assertTrue(item != None) self.assertEqual(item.id, 0) item.save() # Asert that it was assigned an id and shows up in the database self.assertEqual(item.id, 1) items = Item.all() self.assertEqual(len(items), 1) self.assertEqual(items[0].id, 1) self.assertEqual(items[0].name, "fido") self.assertEqual(items[0].price, "dog") self.assertEqual(items[0].available, True)
def test_fetch_all_items(self): """ Test fetching all Items """ item = Item(order_id=1, product_id=1, name="wrench", quantity=1, price=10.50) item.save() item2 = Item(order_id=1, product_id=2, name="hammer", quantity=2, price=11) item2.save() Item.all() self.assertEqual(len(Item.all()), 2)
def test_add_an_item(self): """ Create an item and add it to the database """ items = Item.all() self.assertEqual(items, []) item = Item(sku="ID111", count=3, price=2.00, name="test_item", link="test.com", brand_name="gucci", is_available=True) self.assertTrue(item != None) self.assertEqual(item.id, None) item.save() # Assert that it was assigned an id and shows up in the database self.assertEqual(item.id, 1) items = Item.all() self.assertEqual(len(items), 1)
def get(self): if request.args.get('item') is not None: bucketlist_id = int(request.args.get('item')) table = Item.db.table('bucketlists') result = table.get(where('id') == bucketlist_id) if result is None: return jsonify({}) return jsonify(result) items = jsonify(Item.all()) return items
def list_items(): """ Returns all of the Items """ items = [] price = request.args.get('price') name = request.args.get('name') if price: items = Item.find_by_price(price) elif name: items = Item.find_by_name(name) else: items = Item.all() results = [item.serialize() for item in items] return make_response(jsonify(results), status.HTTP_200_OK)
def test_update_a_item(self): """ Update a Item """ item = Item(0, "fido", "dog", True) item.save() self.assertEqual(item.id, 1) # Change it an save it item.price = "k9" item.save() self.assertEqual(item.id, 1) # Fetch it back and make sure the id hasn't changed # but the data did change items = Item.all() self.assertEqual(len(items), 1) self.assertEqual(items[0].price, "k9") self.assertEqual(items[0].name, "fido")
def test_delete_all_items(self): """ Delete all Items """ item = Item(sku="ID111", count=3, price=2.00, name="test_item", link="test.com", brand_name="gucci", is_available=True) item.save() Item(sku="ID222", count=5, price=10.00, name="some_item", link="link.com", brand_name="nike", is_available=False).save() self.assertEqual(len(Item.all()), 2) # Remove all items from the Items table Item.query.delete() # Check if the number of items in Item table is zero because they were removed self.assertEqual(len(Item.all()), 0)
def test_update_an_item(self): """ Update an Item """ item = Item(order_id=1, product_id=1, name="wrench", quantity=1, price=10.50) item.save() self.assertEqual(item.id, 1) item.price = 12.0 item.save() items = Item.all() self.assertEqual(len(items), 1) self.assertEqual(items[0].price, 12.0)
def test_update_an_item(self): """ Update an Item """ item = Item(sku="ID111", count=3, price=2.00, name="test_item", link="test.com", brand_name="gucci", is_available=True) item.save() self.assertEqual(item.id, 1) # Change it an save it item.sku = "ID222" item.save() self.assertEqual(item.id, 1) # Fetch it back and make sure the id hasn't changed # but the data did change items = Item.all() self.assertEqual(len(items), 1) self.assertEqual(items[0].sku, "ID222")
def list_items(): """ Returns all of the Items --- tags: - Items description: The Items endpoint allows you to query Items parameters: - name: order_id in: query description: the order_id of the Item you are looking for required: false type: integer - name: product_id in: query description: the product_id of the Item you are looking for required: false type: integer - name: quantity in: query description: the quantity of the Item you are looking for required: false type: integer - name: price in: query description: the price of the Item you are looking for required: false type: number - name: name in: query description: the name of the Item you are looking for required: false type: string definitions: Item: type: object properties: id: type: integer description: unique id assigned internally by service name: type: string description: the item name order_id: type: integer description: the order_id of the item product_id: type: integer description: the product_id of the item quantity: type: integer description: the quantity of the item price: type: number description: the price of the item responses: 200: description: An array of Items schema: type: array items: schema: $ref: '#/definitions/Item' """ items = [] order_id = request.args.get('order_id') product_id = request.args.get('product_id') quantity = request.args.get('quantity') price = request.args.get('price') name = request.args.get('name') if order_id: items = Item.find_by_order_id(order_id) elif product_id: items = Item.find_by_product_id(product_id) elif quantity: items = Item.find_by_quantity(quantity) elif price: items = Item.find_by_price(price) elif name: items = Item.find_by_name(name) else: items = Item.all() results = [item.serialize() for item in items] return make_response(jsonify(results), status.HTTP_200_OK)