Matt W1CDN
  • Joined on 2023-04-08
W1CDN opened issue W1CDN/aprs_tool#37 2023-07-12 14:42:22 -05:00
KISS connection seems unstable
W1CDN commented on pull request W1CDN/aprs_tool#30 2023-07-09 22:19:12 -05:00
Add status page

Eh, the times work for now.

Still need to figure out relative paths, though. Works on dev but not on production.

# this should work: stations = json.loads(requests.get(url_for("stations"…
W1CDN commented on pull request W1CDN/aprs_tool#30 2023-07-09 11:45:01 -05:00
Add status page

Need to access the stations list via a new API endpoint.

This should give dates in the right format. Top table here uses API, bottom is raw db query results: ![image](/attachments/c07bb3a2-de0…

W1CDN commented on pull request W1CDN/aprs_tool#30 2023-07-09 10:17:31 -05:00
Add status page

Stations table update seems to work now. Need to query the stations table at index.html rather than doing the math on the frames table.

W1CDN commented on pull request W1CDN/aprs_tool#30 2023-07-08 21:57:46 -05:00
Add status page

Got test_db.py as an example for upsert code. Added the stations table definition to schema.sql so I can track changes there.

Will have to manually fill in the table to match what I have in my…

W1CDN commented on pull request W1CDN/aprs_tool#30 2023-06-28 17:30:09 -05:00
Add status page

This packet isn't included, why? image

W1CDN opened issue W1CDN/aprs_tool#34 2023-06-28 11:32:24 -05:00
Report whether direwolf KISS connection is active or not
W1CDN commented on issue W1CDN/aprs_tool#28 2023-06-27 21:48:56 -05:00
New API endpoint: stations

Copied from W1CDN/aprs_tool#30 (comment):


Experimenting with new stations table.

CREATE TABLE "stations" (
	"id"	INTEGER NOT NULL…
W1CDN commented on issue W1CDN/aprs_tool#28 2023-06-27 21:47:19 -05:00
New API endpoint: stations

No, this will be a different PR. The query right now seems OK, and I turned off autoremove for now in 8f3b2ae707.

W1CDN commented on issue W1CDN/aprs_tool#31 2023-06-27 21:45:34 -05:00
Remove old data from frames table

I am going to add stations table in another PR. But I turned off autoremove in 8f3b2ae707.

W1CDN commented on issue W1CDN/aprs_tool#33 2023-06-27 10:48:12 -05:00
Store distance from digipeater in database

It should be distance from the originating station, not the object (if it's an object). If we don't have the location of the originating station yet, what to do?

W1CDN opened issue W1CDN/aprs_tool#33 2023-06-27 10:36:03 -05:00
Store distance in database
W1CDN commented on issue W1CDN/aprs_tool#32 2023-06-26 12:09:45 -05:00
Handle telemetry

OK, testing with HT indicates that regular packets are working fine, but telemetry isn't quite.

W1CDN opened issue W1CDN/aprs_tool#32 2023-06-26 11:55:42 -05:00
Handle telemetry
W1CDN commented on pull request W1CDN/aprs_tool#30 2023-06-24 21:38:33 -05:00
Add status page

Exciting to see live https://w1cdn.net/aprs_api: image

W1CDN commented on pull request W1CDN/aprs_tool#30 2023-06-24 21:24:35 -05:00
Add status page

Experimenting with new stations table.

CREATE TABLE "stations" (
	"id"	INTEGER NOT NULL UNIQUE,
	"from"	TEXT,
	"frames_id"	INTEGER,
	"last_heard_unix"	INTEGER,
	"count"	INTEGER,
	PRIM…
W1CDN opened issue W1CDN/aprs_tool#31 2023-06-24 21:19:52 -05:00
Remove old data from frames table
W1CDN commented on issue W1CDN/aprs_tool#28 2023-06-24 19:07:25 -05:00
New API endpoint: stations

Working on this in #30.

W1CDN created pull request W1CDN/aprs_tool#30 2023-06-24 11:21:50 -05:00
Add status page
W1CDN commented on issue W1CDN/aprs_tool#16 2023-06-24 11:18:54 -05:00
Digipeater dashboard

Got index/status page stubbed out, and lists recent packets.