def view(id):
if request.method == 'POST':
assigned_datapoint = get_assigned_datapoint(id,
check_author=True,
state=1)
db = get_db()
db.execute('UPDATE assigned SET state = 0, body = ""'
' WHERE id = ?', (id, ))
db.commit()
return redirect(url_for('question.update', id=id))
assigned_datapoint = get_assigned_datapoint(id, check_author=False)
image_path = assigned_datapoint['description']
first_ = image_path.find('_')
second_ = image_path.find('_', first_ + 1)
screen_title = image_path[first_ + 1:second_]
content_description = image_path[second_ + 1:image_path.rfind('.')]
answer = None
if assigned_datapoint['body'] is not None:
answer = " ".join([
f"Q{i+1}: {x}"
for i, x in enumerate(assigned_datapoint['body'].split("%"))
])
db = get_db()
username = db.execute(
'SELECT username FROM user WHERE id = ?',
(assigned_datapoint['user_id'], )).fetchone()['username']
return render_template('question/answer.html',
image_path=image_path,
content_description=content_description,
screen_title=screen_title,
is_view=True,
answer=answer,
username=username)
def update(id):
assigned_datapoint = get_assigned_datapoint(id, state=0)
image_path = assigned_datapoint['description']
first_ = image_path.find('_')
second_ = image_path.find('_', first_ + 1)
screen_title = image_path[first_ + 1:second_]
content_description = image_path[second_ + 1:image_path.rfind('.')]
if request.method == 'POST':
print("=============")
answers = [request.form[f'q{i}'] for i in range(1, 5)]
error = None
if not all(answers):
error = 'You must answer all questions.'
if error is not None:
flash(error)
else:
db = get_db()
answer = '%'.join(answers)
db.execute(
'UPDATE assigned SET state = 1, body = ?'
' WHERE id = ?', (answer, id))
db.commit()
return redirect(url_for('question.next_task'))
return render_template('question/answer.html',
image_path=image_path,
content_description=content_description,
screen_title=screen_title)
def load_logged_in_user():
user_id = session.get('user_id')
if user_id is None:
g.user = None
else:
g.user = get_db().execute('SELECT * FROM user WHERE id = ?',
(user_id, )).fetchone()
def clear(id):
if request.method == 'POST':
db = get_db()
db.execute('UPDATE assigned SET state = 0, body = ""'
' WHERE id = ?', (id))
db.commit()
return redirect(url_for('question.update', id))
return redirect(url_for('question.next_task'))
def datapoint(id):
assigned_datapoints = get_db().execute(
'SELECT a.id, a.user_id, a.datapoint_id as dp_id, dp.description, a.state, a.body, u.username'
' FROM assigned a'
' JOIN datapoint dp ON a.datapoint_id = dp.id'
' JOIN user u ON a.user_id = u.id'
' WHERE (dp.id = ?)', (id, )).fetchall()
if not assigned_datapoints:
datapoint = get_db().execute('SELECT * FROM datapoint WHERE id = ?',
(id, )).fetchone()
if datapoint is None:
abort(404, "Datapoint id {0} doesn't exist.".format(id))
datapoint = datapoint['description']
else:
datapoint = assigned_datapoints[0]['description']
return render_template('question/datapoint.html',
assigned_datapoints=assigned_datapoints,
datapoint=datapoint)
def next_task():
db = get_db()
user = g.user
assigned = db.execute(
'SELECT a.id, a.user_id, a.created, a.state'
' FROM assigned a'
' WHERE (a.user_id = ? AND a.state = 0)'
' ORDER BY a.created DESC', (user['id'], )).fetchone()
if assigned is None:
return redirect(url_for('question.index'))
return redirect(url_for('question.update', id=assigned['id']))
def all_annotation(username):
if username is None:
username = g.user['username']
assigned_datapoints = get_db().execute(
'SELECT a.id, a.user_id, a.datapoint_id as dp_id, dp.description, a.state, a.body, u.username'
' FROM assigned a'
' JOIN datapoint dp ON a.datapoint_id = dp.id'
' JOIN user u ON a.user_id = u.id'
' WHERE (u.username = ?)', (username, )).fetchall()
return render_template('question/all_annotations.html',
assigned_datapoints=assigned_datapoints)
def index():
print("SS ", current_app.url_map)
db = get_db()
user = g.user
assigned_set = db.execute(
'SELECT a.id, a.user_id, a.created, a.state'
' FROM assigned a'
' WHERE (a.user_id = ?)'
' ORDER BY a.created DESC', (user['id'], )).fetchall()
answered_count = sum(a['state'] == 1 for a in assigned_set)
remaining_count = sum(a['state'] == 0 for a in assigned_set)
return render_template('question/index.html',
answered_count=answered_count,
remaining_count=remaining_count)
def get_assigned_datapoint(id, check_author=True, state=None):
assigned_datapoint = get_db().execute(
'SELECT a.id, a.user_id, a.datapoint_id, dp.description, a.state, a.body'
' FROM assigned a JOIN datapoint dp ON a.datapoint_id = dp.id'
' WHERE (a.id = ?)', (id, )).fetchone()
if assigned_datapoint is None:
abort(404, "Assigned id {0} doesn't exist.".format(id))
if state is not None and assigned_datapoint['state'] != state:
abort(404, "Assigned id {0} is already done.".format(id))
if check_author and assigned_datapoint['user_id'] != g.user['id']:
abort(403)
return assigned_datapoint
def login():
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
db = get_db()
error = None
user = db.execute('SELECT * FROM user WHERE username = ?',
(username, )).fetchone()
if user is None:
error = 'Incorrect username.'
elif not check_password_hash(user['password'], password):
error = 'Incorrect password.'
if error is None:
session.clear()
session['user_id'] = user['id']
return redirect(url_for('index'))
flash(error)
return render_template('auth/login.html')
def register():
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
db = get_db()
error = None
if not username:
error = 'Username is required.'
elif not password:
error = 'Password is required.'
elif db.execute('SELECT id FROM user WHERE username = ?',
(username, )).fetchone() is not None:
error = 'User {} is already registered.'.format(username)
if error is None:
db.execute('INSERT INTO user (username, password) VALUES (?, ?)',
(username, generate_password_hash(password)))
db.commit()
return redirect(url_for('auth.login'))
flash(error)
return render_template('auth/register.html')
def datapoint_list():
datapoints = get_db().execute('SELECT * FROM datapoint').fetchall()
return render_template('question/datapoint_list.html',
datapoints=datapoints)