#!/usr/bin/python3.4
from flask import request, abort, redirect, url_for, flash, render_template
import paginate

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

import wradmin.model as model


class GasthausController:

    def list(self):
        """Lists all inns"""
        q = model.meta.Session.query(model.WrInnCache)
        q = q.order_by(model.WrInnCache.page_title)
        paginator = paginate.Page(q.all(), page=int(request.args.get('page', 1)),
                                  url_maker=lambda page: url_for('gasthaus_list', page=page),
                                  items_per_page=25)
        return render_template('gasthaus_list.html', paginator=paginator)

    def view(self, id):
        """Displays an inn"""
        q = model.meta.Session.query(model.WrInnCache)
        inn = q.get(id)
        if inn is None:
            abort(404)
        return render_template('gasthaus_view.html', inn=inn)

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