use core::fmt::Debug;
use serde::{Deserialize, Serialize};
use strum;
#[derive(
Debug, PartialEq, Eq, Clone, Serialize, Deserialize, strum::EnumString, strum::Display,
)]
pub enum Dialect {
#[strum(serialize = "ansi")]
Ansi,
#[strum(serialize = "bigquery")]
BigQuery,
#[strum(serialize = "clickhouse")]
ClickHouse,
#[strum(serialize = "duckdb")]
DuckDb,
#[strum(serialize = "generic")]
Generic,
#[strum(serialize = "hive")]
Hive,
#[strum(serialize = "mssql")]
MsSql,
#[strum(serialize = "mysql")]
MySql,
#[strum(serialize = "postgres")]
PostgreSql,
#[strum(serialize = "sqlite")]
SQLite,
#[strum(serialize = "snowflake")]
Snowflake,
}
impl Dialect {
pub(super) fn handler(&self) -> Box<dyn DialectHandler> {
match self {
Dialect::MsSql => Box::new(MsSqlDialect),
Dialect::MySql => Box::new(MySqlDialect),
Dialect::BigQuery => Box::new(BigQueryDialect),
Dialect::SQLite => Box::new(SQLiteDialect),
Dialect::ClickHouse => Box::new(ClickHouseDialect),
Dialect::Snowflake => Box::new(SnowflakeDialect),
Dialect::DuckDb => Box::new(DuckDbDialect),
Dialect::Ansi | Dialect::Generic | Dialect::Hive | Dialect::PostgreSql => {
Box::new(GenericDialect)
}
}
}
}
impl Default for Dialect {
fn default() -> Self {
Dialect::Generic
}
}
pub struct GenericDialect;
pub struct SQLiteDialect;
pub struct MySqlDialect;
pub struct MsSqlDialect;
pub struct BigQueryDialect;
pub struct ClickHouseDialect;
pub struct SnowflakeDialect;
pub struct DuckDbDialect;
pub(super) enum ColumnExclude {
Exclude,
Except,
}
pub(super) trait DialectHandler {
fn use_top(&self) -> bool {
false
}
fn ident_quote(&self) -> char {
'"'
}
fn big_query_quoting(&self) -> bool {
false
}
fn column_exclude(&self) -> Option<ColumnExclude> {
None
}
fn set_ops_distinct(&self) -> bool {
true
}
fn except_all(&self) -> bool {
true
}
fn intersect_all(&self) -> bool {
self.except_all()
}
}
impl DialectHandler for GenericDialect {}
impl DialectHandler for SQLiteDialect {
fn set_ops_distinct(&self) -> bool {
false
}
fn except_all(&self) -> bool {
false
}
}
impl DialectHandler for MsSqlDialect {
fn use_top(&self) -> bool {
true
}
}
impl DialectHandler for MySqlDialect {
fn ident_quote(&self) -> char {
'`'
}
fn set_ops_distinct(&self) -> bool {
true
}
}
impl DialectHandler for ClickHouseDialect {
fn ident_quote(&self) -> char {
'`'
}
}
impl DialectHandler for BigQueryDialect {
fn ident_quote(&self) -> char {
'`'
}
fn big_query_quoting(&self) -> bool {
true
}
fn column_exclude(&self) -> Option<ColumnExclude> {
Some(ColumnExclude::Except)
}
fn set_ops_distinct(&self) -> bool {
true
}
}
impl DialectHandler for SnowflakeDialect {
fn column_exclude(&self) -> Option<ColumnExclude> {
Some(ColumnExclude::Exclude)
}
fn set_ops_distinct(&self) -> bool {
false
}
}
impl DialectHandler for DuckDbDialect {
fn column_exclude(&self) -> Option<ColumnExclude> {
Some(ColumnExclude::Exclude)
}
fn except_all(&self) -> bool {
false
}
}