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

use crate::db::return_optional;
use const_format::concatcp;
use dialtone_common::ap::ap_object::ApObject;
use sqlx::{Executor, Postgres};

pub async fn fetch_ap_object(
    exec: impl Executor<'_, Database = Postgres>,
    ap_object_id: &str,
) -> Result<Option<ApObject>, sqlx::Error> {
    let sql = concatcp!(
        "select activity_pub_json
        from ap_object where id = $1 and visibility = 'Visible'"
    );
    let result = sqlx::query(sql)
        .bind(ap_object_id)
        .fetch_optional(exec)
        .await?;
    return_optional(&result)
}