def posts(request, ids):
ids = list(map(int, ids.split('/')))
posts = db.execute('''
SELECT users.username, posts.title, posts.body
FROM posts JOIN users on posts.user_id = users.id
WHERE posts.id IN (%s)
''' % ','.join('?' * len(ids)), ids)
return Response.render(request, 'posts.jinja2', {'posts': posts})
def fetch_transactions(request, user_id):
relogin_items = transactions.process_user(user_id)
if len(relogin_items) > 0:
return Response.render(
request, 'relogin.jinja2', {
'environment': config.plaid.environment,
'plaid_public_key': config.plaid.public_key,
'relogin_items': relogin_items,
})
else:
return Response(code=303, location='/outcomes')
def post(request, id):
posts = db.execute('''
SELECT users.username, posts.title, posts.body
FROM posts JOIN users on posts.user_id = users.id
WHERE posts.id = ?
''', id)
try:
post = next(posts)
except StopIteration:
raise HTTPException(404, 'invalid post id')
return Response.render(request, 'posts.jinja2', {'posts': [post]})
def root(request):
posts = db.execute('''
SELECT posts.id, users.username, posts.title, posts.body
FROM posts JOIN users on posts.user_id = users.id
ORDER BY posts.id DESC LIMIT 10
''')
logged_in = False
if request.get_secure_cookie('user_id', LOGIN_TIME):
logged_in = True
return Response.render(request, 'root.jinja2', {'posts': posts, 'logged_in': logged_in})
def accounts(request, user_id):
items = db.PlaidItem.query \
.filter(db.PlaidItem.user_id == user_id) \
.order_by(db.PlaidItem.plaid_item_id) \
.options(joinedload(db.PlaidItem.accounts)) \
.all()
return Response.render(
request, 'accounts.jinja2', {
'environment': config.plaid.environment,
'plaid_public_key': config.plaid.public_key,
'items': items,
})
def admin(request, user_id):
return Response.render(request, 'admin.jinja2', {})
def login_form(request):
return Response.render(request, 'login.jinja2', {})
def http_exception_handler(e, errors, request, app):
if e.code == 404:
return Response.render(request, '404.jinja2', {})
return default_http_exception_handler(e, errors, request, app)
def demo(request):
return Response.render(request, 'outcomes.jinja2', {'demo': True})
def outcomes(request):
return Response.render(request, 'outcomes.jinja2', {})
def root(request):
user_id = request.get_secure_cookie('user_id', datetime.timedelta(days=30))
return Response.render(request, 'root.jinja2',
{'logged_in': user_id is not None})
def guild_page(request, guild_id):
guild = Session().query(Guilds).get(int(guild_id))
return Response.render(request, 'guild.html', {'guild': guild})
def root(request):
guilds = Session().query(Guilds).all()
return Response.render(request, 'index.html', {'guilds': guilds})
def emoji_stats(request, guild_id):
guild = Session().query(Guilds).get(int(guild_id))
return Response.render(request, 'emoji.html', {'guild': guild})
