rustyroad 1.8.9

Rusty Road is a framework written in Rust that is based on Ruby on Rails. It is designed to provide the familiar conventions and ease of use of Ruby on Rails, while also taking advantage of the performance and efficiency of Rust.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

//! `query_scalar` helpers: one decoded column per row.

use crate::database::pool::shared::pool;
use sqlx::postgres::PgArguments;
use sqlx::query::QueryScalar;
use sqlx::{Decode, Postgres, Type};

/// Runs `query_scalar` and returns exactly one value.
pub async fn scalar_one<'q, T>(
    query: QueryScalar<'q, Postgres, T, PgArguments>,
) -> Result<T, sqlx::Error>
where
    T: Send + Unpin + Type<Postgres> + for<'r> Decode<'r, Postgres>,
{
    query.fetch_one(pool().await).await
}

/// Runs `query_scalar` and returns the value, if any.
pub async fn scalar_optional<'q, T>(
    query: QueryScalar<'q, Postgres, T, PgArguments>,
) -> Result<Option<T>, sqlx::Error>
where
    T: Send + Unpin + Type<Postgres> + for<'r> Decode<'r, Postgres>,
{
    query.fetch_optional(pool().await).await
}

/// Runs `query_scalar` and returns every value.
pub async fn scalar_all<'q, T>(
    query: QueryScalar<'q, Postgres, T, PgArguments>,
) -> Result<Vec<T>, sqlx::Error>
where
    T: Send + Unpin + Type<Postgres> + for<'r> Decode<'r, Postgres>,
{
    query.fetch_all(pool().await).await
}