def test_should_convert_to_dictionary(self):
polling_station = PollingStation(1, 01, "APAC", 002, "KWANIA COUNTY", 01, "ADUKU", 01, "ADYEDA", 01,
"ADYEDA CENTRE")
self.expected_dict = {"NO": 1, "DIST_CODE": 1, "DISTRICT_NAME": "APAC", "EA_CODE": 2,
"EA_NAME": "KWANIA COUNTY", "SUB_COUNTY_CODE": 1, "SUB_COUNTY_NAME": "ADUKU",
"PARISH_CODE": 1, "PARISH_NAME": "ADYEDA",
"PS_CODE": 1, "POLLING_STATION_NAME": "ADYEDA CENTRE"}
self.assertEqual(polling_station.to_dict(), self.expected_dict)
def excel_to_json(self, file_path):
work_book = load_workbook(file_path)
work_book._active_sheet_index = 0
work_sheet = work_book.active
polling_stations = []
for row in work_sheet.rows:
if self.is_valid(row):
polling_station = PollingStation(row[0].value, row[1].value, row[2].value, row[3].value, row[4].value,
row[5].value, row[6].value, row[7].value, row[8].value,
# TODO: an unknown cell is added in the 9th position, so skip it
row[10].value, row[11].value)
polling_stations.append(polling_station.to_dict())
return json.dumps(polling_stations)
def excel_to_json(self, file_path):
work_book = load_workbook(file_path)
work_book._active_sheet_index = 0
work_sheet = work_book.active
polling_stations = []
for row in work_sheet.rows:
if self.is_valid(row):
polling_station = PollingStation(
row[0].value,
row[1].value,
row[2].value,
row[3].value,
row[4].value,
row[5].value,
row[6].value,
row[7].value,
row[8].value,
# TODO: an unknown cell is added in the 9th position, so skip it
row[10].value,
row[11].value)
polling_stations.append(polling_station.to_dict())
return json.dumps(polling_stations)