from quart import Quart
import sqlite3
import os
from db import Database

app = Quart(__name__)
database = Database("/data/database.sqlite")


@app.route("/")
async def hello():
    epigram = database.execute(
        "SELECT text FROM epigrams ORDER BY random() LIMIT 1;"
    ).fetchone()
    return epigram


def init_db():
    num_rows = database.execute("SELECT count() FROM epigrams;").fetchone()
    if num_rows == 0:
        with open("seed_fortunes.txt", "rb") as f:
            data = f.read()
            fortunes = data.split(b"%\n")
            print(fortunes)


if __name__ == "__main__":
    init_db()
    app.run()