def test_four(self):
restaurant = Restaurant(self.connection_string)
order_num = restaurant.place_order(self.input[4])
self.assertLessEqual(0, order_num, "Didn't retrieve proper order number")
order_num = restaurant.place_order('Hamburger')
result = self.query("SELECT * FROM orders WHERE order_number=%s", (order_num,))
self.assertIsNotNone(result[0][4], "New order was not marked filled")
def test_five(self):
restaurant = Restaurant(self.connection_string)
result = restaurant.find_ingredients_by_cost(self.input[5])
self.assertEqual(3, len(result),
"Did not retrieve the right number of recipes")
self.assertIn(('Milkshake', ), result,
"Did not retrieve Milkshake experimental recipe")
def test_three(self):
restaurant = Restaurant(self.connection_string)
result = restaurant.find_course_recipes(self.input[3])
self.assertEqual(3, len(result),
"Did not retrieve the right number of recipes")
self.assertIn(('Milkshake', ), result,
"Did not retrieve Milkshake experimental recipe")
def test_two(self):
restaurant = Restaurant(self.connection_string)
result = restaurant.find_ingredient_better(self.input[2])
self.assertEqual(16, len(result), "Did not retrieve all ingredients")