dialtone_sqlx 0.1.0

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

use dialtone_common::ap::{Actor, ActorType};
use dialtone_common::pages::create_base_url;
use dialtone_common::rest::actors::actor_model::ActorPage;

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

pub async fn page_actors_by_host(
    exec: impl Executor<'_, Database = Postgres>,
    prev_date: Option<&DateTime<Utc>>,
    next_date: Option<&DateTime<Utc>>,
    limit: u32,
    host_name: &str,
    actor_type: Option<&ActorType>,
) -> Result<Option<ActorPage>, sqlx::Error> {
    let pre_select = r#"
        select
            min(modified_at),
            max(modified_at),
            json_agg(activity_pub_json)
        from (
            select
                actor.modified_at,
                actor.activity_pub_json
            from actor
    "#;
    let post_select = "and visibility != 'Banned' order by modified_at asc limit $1) as actor";
    let mut conditions: Vec<String> = Vec::new();
    let mut params: Vec<CondParam> = Vec::new();
    let id_start = create_base_url(host_name);
    params.push(CondParam::String(&id_start));
    conditions.push(format!("id like ${}||'%'", params.len() + 1));
    let a_type_string;
    if actor_type.is_some() {
        let a_type = ActorDbType::from(actor_type.unwrap());
        a_type_string = a_type.to_string();
        params.push(CondParam::String(&a_type_string));
        conditions.push(format!("type = ${}::actor_type", 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<Actor>>, 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(ActorPage {
                        min_modified_at,
                        max_modified_at,
                        page_values: value.0,
                    }))
                }
                Err(err) => match err {
                    Error::ColumnDecode { .. } => Ok(None),
                    _ => Err(err),
                },
            }
        }
    }
}