In [ ]:

    

import os
import sqlite3


    

In [ ]:

    

from flask import Flask, request, render_template, g


    

In [ ]:

    

app = Flask(__name__)
app.config.from_object(__name__)


    

In [ ]:

    

app.config.update(dict(
        DATABASE=os.path.join(app.root_path, 'flask_test.db')
    ))


    

In [ ]:

    

def connect_db():
    if not hasattr(g, 'db_con'):
        g.db_con = sqlite3.connect(app.config['DATABASE'])
        g.db_con.row_factory = sqlite3.Row
    return g.db_con


    

In [ ]:

    

@app.teardown_appcontext
def close_db(error):
    if hasattr(g, 'db_con'):
        g.db_con.close()


    

In [ ]:

    

@app.route('/list')
def list():
    db = connect_db()
    cur = db.execute('select username from entries')
    usernames = cur.fetchall()
    return render_template('list2.html', users=usernames)


    

In [ ]:

    

app.run()


    

In [ ]: