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
#[tracing::instrument(skip(db))]
pub async fn get_macro_user_email_verification(
db: &sqlx::Pool<sqlx::Postgres>,
email: &str,
) -> anyhow::Result<Option<bool>> {
let result = sqlx::query!(
r#"
SELECT "is_verified"
FROM "macro_user_email_verification"
WHERE "email" = $1
"#,
email
)
.fetch_optional(db)
.await?;
Ok(result.map(|r| r.is_verified))
}
#[tracing::instrument(skip(db))]
pub async fn upsert_macro_user_email_verification(
db: &sqlx::Pool<sqlx::Postgres>,
macro_user_id: &str,
email: &str,
is_verified: bool,
) -> anyhow::Result<()> {
let macro_user_id = macro_uuid::string_to_uuid(macro_user_id)?;
sqlx::query!(
r#"
INSERT INTO "macro_user_email_verification" ("macro_user_id", "email", "is_verified")
VALUES ($1, $2, $3)
ON CONFLICT ("email") DO UPDATE SET "macro_user_id" = $1, "is_verified" = $3
"#,
¯o_user_id,
email,
is_verified
)
.execute(db)
.await?;
Ok(())
}
#[cfg(test)]
mod tests {
use super::*;
use sqlx::{Pool, Postgres};
use uuid::Uuid;
#[derive(Debug, serde::Serialize, serde::Deserialize, PartialEq, Eq)]
struct MacroUserEmailVerification {
macro_user_id: Uuid,
email: String,
is_verified: bool,
}
async fn get_macro_user_email_verification(
pool: &Pool<Postgres>,
macro_user_id: &str,
email: &str,
) -> anyhow::Result<Option<MacroUserEmailVerification>> {
let macro_user_id = macro_uuid::string_to_uuid(macro_user_id)?;
let macro_user_email_verification = sqlx::query_as!(
MacroUserEmailVerification,
r#"
SELECT
"macro_user_id",
"email",
"is_verified"
FROM "macro_user_email_verification"
WHERE "macro_user_id" = $1 AND "email" = $2
"#,
¯o_user_id,
&email,
)
.fetch_optional(pool)
.await?;
Ok(macro_user_email_verification)
}
#[sqlx::test]
async fn test_upsert(pool: Pool<Postgres>) -> anyhow::Result<()> {
// create macro user
sqlx::query!(
r#"
INSERT INTO "macro_user" ("id", "email", "stripe_customer_id", "username")
VALUES ($1, $2, $3, $4)
"#,
¯o_uuid::string_to_uuid("11111111-1111-1111-1111-111111111111")?,
"[email protected]",
"cus_123",
"u1",
)
.execute(&pool)
.await?;
sqlx::query!(
r#"
INSERT INTO "macro_user" ("id", "email", "stripe_customer_id", "username")
VALUES ($1, $2, $3, $4)
"#,
¯o_uuid::string_to_uuid("22222222-2222-2222-2222-222222222222")?,
"[email protected]",
"cus_124",
"u2",
)
.execute(&pool)
.await?;
let macro_user_id = macro_uuid::string_to_uuid("11111111-1111-1111-1111-111111111111")?;
let email = "[email protected]".to_string();
let is_verified = false;
upsert_macro_user_email_verification(
&pool,
¯o_user_id.to_string(),
&email,
is_verified,
)
.await?;
assert_eq!(
get_macro_user_email_verification(&pool, ¯o_user_id.to_string(), &email).await?,
Some(MacroUserEmailVerification {
macro_user_id: macro_user_id.clone(),
email: "[email protected]".to_string(),
is_verified: false,
})
);
// update is_verified
upsert_macro_user_email_verification(&pool, ¯o_user_id.to_string(), &email, true)
.await?;
assert_eq!(
get_macro_user_email_verification(&pool, ¯o_user_id.to_string(), &email).await?,
Some(MacroUserEmailVerification {
macro_user_id: macro_user_id.clone(),
email: "[email protected]".to_string(),
is_verified: true,
})
);
// update macro_user_id
upsert_macro_user_email_verification(
&pool,
"22222222-2222-2222-2222-222222222222",
&email,
true,
)
.await?;
assert_eq!(
get_macro_user_email_verification(
&pool,
"22222222-2222-2222-2222-222222222222",
&email
)
.await?,
Some(MacroUserEmailVerification {
macro_user_id: macro_uuid::string_to_uuid("22222222-2222-2222-2222-222222222222")?,
email: "[email protected]".to_string(),
is_verified: true,
})
);
Ok(())
}
}