Additional cleanup.

[philipp/winterrodeln/wradmin.git] / wradmin / controllers / gasthaus.py

diff --git a/wradmin/controllers/gasthaus.py b/wradmin/controllers/gasthaus.py
new file mode 100644 (file)
index 0000000..378e5b9
--- /dev/null
+++ b/wradmin/controllers/gasthaus.py
@@ -0,0 +1,51 @@
+#!/usr/bin/python2.6
+# -*- coding: iso-8859-15 -*-
+import logging
+
+from pylons import request, response, session, url, tmpl_context as c
+from pylons.controllers.util import abort, redirect
+import webhelpers.paginate as paginate
+
+from wradmin.lib.base import BaseController, render
+import wradmin.model as model
+import sqlalchemy as sa
+import formencode
+import re
+
+import wrpylib.wrmwmarkup
+import wrpylib.wrmwcache
+
+log = logging.getLogger(__name__)
+
+class GasthausController(BaseController):
+
+    def list(self):
+        "Lists all inns"
+        q = model.meta.Session.query(model.WrInnCache)
+        q = q.order_by(model.WrInnCache.page_title)
+        c.paginator = paginate.Page(q, page=int(request.params.get('page', 1)), items_per_page = 25)
+        return render('gasthaus_list.html')
+    
+    
+    def view(self, id):
+        "Displays an inn"
+        q = model.meta.Session.query(model.WrInnCache)
+        c.inn =  q.get(id)
+        if c.inn is None: abort(404)
+        return render('gasthaus_view.html')
+    
+    
+    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()
+            session['flash'] = u'Die Gasthausliste wurde erfolgreich aktualisiert.'
+        except wrpylib.wrmwcache.UpdateCacheError as e:
+            if len(e.args) == 3: session['flash'] = u"Fehler bei Gasthaus '{0}': {1}".format(e.args[1], e.args[2])
+            else: session['flash'] = unicode(e)
+        session.save()
+        # Redirect to result page
+        return redirect(url(controller='gasthaus', action='list'))
+