@app.route("/rodelbahn/view/<int:id>")
def rodelbahn_view(id):
- pass
+ get_db()
+ return RodelbahnController().view(id)
@app.route("/rodelbahn/update_regioncache")
#!/usr/bin/python3.4
#from pylons import request, response, session, url, tmpl_context as c
#from pylons.controllers.util import abort, redirect
-from flask import request
+from flask import request, abort
import paginate
import sqlalchemy as sa
c = TemplateContext()
c.paginator = paginate.Page(q.all(), page=int(request.args.get('page', 1)), items_per_page = 25)
return render_genshi_template('rodelbahn_list.html', c=c)
-
-
+
def view(self, id):
- "Displays a sled run"
+ """Displays a sled run"""
q = model.meta.Session.query(model.WrSledrunCache)
- c.sledding = q.get(id)
- if c.sledding is None: abort(404)
+ 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, page=int(request.params.get('page', 1)), items_per_page = 25)
- return render('rodelbahn_view.html')
-
-
+ c.paginator = paginate.Page(q.all(), page=int(request.args.get('page', 1)), 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()
return 'http://winterrodeln-forum.org/'
return 'http://winterrodeln-forum.org/viewforum.php?f={}'.format(forum)
+ def google_maps(self, latitude, longitude):
+ """Builds an URL like http://maps.google.at/maps?q=47.200607,11.260007"""
+ return "http://maps.google.at/maps?q=%.6f,%.6f" % (latitude, longitude)
+
def bool(self, value):
"""Takes a bool value and creates a German representation"""
return wrpylib.wrvalidators.opt_bool_german_to_str(value)
<h3>Rodelbahnberichte</h3>
<py:if test="len(c.paginator) > 0">
-<p>${c.paginator.pager('$link_first $link_previous $first_item bis $last_item von $item_count $link_next $link_last', controller='rodelbahn', action='view', id=c.sledding.page_id)}</p>
+<p>${HTML(c.paginator.pager('$link_first $link_previous $first_item bis $last_item von $item_count $link_next $link_last', url=h.url(controller='rodelbahn', action='view', id=c.sledding.page_id) + '?page=$page'))}</p>
<table>
<tr>
</tr>
</table>
-<p>${c.paginator.pager('~2~', controller='rodelbahn', action='view', id=c.sledding.page_id)}</p>
+<p>${HTML(c.paginator.pager('~2~', url=h.url(controller='rodelbahn', action='view', id=c.sledding.page_id) + '?page=$page'))}</p>
</py:if>
<py:if test="len(c.paginator) == 0">
<p><em>Es sind keine Rodelbahnberichte zu dieser Rodelbahn vorhanden.</em></p>