from ..services.mysql_service import get_db_connection

class Team:
    @staticmethod
    def get_all_teams():
        """Fetch a list of all active teams from the intra database."""
        # This method connects to the 'intra' database directly.
        from ..services.config import Config
        import mysql.connector

        conn = None
        try:
            conn = mysql.connector.connect(
                host=Config.DB_HOST,
                port=Config.DB_PORT,
                user=Config.DB_USER,
                password=Config.DB_PASSWORD,
                database='intra'
            )
            if not conn.is_connected():
                return []

            cursor = conn.cursor(dictionary=True)
            query = """
                SELECT 
                    GID as team_gid, 
                    group_name
                FROM 
                    user_group
                WHERE 
                    workspace_status = 1
                ORDER BY 
                    group_name ASC
            """
            cursor.execute(query)
            teams = cursor.fetchall()
            return teams
        except Exception as e:
            print(f"Error fetching all teams from 'intra' database: {e}")
            return []
        finally:
            if conn and conn.is_connected():
                cursor.close()
                conn.close()