use crate::adapters::contract::_helpers::identifiers::exact_identifier;
use crate::schema_plan::models::LiveColumn;
pub(crate) fn rebuild_statement(
target: &str,
live: &[LiveColumn],
rebuilt: &[(&str, &str)],
) -> String {
let select: Vec<String> = live
.iter()
.map(|column| rebuilt_column(column, rebuilt))
.collect();
format!(
"CREATE OR REPLACE TABLE {target} COPY GRANTS AS SELECT {} FROM {target}",
select.join(", ")
)
}
fn rebuilt_column(column: &LiveColumn, rebuilt: &[(&str, &str)]) -> String {
let name = exact_identifier(&column.name);
match rebuilt.iter().find(|(rebuilt, _)| *rebuilt == column.name) {
Some((_, sql_type)) => format!("CAST({name} AS {sql_type}) AS {name}"),
None => name,
}
}