use crate::duckdb_source::models::DuckDbReadRequest;
use crate::postgres_source::models::SourceTable;
pub(crate) fn quote_identifier(name: &str) -> String {
format!("\"{}\"", name.replace('"', "\"\""))
}
fn from_item((table, sql): (&SourceTable, Option<&str>)) -> String {
match sql {
Some(sql) => subquery(sql),
None => [&table.schema, &table.name]
.map(|name| quote_identifier(name))
.join("."),
}
}
pub(crate) fn select_query(request: &DuckDbReadRequest<'_>) -> String {
let columns: Vec<&str> = request
.columns
.iter()
.map(|column| column.expression.as_str())
.collect();
let filter = request
.filter
.map(|filter| format!(" WHERE {filter}"))
.unwrap_or_default();
format!(
"SELECT {} FROM {}{filter}",
columns.join(", "),
from_item((request.table, request.sql))
)
}
pub(crate) fn count_query((table, sql): (&SourceTable, Option<&str>), filter: &str) -> String {
format!(
"SELECT CAST(COUNT(*) AS VARCHAR) FROM {} WHERE {filter}",
from_item((table, sql))
)
}
pub(crate) fn subquery(sql: &str) -> String {
let body = sql
.trim_start()
.trim_end_matches(|character: char| character == ';' || character.is_whitespace());
format!("({body}\n)")
}