How to Create a Deep Health Check Database in Python

import sqlite3
from datetime import datetime, timedelta
from pathlib import Path

DB_PATH = Path("deep_health_check.db")


def setup_database():
    conn = sqlite3.connect(DB_PATH)
    cursor = conn.cursor()
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS health_checks (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            service TEXT NOT NULL,
            status TEXT NOT NULL,
            response_time_ms INTEGER NOT NULL,
            checked_at TEXT NOT NULL
        )
    """)
    conn.commit()
    return conn


def insert_mock_data(conn):
    services = ["auth", "database", "cache", "api"]
    statuses = ["healthy", "degraded", "unhealthy", "healthy"]
    base_time = datetime.now()
    cursor = conn.cursor()
    for i, service in enumerate(services):
        cursor.execute(
            """
            INSERT INTO health_checks (service, status, response_time_ms, checked_at)
            VALUES (?, ?, ?, ?)
            """,
            (
                service,
                statuses[i],
                (i + 1) * 47 + 12,
                (base_time - timedelta(minutes=i * 5)).isoformat(),
            ),
        )
    conn.commit()


def get_report(conn):
    cursor = conn.cursor()
    cursor.execute("SELECT service, status, response_time_ms, checked_at FROM health_checks ORDER BY checked_at DESC")
    rows = cursor.fetchall()
    return rows


if __name__ == "__main__":
    conn = setup_database()
    insert_mock_data(conn)
    report = get_report(conn)
    for row in report:
        print(', '.join(str(item) for item in row))
    conn.close()