
    g/                     4    d dl mZmZ d dlm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 * FROM feedbacks ORDER BY id DESCerror  )r   cursorexecutefetchallcloser   	Exceptionstr)connr
   	feedbackses       6/var/www/wisegym.app/api/functions/feedback_service.pyget_all_feedbacksr      s    	/ ""--ABBBOO%%	

y!!! / / /Q())3......./s   BB 
B:B5/B:5B:c                  ~   	 t           j        } |                     d          }|                     d          }|                     d          }|                     d          }|r|r|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user_idfeedback_typetitledescriptionr   zMissing required fields  zZINSERT INTO feedbacks (user_id, feedback_type, title, description) VALUES (%s, %s, %s, %s)statuszfeedback submitted   r	   r   jsongetr   r   r
   r   commitr   r   r   )datar   r   r   r   r   r
   r   s           r   submit_feedbackr"      sW   /|((9%%11!!hh}-- 	Fm 	F5 	F 	FG%>?@@#EE ""hmUK8	
 	
 	
 	

"6788#== / / /Q())3......./s%   A:D =B
D 
D<D71D<7D<c                     	 t           j        } |                     d          }|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feedback_idr   zMissing feedback_idr   z#DELETE FROM feedbacks WHERE id = %sr   zfeedback deleted   r	   r   )r!   r$   r   r
   r   s        r   delete_feedbackr&   *   s    /|hh}-- 	BG%:;<<cAA ""<{nMMM

"4566;; / / /Q())3......./s#   5C  BC   
C4
C/)C4/C4N)flaskr   r   	db_configr   r   r"   r&        r   <module>r+      sf    " " " " " " " " ' ' ' ' ' '
/ 
/ 
// / /2/ / / / /r*   