-
Notifications
You must be signed in to change notification settings - Fork 3
/
webdemo.py
266 lines (218 loc) · 7.76 KB
/
webdemo.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
import sys
import json
import sqlite3
import os
from collections import defaultdict
import argparse
import itertools
from flask import Flask, render_template, make_response, url_for
from flask_bootstrap import Bootstrap
from flask import jsonify
from flask import g
#import numpy as np
#import cv2
#from imutils import contours
#import imutils
from ballot_image import ballot_image, contest_options, utils
app = Flask(__name__)
Bootstrap(app)
app.config['BOOTSTRAP_SERVE_LOCAL'] = True
app.config['SERVER_NAME'] = 'localhost:5000'
# from http://flask.pocoo.org/docs/1.0/patterns/sqlite3/
#DATABASE = '/Users/epaulson/development/DaneCountyVotes/Fall2018General/original/records.db'
#IMAGE_PATH = '/Users/epaulson/development/DaneCountyVotes/test_data/images/'
#STYLE_DIR = "/Users/epaulson/development/DaneCountyVotes/Fall2018General/ballot_styles"
DATABASE = './test_data/records.db'
IMAGE_PATH = './test_data/images/'
STYLE_DIR = "./test_data/ballot_styles"
styleLookup = {
"0,1,6,15,16,17,19,27,66": "style7.json",
"00000000280000459009000011": "style7.json",
"0,1,6,15,16,18,19,27,66": "style31.json",
"00000002820002031873000011": "style31.json",
"Ballot Style 31": "style31.json",
"Ballot Style 7": "style7.json",
}
def get_db():
db = getattr(g, '_database', None)
if db is None:
db = g._database = sqlite3.connect(app.config['DATABASE'])
db.row_factory = sqlite3.Row
return db
def query_db(query, args=(), one=False):
cur = get_db().execute(query, args)
rv = cur.fetchall()
cur.close()
return (rv[0] if rv else None) if one else rv
@app.teardown_appcontext
def close_connection(exception):
db = getattr(g, '_database', None)
if db is not None:
db.close()
@app.after_request
def after_request(response):
response.headers["Cache-Control"] = "no-cache, no-store, must-revalidate, public, max-age=0"
response.headers["Expires"] = 0
response.headers["Pragma"] = "no-cache"
return response
@app.route('/')
def index():
return render_template('index.html')
# help from https://chrisalbon.com/python/data_wrangling/break_list_into_chunks_of_equal_size/
def chunks(l, n):
# For item i in a range that is a length of l,
for i in range(0, len(l), n):
# Create an index range for l of n items:
yield l[i:i+n]
@app.route('/images/')
def getImages():
ballots = [x.cvr_id for x in app.config['FILES']]
ballot_chunks = list(chunks(ballots, 500))
data = defaultdict(list)
for chunk in ballot_chunks:
query = "select Precinct, \"Ballot Style\", \"Cast Vote Record\" from results where \"Cast Vote Record\" in ({seq})".format(seq=','.join(['?']*len(chunk)))
ballot_meta = query_db(query, chunk)
if app.config["BY_STYLES"]:
display_key = 'Ballot Style'
else:
display_key = "Precinct"
#print(display_key)
for b in ballot_meta:
#print(b)
data[b[display_key]].append(str(b["Cast Vote Record"]))
'''
with open(app.config['dataset']) as f:
data = defaultdict(list)
ballots = []
for ballot in f.readlines():
ballot = ballot.strip()
ballots.append(int(ballot))
query = "select Precinct, \"Cast Vote Record\" from results where \"Cast Vote Record\" in ({seq})".format(seq=','.join(['?']*len(ballots)))
ballot_meta = query_db(query, ballots)
for b in ballot_meta:
data[b["Precinct"]].append(str(b["Cast Vote Record"]))
'''
results = []
for group_by_key, ballots in data.items():
d = {}
d["text"] = group_by_key
d["selectable"] = False
d["state"] = {"expanded": False}
d["nodes"] = [{"text": x} for x in ballots]
results.append(d)
return jsonify(results)
def common(imgFile):
#ballot_meta = query_db('select Precinct, "Ballot Style" from results where "Cast Vote Record" = ?', [int(imgFile[:-1])], one=True)
ballot_meta = query_db('select Precinct, "Ballot Style" from results where "Cast Vote Record" = ?', [int(imgFile)], one=True)
cvr = None
if app.config["STYLEDIR"]:
styleFile = ballot_meta["Ballot Style"] + "_style.json"
styleFile = styleFile.replace(" ", "_")
styleFile = app.config["STYLEDIR"] + "/" + styleFile
if os.path.isfile(styleFile):
cvr = contest_options.create_cvr(styleFile, get_db(), int(imgFile))
ballot = ballot_image.BallotImage(app.config['PNGDIR'] + "/" + ballot_meta["Precinct"] + "/" + imgFile + 'i-000.png', style=ballot_meta["Ballot Style"], styleDir=STYLE_DIR, cvr=cvr)
return ballot
@app.route('/image/<imgFile>/scored_image')
def scored_image(imgFile):
ballot = common(imgFile)
ballot.find_boxes()
results = ballot.score()
if ballot.express_vote:
buffer = ballot.raw_as_png()
else:
buffer = ballot.scored_as_png()
response = make_response(buffer.tobytes())
response.headers['Content-Type'] = 'image/png'
return response
@app.route('/image/<imgFile>/dewarped_image')
def dewarped_image(imgFile):
ballot = common(imgFile)
ballot.find_boxes()
buffer = ballot.dewarped_as_png()
response = make_response(buffer.tobytes())
response.headers['Content-Type'] = 'image/png'
return response
@app.route('/image/<imgFile>/scored_json')
def score_json(imgFile):
ballot = common(imgFile)
ballot.find_boxes()
#results = ballot.score(imgFile, cvr)
results = ballot.score()
return jsonify(results)
@app.route('/image/<imgFile>/raw')
def imageRaw(imgFile):
ballot = common(imgFile)
buffer = ballot.raw_as_png()
response = make_response(buffer.tobytes())
response.headers['Content-Type'] = 'image/png'
return response
@app.route('/image/<imgFile>/debug/<target>')
def imageCandidateBlocks(imgFile, target):
ballot = common(imgFile)
try:
buffer = ballot.find_boxes()
except Exception as e:
#print("Ignoring exception %s" % (e))
pass
buffer = ballot.debug_image(target)
response = make_response(buffer.tobytes())
response.headers['Content-Type'] = 'image/png'
return response
if __name__ == '__main__':
parser = argparse.ArgumentParser()
group = parser.add_mutually_exclusive_group(required=True)
group.add_argument("--basic", action="store_true")
parser.add_argument("--by-styles", action="store_true")
parser.add_argument("--inputdir", help="Directory to scan",action="append", nargs="+")
parser.add_argument("--cvrids", help="Cast Vote Records to process individually. Requires dbfile as well", type=int, action="append", nargs="+")
parser.add_argument("--cvrfile", help="File of CVR IDs. Requires dbfile as well", action="append", nargs="+")
parser.add_argument("--dbfile", default="test_data/records.db", help="sqlite3 database with CVRs")
parser.add_argument("--pngdir", help="Top level directory for PNGs when using only CVRs")
parser.add_argument("--styledir", help="Top level directory for ballot style files")
args = parser.parse_args()
inputdirs = args.inputdir
dbfile = args.dbfile
cvrids = args.cvrids
cvrfiles = args.cvrfile
pngdir = args.pngdir
styledir = args.styledir
by_styles = args.by_styles
if cvrids:
if dbfile is None:
print("Error: specifying CVR IDs requires a SQLite database to be defined as well")
exit(-1)
if inputdirs:
inputdirs = list(itertools.chain.from_iterable(inputdirs))
if cvrids:
cvrids = list(itertools.chain.from_iterable(cvrids))
if cvrfiles:
cvrfiles = list(itertools.chain.from_iterable(cvrfiles))
files = []
if inputdirs:
for d in inputdirs:
files.extend(utils.generate_files(d))
conn = sqlite3.connect(dbfile)
conn.row_factory = sqlite3.Row
c = conn.cursor()
if cvrfiles:
for fname in cvrfiles:
with open(fname) as f:
ids = f.readlines()
ids = [id.strip() for id in ids]
if not cvrids:
cvrids = []
cvrids.extend(ids)
else:
cvrids.extend(ids)
if cvrids:
for cvr in cvrids:
files.extend(utils.generate_file_from_cvrid(cvr, pngdir, c))
conn.close()
app.config['DATABASE']=dbfile
app.config['FILES']= files
app.config['STYLEDIR'] = styledir
app.config['BY_STYLES'] = by_styles
#app.config['dataset'] = 'test_data/sample100-wd9.txt'
app.config['PNGDIR'] = pngdir
app.run()