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.

1.2 KB
Raw Blame
/// mark the user's notification as done.
#[tracing::instrument(skip(db))]
pub async fn patch_done(
    db: &sqlx::Pool<sqlx::Postgres>,
    notification_id: &str,
    user_id: &str,
) -> anyhow::Result<()> {
    sqlx::query!(
        r#"
        UPDATE user_notification
        SET state = 'done'
        WHERE notification_id = $1 AND user_id = $2 AND deleted_at IS NULL
        "#,
        macro_uuid::string_to_uuid(notification_id)?,
        user_id,
    )
    .execute(db)
    .await?;

    Ok(())
}

/// Marks the user's notifications as done or undone.
#[tracing::instrument(skip(db))]
pub async fn bulk_patch_done(
    db: &sqlx::Pool<sqlx::Postgres>,
    user_id: &str,
    notification_ids: &Vec<uuid::Uuid>,
    done: bool,
) -> anyhow::Result<()> {
    sqlx::query!(
        r#"
        UPDATE user_notification
        SET state = CASE
            WHEN $3 THEN 'done'::notification_state
            WHEN state = 'done' THEN 'seen'::notification_state
            ELSE state
        END
        WHERE user_id = $1
        AND notification_id = ANY($2)
        AND deleted_at IS NULL
        "#,
        user_id,
        notification_ids,
        done
    )
    .execute(db)
    .await?;

    Ok(())
}

#[cfg(test)]
mod test;