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

# Cambiar al directorio del proyecto
os.chdir(r"d:\Proyectos\Scripts\SIDELManagerScripts")

try:
    conn = sqlite3.connect("data/scriptsmanager.db")
    cursor = conn.cursor()

    print("=== SCRIPT GROUPS ===")
    cursor.execute("SELECT id, name, required_level FROM script_groups")
    rows = cursor.fetchall()
    for row in rows:
        print(f"ID: {row[0]}, Name: {row[1]}, Required Level: {row[2]}")

    print("\n=== USERS ===")
    cursor.execute("SELECT id, username, user_level FROM users")
    users = cursor.fetchall()
    for user in users:
        print(f"ID: {user[0]}, Username: {user[1]}, Level: {user[2]}")

    print("\n=== SCRIPTS ===")
    cursor.execute(
        "SELECT id, group_id, filename, display_name, required_level FROM scripts"
    )
    scripts = cursor.fetchall()
    for script in scripts:
        print(
            f"ID: {script[0]}, Group: {script[1]}, File: {script[2]}, Name: {script[3]}, Level: {script[4]}"
        )

    conn.close()
    print("\nConsulta exitosa!")

except Exception as e:
    print(f"Error: {e}")