def associate_image():
data = request.get_json(force=True)
logging.debug(json.dumps(data))
cursor = connect(cursor_factory=psycopg2.extras.DictCursor)
logging.audit(format_message("Link image to registration %s of %s"), data['reg_no'], data['date'])
try:
cursor.execute("UPDATE registered_documents SET doc_id = %(doc_id)s " +
"WHERE number=%(reg)s and date=%(date)s",
{
"doc_id": data['document_id'], "reg": int(data['reg_no']), "date": data['date']
})
rows = cursor.rowcount
if rows == 0:
status_code = 404
else:
delete_application(cursor, data['appn_id'])
status_code = 200
complete(cursor)
except:
rollback(cursor)
raise
return Response(status=status_code, mimetype='application/json')
def remove_application(appn_id):
cursor = connect(cursor_factory=psycopg2.extras.DictCursor)
try:
if 'reject' in request.args:
logging.audit(format_message("Reject application"))
else:
logging.audit(format_message("Remove application"))
rows = delete_application(cursor, appn_id)
finally:
complete(cursor)
if rows == 0:
return Response(status=404)
return Response(status=204, mimetype='application/json')
