U
    üf4  ã                   @   s>  d dl 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	j	 
¡ ZejZejZejZejZejZejZeejƒeejƒ d¡ eejƒ d¡ eejƒ d¡ eejƒ d¡ eejƒ d¡ Ze eddƒ¡ZeeƒZdddd	d
œZdd„ Zejddgd�dd„ ƒZdd„ Ze d¡dd„ ƒZ edk�r:ej!dddd� dS )é    )ÚflaskÚrequestÚjsonifyÚrender_templateNé   zrandom_forest_model_2.pklÚrbZ	localhostZbocahdaglog1989z
asikdeh!@#Zdbmental)ÚhostÚuserZpasswordZdatabasec              
   C   sx   zBt jjf tŽ}| ¡ }d}| || ¡ | ¡  | ¡  | ¡  W n0 t jjk
rr } zt	d|ƒ W 5 d }~X Y nX d S )Na  INSERT INTO tb_kuisioner (sekolah, tanggal, nama, jen_kel, age_14, kesehatan_msk, jumkamar_msk, jumorang_msk, jumkakak_lk_msk, jumkakak_pr_msk, jumadik_lk_msk, jumadik_pr_msk, asuransi_kes, kel_besar_14, prediksi) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)z)Failed to insert record into MySQL table:)
ÚmysqlÚ	connectorÚconnectÚ	db_configÚcursorÚexecuteZcommitÚcloseÚErrorÚprint)ÚdataÚ
connectionr   Zinsert_queryÚerror© r   ú"/var/www/html/prediksi/flaskApp.pyÚinsert_into_database%   s    r   ú/ZPOST)Úmethodsc                  C   s~  t j d¡} t j d¡}t j d¡}t j d¡}|dkr<d}t j d¡}|dkrTd}t j d¡}|dkrld}t j d	¡}|dkr„d}t j d
¡}|dkrœd}t j d¡}|dkr´d}t j d¡}	|	dkrÌd}	t j d¡}
|
dkräd}
t j d¡}|dkrüd}t j d¡}|dk�rd}t |||||||	|
||g
g¡}t |¡d }t|t| ||||||||	|
||t	|ƒfƒ t
dt	|ƒiƒS )NÚnamaÚjenkelÚsekolahÚage_14Ú r   Úkesehatan_mskÚjumkamar_mskÚjumorang_mskÚjumkakak_lk_mskÚjumkakak_pr_mskÚjumadik_lk_mskÚjumadik_pr_mskÚasuransi_kesÚkel_besar_14Z	placement)r   ZformÚgetÚnpZarrayÚmodelZpredictr   Údate_time_stringÚstrr   )r   r   r   r   r    r!   r"   r#   r$   r%   r&   r'   r(   Zinput_queryÚresultr   r   r   Úindex4   sJ    
 *r/   c              
   C   s~   zBt jjf tŽ}|jdd�}| | ¡ | ¡ }| ¡  | ¡  |W S  t jjk
rx } zt	d|ƒ W Y ¢d S d }~X Y nX d S )NT)Z
dictionaryz)Failed to fetch data from MySQL database:)
r
   r   r   r   r   r   Zfetchallr   r   r   )Z	sql_queryr   r   r.   r   r   r   r   Úget_data_from_databasep   s    

r0   z/rekamanc                  C   sh   d} t | ƒ}d}t |ƒ}d}t |ƒ}d}t |ƒ}d}t |ƒ}	d}
t |
ƒ}d}t |ƒ}d}t |ƒ}td	ƒS )
NzDSELECT jen_kel, COUNT(*) AS count FROM tb_kuisioner GROUP BY jen_kelzPSELECT kesehatan_msk, COUNT(*) AS count FROM tb_kuisioner GROUP BY kesehatan_mskzBSELECT age_14, COUNT(*) AS count FROM tb_kuisioner GROUP BY age_14z-SELECT age_14, jumkamar_msk FROM tb_kuisionerz6SELECT kesehatan_msk, jumadik_lk_msk FROM tb_kuisionerz8SELECT jumadik_pr_msk, jumkakak_pr_msk FROM tb_kuisionerzSELECT age_14 FROM tb_kuisionerzHSELECT kesehatan_msk, jumkakak_pr_msk, jumkakak_lk_msk FROM tb_kuisionerz	index.php)r0   r   )Zsql_query_barchartZdata_barchartZsql_query_piechartZdata_piechartZsql_query_linechartZdata_linechartZsql_query_boxplotZdata_boxplotZsql_query_scatterplotZdata_scatterplotZsql_query_heatmapZdata_heatmapZsql_query_histogramZdata_histogramZsql_query_radarchartZdata_radarchartr   r   r   Úrekaman}   s"    r1   Ú__main__Fiˆ  z0.0.0.0)ÚdebugZportr   )"r   r   r   r   Znumpyr*   ZpickleZmysql.connectorr
   ZdatetimeZnowZnowTimeZyearZmonthZdayZhourZminuteZsecondr-   Úzfillr,   ÚloadÚopenr+   ZFlaskÚ__name__Zappr   r   Zrouter/   r0   r1   Úrunr   r   r   r   Ú<module>   s6   
Zü
;
0
