Struct Sqlite 

pub struct Sqlite;

SQLite dialect marker type.

Trait Implementations

impl Dialect for Sqlite

const AUTO_PK: &'static str = "INTEGER PRIMARY KEY AUTOINCREMENT"

Auto-increment primary key DDL fragment.

const INSERT_IGNORE: &'static str = "INSERT OR IGNORE"

INSERT OR IGNORE prefix for this backend.

const CONFLICT_NOTHING: &'static str = ""

Suffix for conflict-do-nothing semantics.

const COLLATE_NOCASE: &'static str = "COLLATE NOCASE"

Case-insensitive collation suffix for ORDER BY / WHERE clauses.

const EPOCH_NOW: &'static str = "unixepoch('now')"

Current epoch seconds expression.

const NOW: &'static str = "datetime('now')"

Current timestamp expression, for direct assignment into a TEXT/TIMESTAMPTZ updated_at-style column (as opposed to Self::EPOCH_NOW, which yields an integer).

const JSON_CAST: &'static str = ""

Cast suffix for a bind parameter carrying pre-serialized JSON text, destined for a JSON-typed column.

const TIMESTAMPTZ_CAST: &'static str = ""

Cast suffix for a bind parameter carrying a pre-formatted timestamp string, destined for a timestamp-typed column.

const GREATEST_FN: &'static str = "MAX"

Scalar function name returning the greatest of two (or more) numeric arguments.

const LEAST_FN: &'static str = "MIN"

Scalar function name returning the least of two (or more) numeric arguments.

fn ilike(col: &str) -> String

Case-insensitive comparison expression for a column.

fn epoch_from_col(col: &str) -> String

Epoch seconds expression for a timestamp column.

fn select_as_text(col: &str) -> String

Project a non-TEXT column so it decodes into a plain String.

fn timestamptz_from_epoch(placeholder: &str) -> String

Timestamp expression for binding a Unix epoch-seconds value into a TEXT/TIMESTAMPTZ compacted_at-style column.