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",
