Module queries 

Functions

clear_all_clips

Delete all clips from the store. Returns the number of rows deleted.

clip_count

Return the total number of clips in the store.

count_clips_before

Return the number of clips whose created_at (ms) is before cutoff_ms. Used by the Settings pane “preview retention change” dialog.

delete_clip

enforce_offline_cap

Drop the oldest unsynced clips that exceed max, keeping the newest max. Returns the number of rows deleted.

get_clip

get_last_flush_at

Read the epoch-millisecond timestamp of the last successful backlog flush. Returns None if no flush has ever been recorded.

insert_clip

list_alert_prefs

list_clips

list_devices

list_retention

list_sources

list_unsynced_clips

Return all clips that have not yet been synced to the relay, ordered oldest first.

replace_id_and_mark_synced

Rename a clip’s id (e.g. temp local id → relay-assigned ULID) and mark it synced. Returns the number of rows updated (0 if the old id was not found).

search_clips

set_alert_pref

set_last_flush_at

Persist the epoch-millisecond timestamp of a successful backlog flush.

set_pinned

set_retention

set_watermark

upsert_device

watermark