def test_crud_create_read_query_uuid_type(self): # Check if query method can handel uuid of both types with self.app_context(): itm = ItemModel(3, "U00000002", "Details of an order") itm.save_to_db() found_item_str = ItemModel.find_by_order_uuid_and_user_id( order_uuid="3", user_id="U00000002")[0] found_item_int = ItemModel.find_by_order_uuid_and_user_id( order_uuid=3, user_id="U00000002")[0] self.assertEquals(found_item_int.order_id, found_item_str.order_id)
def test_crud_create_read_delete(self): with self.app_context(): itm = ItemModel("0001", "U00000000", "Details of an order") self.assertListEqual( ItemModel.find_by_order_uuid_and_user_id(order_uuid="1", user_id="U00000000"), []) itm.save_to_db() self.assertEqual( len( ItemModel.find_by_order_uuid_and_user_id( order_uuid="1", user_id="U00000000")), 1) itm.delete_from_db() self.assertListEqual( ItemModel.find_by_order_uuid_and_user_id(order_uuid="1", user_id="U00000000"), [])
def test_crud_create_read_delete_multi(self): with self.app_context(): itm = ItemModel("2", "U00000001", "Details of an order 😂") self.assertListEqual( ItemModel.find_by_order_uuid_and_user_id(order_uuid="2", user_id="U00000001"), []) itm.save_to_db() self.assertEqual( len( ItemModel.find_by_order_uuid_and_user_id( order_uuid="2", user_id="U00000001")), 1) found_item = ItemModel.find_by_order_uuid_and_user_id( order_uuid="2", user_id="U00000001")[0] self.assertEqual(found_item.order_id, 2) self.assertEqual(found_item.user_id, "U00000001") self.assertEqual(found_item.details, "Details of an order 😂") itm.delete_from_db() self.assertListEqual( ItemModel.find_by_order_uuid_and_user_id(order_uuid="2", user_id="U00000001"), [])