def truck_data(truck_id): database.connect() query = TruckData.select() query = query.where(TruckData.truck_id == truck_id) query = query.order_by(TruckData.timestamp.desc()) data = [d.get_default_dict() for d in query] return json.dumps(data) database.close()
def location_data(lat, lon, radius): database.connect() # NOTE: the "radius" is a square threshold, not circular query = TruckData.select() query = query.where(TruckData.latitude > lat - radius) query = query.where(TruckData.latitude < lat + radius) query = query.where(TruckData.longitude > lon - radius) query = query.where(TruckData.longitude < lon + radius) query = query.order_by(TruckData.timestamp.desc()) data = [d.get_default_dict() for d in query] return json.dumps(data) database.close()
def all_data(): database.connect() query = TruckData.select().order_by(TruckData.timestamp.desc()) data = [d.get_default_dict() for d in query] return json.dumps(data) database.close()