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

# Cambiar al directorio del proyecto
os.chdir(r"d:\Proyectos\Scripts\SIDELManagerScripts")
sys.path.insert(0, os.getcwd())

from app.app import create_app
from app.models import ScriptGroup

# Crear aplicación y contexto
app = create_app()

with app.app_context():
    print("=== TESTING SCRIPTGROUP MODEL ===")

    # Test query
    try:
        groups = ScriptGroup.query.all()
        print(f"Found {len(groups)} groups:")
        for group in groups:
            print(
                f"  ID: {group.id}, Name: {group.name}, Required Level: {group.required_level}"
            )

        # Test specific group
        group_3 = ScriptGroup.query.get(3)
        if group_3:
            print(f"\nGroup ID 3: {group_3.name}")
            print(f"Required Level: {group_3.required_level}")
        else:
            print("\nGroup ID 3 not found!")

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