reports.py

# reports.py
import sqlite3

def get_reports(patient_id):
    conn = sqlite3.connect('healthcare.db')
    reports = conn.execute("SELECT * FROM lab_tests WHERE patient_id = ?", (patient_id,)).fetchall()
    conn.close()
    return reports