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))