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
//! Serialize provider identity reconciliation with inbox synchronization.
use sqlx::PgConnection;
use sqlx::types::Uuid;
/// Lock a provider conversation before taking its thread or message row locks.
///
/// The caller must keep its transaction open for the entire write. Both sync
/// and delivery completion use this order so reconciliation cannot deadlock
/// against a thread upsert followed by a message upsert.
#[tracing::instrument(skip(tx), err)]
pub async fn lock_provider_thread(
tx: &mut PgConnection,
link_id: Uuid,
provider_thread_id: &str,
) -> anyhow::Result<()> {
sqlx::query!(
"SELECT pg_advisory_xact_lock(hashtextextended($1, 0))",
format!("email_provider_thread:{link_id}:{provider_thread_id}"),
)
.execute(tx)
.await?;
Ok(())
}
/// Resolve a confirmed send to Gmail's existing conversation, if sync won.
///
/// Only the sent message moves. The original thread is retained with all of its
/// associations. Once empty, its lookup aliases point at the canonical thread;
/// readers must authorize the canonical inbox before following those aliases.
/// The caller holds [`lock_provider_thread`] and the sent message row lock.
#[tracing::instrument(skip(tx), err)]
pub async fn reconcile_sent_thread(
tx: &mut PgConnection,
link_id: Uuid,
message_id: Uuid,
provider_thread_id: &str,
) -> anyhow::Result<Uuid> {
let original = sqlx::query_scalar!(
"SELECT thread_id FROM email_messages WHERE id = $1 AND link_id = $2",
message_id,
link_id,
)
.fetch_one(&mut *tx)
.await?;
let canonical = sqlx::query_scalar!(
"SELECT id FROM email_threads WHERE link_id = $1 AND provider_id = $2 FOR UPDATE",
link_id,
provider_thread_id,
)
.fetch_optional(&mut *tx)
.await?;
let Some(canonical) = canonical.filter(|id| *id != original) else {
return Ok(original);
};
sqlx::query!(
"UPDATE email_messages SET thread_id = $3, updated_at = NOW() WHERE id = $1 AND link_id = $2",
message_id,
link_id,
canonical,
)
.execute(&mut *tx)
.await?;
sqlx::query!(
"UPDATE email_send_attempts SET thread_id = $3 WHERE message_id = $1 AND link_id = $2",
message_id,
link_id,
canonical,
)
.execute(&mut *tx)
.await?;
let empty = sqlx::query_scalar!(
r#"SELECT NOT EXISTS(SELECT 1 FROM email_messages WHERE thread_id = $1) AS "empty!""#,
original,
)
.fetch_one(&mut *tx)
.await?;
if empty {
sqlx::query!(
r#"UPDATE email_thread_client_ids SET thread_id = $3, created_at = NOW()
WHERE link_id = $1 AND thread_id = $2"#,
link_id,
original,
canonical,
)
.execute(&mut *tx)
.await?;
sqlx::query!(
r#"INSERT INTO email_thread_client_ids (client_id, link_id, thread_id)
VALUES ($1, $2, $3) ON CONFLICT (link_id, client_id)
DO UPDATE SET thread_id = EXCLUDED.thread_id, created_at = NOW()"#,
original,
link_id,
canonical,
)
.execute(&mut *tx)
.await?;
}
super::update::update_thread_metadata(tx, original, link_id).await?;
super::update::sync_thread_calendar_flag(tx, original).await?;
Ok(canonical)
}