X-Git-Url: http://www.average.org/gitweb/?p=loctrkd.git;a=blobdiff_plain;f=gps303%2Fqry.py;h=25f55aab75f1470d13ff0c59ba575c2eb6e5c0ad;hp=4aeb33c4a14ea3f9c8425ea2312e1d25775e3d43;hb=8bf5efdf4f5d069b108e6fd8140f5ebd930b538e;hpb=2cc29ee67b6432e1cd74a21b3c9181b8b5b557f9 diff --git a/gps303/qry.py b/gps303/qry.py index 4aeb33c..25f55aa 100644 --- a/gps303/qry.py +++ b/gps303/qry.py @@ -16,19 +16,24 @@ else: selector = "" c.execute( - "select tstamp, imei, peeraddr, proto, packet from events" + - selector, {"proto": proto} + "select tstamp, imei, peeraddr, proto, packet from events" + selector, + {"proto": proto}, ) for tstamp, imei, peeraddr, proto, packet in c: - if len(packet) > packet[0] + 1: - print("proto", packet[1] , "datalen", len(packet), - "msg.length", packet[0], file=sys.stderr) + if len(packet) > packet[0] + 1: + print( + "proto", + packet[1], + "datalen", + len(packet), + "msg.length", + packet[0], + file=sys.stderr, + ) msg = parse_message(packet) print( - datetime.fromtimestamp(tstamp) - .astimezone(tz=timezone.utc) - .isoformat(), + datetime.fromtimestamp(tstamp).astimezone(tz=timezone.utc).isoformat(), imei, peeraddr, msg,