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})