Trait SqlDialect 

pub trait SqlDialect:
    Database
    + HasStatementCache
    + Sized
    + Send
    + Sync
where
    Self::Connection: Send,
{
    // Required methods
    fn placeholder(n: usize) -> String;
    fn auto_increment_pk() -> &'static str;
    fn rows_affected(res: &Self::QueryResult) -> u64;
    fn last_insert_id(res: &Self::QueryResult) -> i64;

    // Provided methods
    fn supports_returning() -> bool { ... }
    fn current_timestamp_fn() -> &'static str { ... }
    fn int_type() -> &'static str { ... }
    fn bigint_type() -> &'static str { ... }
    fn text_type() -> &'static str { ... }
    fn bool_type() -> &'static str { ... }
    fn float_type() -> &'static str { ... }
    fn blob_type() -> &'static str { ... }
    fn quote_identifier(ident: &str) -> String { ... }
}

A trait that encapsulates all the requirements for a database to work with Premix.

Implementing this trait allows Premix to generate correct SQL syntax and handle database-specific behaviors like placeholder styles and identifier quoting.

Required Methods

fn placeholder(n: usize) -> String

Returns the placeholder for the n-th parameter in a query (e.g., “?” or “$1”).

fn auto_increment_pk() -> &'static str

Returns the SQL fragment for an auto-incrementing Primary Key.

fn rows_affected(res: &Self::QueryResult) -> u64

Returns the number of rows affected by a query result.

fn last_insert_id(res: &Self::QueryResult) -> i64

Returns the ID of the last inserted row.

Provided Methods

fn supports_returning() -> bool

Returns true if the database supports the RETURNING clause.

fn current_timestamp_fn() -> &'static str

Returns the SQL function code for getting the current timestamp.

fn int_type() -> &'static str

Returns the native SQL type for 32-bit integers.

fn bigint_type() -> &'static str

Returns the native SQL type for 64-bit integers.

fn text_type() -> &'static str

Returns the native SQL type for text strings.

fn bool_type() -> &'static str

Returns the native SQL type for booleans.

fn float_type() -> &'static str

Returns the native SQL type for floating-point numbers.

fn blob_type() -> &'static str

Returns the native SQL type for binary data.

fn quote_identifier(ident: &str) -> String

Quotes an identifier (table/column name) to prevent SQL injection.

Dyn Compatibility

This trait is not dyn compatible.

In older versions of Rust, dyn compatibility was called "object safety", so this trait is not object safe.

Implementations on Foreign Types

impl SqlDialect for Sqlite

Available on crate feature sqlite only.

fn placeholder(_n: usize) -> String

fn auto_increment_pk() -> &'static str

fn bigint_type() -> &'static str

fn blob_type() -> &'static str

fn rows_affected(res: &SqliteQueryResult) -> u64

fn last_insert_id(res: &SqliteQueryResult) -> i64

fn supports_returning() -> bool

Implementors