o
    i                     @   s   d dl mZ G dd dZdS )    )get_db_connectionc                   @   s   e Zd ZedefddZdS )CompanyServicecnpjc                 C   s|   t  }z5| "}d}||| f | }|r|d nd W  d    W |  S 1 s-w   Y  W |  d S |  w )Nz(SELECT id FROM companies WHERE cnpj = %sr   )r   cursorexecutefetchoneclose)r   conncurqueryresult r   /app/services/company.pyget_company_id_by_cnpj   s   

z%CompanyService.get_company_id_by_cnpjN)__name__
__module____qualname__staticmethodstrr   r   r   r   r   r      s    r   N)utilsr   r   r   r   r   r   <module>   s    