def hello_world(): query = House.select( House.name, pw.fn.COUNT(Point.id).alias('ct')).group_by(House.name).join( Point, pw.JOIN.LEFT_OUTER).where(House.name != "unknown").order_by( House.id).dicts() vals = [x.get('ct') for x in query] vals.append(1) factor = (50 / float(max(vals))) for y in query: y['height'] = y['ct'] * factor - 50.00 return render_template('index.jade', points=query, houses=houses)
from db import db from models import House, Person, Point db.create_tables([House, Person, Point]) House.get_or_create(name="gryffindor") House.get_or_create(name="ravenclaw") House.get_or_create(name="hufflepuff") House.get_or_create(name="slytherin") House.get_or_create(name="unknown") houses = [i.name for i in House.select()] print houses
update={ Person.name: i['name'] }).execute() except: pass @app.teardown_request def after_request(response): g.db.close() return response db.connect() database = {} houses = [i.name for i in House.select().where(House.name != "unknown")] db.close() message_attachments = [{ "fallback": "Upgrade your Slack client to use messages like these.", "color": "#3AA3E3", "attachment_type": "default", "callback_id": "sorting_hat", "actions": [{ "name": i, "text": i.title(), "type": "button",