def candidate_order(racedate):
racedate_db = PostgresqlExtDatabase('elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1')
)
models.database_proxy.initialize(racedate_db)
if request.method == 'POST':
payload = utils.clean_payload(dict(request.form))
if payload.get('candidates', None):
print payload['candidates']
for idx, candidateid in enumerate(payload['candidates'].split(',')):
oc = models.OverrideCandidate.update(nyt_display_order=idx).where(models.OverrideCandidate.candidate_candidateid == candidateid)
oc.execute()
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
def candidate_detail(racedate, candidateid):
racedate_db = PostgresqlExtDatabase('elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1')
)
models.database_proxy.initialize(racedate_db)
if request.method == 'POST':
payload = utils.clean_payload(dict(request.form))
try:
oc = models.OverrideCandidate.get(models.OverrideCandidate.candidate_candidateid == candidateid)
except models.OverrideCandidate.DoesNotExist:
oc = models.OverrideCandidate.create(candidate_candidateid=candidateid)
utils.update_model(oc, payload)
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
def candidate_detail(racedate, candidateid, raceyear):
racedate_db = PostgresqlExtDatabase(
'elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1'))
models.database_proxy.initialize(racedate_db)
if request.method == 'POST':
payload = utils.clean_payload(dict(request.form))
try:
oc = models.OverrideCandidate.get(
models.OverrideCandidate.candidate_unique_id == candidateid)
except models.OverrideCandidate.DoesNotExist:
oc = models.OverrideCandidate.create(
candidate_unique_id=candidateid)
utils.update_model(oc, payload)
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
def state_detail(racedate, statepostal):
racedate_db = PostgresqlExtDatabase('elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1')
)
models.database_proxy.initialize(racedate_db)
if request.method == 'POST':
payload = utils.clean_payload(dict(request.form))
races = ["%s-%s" % (r.statepostal, r.raceid) for r in models.ElexRace.select().where(models.ElexRace.statepostal == statepostal)]
for r in races:
o = models.OverrideRace.get(
models.OverrideRace.race_raceid == r.split('-')[1],
models.OverrideRace.race_statepostal == r.split('-')[0]
)
o.report=payload['report']
o.report_description=payload['report_description']
o.save()
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
def state_detail(racedate, statepostal, raceyear):
racedate_db = PostgresqlExtDatabase(
'elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1'))
models.database_proxy.initialize(racedate_db)
if request.method == 'POST':
payload = utils.clean_payload(dict(request.form))
races = [
r.race_unique_id for r in models.ElexRace.select().where(
models.ElexRace.statepostal == statepostal)
]
for r in races:
o = models.OverrideRace.get(
models.OverrideRace.race_unique_id == r)
o.report = payload['report']
o.save()
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1')
)
models.database_proxy.initialize(racedate_db)
payload = utils.clean_payload(dict(request.form))
try:
r = models.OverrideRace.get(models.OverrideRace.race_raceid == raceid.split('-')[1], models.OverrideRace.race_statepostal == raceid.split('-')[0])
except models.OverrideRace.DoesNotExist:
r = models.OverrideRace.create(race_raceid=raceid.split('-')[1], race_statepostal=raceid.split('-')[0])
print payload
utils.set_winner(payload['nyt_winner'], raceid)
utils.update_model(r, payload)
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
@app.route('/elections/2016/admin/<racedate>/candidateorder/', methods=['POST'])
def candidate_order(racedate):
racedate_db = PostgresqlExtDatabase('elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1')
)
models.database_proxy.initialize(racedate_db)
if request.method == 'POST':
payload = utils.clean_payload(dict(request.form))
if payload.get('candidates', None):
print payload['candidates']
def race_detail(racedate, raceid, raceyear):
if request.method == 'GET':
try:
racedate_db = PostgresqlExtDatabase(
'elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1'))
models.database_proxy.initialize(racedate_db)
context = utils.build_context(racedate, raceyear)
context['race'] = [
r for r in models.ElexResult.raw(
"""select officename, seatname, race_unique_id, raceid, statepostal, accept_ap_calls from elex_results where race_unique_id = '%s' group by officename, seatname, race_unique_id, raceid, statepostal, accept_ap_calls"""
% raceid)
][0]
context['candidates'] = models.ElexResult.raw(
"""select nyt_runoff, party, nyt_winner, candidate_unique_id, first, last from elex_results where race_unique_id = '%s' group by nyt_runoff, party, nyt_winner, candidate_unique_id, first, last order by last, first DESC;"""
% raceid)
context['ap_winner'] = None
ap_winner = [
m for m in models.ElexResult.raw(
"""select candidate_unique_id, first, last, winner, nyt_winner, nyt_called from elex_results where race_unique_id = '%s' and winner = 'true' group by candidate_unique_id, first, last, winner, nyt_winner, nyt_called order by last, first DESC;"""
% raceid)
]
if len(ap_winner) > 0:
context['ap_winner'] = ap_winner[0]
context['states'] = []
state_list = sorted(list(
set([race.statepostal for race in models.ElexRace.select()])),
key=lambda x: x)
for state in state_list:
race = models.ElexRace.select().where(
models.ElexRace.statepostal == state)[0]
state_dict = {}
state_dict['statepostal'] = state
state_dict['report'] = None
state_dict['report_description'] = None
context['states'].append(state_dict)
return render_template('race_detail.html', **context)
except peewee.OperationalError as e:
context['error'] = e
return render_template('error.html', **context)
if request.method == 'POST':
racedate_db = PostgresqlExtDatabase(
'elex_%s' % racedate,
user=os.environ.get('ELEX_ADMIN_USER', 'elex'),
host=os.environ.get('ELEX_ADMIN_HOST', '127.0.0.1'))
models.database_proxy.initialize(racedate_db)
payload = utils.clean_payload(dict(request.form))
try:
r = models.OverrideRace.get(
models.OverrideRace.race_unique_id == raceid)
except models.OverrideRace.DoesNotExist:
r = models.OverrideRace.create(race_unique_id=raceid,
raceid=raceid.split('-')[1],
statepostal=raceid.split('-')[0])
# nyt_winner is a single ID, there can only be one winner.
utils.set_winner(payload['nyt_winner'], raceid)
print(payload)
# nyt_runoff is a list of ids, there can be 2 or more advancing.
runoff_cands = []
if payload.get('nyt_runoff', None):
runoff_cands = [
x.strip() for x in payload['nyt_runoff'].split(',')
]
utils.set_runoff(runoff_cands, raceid)
utils.update_model(r, payload)
utils.update_views(models.database_proxy)
return json.dumps({"message": "success"})
