sqlload 0.46.0

SQL data loading tooling.
//! Discover source tables from the Postgres catalog.

use tokio_postgres::Client;

use crate::postgres_source::_helpers::catalog::{table_matcher, tables_from_rows};
use crate::postgres_source::constants::{
    CATALOG_COLUMNS_SQL, CATALOG_INDEXED_COLUMNS_SQL, CATALOG_PRIMARY_KEYS_SQL,
};
use crate::postgres_source::errors::PostgresError;
use crate::postgres_source::models::SourceTable;

/// Every table and view whose `schema.table` matches `include` and not `exclude`, with columns, keys and the columns leading an index.
pub async fn read_catalog(
    client: &Client,
    include: &[String],
    exclude: &[String],
) -> Result<Vec<SourceTable>, PostgresError> {
    let pattern_error = |reason: String| PostgresError::Batch {
        table: "the source selection".to_owned(),
        reason,
    };
    let include = table_matcher(include).map_err(pattern_error)?;
    let exclude = table_matcher(exclude).map_err(pattern_error)?;
    let columns = client.query(CATALOG_COLUMNS_SQL, &[]).await?;
    let keys = client.query(CATALOG_PRIMARY_KEYS_SQL, &[]).await?;
    let indexes = client.query(CATALOG_INDEXED_COLUMNS_SQL, &[]).await?;
    Ok(tables_from_rows(
        &columns,
        (&keys, &indexes),
        &include,
        &exclude,
    ))
}