use crate::load_events::main::end_step::end_step;
use crate::load_events::main::step_doing::step_doing;
use crate::load_events::models::{Role, StepEnd};
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::{KeyUses, OdbcReader};
use crate::postgres_source::models::SourceTable;
pub async fn read_catalog(
reader: &OdbcReader,
(include, exclude, keys): (&[String], &[String], &KeyUses),
queries: &[(String, String)],
) -> Result<Vec<SourceTable>, OdbcSourceError> {
let reader = reader.clone();
let patterns = (include.to_vec(), exclude.to_vec(), keys.clone());
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, keys): &(Vec<String>, Vec<String>, KeyUses),
queries: &[(String, String)],
) -> Result<Vec<SourceTable>, OdbcSourceError> {
step_doing("connecting");
let connection = match connect(reader) {
Ok(connection) => {
let label = match connection.database_management_system_name() {
Ok(dbms) => format!("{} through ODBC", dbms.to_uppercase()),
Err(_) => "ODBC".to_owned(),
};
end_step(StepEnd::Connected {
role: Role::Source,
label,
ok: true,
});
connection
}
Err(error) => {
end_step(StepEnd::Connected {
role: Role::Source,
label: "ODBC".to_owned(),
ok: false,
});
return Err(error);
}
};
let mut tables: Vec<SourceTable> = match include.is_empty() {
true => Vec::new(),
false => catalog_tables(&connection, (include, exclude), keys)?,
};
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)
}