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.

547 B
Raw Blame
use model::experiment::Experiment;

/// Gets all of the active experiments
#[tracing::instrument(skip(db))]
pub async fn get_active_experiments(
    db: &sqlx::Pool<sqlx::Postgres>,
) -> anyhow::Result<Vec<Experiment>> {
    let experiments = sqlx::query_as!(
        Experiment,
        r#"
            SELECT e.id, e.active, e."started_at"::timestamptz as started_at, e."ended_at"::timestamptz as ended_at
            FROM "Experiment" e
            WHERE e.active = true
        "#,
    )
    .fetch_all(db)
    .await?;

    Ok(experiments)
}