Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. @app.route("/data", methods=["GET"])
  2. def data():
  3. conn = e.connect()
  4. nelat = request.args["neLat"]
  5. nelng = request.args["neLng"]
  6. swlat = request.args["swLat"]
  7. swlng = request.args["swLng"]
  8. query = conn.execute("SELECT * FROM coordinates WHERE lat < ? AND lat > ? AND lng < ? AND lng > ?", [float(nelat), float(nelng), float(swlat), float(swlng)])
  9. result = {'data': [dict(zip(tuple (query.keys()) ,i)) for i in query.cursor]}
  10. jsonData = json.dumps(result)
  11. return jsonData
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement