Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
use models_email::email::db;
use models_email::email::service;
use sqlx::PgPool;
use sqlx::types::Uuid;
/// Creates an `Init` backfill job for a link. Returns `None` when an active
/// (`Init`/`InProgress`) job already exists for the link — the `uq_active_backfill_job_per_link`
/// partial unique index makes this atomic, so concurrent callers don't create duplicates.
///
/// `is_recovery` marks stale-cursor recovery jobs: they skip the priority pass
/// and refresh existing threads instead of skipping them.
#[tracing::instrument(skip(pool), err)]
pub async fn create_backfill_job(
pool: &PgPool,
link_id: Uuid,
fusionauth_user_id: &str,
num_threads: Option<i32>,
is_recovery: bool,
) -> anyhow::Result<Option<service::backfill::BackfillJob>> {
let id = macro_uuid::generate_uuid_v7();
let record = sqlx::query_as!(
db::backfill::BackfillJob,
r#"
INSERT INTO email_backfill_jobs (id, link_id, fusionauth_user_id, threads_requested_limit, status, is_recovery)
VALUES ($1, $2, $3, $4, 'Init', $5)
ON CONFLICT (link_id) WHERE status IN ('Init', 'InProgress') DO NOTHING
RETURNING
id,
link_id,
fusionauth_user_id,
threads_requested_limit,
total_threads,
threads_retrieved_count,
status as "status: db::backfill::BackfillJobStatus",
created_at,
updated_at
"#,
id,
link_id,
fusionauth_user_id,
num_threads,
is_recovery
)
.fetch_optional(pool)
.await?;
Ok(record.map(Into::into))
}
#[cfg(test)]
mod test;