Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @app.route("/data", methods=["GET"])
- def data():
- conn = e.connect()
- nelat = request.args["neLat"]
- nelng = request.args["neLng"]
- swlat = request.args["swLat"]
- swlng = request.args["swLng"]
- query = conn.execute("SELECT * FROM coordinates WHERE lat < ? AND lat > ? AND lng < ? AND lng > ?", [float(nelat), float(nelng), float(swlat), float(swlng)])
- result = {'data': [dict(zip(tuple (query.keys()) ,i)) for i in query.cursor]}
- jsonData = json.dumps(result)
- return jsonData
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement