def init():
import application.data as data
from application import db
from application.persistence import user_persistence, category_persistence, report_persistence
db.drop_all()
db.create_all()
for user_data in data.users:
user = User(email=user_data['email'],
password=user_data['password'],
user_id=user_data['id'])
user_persistence.save(user)
for category_data in data.categories:
category = Category(name=category_data['name'],
category_id=category_data['id'])
category_persistence.save(category)
for report_data in data.reports:
user_id = report_data['user_id']
category_id = report_data['category_id']
report = Report(lat=report_data['lat'],
lng=report_data['lng'],
description=report_data['description'],
time=report_data['time'],
user=user_persistence.get(user_id),
category=category_persistence.get(category_id),
report_id=report_data['id'])
report_persistence.save(report)
return redirect(url_for('index'))
def get_by_id(user_id):
return user_persistence.get(user_id)
