Struct PostgresConfigStore 

pub struct PostgresConfigStore { /* private fields */ }

sqlx/Postgres-backed config store (clustered tier).

Implementations

impl PostgresConfigStore

pub async fn connect(url: &str) -> Result<Self>

Connect to Postgres at url and ensure the schema exists.

Trait Implementations

impl ConfigStore for PostgresConfigStore

fn list_repos<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<Vec<RegisteredWorkspace>>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

All registered repos, ordered by name.

fn upsert_repo<'life0, 'life1, 'async_trait>( &'life0 self, repo: &'life1 RegisteredWorkspace, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Insert or update a repo (keyed by name).

fn delete_repo<'life0, 'life1, 'async_trait>( &'life0 self, name: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<bool>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Remove a repo by name. Returns whether a row was deleted.

fn list_automations<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<Vec<StoredAutomation>>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

All automations, ordered by id (#220).

fn upsert_automation<'life0, 'life1, 'async_trait>( &'life0 self, automation: &'life1 StoredAutomation, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Insert or update an automation (keyed by id).

fn delete_automation<'life0, 'life1, 'async_trait>( &'life0 self, id: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<bool>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Remove an automation and its run history. Returns whether it existed.

fn claim_automation_fire<'life0, 'life1, 'life2, 'async_trait>( &'life0 self, id: &'life1 str, fire_at: &'life2 str, ) -> Pin<Box<dyn Future<Output = Result<bool>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait, 'life2: 'async_trait,

Claim fire_at for id, returning whether this caller won it.

fn record_run<'life0, 'life1, 'async_trait>( &'life0 self, run: &'life1 AutomationRun, ) -> Pin<Box<dyn Future<Output = Result<()>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Append a run to an automation’s history, trimming to RUN_HISTORY_LIMIT.

fn list_runs<'life0, 'life1, 'async_trait>( &'life0 self, automation_id: &'life1 str, limit: usize, ) -> Pin<Box<dyn Future<Output = Result<Vec<AutomationRun>>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

An automation’s runs, newest first, at most limit.