def __init__(self, entkey, rkey):
super(AlarmReportWorker, self).__init__(rkey,
start_att="dt_start",
start_att_direction="")
self.enterprise = self.report.enterprise
self.FILTERS = [("enterprise =", self.enterprise)]
specs = self.report.getSpecs()
start = specs.get("start", 0)
end = specs.get("end", 0)
if start:
self.FILTERS.append(("dt_start >=", tools.dt_from_ts(start)))
if end:
self.FILTERS.append(("dt_start <", tools.dt_from_ts(end)))
self.report.generate_title("Alarm Report", ts_start=start, ts_end=end)
self.sensor_lookup = tools.lookupDict(
Sensor,
self.enterprise.sensor_set.fetch(limit=200),
valueTransform=lambda s: s.name,
keyprop="key_name")
self.rule_lookup = tools.lookupDict(
Rule, self.enterprise.rule_set.fetch(limit=100))
self.headers = [
"Alarm ID", "Sensor ID", "Sensor", "Rule ID", "Rule", "Apex",
"Start", "End"
]
def __init__(self, entkey, rkey):
super(AlarmReportWorker, self).__init__(rkey, start_att="dt_start", start_att_direction="-")
self.enterprise = self.report.enterprise
self.FILTERS = [("enterprise =", self.enterprise)]
self.report.title = "Alarm Report [ %s ]" % (self.enterprise)
# specs = self.report.getSpecs()
# ts_start = specs.get("ts_start", 0)
# ts_end = specs.get("ts_end", 0)
# if ts_start:
# self.FILTERS.append(("dt_start >=", tools.dt_from_ts(ts_start)))
# if ts_end:
# self.FILTERS.append(("dt_start <", tools.dt_from_ts(ts_end)))
self.sensor_lookup = tools.lookupDict(Sensor, self.enterprise.sensor_set.fetch(limit=100))
self.rule_lookup = tools.lookupDict(Rule, self.enterprise.rule_set.fetch(limit=100))
self.headers = ["Sensor","Rule","Apex","Start","End"]
def __init__(self, entkey, rkey):
super(AlarmReportWorker, self).__init__(rkey, start_att="dt_start", start_att_direction="-")
self.enterprise = self.report.enterprise
self.FILTERS = [("enterprise =", self.enterprise)]
specs = self.report.getSpecs()
start = specs.get("start", 0)
end = specs.get("end", 0)
if start:
self.FILTERS.append(("dt_start >=", tools.dt_from_ts(start)))
if end:
self.FILTERS.append(("dt_start <", tools.dt_from_ts(end)))
self.report.generate_title("Alarm Report", ts_start=start, ts_end=end)
self.sensor_lookup = tools.lookupDict(Sensor, self.enterprise.sensor_set.fetch(limit=200), valueTransform=lambda s : s.name)
self.rule_lookup = tools.lookupDict(Rule, self.enterprise.rule_set.fetch(limit=100))
self.headers = ["Sensor","Rule","Apex","Start","End"]
def __init__(self, entkey, rkey):
super(AnalysisReportWorker, self).__init__(rkey,
start_att="dt_created",
start_att_direction="")
self.enterprise = self.report.enterprise
self.FILTERS = [("enterprise =", self.enterprise)]
specs = self.report.getSpecs()
start = specs.get("start", 0)
end = specs.get("end", 0)
self.columns = specs.get('columns', [])
if isinstance(self.columns, basestring):
self.columns = self.columns.split(',')
sensortype_id = specs.get("sensortype_id")
self.report.generate_title("Analysis Report",
ts_start=start,
ts_end=end,
sensortype_id=sensortype_id)
if start:
self.FILTERS.append(("dt_created >=", tools.dt_from_ts(start)))
if end:
self.FILTERS.append(("dt_created <", tools.dt_from_ts(end)))
if sensortype_id:
self.FILTERS.append(("sensortype =",
db.Key.from_path('Enterprise',
self.enterprise.key().id(),
'SensorType',
int(sensortype_id))))
self.sensor_lookup = tools.lookupDict(
Sensor,
self.enterprise.sensor_set.fetch(limit=200),
valueTransform=lambda s: s.name)
self.headers = ["Key", "Sensor", "Created", "Updated"] + self.columns
def testLookupDicts(self):
user1 = User.Create(email="*****@*****.**", name="Person 1")
user1.put()
user2 = User.Create(email="*****@*****.**", name="Person 2")
user2.put()
lookup = tools.lookupDict([user1, user2], keyprop="key_string")
u1_key = user1.key.urlsafe()
u2_key = user2.key.urlsafe()
self.assertTrue(u1_key in lookup)
self.assertTrue(u2_key in lookup)
self.assertEqual(lookup.get(u1_key).name, "Person 1")
def testLookupDicts(self):
user1 = User.Create(email="*****@*****.**", name="Person 1")
user1.put()
user2 = User.Create(email="*****@*****.**", name="Person 2")
user2.put()
lookup = tools.lookupDict([user1, user2], keyprop="key_string")
u1_key = user1.key.urlsafe()
u2_key = user2.key.urlsafe()
self.assertTrue(u1_key in lookup)
self.assertTrue(u2_key in lookup)
self.assertEqual(lookup.get(u1_key).name, "Person 1")
def range(self, d):
'''
Return recent days of all active habits
'''
start = self.request.get('start_date')
end = self.request.get('end_date')
habits = Habit.Active(self.user)
habitdays = HabitDay.Range(self.user, habits, tools.fromISODate(start), until_date=tools.fromISODate(end))
self.set_response({
'habits': [habit.json() for habit in habits],
'habitdays': tools.lookupDict(habitdays,
keyprop="key_id",
valueTransform=lambda hd: hd.json())
}, success=True)
def recent(self, d):
'''
Return recent days of all active habits
'''
self.success = True
days = self.request.get_range('days', default=5)
habits = Habit.Active(self.user)
start_date = datetime.today() - timedelta(days=days)
habitdays = HabitDay.Range(self.user, habits, start_date)
self.set_response({
'habits': [habit.json() for habit in habits],
'habitdays': tools.lookupDict(habitdays,
keyprop="key_id",
valueTransform=lambda hd: hd.json())
})
def __init__(self, entkey, rkey):
super(AnalysisReportWorker, self).__init__(rkey, start_att="dt_created", start_att_direction="-")
self.enterprise = self.report.enterprise
self.FILTERS = [("enterprise =", self.enterprise)]
specs = self.report.getSpecs()
start = specs.get("start", 0)
end = specs.get("end", 0)
self.columns = specs.get("columns", "").split(",")
sensortype_id = specs.get("sensortype_id")
self.report.generate_title("Analysis Report", ts_start=start, ts_end=end, sensortype_id=sensortype_id)
if start:
self.FILTERS.append(("dt_created >=", tools.dt_from_ts(start)))
if end:
self.FILTERS.append(("dt_created <", tools.dt_from_ts(end)))
if sensortype_id:
self.FILTERS.append(("sensortype =", db.Key.from_path('Enterprise', self.enterprise.key().id(), 'SensorType', int(sensortype_id))))
self.sensor_lookup = tools.lookupDict(Sensor, self.enterprise.sensor_set.fetch(limit=200), valueTransform=lambda s : s.name)
self.headers = ["Key","Sensor","Created","Updated"] + self.columns
def get(self, d):
# TODO: Async fetches
with_habits = self.request.get_range('with_habits', default=0) == 1
with_tracking = self.request.get_range('with_tracking', default=1) == 1
with_goals = self.request.get_range('with_goals', default=1) == 1
with_tasks = self.request.get_range('with_tasks', default=1) == 1
date_start = self.request.get('date_start')
date_end = self.request.get('date_end')
dt_start, dt_end = tools.fromISODate(date_start), tools.fromISODate(
date_end)
iso_dates = []
habits = []
today = datetime.today()
habitdays = []
goals = []
journals, iso_dates = MiniJournal.Fetch(self.user, dt_start, dt_end)
if with_habits:
habits = Habit.Active(self.user)
habitdays = HabitDay.Range(self.user, habits, dt_start, dt_end)
if with_tracking:
tracking_days = TrackingDay.Range(self.user, dt_start, dt_end)
if with_goals:
goals = Goal.Year(self.user, today.year)
if with_tasks:
tasks = Task.DueInRange(self.user, dt_start, dt_end, limit=100)
self.set_response(
{
'dates':
iso_dates,
'journals': [j.json() for j in journals if j],
'habits': [h.json() for h in habits],
'goals': [g.json() for g in goals],
'tasks': [t.json() for t in tasks],
'tracking_days': [p.json() for p in tracking_days],
'habitdays':
tools.lookupDict(habitdays,
keyprop="key_id",
valueTransform=lambda hd: hd.json())
},
success=True)
def _maybe_get_habits(self):
if self.habits is None:
self.habits = tools.lookupDict(Habit.Active(self.user), "key_id")
def _maybe_get_habits(self):
if self.habits is None:
self.habits = tools.lookupDict(Habit.Active(self.user), "key_id")