def main():
engine = create_engine('postgresql://[email protected]/my_metrics')
Base.metadata.create_all(engine)
Session.configure(bind=engine)
session = Session()
food_entries = session.query(FoodEntry).order_by(FoodEntry.date)
for entry in food_entries:
food_name = entry.name
existing_food = session.query(Food).filter_by(name=food_name).all()
if len(existing_food) == 0:
new_food = Food(food_name)
session.add(new_food)
session.commit()
def main():
engine = create_engine('postgresql://[email protected]/my_metrics')
Base.metadata.create_all(engine)
Session.configure(bind=engine)
session = Session()
foods = session.query(Food)
foods_by_name = {}
for food in foods:
foods_by_name[food.name] = food
food_entries = session.query(FoodEntry).order_by(FoodEntry.date)
for entry in food_entries:
food = foods_by_name[entry.name]
entry.food = food
session.commit()
import os
from wsgiref.simple_server import make_server
from pyramid.config import Configurator
from sqlalchemy import create_engine
from tables import Session
if __name__ == "__main__":
engine = create_engine("postgresql://[email protected]/my_metrics")
Session.configure(bind=engine)
config = Configurator()
config.add_renderer(name=".html", factory="renderers.jinja2_renderer.Jinja2Renderer")
config.add_route("hello", "/hello/{name}")
config.add_route("calorie-graph", "/graph")
config.add_route("calorie-graph-data", "/graph/data")
config.add_route("food-list", "/food/list")
config.add_route("food-edit-food-tags-form", "/food/{id}/food_tags/edit_form")
config.add_route("food-edit-food-tags", "/food/{id}/food_tags/edit", request_method="POST")
config.add_route("food-tag-list", "/food_tag/list")
config.add_route("food-tag-add-form", "/food_tag/add_form")
config.add_route("food-tag-add", "/food_tag/add", request_method="POST")
config.add_route("food-entry-add-form", "/food_entry/add_form")
config.add_route("food-entry-add", "/food_entry/add", request_method="POST")
config.add_route("food-entry-list", "/food_entry/list")
config.add_route("lose-it-upload-form", "/food_entry/lose_it_upload_form")
config.add_route("lose-it-upload", "/food_entry/lose_it_upload", request_method="POST")
config.add_route("dynamic-css", "/css/{name}.css")
# TODO: do dynamic file merging for JS like CSS
