Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

2.1 KB
Raw Blame
use models_email::{db, service};
use sqlx::PgPool;
use sqlx::types::Uuid;

/// Applies a partial update to a user's settings. Fields left `None` in the
/// patch keep their existing value (COALESCE); on a fresh insert, an omitted
/// `signature_on_replies_forwards` is written as FALSE, an omitted
/// `read_receipts_enabled` as TRUE, and `signature` as NULL.
// skip `patch` — it carries the user's signature HTML, which shouldn't hit traces.
#[tracing::instrument(skip(pool, patch), err)]
pub async fn patch_settings(
    pool: &PgPool,
    patch: service::settings::SettingsPatch,
) -> anyhow::Result<service::settings::Settings> {
    let result = sqlx::query_as!(
        db::settings::Settings,
        r#"
        INSERT INTO email_settings (link_id, signature_on_replies_forwards, signature, read_receipts_enabled)
        VALUES ($1, COALESCE($2, FALSE), $3, COALESCE($4, TRUE))
        ON CONFLICT (link_id)
        DO UPDATE SET
            signature_on_replies_forwards = COALESCE($2, email_settings.signature_on_replies_forwards),
            signature = COALESCE($3, email_settings.signature),
            read_receipts_enabled = COALESCE($4, email_settings.read_receipts_enabled),
            updated_at = NOW()
        RETURNING link_id, signature_on_replies_forwards, signature, read_receipts_enabled
        "#,
        patch.link_id,
        patch.signature_on_replies_forwards,
        patch.signature,
        patch.read_receipts_enabled,
    )
    .fetch_one(pool)
    .await?;

    Ok(service::settings::Settings::from(result))
}

/// Fetches a user's settings by link ID.
#[tracing::instrument(skip(pool), err)]
pub async fn fetch_settings(
    pool: &PgPool,
    link_id: Uuid,
) -> anyhow::Result<service::settings::Settings> {
    let result = sqlx::query_as!(
        db::settings::Settings,
        r#"
        SELECT link_id, signature_on_replies_forwards, signature, read_receipts_enabled
        FROM email_settings
        WHERE link_id = $1
        "#,
        link_id
    )
    .fetch_one(pool)
    .await?;

    Ok(service::settings::Settings::from(result))
}

#[cfg(test)]
mod test;