release / release (push) Successful in 7m6s
The new Cairn OBS: a self-hosted monitor for networks, hosts and services. Licensed AGPLv3.
66 lines
2.1 KiB
Go
66 lines
2.1 KiB
Go
// SPDX-FileCopyrightText: 2026 Coffey Labs LLC
|
|
// SPDX-License-Identifier: AGPL-3.0-or-later
|
|
|
|
package state
|
|
|
|
// Readings: what obs-beacond polls for itself (Cloudflare, Patroni, the
|
|
// mail round trip), one row each. The evaluator polls and writes here;
|
|
// every other copy reads the row back, so each outside API is asked once
|
|
// however many copies run, and every copy shows the same thing
|
|
// (docs/scale-and-availability.md, Sharing live state). A copy that takes
|
|
// the evaluator's place starts from the last row, so what a poller
|
|
// remembers between rounds (how long Cloudflare has been failing, the
|
|
// mail round trip's day of history) carries over.
|
|
|
|
import (
|
|
"database/sql"
|
|
"errors"
|
|
"time"
|
|
)
|
|
|
|
const readingsSchema = `
|
|
CREATE TABLE IF NOT EXISTS readings (
|
|
name TEXT PRIMARY KEY, body TEXT NOT NULL, at_ms BIGINT NOT NULL
|
|
);
|
|
`
|
|
|
|
// PutReading stores a poller's latest reading, unless a newer one is there
|
|
// already (a copy that just lost the lease may still finish a round).
|
|
func (d *DB) PutReading(name string, body []byte, at time.Time) error {
|
|
_, err := d.exec(`INSERT INTO readings (name, body, at_ms) VALUES (?, ?, ?)
|
|
ON CONFLICT (name) DO UPDATE SET body = excluded.body, at_ms = excluded.at_ms
|
|
WHERE readings.at_ms <= excluded.at_ms`, name, string(body), at.UnixMilli())
|
|
return err
|
|
}
|
|
|
|
// Reading reads a poller's latest reading and when it was taken.
|
|
func (d *DB) Reading(name string) ([]byte, time.Time, error) {
|
|
var body string
|
|
var ms int64
|
|
err := d.queryRow(`SELECT body, at_ms FROM readings WHERE name = ?`, name).Scan(&body, &ms)
|
|
if errors.Is(err, sql.ErrNoRows) {
|
|
return nil, time.Time{}, ErrNotFound
|
|
}
|
|
return []byte(body), time.UnixMilli(ms), err
|
|
}
|
|
|
|
// ReadingTimes says when each reading was taken, to find the ones a copy
|
|
// has missed.
|
|
func (d *DB) ReadingTimes() (map[string]time.Time, error) {
|
|
rows, err := d.query(`SELECT name, at_ms FROM readings`)
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
defer rows.Close()
|
|
out := map[string]time.Time{}
|
|
for rows.Next() {
|
|
var n string
|
|
var ms int64
|
|
if err := rows.Scan(&n, &ms); err != nil {
|
|
return nil, err
|
|
}
|
|
out[n] = time.UnixMilli(ms)
|
|
}
|
|
return out, rows.Err()
|
|
}
|