21 lines
431 B
Python
21 lines
431 B
Python
import sqlite3
|
|
import flask
|
|
from webapp import app, config
|
|
|
|
@app.before_request
|
|
def make_cursor():
|
|
flask.g.conn = sqlite3.connect(config.DB_FILE)
|
|
flask.g.db = flask.g.conn.cursor()
|
|
|
|
@app.teardown_request
|
|
def teardown_cursor(e):
|
|
flask.g.db.close()
|
|
flask.g.conn.commit()
|
|
flask.g.conn.close()
|
|
|
|
def execute(query, *args):
|
|
return flask.g.db.execute(query, args)
|
|
|
|
def fetchall():
|
|
return flask.g.db.fetchall()
|