#!/usr/bin/python3.4
from flask import request, abort, redirect, session, url_for
import paginate
import sqlalchemy as sa

import wrpylib.wrmwmarkup
import wrpylib.wrmwcache
import wrpylib.mwmarkup

import wradmin.model as model
from wradmin.genshi import render_genshi_template, TemplateContext


class RodelbahnController:

    def list(self):
        """Lists all sled runs"""
        q = model.meta.Session.query(model.WrSledrunCache)
        q = q.order_by(model.WrSledrunCache.page_title)
        c = TemplateContext()
        c.paginator = paginate.Page(q.all(), page=int(request.args.get('page', 1)),
                                    url_maker=lambda page: url_for('rodelbahn_list', page=page),
                                    items_per_page=25)
        return render_genshi_template('rodelbahn_list.html', c=c)

    def view(self, id):
        """Displays a sled run"""
        q = model.meta.Session.query(model.WrSledrunCache)
        c = TemplateContext()
        c.sledding = q.get(id)
        if c.sledding is None:
            abort(404)
        q = model.meta.Session.query(model.WrReport)
        q = q.filter_by(page_id=id).order_by(sa.sql.expression.desc(model.WrReport.id))
        c.paginator = paginate.Page(q.all(), page=int(request.args.get('page', 1)),
                                    url_maker=lambda page: url_for('rodelbahn_view', id=id, page=page),
                                    items_per_page=25)
        return render_genshi_template('rodelbahn_view.html', c=c)

    def update(self):
        """Updates the wrsledruncache table from the wiki"""
        c = model.meta.Session.connection()
        try:
            wrpylib.wrmwcache.update_wrsledruncache(c)
            model.meta.Session.commit()
            session['flash'] = 'Die Rodelbahnliste wurde erfolgreich aktualisiert.'
        except wrpylib.wrmwcache.UpdateCacheError as e:
            title = str(e.args[1])
            title = wrpylib.mwmarkup.to_title(title)
            msg = str(e.args[2])
            msg = msg.replace('\n', '; ')
            if len(e.args) == 3: session['flash'] = "Fehler bei Rodelbahn '{0}': {1}".format(title, msg)
            else: session['flash'] = str(e)
        # Redirect to result page
        return redirect(url_for('rodelbahn_list'))

    def update_regioncache(self):
        "Updates the wrregioncache table from the wiki"
        c = model.meta.Session.connection()
        try:
            wrpylib.wrmwcache.update_wrregioncache(c)
            model.meta.Session.commit()
            session['flash'] = 'Die Rodelbahneinträge in den Regionslisten wurden erfolgreich aktualisiert.'
        except wrpylib.wrmwcache.UpdateCacheError as e:
            session['flash'] = str(e)
        session.save()
        # Redirect to result page
        return redirect(url(controller='rodelbahn', action='list'))