import sqlite3
from pathlib import Path

BASE_DIR = Path(__file__).resolve().parent.parent
DATA_DIR = BASE_DIR / "data"
DB_PATH = DATA_DIR / "introspection.db"


def main() -> None:
    DATA_DIR.mkdir(parents=True, exist_ok=True)
    conn = sqlite3.connect(str(DB_PATH))
    cur = conn.cursor()

    # Crear tabla introspection vacía
    cur.execute(
        """
        DROP TABLE IF EXISTS introspection;
        """
    )

    cur.execute(
        """
        CREATE TABLE introspection (
            timestamp TEXT NOT NULL,
            sha1sum   TEXT NOT NULL,
            rule      TEXT NOT NULL
        );
        """
    )

    conn.commit()
    conn.close()

    print(f"[INFO] introspection.db creada a {DB_PATH} amb taula 'introspection' buida.")


if __name__ == "__main__":
    main()