Expand description
Query functions for the reflectors table.
The reflectors table is the central registry populated by Tier 1 discovery
sweeps. Each row represents a unique D-STAR reflector identified by its
callsign (e.g., REF001, XLX320, DCS001).
Tier 1 fetchers call upsert after each sweep to insert newly-discovered
reflectors or update metadata (IP address, dashboard URL, last-seen time)
for existing ones. Tier 2 monitors query get_active to decide which
reflectors have recent activity and deserve live monitoring.
Structsยง
- Reflector
Row ๐ - A single row from the
reflectorstable.
Functionsยง
- count_
total ๐ - Returns the total number of rows in the
reflectorstable. - get_
active ๐ - Returns all reflectors that have been seen since the given timestamp.
- get_
tier2_ ๐eligible - Returns reflectors eligible for Tier 2 monitoring.
- set_
tier2_ ๐available - Sets the
tier2_availableflag for a reflector. - upsert ๐
- Inserts a new reflector or updates an existing one on callsign conflict.