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)
