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

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

    cursor.execute(
        "SELECT id, name, conda_environment FROM script_groups WHERE id = 5;"
    )
    result = cursor.fetchone()

    if result:
        print(f"Group ID: {result[0]}")
        print(f"Name: {result[1]}")
        print(f"Environment: {result[2]}")
    else:
        print("No group found with ID 5")

    conn.close()
    print("Database check completed successfully")

except Exception as e:
    print(f"Error: {e}")
    sys.exit(1)