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.3 KB
Raw Blame
use sqlx::types::Uuid;

/// Creates user notifications for a given notification
#[tracing::instrument(skip(transaction, user_ids))]
pub async fn create_bulk_user_notifications(
    transaction: &mut sqlx::Transaction<'_, sqlx::Postgres>,
    notification_id: &Uuid,
    user_ids: &[String],
) -> anyhow::Result<()> {
    sqlx::query!(
        r#"
        INSERT INTO user_notification ("notification_id", "user_id") 
        SELECT $1, user_id
        FROM UNNEST($2::text[]) as user_id
        "#,
        notification_id,
        user_ids,
    )
    .execute(transaction.as_mut())
    .await?;

    Ok(())
}

#[cfg(test)]
mod tests {
    use super::*;
    use macro_db_migrator::MACRO_DB_MIGRATIONS;
    use sqlx::{Pool, Postgres};

    #[sqlx::test(
        migrator = "MACRO_DB_MIGRATIONS",
        fixtures(path = "../../fixtures", scripts("user_notifications"))
    )]
    async fn test_create_bulk_user_notifications(pool: Pool<Postgres>) -> anyhow::Result<()> {
        let mut transaction = pool.begin().await?;
        create_bulk_user_notifications(
            &mut transaction,
            &"0193b1ea-a542-7589-893b-2b4a509c1e76".parse().unwrap(),
            &[
                "macro|[email protected]".to_string(),
                "macro|[email protected]".to_string(),
            ],
        )
        .await?;

        Ok(())
    }
}