Python TruckData示例

示例#1

文件： api.py 项目： athas/architecture-course-project

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

示例#2

文件： api.py 项目： Athas/architecture-course-project

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

示例#3

文件： api.py 项目： athas/architecture-course-project

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

示例#4

文件： api.py 项目： Athas/architecture-course-project

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

示例#5

def recent_data():
    database.connect()
    collected = []
    for truck, points in json.loads(request.data).iteritems():
        for time, coords in points.iteritems():
            new = TruckData()
            new.timestamp = float(time)
            new.truck_id = int(truck)
            new.latitude = float(coords[0])
            new.longitude = float(coords[1])
            new.save()
            collected.append(new)

    database.close()
    return "success"

示例#6

文件： aggregator.py 项目： Athas/architecture-course-project

def recent_data():
    database.connect()
    collected = []
    for truck, points in json.loads(request.data).iteritems():
        for time, coords in points.iteritems():
            new = TruckData()
            new.timestamp = float(time)
            new.truck_id = int(truck)
            new.latitude = float(coords[0])
            new.longitude = float(coords[1])
            new.save()
            collected.append(new)

    database.close()
    return "success"

示例#7

文件： api.py 项目： athas/architecture-course-project

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

示例#8

文件： api.py 项目： Athas/architecture-course-project

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