use duckdb::Connection;
use super::ResolvedPartition;
use crate::error::TesseraError;
fn sql_str(value: &str) -> String {
format!("'{}'", value.replace('\'', "''"))
}
fn sql_url_list(urls: &[String]) -> String {
if let [single] = urls {
return sql_str(single);
}
let quoted: Vec<String> = urls.iter().map(|url| sql_str(url)).collect();
format!("[{}]", quoted.join(", "))
}
pub fn build_relation(
parts: &[ResolvedPartition],
columns: Option<&[&str]>,
) -> Result<Connection, TesseraError> {
let connection =
Connection::open_in_memory().map_err(|err| TesseraError::Network(err.to_string()))?;
let _ = connection.execute_batch("INSTALL httpfs; LOAD httpfs;");
let multi = parts.len() > 1;
let select_cols = columns.map_or_else(|| "*".to_string(), |columns| columns.join(", "));
let selects: Vec<String> = parts
.iter()
.map(|(partition, urls)| {
let projection = if multi {
format!(
"{}, {} AS coin, {} AS month",
select_cols,
sql_str(&partition.coin),
sql_str(&partition.month)
)
} else {
select_cols.clone()
};
format!(
"SELECT {projection} FROM read_parquet({})",
sql_url_list(urls)
)
})
.collect();
let query = selects.join("\nUNION ALL\n");
connection
.execute_batch(&format!("CREATE OR REPLACE TEMP VIEW tessera AS {query}"))
.map_err(|err| TesseraError::Network(err.to_string()))?;
Ok(connection)
}