4203af5b81
Merge pull request 'Sort, filter, and limit results at /packets' (#23) from sort-filter into main
Like this from current dw logs and frontail. Fields like callsign, count, last heard, location, symbol?
Something like this (in current dw log going to frontail), but more interactive (sorting and filtering):
A lot of this work can be repurposed for #28, but I'll open a new PR for that.
Letting this branch run on the live system for a bit to see if anything breaks, then will close.
New field created_unix works. As a bonus, you can group vaguely by timestamp using a wildcard. For example, http://127.0.0.1:5001/packets?created_unix=1684029% captures values between…
You can also already pull limited time blocks using wildcards on created: http://127.0.0.1:5001/packets?created=2023-04% returns packets in April 2023.
To close #27, is it easier to query on timestamp or by the text version of created?
I added LIKE instead of =, which will let you do wildcards with % as in:
http://127.0.0.1:5001/packets?created=2023-04% or http://127.0.0.1:5001/packets?from=%UND%.
Excited about the latest commit, which allows you to query on any field in the frames table.
I'm not sure if you can do wildcards or not.
{'raw': 'K0UND-2>APDW16,WIDE1-1,WIDE2-1:}WLNK-1>APWLK,TCPIP,K0UND-2*::W1CDN-13 :ack1', 'from': 'K0UND-2', 'to': 'APDW16', 'path': ['WIDE1-1', 'WIDE2-1'], 'via': '', 'format': 'thirdparty',…On live code, moved the rest of the processing inside the try()...else() at
try: |
{'raw': 'K0UND-2>APDW16,WIDE2-1:!b69Ld5xIC# #UND SARA; undsara.org; 146.865 (-) 123.0', 'from': 'K0UND-2', 'to': 'APDW16', 'path': ['WIDE2-1'], 'via': '', 'messagecapable': False, 'format':…The query was ordering by row ID by default, I added ORDER BY created DESC.
Now messages don't work (unrelated to recent change):
{'raw': 'W1CDN-2>APQTH1,K0UND-2,WIDE2-2::W1CDN-2 :Test…The packets are still getting into the db, it's the query that is broken. Will have to rethink this when I have a moment.