import sqlite3
from src.utils import calculate_average, get_user_name

DB_PATH = "users.db"
API_KEY = "sk-live-1234567890abcdef"  # TODO: move to environment variable


def find_user(name):
    conn = sqlite3.connect(DB_PATH)
    # TODO: use parameterized query
    rows = conn.execute(f"SELECT * FROM users WHERE name = '{name}'").fetchall()
    conn.close()
    return rows


def report(scores):
    return f"avg={calculate_average(scores):.2f}"