dialtone_sqlx 0.1.0

use chrono::{DateTime, Utc};
use sqlx::types::Json;
use sqlx::{Error, Executor, Postgres, Row};

use dialtone_common::ap::ap_object::ApObject;
use dialtone_common::rest::ap_objects::ap_object_model::ApObjectPage;

use crate::db::{bind_params, date_range_condition, make_where_clause, CondParam};

pub async fn page_ap_objects_by_host(
    exec: impl Executor<'_, Database = Postgres>,
    prev_date: Option<&DateTime<Utc>>,
    next_date: Option<&DateTime<Utc>>,
    limit: u32,
    host_name: &str,
) -> Result<Option<ApObjectPage>, sqlx::Error> {
    let pre_select = r#"
        select
            min(modified_at),
            max(modified_at),
            json_agg(activity_pub_json)
        from (
            select
                ap_object.activity_pub_json,
                ap_object.modified_at
            from ap_object
    "#;
    let post_select = "and visibility = 'Visible' order by modified_at asc limit $1) as ap_object";
    let mut conditions: Vec<String> = Vec::new();
    let params: Vec<CondParam> = vec![CondParam::String(host_name)];
    conditions.push(format!(
        "ap_object.received_for_host = ${}",
        params.len() + 1
    ));
    let (conditions, params) =
        date_range_condition(prev_date, next_date, "modified_at", conditions, params);
    let where_clause = make_where_clause(&conditions);
    let sql = format!("{} {} {}", pre_select, where_clause, post_select);
    let mut query = sqlx::query(&sql).bind(limit);
    query = bind_params(query, &params);
    // left here for future reference
    // println!("sql = {}", query.sql());
    let result = query.fetch_optional(exec).await?;
    match result {
        None => Ok(None),
        Some(row) => {
            let page_values = row.try_get::<Json<Vec<ApObject>>, usize>(2);
            match page_values {
                Ok(value) => {
                    let min_modified_at = row.get::<DateTime<Utc>, usize>(0);
                    let max_modified_at = row.get::<DateTime<Utc>, usize>(1);
                    Ok(Some(ApObjectPage {
                        min_modified_at,
                        max_modified_at,
                        page_values: value.0,
                    }))
                }
                Err(err) => match err {
                    Error::ColumnDecode { .. } => Ok(None),
                    _ => Err(err),
                },
            }
        }
    }
}