gps303/qry.py

   1 from datetime import datetime, timezone
   2 from sqlite3 import connect
   3 import sys
   4
   5 from .GT06mod import *
   6
   7 db = connect(sys.argv[1])
   8 c = db.cursor()
   9 c.execute(
  10     "select timestamp, imei, clntaddr, length, proto, payload from events"
  11 )
  12 for timestamp, imei, clntaddr, length, proto, payload in c:
  13     print(
  14         datetime.fromtimestamp(timestamp)
  15         .astimezone(tz=timezone.utc)
  16         .isoformat(),
  17         make_object(length, proto, payload),
  18     )