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
use crate::handler::{fetch_inactive_link_ids, fetch_unused_link_ids};
use anyhow::Result;
use macro_db_migrator::MACRO_DB_MIGRATIONS;
use sqlx::{Pool, Postgres};
use uuid::Uuid;
#[sqlx::test(
migrator = "MACRO_DB_MIGRATIONS",
fixtures(path = "../fixtures", scripts("fetch_inactive_links"))
)]
async fn fetch_inactive_link_ids_returns_unused_links(pool: Pool<Postgres>) -> Result<()> {
const _: &sqlx::migrate::Migrator = &MACRO_DB_MIGRATIONS;
// Link created 40 days ago with no history should be returned (threshold: 30 days)
let result = fetch_unused_link_ids(&pool, 30).await?;
let unused_link_id = Uuid::parse_str("00000000-0000-0000-0000-000000000001")?;
assert!(
result.contains(&unused_link_id),
"Should include link with no history older than threshold"
);
Ok(())
}
#[sqlx::test(
migrator = "MACRO_DB_MIGRATIONS",
fixtures(path = "../fixtures", scripts("fetch_inactive_links"))
)]
async fn fetch_inactive_link_ids_returns_stale_history_links(pool: Pool<Postgres>) -> Result<()> {
// Link with history last updated 90 days ago should be returned (threshold: 60 days)
let result = fetch_inactive_link_ids(&pool, 60).await?;
let stale_link_id = Uuid::parse_str("00000000-0000-0000-0000-000000000002")?;
assert!(
result.contains(&stale_link_id),
"Should include link with stale history"
);
Ok(())
}
#[sqlx::test(
migrator = "MACRO_DB_MIGRATIONS",
fixtures(path = "../fixtures", scripts("fetch_inactive_links"))
)]
async fn fetch_inactive_link_ids_excludes_active_links(pool: Pool<Postgres>) -> Result<()> {
let unused_result = fetch_unused_link_ids(&pool, 30).await?;
let inactive_result = fetch_inactive_link_ids(&pool, 60).await?;
// Link with recent history should NOT be returned
let active_link_id = Uuid::parse_str("00000000-0000-0000-0000-000000000003")?;
assert!(
!unused_result.contains(&active_link_id) && !inactive_result.contains(&active_link_id),
"Should not include link with recent history"
);
// Recently created link with no history should NOT be returned
let new_link_id = Uuid::parse_str("00000000-0000-0000-0000-000000000004")?;
assert!(
!unused_result.contains(&new_link_id) && !inactive_result.contains(&new_link_id),
"Should not include recently created link"
);
Ok(())
}
#[sqlx::test(
migrator = "MACRO_DB_MIGRATIONS",
fixtures(path = "../fixtures", scripts("fetch_inactive_links"))
)]
async fn fetch_inactive_link_ids_excludes_macro_internal_links(pool: Pool<Postgres>) -> Result<()> {
let unused_result = fetch_unused_link_ids(&pool, 30).await?;
let inactive_result = fetch_inactive_link_ids(&pool, 60).await?;
// Links with @macro.com in macro_id should never be deleted
let internal_link_id = Uuid::parse_str("00000000-0000-0000-0000-000000000005")?;
assert!(
!unused_result.contains(&internal_link_id) && !inactive_result.contains(&internal_link_id),
"Should not include internal @macro.com links"
);
Ok(())
}
#[sqlx::test(
migrator = "MACRO_DB_MIGRATIONS",
fixtures(path = "../fixtures", scripts("fetch_inactive_links"))
)]
async fn fetch_inactive_link_ids_respects_threshold_parameters(pool: Pool<Postgres>) -> Result<()> {
// With very high thresholds, nothing should be returned
let unused_result = fetch_unused_link_ids(&pool, 365).await?;
let inactive_result = fetch_inactive_link_ids(&pool, 365).await?;
assert!(
unused_result.is_empty() && inactive_result.is_empty(),
"High thresholds should return no links"
);
// With very low thresholds, more links should be returned
let unused_result = fetch_unused_link_ids(&pool, 1).await?;
let inactive_result = fetch_inactive_link_ids(&pool, 1).await?;
assert!(
!unused_result.is_empty() || !inactive_result.is_empty(),
"Low thresholds should return some links"
);
Ok(())
}