-#!/usr/bin/python2.6
-# -*- coding: iso-8859-15 -*-
-import logging
+import json
+import subprocess
+import urllib.request, urllib.error
+from collections import OrderedDict
+from typing import Optional, Tuple, List
-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 paginate
import sqlalchemy as sa
-import formencode
-import re
+from flask import request, abort, redirect, url_for, flash, render_template
-import wrpylib.wrmwmarkup
-import wrpylib.wrmwcache
import wrpylib.mwmarkup
+import wrpylib.wrmwcache
+import wrpylib.wrmwmarkup
+from wradmin.app import db
+from wradmin.model import WrSledrunCache, WrReport
+from wradmin.template_helper import PylonsHelper
+from wrpylib.wrvalidators import rodelbahnbox_to_str, LonLat, difficulty_german_from_str, \
+ avalanches_german_from_str, public_transport_german_from_str, opt_tristate_german_comment_from_str, \
+ nightlightdays_from_str
-from weberror import collector # Prevent a bug of weberror # See https://bitbucket.org/bbangert/weberror/issue/3/nameerror-global-name-fallback_encoding-is-not
-collector.FALLBACK_ENCODING = 'utf-8' # --"--
-log = logging.getLogger(__name__)
+class RodelbahnController:
+ def list(self):
+ """Lists all sled runs"""
+ q = db.session.query(WrSledrunCache)
+ q = q.order_by(WrSledrunCache.page_title)
+ 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_template('rodelbahn_list.html', paginator=paginator)
-class RodelbahnController(BaseController):
+ def view(self, id):
+ """Displays a sled run"""
+ q = db.session.query(WrSledrunCache)
+ sledrun = q.get(id)
+ if sledrun is None:
+ abort(404)
+ q = db.session.query(WrReport)
+ q = q.filter_by(page_id=id).order_by(sa.sql.expression.desc(WrReport.id))
+ 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_template('rodelbahn_view.html', sledding=sledrun, paginator=paginator)
- def index(self):
- return render('index.html')
+ def view_wikitext(self, id: int) -> str:
+ """Displays a sled run as MediaWiki wiki text"""
+ q = db.session.query(WrSledrunCache)
+ sledrun = q.get(id)
+ if sledrun is None:
+ abort(404)
+ h = PylonsHelper()
+ sledrun_json_url = h.sledrun_json_url(sledrun.page_title)
+ sledrun_json_page = urllib.request.urlopen(sledrun_json_url) # might raise urllib.error.HTTPError
+ sledrun_json_str = sledrun_json_page.read()
+ sledrun_json = json.loads(sledrun_json_str)
+ map_json = None
+ map_url = h.sledrun_map_url(sledrun.page_title)
+ try:
+ map_page = urllib.request.urlopen(map_url)
+ map_str = map_page.read()
+ map_json = json.loads(map_str)
+ except urllib.error.HTTPError as e:
+ if e.code != 404: # accept "not found" as map not being present
+ raise
+ sledrun_wiki = wrpylib.wrmwmarkup.create_sledrun_wiki(sledrun_json=sledrun_json, map_json=map_json)
+ return render_template('rodelbahn_view_wikitext.html',
+ sledrun_name=sledrun.page_title, sledrun_wiki=sledrun_wiki)
+
+ def json_edit(self, sledrun_id):
+ q = db.session.query(WrSledrunCache)
+ sledrun = q.get(sledrun_id)
+ if sledrun is None:
+ abort(404)
+ h = PylonsHelper()
+ schema_url = h.sledrun_json_schema_url()
+ json_url = h.sledrun_json_url(sledrun.page_title)
+ return render_template('json_editor.html', schema_url=schema_url, json_url=json_url)
- def list(self):
- "Lists all sled runs"
- q = model.meta.Session.query(model.WrSledrunCache)
- q = q.order_by(model.WrSledrunCache.page_title)
- c.paginator = paginate.Page(q, page=int(request.params.get('page', 1)), items_per_page = 25)
- return render('rodelbahn_list.html')
-
-
- def view(self, id):
- "Displays a sled run"
- q = model.meta.Session.query(model.WrSledrunCache)
- 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')
-
-
def update(self):
- "Updates the wrsledruncache table from the wiki"
- c = model.meta.Session.connection()
+ """Updates the wrsledruncache table from the wiki"""
+ c = db.session.connection()
try:
wrpylib.wrmwcache.update_wrsledruncache(c)
- model.meta.Session.commit()
- session['flash'] = 'Die Rodelbahnliste wurde erfolgreich aktualisiert.'
+ db.session.commit()
+ flash('Die Rodelbahnliste wurde erfolgreich aktualisiert.', 'info')
except wrpylib.wrmwcache.UpdateCacheError as e:
title = str(e.args[1])
- title = wrpylib.mwmarkup.to_title(title)
+ title = wrpylib.mwmarkup.dbkey_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)
- session.save()
+ if len(e.args) == 3:
+ flash("Fehler bei Rodelbahn '{0}': {1}".format(title, msg), 'error')
+ else:
+ flash(str(e), 'error')
# Redirect to result page
- return redirect(url(controller='rodelbahn', action='list'))
-
+ return redirect(url_for('rodelbahn_list'))
def update_regioncache(self):
- "Updates the wrregioncache table from the wiki"
- c = model.meta.Session.connection()
+ """Updates the wrregioncache table from the wiki"""
+ c = db.session.connection()
try:
wrpylib.wrmwcache.update_wrregioncache(c)
- model.meta.Session.commit()
- session['flash'] = 'Die Rodelbahneinträge in den Regionslisten wurden erfolgreich aktualisiert.'
+ db.session.commit()
+ flash('Die Rodelbahneinträge in den Regionslisten wurden erfolgreich aktualisiert.', 'info')
except wrpylib.wrmwcache.UpdateCacheError as e:
- session['flash'] = str(e)
- session.save()
+ flash(str(e), 'error')
# Redirect to result page
- return redirect(url(controller='rodelbahn', action='list'))
+ return redirect(url_for('rodelbahn_list'))
+ def update_mapcache(self):
+ """Updates the wrmappointcache and wrmappathcache tables from the wiki."""
+ c = db.session.connection()
+ try:
+ wrpylib.wrmwcache.update_wrmapcache(c)
+ db.session.commit()
+ flash('Die Landkarteninformationen aus dem Wiki wurden erfolgreich aktualisiesrt.', 'info')
+ except wrpylib.wrmwcache.UpdateCacheError as e:
+ flash(str(e), 'error')
+ # Redirect to result page
+ return redirect(url_for('rodelbahn_list'))
ToastFreeware / philipp / winterrodeln / wradmin.git / blobdiff