139 lines
4.7 KiB
Python
Executable File
139 lines
4.7 KiB
Python
Executable File
#!/usr/bin/python3
|
|
# -*- coding: utf-8 -*-
|
|
"""
|
|
Created on Thu Aug 17 22:25:52 2017
|
|
|
|
@author: arofarn
|
|
"""
|
|
|
|
###########
|
|
# IMPORTS #
|
|
###########
|
|
|
|
from cameteo import *
|
|
from flask import render_template
|
|
from flask_bootstrap import Bootstrap
|
|
from flask_nav import Nav
|
|
from flask_nav.elements import *
|
|
import pandas as pd
|
|
from bokeh.plotting import figure
|
|
from bokeh.embed import components
|
|
from bokeh.models import ColumnDataSource
|
|
from bokeh.resources import INLINE
|
|
|
|
########
|
|
# MAIN #
|
|
########
|
|
|
|
bootstrap = Bootstrap(app)
|
|
|
|
nav = Nav()
|
|
nav.init_app(app)
|
|
|
|
navbar = Navbar('Camétéo',
|
|
View('Accueil', 'index'),
|
|
View('Toutes les données', 'all_data'),
|
|
Subgroup('Par données',
|
|
View("Température de l'air", 'by_data_type', dt='AT'),
|
|
View("Humidité relative", 'by_data_type', dt='RH'),
|
|
View("Pression atmosphérique (locale)", 'by_data_type', dt='AP'),
|
|
View("Pression atmosphérique (mer)", 'by_data_type', dt='MSLP'),
|
|
View("Altitude", 'by_data_type', dt='ALTI'),
|
|
),
|
|
Subgroup('Par capteur',
|
|
View("Capteur BME280", 'by_sensor', sens = 'AdaBME280_1')
|
|
),
|
|
Subgroup('Photos',
|
|
View('Dernière Photo', 'picture', num=0),
|
|
View('Première Photo', 'picture', num=999999999),
|
|
),
|
|
View('Configuration', 'config_page')
|
|
)
|
|
|
|
nav.register_element('top', navbar)
|
|
|
|
js_resources = INLINE.render_js()
|
|
css_resources = INLINE.render_css()
|
|
|
|
@app.route('/')
|
|
def index():
|
|
return render_template('index.html.j2')
|
|
|
|
@app.route('/picture=<num>')
|
|
def picture(num):
|
|
num=int(num)
|
|
if num < 0 :
|
|
num = 0
|
|
pictures = Photo.query.order_by(Photo.file_date.desc())
|
|
if num > pictures.count()-1:
|
|
num = pictures.count()-1
|
|
pict = pictures[num]
|
|
return render_template('photos.html.j2', picture_path = os.path.join("static/photos", pict.file_name), numero = num )
|
|
|
|
@app.route('/all_data')
|
|
def all_data():
|
|
date_deb = datetime.utcnow()-timedelta(seconds=3600)
|
|
res = Data.query.filter(Data.dbdate >= date_deb)
|
|
return render_template('data_viz.html.j2', dat=res.order_by(Data.dbdate.desc()).paginate(per_page=15))
|
|
|
|
@app.route('/type_id=<dt>')
|
|
def by_data_type(dt):
|
|
date_deb = datetime.now()-timedelta(hours=1)
|
|
#Récupération des données à afficher
|
|
q = Data.query.filter(Data.type_id == dt).filter(Data.dbdate >= date_deb).order_by(Data.valdate)
|
|
#q = Data.query.filter(Data.type_id == dt).order_by(Data.valdate)
|
|
res = pd.read_sql(q.selectable, db.engine)
|
|
|
|
plot_data = ColumnDataSource(data=dict(dates = res['data_valdate'], values = res['data_value']))
|
|
|
|
#Préparation du graphique
|
|
data_plot = figure(tools = "hover,pan,reset,save,wheel_zoom",
|
|
title = dt,
|
|
x_axis_label = 'Date',
|
|
x_axis_type = 'datetime',
|
|
y_axis_label = dt,
|
|
plot_height = 400,
|
|
plot_width = 1140,
|
|
)
|
|
data_plot.line('dates', 'values', source=plot_data, line_width=2)
|
|
|
|
script, div = components(data_plot)
|
|
|
|
return render_template('data_graph.html.j2',
|
|
data_type = dt,
|
|
dat=q.order_by(Data.dbdate.desc()).paginate(per_page=15),
|
|
plot_script=script,
|
|
plot_div=div,
|
|
js_resources=js_resources,
|
|
css_resources=css_resources,
|
|
)
|
|
|
|
@app.route('/sensor_id=<sens>')
|
|
def by_sensor(sens):
|
|
date_deb = datetime.utcnow()-timedelta(seconds=3600)
|
|
res = Data.query.filter(Data.sensor_id == sens).filter(Data.dbdate >= date_deb)
|
|
return render_template('data_viz.html.j2', dat=res.order_by(Data.dbdate.desc()).paginate(per_page=15))
|
|
|
|
@app.route('/configuration', methods=['GET', 'POST'])
|
|
def config_page():
|
|
|
|
if request.method == 'POST':
|
|
pass
|
|
else:
|
|
pass
|
|
|
|
return render_template('config_page.html.j2')
|
|
|
|
@app.route('/json_type_id=<dt>')
|
|
def json_by_data_type(dt):
|
|
date_deb = datetime.now()-timedelta(hours=1)
|
|
#Récupération des données à afficher
|
|
q = Data.query.filter(Data.type_id == dt).filter(Data.dbdate >= date_deb).order_by(Data.valdate)
|
|
#q = Data.query.filter(Data.type_id == dt).order_by(Data.valdate)
|
|
res = pd.read_sql(q.selectable, db.engine)
|
|
|
|
return res.to_json()
|
|
|
|
if __name__=="__main__":
|
|
app.run(host="0.0.0.0")
|