def _on_finish(db):
try:
status = ErrorCode.SUCCESS
self.db = db
res = []
stop = []
track = []
track_sample = UWEB.TRACK_SAMPLE.NO
# 2014.08.01 a week.
if ((start_time < LIMIT.MASS_POINT_QUERY_TIME) and
((end_time - start_time) > LIMIT.MASS_POINT_QUERY_INTERVAL)):
status = ErrorCode.MASS_POINT_QUERY_EXCESS
self.write_ret(status)
self.finish()
return
for item in range(days):
timestamp = start_time + 1 * 60 * 60 * 24 * (item)
date = get_date_from_utc(timestamp)
year, month, day = date.year, date.month, date.day
start_time_, end_time_ = start_end_of_day(
year=year, month=month, day=day)
# NOTE: handle for the first and last point
if item == 0:
start_time_ = start_time
elif item == days - 1:
end_time_ = end_time
if cellid_flag == 1: # cellid
track = self.get_track(
tid, start_time_, end_time_, cellid=True)
else: # gps
# cellid_flag is None or 0, only gps track
track = self.get_track(
tid, start_time_, end_time_, cellid=False)
if track:
last_point = track[-1]
last_point = get_locations_with_clatlon(
[last_point], self.db)[0]
distance = self.get_track_distance(track)
r = dict(timestamp=last_point.timestamp,
distance=distance,
latitude=last_point.latitude,
longitude=last_point.longitude,
clatitude=last_point.clatitude,
clongitude=last_point.clongitude,
name=self.get_track_name(last_point))
else:
r = dict(timestamp=end_time_,
distance=0,
latitude=0,
longitude=0,
clatitude=0,
clongitude=0,
name=u'')
res.append(r)
if cellid_flag == 1: # cellid
track = self.get_track(
tid, start_time, end_time, cellid=True)
else: # gps
# cellid_flag is None or 0, only gps track
track = self.get_track(
tid, start_time, end_time, cellid=False)
if len(track) > LIMIT.MASS_POINT_NUMBER: # > 1000
track_sample = UWEB.TRACK_SAMPLE.YES
track = get_sampled_list(track, LIMIT.MASS_POINT_NUMBER)
stop = self.get_stop_point(tid, start_time, end_time)
res.reverse()
stop.reverse()
self.write_ret(status,
dict_=DotDict(res=res,
stop=stop,
track=track,
track_sample=track_sample))
self.finish()
except Exception as e:
status = ErrorCode.SERVER_BUSY
logging.exception("[UWEB] Mass-point day request failed. "
" uid: %s, tid: %s. Exception: %s.",
self.current_user.uid, tid, e.args)
self.write_ret(status)
self.finish()
def _on_finish(db):
try:
status = ErrorCode.SUCCESS
self.db = db
track = []
track_sample = UWEB.TRACK_SAMPLE.NO
stop = []
start = {}
end = {}
# 2014.08.01 a week.
if start_time < LIMIT.MASS_POINT_QUERY_TIME and (end_time-start_time) > LIMIT.MASS_POINT_QUERY_INTERVAL:
status = ErrorCode.MASS_POINT_QUERY_EXCESS
self.write_ret(status,
dict_=DotDict(track=track,
stop=stop,
start=start,
end=end))
self.finish()
return
if cellid_flag == 1: # cellid
track = self.get_track(tid, start_time, end_time, cellid=True)
else: # gps
# cellid_flag is None or 0, only gps track
track = self.get_track(tid, start_time, end_time, cellid=False)
if track:
# NOTE: if latlons are legal, but clatlons are illlegal, offset
# them and update them in db.
_start_time = time.time()
track = get_locations_with_clatlon(track, self.db)
_now_time = time.time()
if _now_time - _start_time > 3: # 3 seconds
logging.info("[UWEB] Track offset used time: %s s, tid: %s, cid: %s",
_now_time - _start_time, tid, self.current_user.cid)
# NOTE: filter point without valid clat and clon
_track = []
for t in track:
if t['clongitude'] and ['clatitude']:
_track.append(t)
else:
logging.info("[UWEB] Invalid point: %s, drop it, cid: %s",
t, self.current_user.cid)
track = _track
stop = self.get_stop_point(tid, start_time, end_time)
if stop: # some handle for the stop
oldest_stop = stop[0]
newest_stop = stop[-1]
starts = self.get_track(tid, start_time, newest_stop['start_time'])
if starts:
distance = self.get_track_distance(starts)
lid=starts[0]['id']
location = self.db.get("SELECT * FROM T_LOCATION"
" WHERE id = %s AND tid = %s LIMIT 1",
lid, tid)
_start_time=starts[0]["timestamp"]
_end_time=starts[-1]["timestamp"]
start = dict(lid=lid,
tid=tid,
start_time=_start_time,
end_time=0,
idle_time=abs(_end_time-_start_time),
name=self.get_track_name(location),
longitude=location['longitude'],
latitude=location['latitude'],
clongitude=location['clongitude'],
clatitude=location['clatitude'],
distance=distance)
oldest_stop['distance'] = self.get_track_distance(
self.get_track( tid,
start['start_time'],
oldest_stop['start_time']))
ends = self.get_track(tid, newest_stop['start_time'], end_time)
if ends:
lid=ends[-1]['id']
location = self.db.get("SELECT * FROM T_LOCATION"
" WHERE id = %s",
lid)
_start_time=ends[-1]["timestamp"]
_end_time=int(time.time())
end = dict(lid=lid,
tid=tid,
start_time=_start_time,
end_time=_end_time,
idle_time=abs(_end_time-_start_time),
name=self.get_track_name(location),
longitude=location['longitude'],
latitude=location['latitude'],
clongitude=location['clongitude'],
clatitude=location['clatitude'],
distance=0)
#NOTE: special handle for end time
end['distance'] = self.get_track_distance(
self.get_track(tid,
newest_stop['start_time'],
end['start_time']))
#NOTE: last point is a stop
if newest_stop['end_time'] == 0:
#if location['speed'] < LIMIT.SPEED_LIMIT: # may be stop
if location['speed'] <= LIMIT.SPEED_LIMIT: # may be stop
# end_time of last one of track is useless
newest_stop['end_time'] = end['start_time']
newest_stop['name'] = end['name']
newest_stop['idle_time'] = abs(newest_stop['end_time']-newest_stop['start_time'])
newest_stop['distance'] = newest_stop['distance'] + self.get_track_distance(
self.get_track(tid,
newest_stop['start_time'],
end['start_time']))
# special handle for the last point
newest_stop['start_time'] = end['start_time']
end = newest_stop
stop.pop()
else: # it should never happpen
pass
# full the stop
for item in stop:
#NOTE: end_time is should be bigger than start_time
item['idle_time'] = abs(item['end_time']-item['start_time'])
if item.name is None:
name = self.get_track_name(item)
if start and stop:
if start['start_time'] == oldest_stop['start_time']:
start = {}
if end and stop:
if end['start_time'] == newest_stop['start_time']:
end = {}
if track and (not stop):
start = dict(lid=track[0]['id'],
tid=tid,
start_time=track[0]['timestamp'],
end_time=0,
idle_time=0,
name=self.get_track_name(track[0]),
longitude=track[0]['longitude'],
latitude=track[0]['latitude'],
clongitude=track[0]['clongitude'],
clatitude=track[0]['clatitude'],
distance=0)
end = dict(lid=track[-1]['id'],
tid=tid,
start_time=track[-1]['timestamp'],
end_time=0,
idle_time=0,
name=self.get_track_name(track[-1]),
longitude=track[-1]['longitude'],
latitude=track[-1]['latitude'],
clongitude=track[-1]['clongitude'],
clatitude=track[-1]['clatitude'],
distance=0)
end['distance'] = self.get_track_distance(
self.get_track(tid,
start['start_time'], end['start_time']))
# special handle for the newest stop
if stop and end:
if stop[-1]['end_time'] > end['start_time']:
stop[-1]['end_time'] = end['start_time']
stop[-1]['idle_time'] = abs(end['start_time']-stop[-1]['start_time'])
# modify name & degere
for item in track:
item['degree'] = float(item['degree'])
# if start is equal end, just provide start
if start and end:
if start['start_time'] == end['start_time']:
end = {}
if len(track) > LIMIT.MASS_POINT_NUMBER: # > 1000
track_sample = UWEB.TRACK_SAMPLE.YES
track = get_sampled_list(track, LIMIT.MASS_POINT_NUMBER)
logging.info("[UEB] Tid:%s mass point query, returned %s points.", tid, len(track))
# reverse the stop
stop.reverse()
# NOTE: replace null with ''
for item in track:
if item.name is None:
item['name'] = ''
self.write_ret(status,
dict_=DotDict(track=track,
track_sample=track_sample,
stop=stop,
start=start,
end=end))
self.finish()
except Exception as e:
status = ErrorCode.SERVER_BUSY
logging.exception("[UWEB] Mass-point basic request failed. uid: %s, tid: %s. Exception: %s.",
self.current_user.uid, tid, e.args )
self.write_ret(status)
self.finish()
