o
    –t;hV  ã                   @   s   d dl Z dd„ Zdd„ ZdS )é    Nc                  C   s:   t  d¡} |  ¡ }| d¡ dd„ | ¡ D ƒ}|  ¡  |S )Núneuropulse.dbz2SELECT id, title, description, status FROM ticketsc                 S   s*   g | ]}|d  |d |d |d dœ‘qS )r   é   é   é   )ÚidÚtitleÚdescriptionÚstatus© )Ú.0Úrowr
   r
   ú /var/www/html/utils/ticketing.pyÚ
<listcomp>   s   * z load_tickets.<locals>.<listcomp>)Úsqlite3ÚconnectÚcursorÚexecuteÚfetchallÚclose)Úconnr   Úticketsr
   r
   r   Úload_tickets   s   

r   c                 C   s8   t  d¡}| ¡ }| d| |df¡ | ¡  | ¡  d S )Nr   zAINSERT INTO tickets (title, description, status) VALUES (?, ?, ?)ÚOuvert)r   r   r   r   Úcommitr   )r   r   r   r   r
   r
   r   Úsave_ticket   s
   
r   )r   r   r   r
   r
   r
   r   Ú<module>   s    