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
//! Publication outbox over `external_chat_message` revisions.
use super::*;
use crate::domain::ports::{
AudienceRepository, ChatEffect, EffectsRepository, MessageNotice, Origin,
};
use async_trait::async_trait;
#[async_trait]
impl EffectsRepository for PgExternalChatRepository {
async fn pending_effects(&self, limit: i64) -> ExternalChatResult<Vec<ChatEffect>> {
sqlx::query!(
r#"SELECT b.id AS chat_id, m.message_id AS "message_id!", m.effect_revision, m.published_revision, m.origin, m.content_revision, m.deleted_at, p.user_id, m.kind
FROM external_chat_message m
JOIN external_chat b ON b.id = m.chat_id
JOIN external_chat_person p ON p.id = m.person_id
WHERE m.message_id IS NOT NULL AND m.published_revision < m.effect_revision AND m.notification_retry_at <= now()
ORDER BY m.notification_retry_at, m.message_id LIMIT $1"#,
limit
)
.fetch_all(&self.pool)
.await
.map_err(failure)?
.into_iter()
.map(|row| {
Ok(ChatEffect {
chat_id: row.chat_id,
message_id: row.message_id,
revision: row.effect_revision,
first_publication: row.published_revision == 0 && row.content_revision == 0 && row.deleted_at.is_none(),
origin: match row.origin.as_str() {
"macro" => Origin::Macro,
"history" => Origin::History,
"remote" => Origin::Remote,
other => return Err(corrupt(format_args!("message origin {other:?}"))),
},
associated_user: row.user_id,
system: row.kind == "system",
})
})
.collect()
}
async fn published(&self, message: Uuid, revision: i64) -> ExternalChatResult<()> {
sqlx::query!(
"UPDATE external_chat_message SET published_revision = GREATEST(published_revision, $2) WHERE message_id = $1",
message,
revision
)
.execute(&self.pool)
.await
.map_err(failure)?;
Ok(())
}
async fn defer_effect(&self, message: Uuid) -> ExternalChatResult<()> {
sqlx::query!(
"UPDATE external_chat_message SET notification_retry_at = now() + interval '30 seconds' WHERE message_id = $1",
message
)
.execute(&self.pool)
.await
.map_err(failure)?;
Ok(())
}
}
#[async_trait]
impl AudienceRepository for PgExternalChatRepository {
async fn link_viewers(&self, chat: Uuid) -> ExternalChatResult<Vec<String>> {
sqlx::query_scalar!(
"SELECT user_id FROM external_chat_read_state WHERE chat_id = $1 AND external_chat_can_view(chat_id, user_id)",
chat
)
.fetch_all(&self.pool)
.await
.map_err(failure)
}
async fn message_notice(
&self,
chat: Uuid,
message: Uuid,
) -> ExternalChatResult<Option<MessageNotice>> {
Ok(sqlx::query!(
r#"SELECT g.provider, g.name, m.deleted_at IS NOT NULL OR m.content_revision > 0 AS "superseded!"
FROM external_chat g JOIN external_chat_message m ON m.chat_id = g.id
WHERE g.id = $1 AND m.id = $2"#,
chat,
message
)
.fetch_optional(&self.pool)
.await
.map_err(failure)?
.map(|row| -> ExternalChatResult<MessageNotice> {
Ok(MessageNotice {
provider: row
.provider
.parse()
.map_err(|_| corrupt(format_args!("provider {:?}", row.provider)))?,
chat_name: row.name,
superseded: row.superseded,
})
})
.transpose()?)
}
}