#!/usr/bin/env python3
import sqlite3
import os

print("Starting simple audit...")

# Simple database check
db_paths = [
    "/opt/struktur/social-media-agent/cases.db",
    "/opt/struktur/social-media-agent/db/posts.db", 
    "/opt/struktur/social-media-radar/signals/radar.db",
    "/var/lib/sma-data/signals.db",
    "/var/lib/sma-data/cases.db"
]

print("Checking database accessibility:")
for db_path in db_paths:
    if os.path.exists(db_path):
        try:
            conn = sqlite3.connect(db_path)
            cursor = conn.cursor()
            cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
            tables = cursor.fetchall()
            print(f"  ✓ {db_path}: {len(tables)} Tabellen")
            conn.close()
        except Exception as e:
            print(f"  ✗ {db_path}: Fehler - {e}")
    else:
        print(f"  ? {db_path}: Datei nicht gefunden")

print("\nPrüfung abgeschlossen.")