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.

827 B
Raw Blame
use anyhow::Result;
use model::chat::{AttachmentType, ChatAttachment};
use sqlx::{Postgres, Transaction};

#[tracing::instrument(skip(transaction))]
pub async fn get_attachment(
    transaction: &mut Transaction<'_, Postgres>,
    id: &str,
) -> Result<ChatAttachment> {
    let attachment = sqlx::query_as!(
        ChatAttachment,
        r#"
            SELECT
                ca.id,
                ca."entity_type" as "attachment_type: AttachmentType",
                ca."entity_id"::TEXT as "attachment_id!",
                ca."chatId" as "chat_id",
                ca."messageId" as "message_id"
            FROM
                "ChatAttachment" ca
            WHERE
                ca."id" = $1
            LIMIT 1
        "#,
        id,
    )
    .fetch_one(transaction.as_mut())
    .await?;

    Ok(attachment)
}