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…
Copied from W1CDN/aprs_tool#30 (comment):
Experimenting with new stations table.
CREATE TABLE "stations" (
"id" INTEGER NOT NULL…No, this will be a different PR. The query right now seems OK, and I turned off autoremove for now in 8f3b2ae707.
I am going to add stations table in another PR. But I turned off autoremove in 8f3b2ae707.
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?
OK, testing with HT indicates that regular packets are working fine, but telemetry isn't quite.
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…