def get(self):
numDeleted = 0
try:
# Look for CameraEvents marked deleted
q = CameraEvent.all()
q.filter("deleted =",True)
for event in q.fetch(10):
# Delete any frames belonging to this deleted CameraSource.
q2 = CameraFrame.all()
q2.filter("event_id =", event.key())
if q2.count() > 0:
for frame in q2.fetch(500):
frame.delete()
numDeleted += 1
else:
# No more frames belonging to this event, so delete it too.
event.delete()
numDeleted += 1
# Look for CameraSources marked deleted
q = CameraSource.all()
q.filter("deleted =",True)
for cam in q.fetch(10):
# Mark any events belonging to this deleted CameraSource as deleted.
q2 = CameraEvent.all()
q2.filter("camera_id =", cam.key()).filter("deleted =",False)
for event in q2.fetch(100):
numDeleted += 1
event.deleted = True
event.put()
# Delete any frames belonging to this deleted CameraSource.
q2 = CameraFrame.all()
q2.filter("camera_id =", cam.key())
for frame in q2.fetch(500):
frame.delete()
numDeleted += 1
# Only delete the camera itself if nothing else needed to be done.
if numDeleted == 0:
cam.delete()
numDeleted += 1
except DeadlineExceededError:
pass
self.response.headers['Content-Type'] = 'text/plain'
self.response.out.write("Deleted %d objects." % numDeleted)
def get(self):
keyname = self.request.get('event')
if keyname is None:
self.error(500)
self.response.out.write("missing event")
return
event = CameraEvent.get(db.Key(keyname))
if event is None or event.deleted == True:
self.error(404)
self.response.out.write("unknown event")
return
if not event.viewed:
event.viewed = True
event.put()
q2 = CameraFrame.all()
#q2.filter("event_id =", event.key()).order("image_time")
q2.filter("camera_id =", event.camera_id).filter("image_time >=", event.event_start).filter("image_time <=", event.event_end).order("image_time")
template_values = {
'user': users.get_current_user(),
'logout_url': users.create_logout_url('/'),
'event': event,
'framelist': q2.fetch(100),
'timenow': datetime.utcnow(),
}
path = os.path.join(os.path.dirname(__file__), 'inc/imgseq.html')
self.response.out.write(template.render(path, template_values))
def get(self):
q = CameraSource.all()
q.filter("deleted =", False).order("-creation_time")
results = q.fetch(MAX_CAMERAS)
startofweek = datetime.now().replace(hour=0, minute=0, second=0) - timedelta(days=datetime.now().isoweekday() % 7)
#startofmonth = datetime.now().replace(day=1,hour=0,minute=0,second=0)
startofmonth = datetime.now().replace(hour=0, minute=0, second=0) - timedelta(days=30)
startofyesterday = datetime.now().replace(hour=0,minute=0,second=0) - timedelta(days=1)
startoftoday = datetime.now().replace(hour=0,minute=0,second=0)
for cam in results:
# Generate a human-readable status indicator.
# TODO: cam.enabled, cam.last_poll_time, cam.last_poll_result
if not cam.enabled:
cam.status_text = "Disabled"
else:
lastimg_time = memcache.get("camera{%s}.lastimg_time" % cam.key())
if lastimg_time is None:
cam.status_text = "Enabled, but not recently polled"
else:
td = (datetime.now() - lastimg_time)
cam.status_text = "Enabled, polled %s ago" % td
# TODO: deleted frames should not be included in these counts.
qf = CameraFrame.all(keys_only=True)
qf.filter("camera_id =", cam.key())
qe = CameraEvent.all(keys_only=True)
qe.filter("deleted =", False).filter("camera_id =", cam.key())
cam.ftotal = qf.count()
cam.etotal = qe.count()
qf.filter("image_time >=", startofmonth)
qe.filter("event_start >=", startofmonth)
cam.fthismonth = qf.count()
cam.ethismonth = qe.count()
qf.filter("image_time >=", startofweek)
qe.filter("event_start >=", startofweek)
cam.fthisweek = qf.count()
cam.ethisweek = qe.count()
qf.filter("image_time >=", startoftoday)
qe.filter("event_start >=", startoftoday)
cam.ftoday = qf.count()
cam.etoday = qe.count()
qf = CameraFrame.all(keys_only=True)
qf.filter("camera_id =", cam.key())
qf.filter("image_time >=", startofyesterday)
qf.filter("image_time <", startoftoday)
qe = CameraEvent.all(keys_only=True)
qe.filter("deleted =", False)
qe.filter("camera_id =", cam.key())
qe.filter("event_start >=", startofyesterday)
qe.filter("event_start <", startoftoday)
cam.fyesterday = qf.count()
cam.eyesterday = qe.count()
template_values = {
'user': users.get_current_user(),
'logout_url': users.create_logout_url('/'),
'camlist': results,
'timenow': datetime.utcnow(),
}
path = os.path.join(os.path.dirname(__file__), 'inc/summary.html')
self.response.out.write(template.render(path, template_values))
