def setUp(self): self.purchase_order_file_location = 'purchase_orders.xlsx' self.purchase_order_with_missing_data_file_location = 'purchase_orders_with_missing_data.xlsx' self.create_purchase_order_workbook() self.create_purchase_order_workbook_with_missing_data() self.imported_purchase_order_data = [{ 'order_number': 54101099, 'so_number': 20153976, 'po_date': '2015-01-15', 'po_type': 'ZLC', 'items': [{ 'material_code': 'SL005144', 'material_description': 'Laptop Lenovo ThinkPad T510', 'quantity': 8000, 'value': 3436.82, 'po_item_number': 10, 'so_item_number': 10 }, { 'material_code': 'SL002248', 'material_description': 'Laptop bag', 'quantity': 1000, 'value': 2000.01, 'po_item_number': 20, 'so_item_number': 20 }] }, { 'order_number': 54101128, 'so_number': 20143982, 'po_date': '2015-01-15', 'po_type': 'NB', 'items': [{ 'material_code': 'S0000208', 'material_description': 'F-75 therap.diet sachet 102.5g/CAR-120', 'quantity': 5000, 'value': 4850.19, 'po_item_number': 20, 'so_item_number': 20 }] }] self.updated_imported_purchase_order_data = [{ 'order_number': 54101099, 'so_number': 20153976, 'po_date': '2015-10-15', 'po_type': 'NB', 'items': [{ 'material_code': 'SL005144', 'material_description': 'Laptop Lenovo ThinkPad T510', 'quantity': 16000, 'value': 6873.64, 'po_item_number': 10, 'so_item_number': 10 }, { 'material_code': 'SL002248', 'material_description': 'Laptop bag', 'quantity': 1000, 'value': 2000.01, 'po_item_number': 20, 'so_item_number': 20 }] }, { 'order_number': 54101128, 'so_number': 20143982, 'po_date': '2015-11-15', 'po_type': 'ZLC', 'items': [{ 'material_code': 'S0000208', 'material_description': 'F-75 therap.diet sachet 102.5g/CAR-120', 'quantity': 5000, 'value': 4850.19, 'po_item_number': 20, 'so_item_number': 20 }] }] self.facade = PurchaseOrderFacade(self.purchase_order_file_location) self.missing_data_facade = PurchaseOrderFacade( self.purchase_order_with_missing_data_file_location)