def get(self, datestr):
session = Session()
M = make_table_model("skylight")
res = session.execute(
"select sum(count) ,datetime from skylight where date(datetime) = '%s' group by datetime" % datestr
).fetchall()
res = [(str(r[1]), int(r[0])) for r in res]
res = json.dumps(res)
self.render("chart/tmp.html", res=res)
