use crate::odbc_source::_helpers::catalog::{catalog_tables, described, source_table};
use crate::odbc_source::_helpers::connect::connect;
use crate::odbc_source::_helpers::query::from_item;
use crate::odbc_source::errors::OdbcSourceError;
use crate::odbc_source::models::OdbcReader;
use crate::postgres_source::models::SourceTable;
pub async fn read_catalog(
reader: &OdbcReader,
(include, exclude): (&[String], &[String]),
queries: &[(String, String)],
) -> Result<Vec<SourceTable>, OdbcSourceError> {
let reader = reader.clone();
let patterns = (include.to_vec(), exclude.to_vec());
let queries = queries.to_vec();
tokio::task::spawn_blocking(move || catalog(&reader, &patterns, &queries))
.await
.map_err(|error| OdbcSourceError::Invalid(format!("the catalog read stopped: {error}")))?
}
fn catalog(
reader: &OdbcReader,
(include, exclude): &(Vec<String>, Vec<String>),
queries: &[(String, String)],
) -> Result<Vec<SourceTable>, OdbcSourceError> {
let connection = connect(reader)?;
let mut tables: Vec<SourceTable> = match include.is_empty() {
true => Vec::new(),
false => catalog_tables(&connection, (include, exclude))?,
};
for (name, sql) in queries {
let columns = described(&connection, &from_item("", name, Some(sql)))
.map_err(|error| OdbcSourceError::Invalid(format!("query table {name}: {error}")))?;
tables.push(source_table(
(String::new(), name.clone()),
columns,
Vec::new(),
));
}
Ok(tables)
}