def home():
S = getsession()
R = S.query(models.Review).first()
return flask.render_template('home.html', item=R)
def show(building, room):
S = getsession()
R = S.query(models.Review).join(models.Room).filter(models.Room.name == room).all()
return flask.render_template('list.html', content = R)
def showfloor(building, floor):
S = getsession()
findfloor = S.query(models.Floor).filter(models.Floor.name == floor).join(models.Building).filter(models.Building.name == building).all()
R = S.query(models.Room).join(models.Floor).filter(models.Floor.name == floor).all()
rooms = [{'name': str(x),'url': "/room/MC/" + x.name, 'mapY': x.mapy, 'mapX': x.mapx} for x in R]
return flask.render_template('floor.html', rooms = rooms, imageurl ="http://csclub.uwaterloo.ca/~mimcpher/loo/maps/images/"+building+"/"+floor+".png")
def listall():
S = getsession()
Rs = S.query(models.Review).all()
return flask.render_template('list.html', content=Rs)
def browse():
S = getsession()
floors = S.query(models.Floor).all()
foo = [{'name': str(x).replace(',', ' '), 'url': str(x).replace(',','/')} for x in floors]
return flask.render_template('browse.html', floors=foo)
import os
from loo.database import init_db
init_db()
from loo.database import getsession
session = getsession()
import loo.models as models
buildings = os.listdir("maps/names/")
for building in buildings:
theb = models.Building(building, open('maps/names/' + building ).read().strip())
session.add(theb)
session.commit()
floors = os.listdir("maps/images/" + building)
for floor in floors:
floor = floor.split(".")[0]
print building, floor
thef = models.Floor(floor, theb)
session.add(thef)
session.commit()
