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