
    2hc                     $    S SK Jr   " S S5      rg)   )get_db_connectionc                   $    \ rS rSr\S 5       rSrg)Team   c                     SSK Jn   SSKnSn UR                  R	                  U R
                  U R                  U R                  U R                  SS9nUR                  5       (       d@  / U(       a7  UR                  5       (       a!  WR                  5         UR                  5         $ $ $ UR                  SS9nS	nUR                  U5        UR                  5       nUU(       a7  UR                  5       (       a!  UR                  5         UR                  5         $ $ $ ! [         aX  n[        S
U 35        / s SnAU(       a7  UR                  5       (       a!  WR                  5         UR                  5         $ $ $ SnAff = f! U(       a7  UR                  5       (       a!  WR                  5         UR                  5         f f f = f)z9Fetch a list of all active teams from the intra database.r   )Config    Nintra)hostportuserpassworddatabaseT)
dictionarya  
                SELECT 
                    GID as team_gid, 
                    group_name
                FROM 
                    user_group
                WHERE 
                    workspace_status = 1
                ORDER BY 
                    group_name ASC
            z0Error fetching all teams from 'intra' database: )services.configr   mysql.connector	connectorconnectDB_HOSTDB_PORTDB_USERDB_PASSWORDis_connectedclosecursorexecutefetchall	Exceptionprint)r   mysqlconnr   queryteamses          )/var/www/fran/franai/models/team_model.pyget_all_teamsTeam.get_all_teams   sn    	- 	??**^^^^^^++  + D $$&&* ))++

 ,t' [[D[1F
E NN5!OO%E
 ))++

 ,t	  	DQCHII))++

 ,t		 ))++

 ,ts7   AD (3D 
E<$E73E<4E? 7E<<E? ?A F? N)__name__
__module____qualname____firstlineno__staticmethodr&   __static_attributes__r(       r%   r   r      s    ' 'r/   r   N)services.mysql_servicer   r   r(   r/   r%   <module>r1      s    6) )r/   