use crate::odbc_source::constants::{IDENTIFIER_QUOTE, QUERY_ALIAS};
use crate::odbc_source::models::OdbcReadRequest;
use crate::postgres_source::models::SourceTable;
pub(crate) fn quote_identifier(name: &str) -> String {
let doubled = format!("{IDENTIFIER_QUOTE}{IDENTIFIER_QUOTE}");
format!(
"{IDENTIFIER_QUOTE}{}{IDENTIFIER_QUOTE}",
name.replace(IDENTIFIER_QUOTE, &doubled)
)
}
pub(crate) fn from_item(schema: &str, table: &str, sql: Option<&str>) -> String {
match (sql, schema.is_empty()) {
(Some(sql), _) => {
let body = sql
.trim_start()
.trim_end_matches(|character: char| character == ';' || character.is_whitespace());
format!("({body}\n) {QUERY_ALIAS}")
}
(None, true) => quote_identifier(table),
(None, false) => format!("{}.{}", quote_identifier(schema), quote_identifier(table)),
}
}
pub(crate) fn select_query(request: &OdbcReadRequest<'_>) -> String {
let items: Vec<&str> = request
.columns
.iter()
.map(|column| column.expression.as_str())
.collect();
let from = from_item(&request.table.schema, &request.table.name, request.sql);
let filter = request
.filter
.map(|filter| format!(" WHERE {filter}"))
.unwrap_or_default();
format!("SELECT {} FROM {from}{filter}", items.join(", "))
}
pub(crate) fn count_query(table: &SourceTable, sql: Option<&str>, filter: &str) -> String {
format!(
"SELECT COUNT(*) FROM {} WHERE {filter}",
from_item(&table.schema, &table.name, sql)
)
}