from flask import ( Blueprint, flash, g, redirect, render_template, session, request, url_for ) from werkzeug.exceptions import abort from webapp.auth import login_required from webapp.db import get_db bp = Blueprint('dashboard', __name__) @bp.route('/') @login_required def index(): """db = get_db() posts = db.execute( 'SELECT p.id, title, body, created, author_id, username' ' FROM post p JOIN user u ON p.author_id = u.id' ' ORDER BY created DESC' ).fetchall()""" return render_template('dashboard/index.html', perm=session.get('user_perm'))