U
    id                     @   s   d dl mZ G dd dZdS )    )get_connectionc                   @   s"   e Zd ZdZeedddZdS )Ftp_Servicea  
    create table Formats (
    Id_Format int primary key identity(1,1),
    Format_Name varchar(100) not null,
    Format_Path varchar(100) not null,
    Format_Action_Description varchar(255) not null,
    Python_Path_Execution varchar(255) not null
    )
    )	id_formatc                 C   sL   d }t  }| }d}||| f | }|  |  |rH|d S d S )Nz
                Select
                    Format_Path
                from
                    Formats
                where Id_Format = ?
                r   )r   cursorexecutefetchoneclose)r   resultconnr   query r   [C:\Users\victor.barrera\Documents\proyectos\elepV3\Elep\src\App\api\services\Ftp_Service.pyget_path_By_id   s    zFtp_Service.get_path_By_idN)__name__
__module____qualname____doc__staticmethodintr   r   r   r   r   r      s   
r   N)Consultas_SQL.conexionr   r   r   r   r   r   <module>   s   