dialtone_sqlx 0.1.0

Dialtone SQLx Back-End
Documentation 
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

use crate::db::user_principal::UserPrincipalStatusType;
use dialtone_common::rest::users::web_user::UserStatus;
use sqlx::{Executor, Postgres};

pub async fn change_user_status(
    exec: impl Executor<'_, Database = Postgres>,
    acct: &str,
    status: &UserStatus,
) -> Result<Option<()>, sqlx::Error> {
    let user_status = UserPrincipalStatusType::from(status);
    let result = sqlx::query(
        r#"
        update user_principal
        set status = $1
        where acct = $2
        returning acct
        "#,
    )
    .bind(user_status)
    .bind(&acct)
    .fetch_optional(exec)
    .await?;
    match result {
        None => Ok(None),
        Some(_) => Ok(Some(())),
    }
}