def __write_filing_to_excel(self, business_identifier, filing):
self.__filing_sheet.write(self.__filing_sheet_row_index, 0,
format_non_date(business_identifier))
self.__filing_sheet.write(self.__filing_sheet_row_index, 1,
format_json(filing._filing_json)) # pylint: disable=protected-access
self.__filing_sheet.write(self.__filing_sheet_row_index, 2,
format_date(filing._completion_date)) # pylint: disable=protected-access
self.__filing_sheet.write(self.__filing_sheet_row_index, 3,
format_date(filing._filing_date)) # pylint: disable=protected-access
self.__filing_sheet.write(self.__filing_sheet_row_index, 4,
format_non_date(filing._filing_type)) # pylint: disable=protected-access
self.__filing_sheet.write(self.__filing_sheet_row_index, 5,
format_date(filing.effective_date))
self.__filing_sheet.write(self.__filing_sheet_row_index, 6,
format_non_date(filing._payment_token)) # pylint: disable=protected-access
self.__filing_sheet.write(self.__filing_sheet_row_index, 7,
format_date(filing._payment_completion_date)) # pylint: disable=protected-access
self.__filing_sheet.write(
self.__filing_sheet_row_index, 8,
format_json([x.colin_event_id for x in filing.colin_event_ids]))
self.__filing_sheet.write(self.__filing_sheet_row_index, 9,
format_non_date(filing.status))
self.__filing_sheet.write(self.__filing_sheet_row_index, 10,
format_boolean(filing.paper_only))
self.__filing_sheet_row_index += 1
def __json_filings(cls, filings):
filings_json_list = []
for filing in filings:
d = {
'completionDate':
format_date(filing._completion_date), # pylint: disable=protected-access
'filingDate':
format_date(filing._filing_date), # pylint: disable=protected-access
'filingId':
filing.id,
'filingType':
format_non_date(filing._filing_type), # pylint: disable=protected-access
'effectiveDate':
format_date(filing.effective_date),
'paymentToken':
format_non_date(filing._payment_token), # pylint: disable=protected-access
'paymentCompletionDate':
format_date(filing._payment_completion_date), # pylint: disable=protected-access
'colinEventIds':
[x.colin_event_id for x in filing.colin_event_ids],
'status':
format_non_date(filing._status), # pylint: disable=protected-access
'paperOnly':
format_boolean(filing.paper_only),
# Don't want to use format_json here because we're
# running jsonify later and it will get all escaped
'filingJson':
format_non_date(filing._filing_json) # pylint: disable=protected-access
}
filings_json_list.append(d)
return filings_json_list
def __json_filings(self, filings):
filings_json_list = []
for filing in filings:
d = {
'completionDate':
format_date(filing._completion_date),
'filingDate':
format_date(filing._filing_date),
'filingType':
format_non_date(filing._filing_type),
'effectiveDate':
format_date(filing.effective_date),
'paymentToken':
format_non_date(filing._payment_token),
'paymentCompletionDate':
format_date(filing._payment_completion_date),
'colinEventId':
format_non_date(filing.colin_event_id),
'status':
format_non_date(filing._status),
'paperOnly':
format_boolean(filing.paper_only),
# Don't want to use format_json here because we're
# running jsonify later and it will get all escaped
'filingJson':
format_non_date(filing._filing_json)
}
filings_json_list.append(d)
return filings_json_list