Struct PostgresBackend 

pub struct PostgresBackend { /* private fields */ }

PostgreSQL-backed usage persistence.

Counters are stored in a fraiseql_usage_counters table using UPSERT semantics. The schema is created automatically on PostgresBackend::new if it does not already exist.

The table schema is:

CREATE TABLE fraiseql_usage_counters (
    tenant_id   TEXT NOT NULL,
    period      TEXT NOT NULL,
    entity_type TEXT NOT NULL,
    count       BIGINT NOT NULL DEFAULT 0,
    updated_at  TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    PRIMARY KEY (tenant_id, period, entity_type)
);

Implementations

impl PostgresBackend

pub async fn new(pool: PgPool) -> Result<Self, String>

Create a new PostgreSQL backend, ensuring the schema exists.

Errors

Returns an error if the schema migration fails.

Trait Implementations

impl Clone for PostgresBackend

fn clone(&self) -> PostgresBackend

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PostgresBackend

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl UsageBackend for PostgresBackend

fn flush<'life0, 'life1, 'async_trait>( &'life0 self, counters: &'life1 HashMap<(String, String, String), u64>, ) -> Pin<Box<dyn Future<Output = Result<(), String>> + Send + 'async_trait>>

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

Flush all current counter values to the backing store.

fn load<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<HashMap<(String, String, String), u64>, String>> + Send + 'async_trait>>

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

Load all persisted counters from the backing store.