mirror of
https://github.com/blakeblackshear/frigate.git
synced 2026-09-17 08:04:42 -04:00
Josh Hawkins
f3a31e2fb4
* add a notice registry and System Health tab Problems Frigate detects on its own (ffmpeg crash loops, stuck detectors, failed model downloads, recordings deleted before their retention period) only ever existed as log lines. This adds a `NoticeRegistry` in the main process backed by two tables, an `update_notice` IPC topic so producers in other processes can reach it through the dispatcher, an admin-only API and websocket topic, and a Health tab that lists them. Kinds declare their own mode, severity, and category in one place: state notices are resolved by their producer, event notices are dismissed by the user. * treat a prerelease as behind its final release * fix notices clearing early * rename menu items and update docs * don't resolve the update notice on a failed version lookup
39 lines
1.2 KiB
Python
39 lines
1.2 KiB
Python
"""Peewee migrations -- 038_create_notices.py.
|
|
|
|
Creates the two notice tables: active notices, and per-kind lifetime counts.
|
|
"""
|
|
|
|
import peewee as pw
|
|
|
|
SQL = pw.SQL
|
|
|
|
|
|
def migrate(migrator, database, fake=False, **kwargs):
|
|
migrator.sql(
|
|
'CREATE TABLE IF NOT EXISTS "notice" ('
|
|
'"id" VARCHAR(150) NOT NULL PRIMARY KEY, '
|
|
'"kind" VARCHAR(50) NOT NULL, '
|
|
'"scope" VARCHAR(100), '
|
|
'"params" TEXT NOT NULL, '
|
|
'"first_seen" DATETIME NOT NULL, '
|
|
'"last_seen" DATETIME NOT NULL, '
|
|
'"count" INTEGER NOT NULL, '
|
|
'"dismissed_at" DATETIME)'
|
|
)
|
|
migrator.sql('CREATE INDEX IF NOT EXISTS "notice_kind" ON "notice" ("kind")')
|
|
migrator.sql(
|
|
'CREATE TABLE IF NOT EXISTS "noticestats" ('
|
|
'"kind" VARCHAR(50) NOT NULL PRIMARY KEY, '
|
|
'"occurrences" INTEGER NOT NULL, '
|
|
'"dismissals" INTEGER NOT NULL, '
|
|
'"first_seen" DATETIME NOT NULL, '
|
|
'"last_seen" DATETIME NOT NULL, '
|
|
'"reported_occurrences" INTEGER NOT NULL DEFAULT 0, '
|
|
'"reported_dismissals" INTEGER NOT NULL DEFAULT 0)'
|
|
)
|
|
|
|
|
|
def rollback(migrator, database, fake=False, **kwargs):
|
|
migrator.sql('DROP TABLE IF EXISTS "notice"')
|
|
migrator.sql('DROP TABLE IF EXISTS "noticestats"')
|