def setUp(self): self.programme_file_location = 'programmes.xlsx' self.programme_file_with_missing_data_location = 'programmes_with_missing_data.xlsx' self.create_programme_workbook() self.create_programme_workbook_with_missing_data() self.imported_programme_data = [{ 'name': 'YI107 - PCR 3 KEEP CHILDREN SAFE', 'wbs_element_ex': '4380/A0/04/107' }, { 'name': 'YI105 - PCR 1 KEEP CHILDREN AND MOTHERS', 'wbs_element_ex': '4380/A0/04/105' }, { 'name': 'Y108 - PCR 4 CROSS SECTORAL', 'wbs_element_ex': '4380/A0/04/108' }, { 'name': 'YP109 - PCR 5 SUPPORT', 'wbs_element_ex': '4380/A0/04/800' }] self.imported_missing_programme_data = [{ 'name': 'Y108 - PCR 4 CROSS SECTORAL', 'wbs_element_ex': '4380/A0/04/108' }] self.updated_programme_data = [ { 'name': 'YI107 - PCR 3 KEEP CHILDREN SAFE ALWAYS', 'wbs_element_ex': '4380/A0/04/107' }, { 'name': 'YI105 - PCR 1 KEEP CHILDREN AND MOTHERS SAFE', 'wbs_element_ex': '4380/A0/04/105' }, ] self.facade = ProgrammeFacade(self.programme_file_location) self.facade_for_missing = ProgrammeFacade( self.programme_file_with_missing_data_location)