
    扦jV                         S SK JrJrJr  S SKrS SKr\" 5       rSrSr\" S5      4S\	4S jjr
\R                  S5      \" S5      4S\	4S	 jj5       r\R                  S
5      \" S5      4S\	4S jj5       rg)    )FastAPIHeaderHTTPExceptionN;c5a0b5c4467c56f25c84918906546868bfcd4427b9caaf6bd9151ba3192z/home/louj/iot/iot.db.	x_api_keyc                 ,    U [         :w  a
  [        SSS9eg )Ni  u   Non autoriséstatus_codedetail)API_KEYr   )r   s    /home/louj/iot/api.pyverifier_cler   	   s    GODD     z/temperaturec                    [        U 5        [        R                  " [        5      nUR	                  S5      R                  5       nUR                  5         Uc
  [        SSS9eUS   [        [        R                  " 5       US   -
  5      S.$ )NzaSELECT valeur, timestamp FROM mesures WHERE capteur='temperature' ORDER BY timestamp DESC LIMIT 1     Aucune donnée disponibler	   r      )temperatureil_y_a_secondes
r   sqlite3connectDB_PATHexecutefetchonecloser   roundtimer   connrows      r   get_temperaturer"      st    ??7#D
,,khj  	JJL
{4OPPq6eDIIK#a&<P6QRRr   z/niveau_eauc                    [        U 5        [        R                  " [        5      nUR	                  S5      R                  5       nUR                  5         Uc
  [        SSS9eUS   [        [        R                  " 5       US   -
  5      S.$ )Nz`SELECT valeur, timestamp FROM mesures WHERE capteur='niveau_eau' ORDER BY timestamp DESC LIMIT 1r   r   r	   r   r   )
niveau_eaur   r   r   s      r   
get_niveaur%      st    ??7#D
,,jhj  	JJL
{4OPPa&U499;Q;O5PQQr   )fastapir   r   r   r   r   appr   r   strr   getr"   r%    r   r   <module>r+      s    2 2  i
G
!"(+ EC E %+C[ 	Ss 	S 	S  &s 	R# 	R 	Rr   