X-Git-Url: http://average.org/gitweb/?a=blobdiff_plain;f=gps303%2Fqry.py;h=17228c650b3a67148bfbfb96a26ef6bc4874bcd1;hb=97c5fc86f9fbab5df74879b9b2a705dbb8dcba63;hp=76df8f223397eacaf53cda0b00c9390bede4a43d;hpb=8be4295a5027349ebbf5242d131c5a942181f7a6;p=loctrkd.git diff --git a/gps303/qry.py b/gps303/qry.py index 76df8f2..17228c6 100644 --- a/gps303/qry.py +++ b/gps303/qry.py @@ -2,7 +2,7 @@ from datetime import datetime, timezone from sqlite3 import connect import sys -from .gps303proto import * +from .gps303proto import parse_message, proto_by_name db = connect(sys.argv[1]) c = db.cursor() @@ -16,15 +16,17 @@ else: selector = "" c.execute( - "select timestamp, imei, clntaddr, length, proto, payload from events" + + "select tstamp, imei, peeraddr, proto, packet from events" + selector, {"proto": proto} ) -for timestamp, imei, clntaddr, length, proto, payload in c: - msg = make_object(length, proto, payload) +for tstamp, imei, peeraddr, proto, packet in c: + msg = parse_message(packet) print( - datetime.fromtimestamp(timestamp) + datetime.fromtimestamp(tstamp) .astimezone(tz=timezone.utc) .isoformat(), + imei, + peeraddr, msg, )