Work with cell location data; use opencellid

[loctrkd.git] / gps303 / qry.py

diff --git a/gps303/qry.py b/gps303/qry.py
index 2d4889921334e452226ec09faa04826fcc66ec6a..2a8e266351d5a4c6932d7b16f61a59fe20ad45e8 100644 (file)
--- a/gps303/qry.py
+++ b/gps303/qry.py
@@ -1,4 +1,4 @@
-from datetime import datetime
+from datetime import datetime, timezone
 from sqlite3 import connect
 import sys
 
@@ -6,7 +6,13 @@ from .GT06mod import *
 
 db = connect(sys.argv[1])
 c = db.cursor()
-c.execute("select timestamp, imei, clntaddr, proto, payload from events")
-for timestamp, imei, clntaddr, proto, payload in c:
-    print(datetime.fromtimestamp(timestamp).isoformat(),
-            make_object(proto, payload))
+c.execute(
+    "select timestamp, imei, clntaddr, length, proto, payload from events"
+)
+for timestamp, imei, clntaddr, length, proto, payload in c:
+    print(
+        datetime.fromtimestamp(timestamp)
+        .astimezone(tz=timezone.utc)
+        .isoformat(),
+        make_object(length, proto, payload),
+    )