From 24c97de3b995e8871ebf8467dd860ba4b1572caf Mon Sep 17 00:00:00 2001 From: Javier Palacios Date: Thu, 1 Nov 2012 22:03:50 +0100 Subject: [PATCH] Drop sqared positions from database --- wifiscanner/wifimap/db.py | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) diff --git a/wifiscanner/wifimap/db.py b/wifiscanner/wifimap/db.py index e5a4c45..20645ce 100644 --- a/wifiscanner/wifimap/db.py +++ b/wifiscanner/wifimap/db.py @@ -9,10 +9,7 @@ create_db = """ n INTEGER DEFAULT 0, lat REAL DEFAULT 0, lon REAL DEFAULT 0, - alt REAL DEFAULT 0, - lat2 REAL DEFAULT 0, - lon2 REAL DEFAULT 0, - alt2 REAL DEFAULT 0 + alt REAL DEFAULT 0 ); """ @@ -53,9 +50,9 @@ class database : query = [] lat , lon , alt = gps if lat and lon : - query.append( "lat=lat+%f , lat2=lat2+%f , lon=lon+%f , lon2=lon2+%f" % ( lat , lat*lat , lon , lon*lon ) ) + query.append( "lat=lat+%f , lon=lon+%f" % ( lat , lon ) ) if alt : - query.append( "alt=alt+%f , alt2=alt2+%f" % ( alt , alt*alt ) ) + query.append( "alt=alt+%f" % ( alt ) ) return " , ".join( query ) def add ( self , mac , rss , timestamp , gps ) : -- 1.7.9.5