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.8 KB
Raw Blame
use crate::model::Message;
use anyhow::{Context, Result};
use macro_user_id::{cowlike::CowLike, user_id::MacroUserIdStr};
use sqlx::{Executor, Postgres};
use uuid::Uuid;

#[derive(Debug)]
pub struct CreateMessageOptions {
    pub channel_id: Uuid,
    pub sender_id: String,
    pub content: String,
    pub thread_id: Option<Uuid>,
}

#[tracing::instrument(skip(executor))]
pub async fn create_message<'e, E>(executor: E, options: CreateMessageOptions) -> Result<Message>
where
    E: Executor<'e, Database = Postgres>,
{
    let message_id = macro_uuid::generate_uuid_v7();

    let message = sqlx::query!(
        r#"
        INSERT INTO comms_messages (id, parent_entity_type, parent_entity_id, sender_id, content, thread_id)
        VALUES ($1, 'channel', $2::uuid::text, $3, $4, $5)
        RETURNING
            id,
            parent_entity_id::uuid AS "channel_id!",
            sender_id,
            content,
            created_at,
            updated_at,
            thread_id,
            edited_at as "edited_at: chrono::DateTime<chrono::Utc>",
            deleted_at as "deleted_at: chrono::DateTime<chrono::Utc>" 
        "#,
        message_id,
        options.channel_id,
        options.sender_id,
        options.content,
        options.thread_id
    )
    .try_map(|row| {
        Ok(Message {
            id: row.id,
            channel_id: row.channel_id,
            thread_id: row.thread_id,
            sender_id: MacroUserIdStr::parse_from_str(&row.sender_id)
                .map_err(|e| sqlx::Error::Decode(Box::new(e)))?
                .into_owned(),
            content: row.content,
            created_at: row.created_at,
            updated_at: row.updated_at,
            edited_at: row.edited_at,
            deleted_at: row.deleted_at,
        })
    })
    .fetch_one(executor)
    .await
    .context("unable to create message")?;

    Ok(message)
}