get nearby stations from sqlite3 db

[pywienerlinien] / gotovienna / defaults.py

diff --git a/gotovienna/defaults.py b/gotovienna/defaults.py
index 5491e0d..9f5df69 100644 (file)
--- a/gotovienna/defaults.py
+++ b/gotovienna/defaults.py
@@ -15,6 +15,10 @@ if not path.exists(cache_folder):
 cache_lines = path.join(cache_folder, 'lines.json')
 cache_stations = path.join(cache_folder, 'stations.json')
 
+# SQL & GPS
+sql_gps_query = 'SELECT name FROM stations WHERE lat > ? and lat < ? and lon > ? and lon < ?'
+sql_file = path.expanduser('~/.gotovienna/stations.db')
+
 # iTip
 
 line_overview = 'http://www.wienerlinien.at/itip/linienwahl/'