def setUp(self): self.release_order_file_location = 'release_orders.xlsx' self.release_order_with_missing_data_file_location = 'release_orders_with_missing_data.xlsx' self.create_release_order_workbook() self.create_release_order_with_missing_data_workbook() self.imported_release_order_data = [{ 'order_number': 54101099.0, 'so_number': 20148031.0, 'purchase_order': 81018523.0, 'consignee': 'L438000393', 'consignee_name': 'OYAM DISTRICT ADMIN', 'waybill': 72081598.0, 'shipment_end_date': '2014-01-08', 'items': [{ 'ro_item_number': 10, 'material_code': 'SL005144', 'description': 'Laptop Lenovo ThinkPad T510', 'quantity': 1, 'value': 1167.66, 'purchase_order': 81018523.0, 'po_item_number': 10, 'so_item_number': 10 }, { 'ro_item_number': 20, 'material_code': 'SL002248', 'description': 'Laptop bag', 'quantity': 1, 'value': 26.81, 'purchase_order': 81018523.0, 'po_item_number': 20, 'so_item_number': 20 }] }, { 'order_number': 54101128.0, 'so_number': 20147537.0, 'purchase_order': 45132639.0, 'consignee': 'L438000181', 'consignee_name': 'GULU HOSPITAL', 'waybill': 72081746.0, 'shipment_end_date': '2014-04-08', 'items': [{ 'ro_item_number': 10, 'material_code': 'S0000208', 'description': 'F-75 therap.diet sachet 102.5g/CAR-120', 'quantity': 20, 'value': 1188.79, 'purchase_order': 45132639.0, 'po_item_number': 20, 'so_item_number': 20 }] }] self.updated_imported_release_order_data = [{ 'order_number': 54101099.0, 'so_number': 20148031.0, 'purchase_order': 81018523.0, 'consignee': 'L438000393', 'consignee_name': 'OYAM DISTRICT ADMIN', 'waybill': 72081598.0, 'shipment_end_date': '2014-01-08', 'items': [{ 'ro_item_number': 10, 'material_code': 'SL005144', 'description': 'Laptop Lenovo ThinkPad T510', 'quantity': 2, 'value': 2335.32, 'purchase_order': 81018523.0, 'po_item_number': 10, 'so_item_number': 10 }, { 'ro_item_number': 20, 'material_code': 'SL002248', 'description': 'Laptop bag', 'quantity': 1, 'value': 26.81, 'purchase_order': 81018523.0, 'po_item_number': 20, 'so_item_number': 20 }] }, { 'order_number': 54101128.0, 'so_number': 20147537.0, 'purchase_order': 45132639.0, 'consignee': 'L438000181', 'consignee_name': 'GULU HOSPITAL', 'waybill': 72081746.0, 'shipment_end_date': '2014-04-08', 'items': [{ 'ro_item_number': 10, 'material_code': 'S0000208', 'description': 'F-75 therap.diet sachet 102.5g/CAR-120', 'quantity': 20, 'value': 1188.79, 'purchase_order': 45132639.0, 'po_item_number': 20, 'so_item_number': 20 }] }] self.facade = ReleaseOrderFacade(self.release_order_file_location) self.facade_with_missing_data = ReleaseOrderFacade( self.release_order_with_missing_data_file_location)