def _get_field_map(cls):
"""
Return metadata for each field defined on this model, to aid in serializing
and exporing data.
"""
return OrderedDict([
('org_id', {
'sql': 'organization.uuid',
'label': 'unit:id:admin',
'serializer': cls.serializers['string'],
}),
('name', {
'sql': 'organization.name',
'label': Organization.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('name_confidence', {
'sql': 'organization.name_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('name'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('division_id', {
'sql': 'organization.division_id',
'label': Organization.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('division_id_confidence', {
'sql': 'organization.division_id_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('division_id'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('classifications', {
'sql': 'organization.classifications',
'label': Organization.get_spreadsheet_field_name('classification'),
'serializer': cls.serializers['list'],
}),
('classifications_confidence', {
'sql': 'organization.classifications_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('classification'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('aliases', {
'sql': 'organization.aliases',
'label': Organization.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('aliases_confidence', {
'sql': 'organization.aliases_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('aliases'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('firstciteddate', {
'sql': 'organization.first_cited_date',
'label': Organization.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('firstciteddate_confidence', {
'sql': 'organization.first_cited_date_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('firstciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('lastciteddate', {
'sql': 'organization.last_cited_date',
'label': Organization.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('lastciteddate_confidence', {
'sql': 'organization.last_cited_date_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('lastciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('realstart', {
'sql': 'organization.real_start',
'label': Organization.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('realstart_confidence', {
'sql': 'organization.real_start_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('realstart'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('open_ended', {
'sql': 'organization.open_ended',
'label': Organization.get_spreadsheet_field_name('open_ended'),
'serializer': cls.serializers['identity'],
}),
('open_ended_confidence', {
'sql': 'organization.open_ended_confidence',
'label': Organization.get_spreadsheet_confidence_field_name('open_ended'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_id', {
'sql': 'person.uuid',
'label': 'person:admin:id',
'serializer': cls.serializers['string'],
}),
('person_id_confidence', {
'sql': 'membership.person_id_confidence',
'label': 'person:posting:confidence',
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_name', {
'sql': 'person.name',
'label': Person.get_spreadsheet_field_name('name'),
'serializer': cls.serializers['identity'],
}),
('person_name_confidence', {
'sql': 'person.name_confidence',
'label': Person.get_spreadsheet_confidence_field_name('name'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_aliases', {
'sql': 'person.aliases',
'label': Person.get_spreadsheet_field_name('aliases'),
'serializer': cls.serializers['list'],
}),
('person_aliases_confidence', {
'sql': 'person.aliases_confidence',
'label': Person.get_spreadsheet_confidence_field_name('aliases'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_division_id', {
'sql': 'person.division_id',
'label': Person.get_spreadsheet_field_name('division_id'),
'serializer': cls.serializers['division_id'],
}),
('person_division_id_confidence', {
'sql': 'person.division_id_confidence',
'label': Person.get_spreadsheet_confidence_field_name('division_id'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_date_of_birth', {
'sql': 'person.date_of_birth',
'label': PersonBiography.get_spreadsheet_field_name('date_of_birth'),
'serializer': cls.serializers['list'],
}),
('person_date_of_birth_confidence', {
'sql': 'person.date_of_birth_confidence',
'label': PersonBiography.get_spreadsheet_confidence_field_name('date_of_birth'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_date_of_death', {
'sql': 'person.date_of_death',
'label': PersonBiography.get_spreadsheet_field_name('date_of_death'),
'serializer': cls.serializers['list'],
}),
('person_date_of_death_confidence', {
'sql': 'person.date_of_death_confidence',
'label': PersonBiography.get_spreadsheet_confidence_field_name('date_of_death'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_deceased', {
'sql': 'person.deceased',
'label': PersonBiography.get_spreadsheet_field_name('deceased'),
'serializer': cls.serializers['list'],
}),
('person_deceased_confidence', {
'sql': 'person.deceased_confidence',
'label': PersonBiography.get_spreadsheet_confidence_field_name('deceased'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_account_types', {
'sql': 'person.account_types',
'label': PersonExtra.get_spreadsheet_field_name('account_type'),
'serializer': cls.serializers['list'],
}),
('person_account_types_confidence', {
'sql': 'person.account_types_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('account_type'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_accounts', {
'sql': 'person.accounts',
'label': PersonExtra.get_spreadsheet_field_name('account'),
'serializer': cls.serializers['list'],
}),
('person_accounts_confidence', {
'sql': 'person.accounts_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('account'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_external_link_descriptions', {
'sql': 'person.external_link_descriptions',
'label': PersonExtra.get_spreadsheet_field_name('external_link_description'),
'serializer': cls.serializers['list'],
}),
('person_external_link_descriptions_confidence', {
'sql': 'person.external_link_descriptions_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('external_link_description'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_media_descriptions', {
'sql': 'person.media_descriptions',
'label': PersonExtra.get_spreadsheet_field_name('media_description'),
'serializer': cls.serializers['list'],
}),
('person_media_descriptions_confidence', {
'sql': 'person.media_descriptions_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('media_description'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_notes', {
'sql': 'person.notes',
'label': PersonExtra.get_spreadsheet_field_name('notes'),
'serializer': cls.serializers['list'],
}),
('person_notes_confidence', {
'sql': 'person.notes_confidence',
'label': PersonExtra.get_spreadsheet_confidence_field_name('notes'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_role', {
'sql': 'membership.role',
'label': MembershipPerson.get_spreadsheet_field_name('role'),
'serializer': cls.serializers['identity'],
}),
('person_role_confidence', {
'sql': 'membership.role_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('role'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_rank', {
'sql': 'membership.rank',
'label': MembershipPerson.get_spreadsheet_field_name('rank'),
'serializer': cls.serializers['identity'],
}),
('person_rank_confidence', {
'sql': 'membership.rank_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('rank'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_title', {
'sql': 'membership.title',
'label': MembershipPerson.get_spreadsheet_field_name('title'),
'serializer': cls.serializers['identity'],
}),
('person_title_confidence', {
'sql': 'membership.title_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('title'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate', {
'sql': 'membership.first_cited_date',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate'),
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_year', {
'sql': 'membership.first_cited_date_year',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate') + ':year',
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_month', {
'sql': 'membership.first_cited_date_month',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate') + ':month',
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_day', {
'sql': 'membership.first_cited_date_day',
'label': MembershipPerson.get_spreadsheet_field_name('firstciteddate') + ':day',
'serializer': cls.serializers['identity'],
}),
('person_firstciteddate_confidence', {
'sql': 'membership.first_cited_date_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('firstciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_realstart', {
'sql': 'membership.real_start',
'label': MembershipPerson.get_spreadsheet_field_name('realstart'),
'serializer': cls.serializers['identity'],
}),
('person_realstart_confidence', {
'sql': 'membership.real_start_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('realstart'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_startcontext', {
'sql': 'membership.start_context',
'label': MembershipPerson.get_spreadsheet_field_name('startcontext'),
'serializer': cls.serializers['identity'],
}),
('person_startcontext_confidence', {
'sql': 'membership.start_context_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('startcontext'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate', {
'sql': 'membership.last_cited_date',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate'),
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_year', {
'sql': 'membership.last_cited_date_year',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate') + ':year',
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_month', {
'sql': 'membership.last_cited_date_month',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate') + ':month',
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_day', {
'sql': 'membership.last_cited_date_day',
'label': MembershipPerson.get_spreadsheet_field_name('lastciteddate') + ':day',
'serializer': cls.serializers['identity'],
}),
('person_lastciteddate_confidence', {
'sql': 'membership.last_cited_date_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('lastciteddate'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_realend', {
'sql': 'membership.real_end',
'label': MembershipPerson.get_spreadsheet_field_name('realend'),
'serializer': cls.serializers['identity'],
}),
('person_realend_confidence', {
'sql': 'membership.real_end_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('realend'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
('person_endcontext', {
'sql': 'membership.end_context',
'label': MembershipPerson.get_spreadsheet_field_name('endcontext'),
'serializer': cls.serializers['identity'],
}),
('person_endcontext_confidence', {
'sql': 'membership.end_context_confidence',
'label': MembershipPerson.get_spreadsheet_confidence_field_name('endcontext'),
'confidence': True,
'serializer': cls.serializers['identity'],
}),
])
