From 0a3288ad7ed56d995f9e0c15527f1a3af9a6d757 Mon Sep 17 00:00:00 2001 From: Eugene Crosser Date: Wed, 27 Apr 2022 21:58:59 +0200 Subject: [PATCH] update mkgpx to the new api --- gps303/mkgpx.py | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) diff --git a/gps303/mkgpx.py b/gps303/mkgpx.py index 0d1fe89..40588a0 100644 --- a/gps303/mkgpx.py +++ b/gps303/mkgpx.py @@ -7,9 +7,8 @@ from .opencellid import qry_cell db = connect(sys.argv[1]) c = db.cursor() -c.execute( - "select timestamp, imei, clntaddr, length, proto, payload from events" -) +c.execute("select tstamp, packet from events where proto in ({})" + .format(", ".join([str(n) for n in (WIFI_POSITIONING.PROTO, WIFI_OFFLINE_POSITIONING.PROTO, GPS_POSITIONING.PROTO, GPS_OFFLINE_POSITIONING.PROTO)]))) print(""" """) -for timestamp, imei, clntaddr, length, proto, payload in c: - msg = make_object(length, proto, payload) +for tstamp, packet in c: + msg = parse_message(packet) if isinstance(msg, (WIFI_POSITIONING, WIFI_OFFLINE_POSITIONING)): lat, lon = qry_cell(sys.argv[2], msg.mcc, msg.gsm_cells) if lat is None or lon is None: @@ -31,7 +30,7 @@ for timestamp, imei, clntaddr, length, proto, payload in c: lat, lon = msg.latitude, msg.longitude else: continue - isotime = datetime.fromtimestamp(timestamp).astimezone(tz=timezone.utc).isoformat() + isotime = datetime.fromtimestamp(tstamp).astimezone(tz=timezone.utc).isoformat() isotime = isotime[:isotime.rfind(".")] + "Z" trkpt = """ @@ -39,7 +38,7 @@ for timestamp, imei, clntaddr, length, proto, payload in c: print(trkpt) if False: print( - datetime.fromtimestamp(timestamp) + datetime.fromtimestamp(tstamp) .astimezone(tz=timezone.utc) .isoformat(), msg, -- 2.39.2