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 model::chat::Chat;
use model_owner::Owner;
use sqlx::{Pool, Postgres};

#[tracing::instrument(skip(db))]
pub async fn get_chats(db: &Pool<Postgres>, user_id: &str) -> anyhow::Result<Vec<Chat>> {
    let mut chats: Vec<Chat> = Vec::new();
    chats.extend(
        sqlx::query!(
            r#"
        SELECT
            c.id,
            c.name,
            c.model,
            c."tokenCount" as "token_count",
            c."userId" as "user_id",
            c."createdAt"::timestamptz as "created_at",
            c."updatedAt"::timestamptz as "updated_at",
            c."deletedAt"::timestamptz as "deleted_at",
            c."projectId" as "project_id",
            c."isPersistent" as "is_persistent"
        FROM "Chat" c
        WHERE c."userId" = $1 AND c."deletedAt" IS NULL
        "#,
            user_id,
        )
        .try_map(|row| {
            Ok(Chat {
                id: row.id,
                name: row.name,
                user_id: Owner::from_principal_str(&row.user_id)
                    .map_err(|e| sqlx::Error::Decode(Box::new(e)))?,
                model: Some(row.model),
                project_id: row.project_id,
                created_at: row.created_at,
                updated_at: row.updated_at,
                token_count: row.token_count,
                is_persistent: row.is_persistent,
                deleted_at: row.deleted_at,
            })
        })
        .fetch_all(db)
        .await?,
    );

    Ok(chats)
}

#[cfg(test)]
mod tests {
    use super::*;
    use sqlx::{Pool, Postgres};

    #[sqlx::test(fixtures(path = "../../fixtures", scripts("chat_example")))]
    async fn test_get_chats(pool: Pool<Postgres>) -> anyhow::Result<()> {
        let chats = get_chats(&pool, "macro|[email protected]").await?;
        assert_eq!(chats.len(), 3);
        Ok(())
    }
}