import json

from flask import render_template, jsonify, request, abort

from jinja2 import Markup

from sqlalchemy.orm import joinedload

from database import db_session

import models

@app.route('/annotationclient/<event_code>')

def page_annotationclient_event_code(event_code):

    #TODO: check event code + get event session

    event_query = db_session.query(models.Event).filter(models.Event.code==event_code)

    event = event_query.one()

    if not event:

        abort(404)

    #TODO: See why the relationship management does not work

    event_session_q = db_session.query(models.EventSession).filter(models.EventSession.event_id==event.id).order_by(models.EventSession.order.desc())

    event_session = event_session_q.first()

    categories_json = None

    if event_session:

        categories_json = event_session.categories_json

    if not categories_json:

        categories_json = None

    return render_template('annotationclient.html',

        logging = True,

        event_code = event_code,

        categories_json = Markup(json.dumps(categories_json).replace('\'','\\\'')) if categories_json else None

    )