U
    M®~ht  ã                   @   sj   d dl mZmZmZmZmZmZmZ d dlZd dl	Z	d dl
Z
d dlZeeƒZejdddgddd„ ƒZdS )	é    )ÚFlaskÚrender_templateÚrequestÚredirectÚurl_forÚsend_from_directoryÚResponseNú/ÚGETÚPOST)Úmethodsc                  C   s¼  zt jdddddd} W n< t jk
rT } ztd|› ƒ t d¡ W 5 d }~X Y nX | jd	d
}tj}| 	¡ }| 
d¡dkrltjdkr¶| d¡ | ¡ }ttj|dd	tdddS tjdkr¸tjd	d}d}|d |d |d |d |d |d |d |d |d |d |d  |d! |d" |d# |d$ |d% |d& |d' f}| ||¡ |  ¡  tt i ¡ddS nL| 
d¡d(krptjdkr´| d)¡ | ¡ }ttj|dd	tdddS tjdkr¸tjd	d}d*}| |¡ d+}|d, |d- |d. |d/ |d0 |d1 |d2 |d3 |d4 |d5 |d6 |d7 |d8 |d9 |d: |d; |d< f}| ||¡ |  ¡  tt i ¡ddS nH| 
d¡d=kr¸tjdkr¸| d>¡ | ¡ }ttj|dd	tdddS d S )?NZmichaldbZJakSeTiDari12z	127.0.0.1iê  Zskoula)ÚuserÚpasswordÚhostÚportZdatabasez&Error connecting to MariaDB Platform: é   T)Ú
dictionaryÚwhatZlasenar
   z-SELECT * FROM lasena ORDER BY id DESC LIMIT 1é   )ÚindentÚ	sort_keysÚdefaultzapplication/json)Úmimetyper   )Úforceaf  
            INSERT INTO lasena 
            (vchod, vchod_topi, obyvak, obyvak_topi, loznice, loznice_topi, pokoj_predni, pokoj_predni_topi, koupelna, koupelna_topi, pokoj_zadni, pokoj_zadni_topi, venku, rezim, time, garaz, pressure, full)
            VALUES 
            (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
            ZvchodZ
vchod_topiZobyvakZobyvak_topiZlozniceZloznice_topiZpokoj_predniZpokoj_predni_topiZkoupelnaZkoupelna_topiZpokoj_zadniZpokoj_zadni_topiZvenkuZrezimÚtimeZgarazZpressureÚfullZledtechz.SELECT * FROM ledtech ORDER BY id DESC LIMIT 1zÊ
            UPDATE ledtech
            SET outdoor_image_encoded = NULL, indoor_image_encoded = NULL
            WHERE outdoor_image_encoded IS NOT NULL OR indoor_image_encoded IS NOT NULL
            a‘  
            INSERT INTO ledtech 
            (indoor_temp, indoor_pressure, indoor_humidity, indoor_moisture, indoor_light, indoor_gas, outdoor_temp, outdoor_pressure, outdoor_humidity, outdoor_rain, cpu_temp, cpu_load, memory, hdd, updated, outdoor_image_encoded, indoor_image_encoded)
            VALUES 
            (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
            Zindoor_tempZindoor_pressureZindoor_humidityZindoor_moistureZindoor_lightZ
indoor_gasZoutdoor_tempZoutdoor_pressureZoutdoor_humidityZoutdoor_rainZcpu_tempZcpu_loadZmemoryZhddÚupdatedZoutdoor_image_encodedZindoor_image_encodedZdieselz-SELECT * FROM diesel ORDER BY id DESC LIMIT 1)ÚpymysqlÚconnectÚErrorÚprintÚsysÚexitÚcursorr   ÚargsÚto_dictÚgetÚmethodÚexecuteZfetchoner   ÚjsonÚdumpsÚstrÚget_jsonZcommit)ÚconnÚeÚcurr$   ÚresultZsqlÚvalZdelete_old_images_sql© r2   ú)C:\projects\skoula.cz\api\app\__init__.pyÚindex	   s¬    û

ÿîÿ
ïÿr4   )Úflaskr   r   r   r   r   r   r   r)   Zrequestsr   r!   Ú__name__ÚappÚrouter4   r2   r2   r2   r3   Ú<module>   s   $