a
    0i                     @   s   d dl mZ dd ZdS )    )get_connectionc               
   C   s   d} zzJt  }|std| }||  | }dd |D W W |rP|  S  ty } z,td|  g W  Y d}~W |r|  S d}~0 0 W |r|  n|r|  0 dS )z.Obtiene las divisiones desde la base de datos.z
    SELECT
        Division.DivisionID, 
        Division.Division, 
        Division.CompanyID
    FROM
        dbo.Division
    u4   No se pudo establecer conexión con la base de datosc                 S   s$   g | ]}|d  |d |d dqS )r         )Z
DivisionIDdivisionZ	CompanyID ).0rowr   r   E/var/www/html/src/Consultas_SQL/SupYCtrol/DataMaster/DMDivisionSQL.py
<listcomp>       z get_division.<locals>.<listcomp>z0[Error inesperado] Error obteniendo divisiones: N)r   ConnectionErrorcursorexecutefetchallclose	Exceptionprint)queryconnr   resultser   r   r	   get_division   s,    

r   N)Consultas_SQL.conexionr   r   r   r   r   r	   <module>   s   