gps303/qry.py

   1 from datetime import datetime
   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("select timestamp, imei, clntaddr, proto, payload from events")
  10 for timestamp, imei, clntaddr, proto, payload in c:
  11     print(datetime.fromtimestamp(timestamp).isoformat(),
  12             make_object(proto, payload))