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('camera') if keyname is not None: cam = CameraSource.get(db.Key(keyname)) else: self.error(500) return period = self.request.get('period') q2 = CameraEvent.all() q2.filter("camera_id =", cam.key()).filter("deleted =", False).order("-event_start") if period == "today": q2.filter("event_start >=", datetime.now().replace(hour=0,minute=0,second=0)) elif period == "yesterday": q2.filter("event_start >=", datetime.now().replace(hour=0,minute=0,second=0) - timedelta(days=1)) q2.filter("event_start <", datetime.now().replace(hour=0,minute=0,second=0)) elif period == "week": startofweek = datetime.now().replace(hour=0, minute=0, second=0) - timedelta(days=datetime.now().isoweekday() % 7) q2.filter("event_start >=", startofweek) elif period == "month": #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) q2.filter("event_start >=", startofmonth) elif period == "all": pass else: return #cam.total = q2.count() results = q2.fetch(1000) for event in results: event.duration_text = (event.event_end - event.event_start) template_values = { 'user': users.get_current_user(), 'logout_url': users.create_logout_url('/'), 'camera': cam, 'eventlist': results, 'timenow': datetime.utcnow(), } path = os.path.join(os.path.dirname(__file__), 'inc/browse.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))