1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
# coding: utf-8
import os
import time
import datetime
import calendar
import bottle
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from ebus.sql import model
app = bottle.Bottle("ebus")
bottle.debug()
engine = create_engine("postgresql://jack:jack@10.2.2.22:5432/ebus",echo=True)
Session = sessionmaker()
Session.configure(bind=engine)
@app.route("/")
def do_index():
return serve_static("index.html")
@app.route('/static/:filename')
def serve_static(filename):
return bottle.static_file(filename,
root=os.path.join(os.path.dirname(__file__),"static"))
@app.route("/list")
def list():
sensors = Session().query(model.Sensor).all()
return {"type":"list","data":map(lambda sensor: sensor.name, sensors)}
@app.route("/:when#today|yesterday|week|month#/:sensor")
def get_value(when,sensor):
s = Session()
sensor = s.query(model.Sensor).filter(model.Sensor.name == sensor).first()
values = Session().query(model.Value).add_columns("value_float","value_string","value_int")
values = values.filter(model.Value.sensor == sensor)
now = datetime.datetime.now()
f,t = None, None
if when == "today":
f = now.date()
t = now.date() + datetime.timedelta(1)
elif when == "yesterday":
f = now.date() - datetime.timedelta(1)
t = now
elif when == "week":
f = now.date() - datetime.timedelta(now.isoweekday())
t = now.date() + datetime.timedelta(7-now.isoweekday())
elif when == "month":
f = now.date() - datetime.timedelta(now.day)
t = f + datetime.timedelta( calendar.monthrange(f.year, f.month)[1] )
else:
raise Exception("illegal timerange")
values = values.filter(model.Value.timestamp.between(f,t))
x = values.all()
v=[]
for value in values.all():
v.append(value.value())
return {"type":when,"data":v}
|
