def process_contest_office_from_structured_json(
one_contest_office_structured_json, google_civic_election_id, local_ballot_order, save_to_db):
voter_id = 1 # TODO Temp
logger.debug("General contest_type")
office = one_contest_office_structured_json['office']
# The number of candidates that a voter may vote for in this contest.
if 'numberVotingFor' in one_contest_office_structured_json:
number_voting_for = one_contest_office_structured_json['numberVotingFor']
else:
number_voting_for = 1
# The number of candidates that will be elected to office in this contest.
if 'numberElected' in one_contest_office_structured_json:
number_elected = one_contest_office_structured_json['numberElected']
else:
number_elected = 1
results = process_contest_common_fields_from_structured_json(one_contest_office_structured_json)
ballot_placement = results['ballot_placement'] # A number specifying the position of this contest
# on the voter's ballot.
primary_party = results['primary_party'] # If this is a partisan election, the name of the party it is for.
district_name = results['district_name'] # The name of the district.
district_scope = results['district_scope'] # The geographic scope of this district. If unspecified the
# district's geography is not known. One of: national, statewide, congressional, stateUpper, stateLower,
# countywide, judicial, schoolBoard, cityWide, township, countyCouncil, cityCouncil, ward, special
district_ocd_id = results['district_ocd_id']
electorate_specifications = results['electorate_specifications'] # A description of any additional
# eligibility requirements for voting in this contest.
special = results['special'] # "Yes" or "No" depending on whether this a contest being held
# outside the normal election cycle.
# We want to convert this from an array to three fields for the same table
# levels: string, A list of office levels to filter by. Only offices that serve at least one of these levels
# will be returned. Divisions that don't contain a matching office will not be returned. (repeated)
# Allowed values
# administrativeArea1 -
# administrativeArea2 -
# country -
# international -
# locality -
# regional -
# special -
# subLocality1 -
# subLocality2 -
# The levels of government of the office for this contest. There may be more than one in cases where a
# jurisdiction effectively acts at two different levels of government; for example, the mayor of the
# District of Columbia acts at "locality" level, but also effectively at both "administrative-area-2"
# and "administrative-area-1".
level_structured_json = one_contest_office_structured_json['level']
contest_level = []
for one_level in level_structured_json:
contest_level.append(one_level)
if 0 in contest_level:
contest_level0 = contest_level[0]
else:
contest_level0 = ''
if 1 in contest_level:
contest_level1 = contest_level[1]
else:
contest_level1 = ''
if 2 in contest_level:
contest_level2 = contest_level[2]
else:
contest_level2 = ''
# roles: string, A list of office roles to filter by. Only offices fulfilling one of these roles will be returned.
# Divisions that don't contain a matching office will not be returned. (repeated)
# Allowed values
# deputyHeadOfGovernment -
# executiveCouncil -
# governmentOfficer -
# headOfGovernment -
# headOfState -
# highestCourtJudge -
# judge -
# legislatorLowerBody -
# legislatorUpperBody -
# schoolBoard -
# specialPurposeOfficer -
roles_structured_json = one_contest_office_structured_json['roles']
# for one_role in roles_structured_json:
# Figure out how we are going to use level info
candidates = one_contest_office_structured_json['candidates']
internal_contest_office_id = 0 # Set to 0 in case a new one is not created
# Note that all of the information saved here is independent of a particular voter
if save_to_db:
if office and district_name and district_scope and district_ocd_id and google_civic_election_id:
try:
# Try to find earlier version based on name of the office google_civic_election_id
query1 = GoogleCivicContestOffice.objects.all()
query1 = query1.filter(google_civic_election_id__exact=google_civic_election_id)
query1 = query1.filter(district_scope__exact=district_scope)
query1 = query1.filter(office__exact=office)
# Was at least one existing entry found based on the above criteria?
if len(query1):
google_civic_contest_office = query1[0]
# If no entries found previously, create a new entry
else:
google_civic_contest_office = \
GoogleCivicContestOffice.objects.create(office=office,
google_civic_election_id=google_civic_election_id,
number_voting_for=number_voting_for,
number_elected=number_elected,
contest_level0=contest_level0,
contest_level1=contest_level1,
contest_level2=contest_level2,
ballot_placement=ballot_placement,
primary_party=primary_party,
district_name=district_name,
district_scope=district_scope,
district_ocd_id=district_ocd_id,
electorate_specifications=electorate_specifications,
special=special,
)
# The internal id is needed since there isn't a ContestOffice google identifier
internal_contest_office_id = google_civic_contest_office.id
except Exception as e:
handle_record_not_found_exception(e, logger=logger)
if value_exists(voter_id) and value_exists(google_civic_election_id) and value_exists(district_ocd_id):
google_civic_ballot_item_manager = GoogleCivicBallotItemManager()
google_civic_ballot_item_manager.save_ballot_item_for_voter(
voter_id, google_civic_election_id, district_ocd_id, ballot_placement, local_ballot_order)
process_candidates_from_structured_json(
candidates, google_civic_election_id, internal_contest_office_id, save_to_db)
return
def process_contest_office_from_structured_json(
one_contest_office_structured_json, google_civic_election_id,
local_ballot_order, save_to_db):
voter_id = 1 # TODO Temp
logger.debug("General contest_type")
office = one_contest_office_structured_json['office']
# The number of candidates that a voter may vote for in this contest.
if 'numberVotingFor' in one_contest_office_structured_json:
number_voting_for = one_contest_office_structured_json[
'numberVotingFor']
else:
number_voting_for = 1
# The number of candidates that will be elected to office in this contest.
if 'numberElected' in one_contest_office_structured_json:
number_elected = one_contest_office_structured_json['numberElected']
else:
number_elected = 1
results = process_contest_common_fields_from_structured_json(
one_contest_office_structured_json)
ballot_placement = results[
'ballot_placement'] # A number specifying the position of this contest
# on the voter's ballot.
primary_party = results[
'primary_party'] # If this is a partisan election, the name of the party it is for.
district_name = results['district_name'] # The name of the district.
district_scope = results[
'district_scope'] # The geographic scope of this district. If unspecified the
# district's geography is not known. One of: national, statewide, congressional, stateUpper, stateLower,
# countywide, judicial, schoolBoard, cityWide, township, countyCouncil, cityCouncil, ward, special
district_ocd_id = results['district_ocd_id']
electorate_specifications = results[
'electorate_specifications'] # A description of any additional
# eligibility requirements for voting in this contest.
special = results[
'special'] # "Yes" or "No" depending on whether this a contest being held
# outside the normal election cycle.
# We want to convert this from an array to three fields for the same table
# levels: string, A list of office levels to filter by. Only offices that serve at least one of these levels
# will be returned. Divisions that don't contain a matching office will not be returned. (repeated)
# Allowed values
# administrativeArea1 -
# administrativeArea2 -
# country -
# international -
# locality -
# regional -
# special -
# subLocality1 -
# subLocality2 -
# The levels of government of the office for this contest. There may be more than one in cases where a
# jurisdiction effectively acts at two different levels of government; for example, the mayor of the
# District of Columbia acts at "locality" level, but also effectively at both "administrative-area-2"
# and "administrative-area-1".
level_structured_json = one_contest_office_structured_json['level']
contest_level = []
for one_level in level_structured_json:
contest_level.append(one_level)
if 0 in contest_level:
contest_level0 = contest_level[0]
else:
contest_level0 = ''
if 1 in contest_level:
contest_level1 = contest_level[1]
else:
contest_level1 = ''
if 2 in contest_level:
contest_level2 = contest_level[2]
else:
contest_level2 = ''
# roles: string, A list of office roles to filter by. Only offices fulfilling one of these roles will be returned.
# Divisions that don't contain a matching office will not be returned. (repeated)
# Allowed values
# deputyHeadOfGovernment -
# executiveCouncil -
# governmentOfficer -
# headOfGovernment -
# headOfState -
# highestCourtJudge -
# judge -
# legislatorLowerBody -
# legislatorUpperBody -
# schoolBoard -
# specialPurposeOfficer -
roles_structured_json = one_contest_office_structured_json['roles']
# for one_role in roles_structured_json:
# Figure out how we are going to use level info
candidates = one_contest_office_structured_json['candidates']
internal_contest_office_id = 0 # Set to 0 in case a new one is not created
# Note that all of the information saved here is independent of a particular voter
if save_to_db:
if office and district_name and district_scope and district_ocd_id and google_civic_election_id:
try:
# Try to find earlier version based on name of the office google_civic_election_id
query1 = GoogleCivicContestOffice.objects.all()
query1 = query1.filter(
google_civic_election_id__exact=google_civic_election_id)
query1 = query1.filter(district_scope__exact=district_scope)
query1 = query1.filter(office__exact=office)
# Was at least one existing entry found based on the above criteria?
if len(query1):
google_civic_contest_office = query1[0]
# If no entries found previously, create a new entry
else:
google_civic_contest_office = \
GoogleCivicContestOffice.objects.create(office=office,
google_civic_election_id=google_civic_election_id,
number_voting_for=number_voting_for,
number_elected=number_elected,
contest_level0=contest_level0,
contest_level1=contest_level1,
contest_level2=contest_level2,
ballot_placement=ballot_placement,
primary_party=primary_party,
district_name=district_name,
district_scope=district_scope,
district_ocd_id=district_ocd_id,
electorate_specifications=electorate_specifications,
special=special,
)
# The internal id is needed since there isn't a ContestOffice google identifier
internal_contest_office_id = google_civic_contest_office.id
except Exception as e:
handle_record_not_found_exception(e, logger=logger)
if value_exists(voter_id) and value_exists(
google_civic_election_id) and value_exists(district_ocd_id):
google_civic_ballot_item_manager = GoogleCivicBallotItemManager()
google_civic_ballot_item_manager.save_ballot_item_for_voter(
voter_id, google_civic_election_id, district_ocd_id,
ballot_placement, local_ballot_order)
process_candidates_from_structured_json(candidates,
google_civic_election_id,
internal_contest_office_id,
save_to_db)
return
