Function run_sqlx_scalar_query

xtask/src/main.rs:5015–5024

(conn: &mut sqlx::PgConnection, value: i32)

}

async fn run_sqlx_scalar_query(conn: &mut sqlx::PgConnection, value: i32) -> Result<()> {
    let row = sqlx::query("SELECT $1::int4 + 1 AS answer")
        .bind(value)
        .fetch_one(conn)
        .await
        .context("run SQLx scalar query")?;
    let answer: i32 = row.try_get("answer").context("read SQLx answer")?;
    ensure!(answer == value + 1, "SQLx query returned {answer}");
    Ok(())
}

async fn run_sqlx_vector_query(conn: &mut sqlx::PgConnection) -> Result<()> {
    let row = sqlx::query("SELECT '[1,2,3]'::vector <-> '[1,2,4]'::vector AS distance")