
    igS
                     :    d dl mZmZ d dlmZ d Zd Zd Zd ZdS )    )requestjsonify)get_db_connectionc                  z   	 t                      } |                     d          }|                    d           |                                }|                                 |                                  t          |          S # t          $ r*}t          dt          |          i          dfcY d }~S d }~ww xY w)NT)
dictionaryz>SELECT id, name, description FROM equipments ORDER BY name ASCerror  )r   cursorexecutefetchallcloser   	Exceptionstr)connr
   
equipmentses       7/var/www/wisegym.app/api/functions/equipment_service.pyget_all_equipmentsr      s    	/ ""--WXXX__&&


z""" / / /Q())3......./s   BB 
B:B5/B:5B:c                     	 t           j        } |                     d          }|                     d          }|r|st          ddi          dfS t	                      }|                                }|                    d||f           |                                 |                                 |                                 t          ddi          d	fS # t          $ r*}t          dt          |          i          d
fcY d }~S d }~ww xY w)Nnamedescriptionr   zMissing name or description  z:INSERT INTO equipments (name, description) VALUES (%s, %s)statuszEquipment created   r	   r   jsongetr   r   r
   r   commitr   r   r   )datar   r   r   r
   r   s         r   create_equipmentr       s!   /|xxhh}-- 	J; 	JG%BCDDcII ""H;	
 	
 	
 	

"5677<< / / /Q())3......./s%   AC BC 
D"DDDc                  P   	 t           j        } |                     d          }|                     d          }|s|st          ddi          dfS t	                      }|                                }|r|                    d|f           n|                    d|f           |                                 |                                 |                                 t          dd	i          d
fS # t          $ r*}t          dt          |          i          dfcY d }~S d }~ww xY w)Nr   idr   z#Provide either name or id to deleter   z&DELETE FROM equipments WHERE name = %sz$DELETE FROM equipments WHERE id = %sr   zEquipment deleted   r	   r   )r   r   equipment_idr   r
   r   s         r   delete_equipmentr%   (   s6   /|xxxx~~ 	RL 	RG%JKLLcQQ "" 	TNNCdWMMMMNNAL?SSS

"5677<< / / /Q())3......./s%   AC1 B!C1 1
D%;D D% D%c                     	 t           j        } |                     d          }|                     d          }|                     d          }|r|r|t          ddi          dfS |dvrt          ddi          dfS t	                      }|                                }|                    d	| d
||f           |                                 |                                 |                                 t          ddi          dfS # t          $ r*}t          dt          |          i          dfcY d }~S d }~ww xY w)Nr"   fieldvaluer   zMissing id, field or valuer   )r   r   zInvalid fieldzUPDATE equipments SET z = %s WHERE id = %sr   zEquipment updatedr#   r	   r   )r   r$   r'   r(   r   r
   r   s          r   update_equipment_fieldr)   A   s[   /|xx~~!!!! 	I5 	IEMG%ABCCSHH///G_566;; ""JJJJUT`Labbb

"5677<< / / /Q())3......./s+   A#D
 &D
 =BD
 

D>D93D>9D>N)	flaskr   r   	db_configr   r   r    r%   r)        r   <module>r.      su    " " " " " " " " ' ' ' ' ' '
/ 
/ 
// / /./ / /2/ / / / /r-   