Enum Dialect 

pub enum Dialect {
    Postgres,
    Sqlite,
    MySql,
}

A supported database dialect.

Variants

Postgres

Sqlite

MySql

Implementations

impl Dialect

pub fn from_database(database: &str) -> Self

Pick the dialect from the manifest’s stack.database ("sqlite" → SQLite, "mysql" → MySQL, else the Postgres default).

pub fn id_pk_ddl(self) -> &'static str

The id primary-key column DDL (no trailing comma). Postgres generates the UUID in the database; SQLite and MySQL have no UUID generator, so the app supplies it on insert. MySQL uses BINARY(16) — the type sqlx encodes/decodes uuid::Uuid to natively, so the generated model, binds and FromRow stay uniform across dialects.

pub fn app_generates_id(self) -> bool

Whether the app must generate id on insert (SQLite, MySQL) rather than the database (Postgres).

pub fn supports_returning(self) -> bool

Whether the dialect supports INSERT/UPDATE ... RETURNING *. Postgres and SQLite do; MySQL does not, so the generated repository re-reads the row with a SELECT after writing (it knows the id, which the app generates).

pub fn column_type(self, ty: FieldType) -> &'static str

The SQL column type for a scalar field.

pub fn timestamp_type_default(self) -> &'static str

The TYPE NOT NULL DEFAULT ... fragment for the created_at/updated_at columns.

pub fn now_expr(self) -> &'static str

The SQL expression for “now” used in UPDATE ... SET updated_at = <now>.

pub fn placeholder(self, n: usize) -> String

A bind placeholder for parameter n (1-based): $n on Postgres, ?n on SQLite, and a bare positional ? on MySQL (its protocol binds positionally, without an index).

pub fn pool_type(self) -> &'static str

The sqlx pool type used in generated code.

pub fn pool_options(self) -> &'static str

The sqlx pool-options type.

pub fn sqlx_module(self) -> &'static str

The sqlx submodule the pool types live in (sqlx::postgres / sqlx::sqlite / sqlx::mysql).

pub fn sqlx_feature(self) -> &'static str

The sqlx feature to enable in the generated Cargo.toml.

pub fn integrity_error_mapping(self) -> String

The full if let sqlx::Error::Database(..) { .. } block, inside From<sqlx::Error>, that classifies a database integrity error into Error::Conflict (unique violation) or Error::ForeignKey. Indented to sit at the 8-space body level of the from function.

Postgres and SQLite expose distinct codes through .code() (SQLSTATE / extended result code). MySQL collapses both to SQLSTATE 23000, so it must read the numeric error code (1062 duplicate key; 1451, 1452, 1216, 1217 foreign key) off the concrete MySqlDatabaseError.

pub fn example_url(self, project: &str) -> String

An example DATABASE_URL for .env.example.

Trait Implementations

impl Clone for Dialect

fn clone(&self) -> Self

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Copy for Dialect

impl Debug for Dialect

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for Dialect

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Eq for Dialect

impl PartialEq for Dialect

fn eq(&self, other: &Self) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl StructuralPartialEq for Dialect