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')