import os
import sys
from flask import Flask, render_template, request
import sqlite3
sys.path.insert(0, os.path.dirname(__file__))
app = Flask(__name__)

def get_db_connection():
    conn = sqlite3.connect('database.db')
    conn.row_factory = sqlite3.Row
    return conn

@app.route('/')
def index():
    conn = get_db_connection()
    dataaudiometries = conn.execute('SELECT * FROM dataaudiometries').fetchall()
    conn.close()
    return render_template('index.html', dataaudiometries=dataaudiometries)


if __name__ == "__main__":
    app.run(debug=True)