Struct diesel::sqlite::Sqlite

pub struct Sqlite;

Available on crate feature sqlite only.

The SQLite backend

Trait Implementations

impl Backend for Sqlite

type QueryBuilder = SqliteQueryBuilder

The concrete QueryBuilder implementation for this backend.

impl Clone for Sqlite

fn clone(&self) -> Sqlite

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<'conn, 'query> ConnectionGatWorkaround<'conn, 'query, Sqlite, DefaultLoadingMode> for SqliteConnection

type Cursor = StatementIterator<'conn, 'query>

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

The cursor type returned by LoadConnection::load

type Row = SqliteRow<'conn, 'query>

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

The row type used as Iterator::Item for the iterator implementation of ConnectionGatWorkaround::Cursor

impl Debug for Sqlite

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

Formats the value using the given formatter.

impl Default for Sqlite

fn default() -> Sqlite

Returns the “default value” for a type.

impl<V, T, QId, C, Op, const STATIC_QUERY_ID: bool> ExecuteDsl<C, Sqlite> for (No, InsertStatement<T, BatchInsert<V, T, QId, STATIC_QUERY_ID>, Op>)where
    C: Connection<Backend = Sqlite>,
    T: Table + QueryId + 'static,
    T::FromClause: QueryFragment<Sqlite>,
    Op: QueryFragment<Sqlite> + QueryId,
    SqliteBatchInsertWrapper<V, T, QId, STATIC_QUERY_ID>: QueryFragment<Sqlite> + QueryId + CanInsertInSingleQuery<Sqlite>,

fn execute((No, query): Self, conn: &mut C) -> QueryResult<usize>

Execute this command

impl<V, T, QId, C, Op, const STATIC_QUERY_ID: bool> ExecuteDsl<C, Sqlite> for (Yes, InsertStatement<T, BatchInsert<Vec<ValuesClause<V, T>>, T, QId, STATIC_QUERY_ID>, Op>)where
    C: Connection<Backend = Sqlite>,
    T: Table + Copy + QueryId + 'static,
    T::FromClause: QueryFragment<Sqlite>,
    Op: Copy + QueryId + QueryFragment<Sqlite>,
    V: InsertValues<T, Sqlite> + CanInsertInSingleQuery<Sqlite> + QueryId,

fn execute((Yes, query): Self, conn: &mut C) -> QueryResult<usize>

Execute this command

impl<V, T, QId, C, Op, O, const STATIC_QUERY_ID: bool> ExecuteDsl<C, Sqlite> for InsertStatement<T, BatchInsert<Vec<ValuesClause<V, T>>, T, QId, STATIC_QUERY_ID>, Op>where
    T: QuerySource,
    C: Connection<Backend = Sqlite>,
    V: ContainsDefaultableValue<Out = O>,
    O: Default,
    (O, Self): ExecuteDsl<C, Sqlite>,

fn execute(query: Self, conn: &mut C) -> QueryResult<usize>

Execute this command

impl FromSql<BigInt, Sqlite> for i64

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Binary, Sqlite> for *const [u8]

The returned pointer is only valid for the lifetime to the argument of from_sql. This impl is intended for uses where you want to write a new impl in terms of Vec<u8>, but don’t want to allocate. We have to return a raw pointer instead of a reference with a lifetime due to the structure of FromSql

fn from_sql(bytes: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Bool, Sqlite> for bool

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Date, Sqlite> for NaiveDate

Available on crate feature chrono only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Date, Sqlite> for NaiveDate

Available on crate feature time only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Date, Sqlite> for String

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Double, Sqlite> for f64

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Float, Sqlite> for f32

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Integer, Sqlite> for i32

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Numeric, Sqlite> for BigDecimal

Available on crate feature bigdecimal only.

fn from_sql(bytes: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<SmallInt, Sqlite> for i16

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Text, Sqlite> for *const str

The returned pointer is only valid for the lifetime to the argument of from_sql. This impl is intended for uses where you want to write a new impl in terms of String, but don’t want to allocate. We have to return a raw pointer instead of a reference with a lifetime due to the structure of FromSql

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Time, Sqlite> for NaiveTime

Available on crate feature chrono only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Time, Sqlite> for NaiveTime

Available on crate feature time only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Time, Sqlite> for String

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamp, Sqlite> for NaiveDateTime

Available on crate feature chrono only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamp, Sqlite> for PrimitiveDateTime

Available on crate feature time only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamp, Sqlite> for String

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Sqlite> for DateTime<Local>

Available on crate feature chrono only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Sqlite> for DateTime<Utc>

Available on crate feature chrono only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Sqlite> for NaiveDateTime

Available on crate feature chrono only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Sqlite> for OffsetDateTime

Available on crate feature time only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Sqlite> for PrimitiveDateTime

Available on crate feature time only.

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Timestamptz, Sqlite> for String

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl<'a> HasBindCollector<'a> for Sqlite

type BindCollector = SqliteBindCollector<'a>

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

The concrete BindCollector implementation for this backend.

impl<'a> HasRawValue<'a> for Sqlite

type RawValue = SqliteValue<'a, 'a, 'a>

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

The actual type given to FromSql, with lifetimes applied. This type should not be used directly. Use the RawValue helper type instead.

impl HasSqlType<BigInt> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Binary> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Bool> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Date> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Double> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Float> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Integer> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Numeric> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<SmallInt> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Text> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Time> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Timestamp> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Timestamptz> for Sqlite

fn metadata(_: &mut ()) -> SqliteType

Fetch the metadata for the given type

impl Hash for Sqlite

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)where
    H: Hasher,
    Self: Sized,

Feeds a slice of this type into the given Hasher.

impl<'a, L> IntoBoxedClause<'a, Sqlite> for LimitOffsetClause<LimitClause<L>, NoOffsetClause>where
    L: QueryFragment<Sqlite> + Send + 'a,

type BoxedClause = BoxedLimitOffsetClause<'a, Sqlite>

Resulting type

fn into_boxed(self) -> Self::BoxedClause

Convert the given query node in it’s boxed representation

impl<'a, L, O> IntoBoxedClause<'a, Sqlite> for LimitOffsetClause<LimitClause<L>, OffsetClause<O>>where
    L: QueryFragment<Sqlite> + Send + 'a,
    O: QueryFragment<Sqlite> + Send + 'a,

type BoxedClause = BoxedLimitOffsetClause<'a, Sqlite>

Resulting type

fn into_boxed(self) -> Self::BoxedClause

Convert the given query node in it’s boxed representation

impl<'a> IntoBoxedClause<'a, Sqlite> for LimitOffsetClause<NoLimitClause, NoOffsetClause>

type BoxedClause = BoxedLimitOffsetClause<'a, Sqlite>

Resulting type

fn into_boxed(self) -> Self::BoxedClause

Convert the given query node in it’s boxed representation

impl<'a, O> IntoBoxedClause<'a, Sqlite> for LimitOffsetClause<NoLimitClause, OffsetClause<O>>where
    O: QueryFragment<Sqlite> + Send + 'a,

type BoxedClause = BoxedLimitOffsetClause<'a, Sqlite>

Resulting type

fn into_boxed(self) -> Self::BoxedClause

Convert the given query node in it’s boxed representation

impl PartialEq<Sqlite> for Sqlite

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

This method tests for self and other values to be equal, and is used by ==.

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

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl QueryBuilder<Sqlite> for SqliteQueryBuilder

fn push_sql(&mut self, sql: &str)

Add sql to the end of the query being constructed.

fn push_identifier(&mut self, identifier: &str) -> QueryResult<()>

Quote identifier, and add it to the end of the query being constructed.

fn push_bind_param(&mut self)

Add a placeholder for a bind parameter to the end of the query being constructed.

fn finish(self) -> String

Returns the constructed SQL query.

fn push_bind_param_value_only(&mut self)

Increases the internal counter for bind parameters without adding the bind parameter itself to the query

impl SqlDialect for Sqlite

type ReturningClause = DoesNotSupportReturningClause

Configures how this backends supports RETURNING clauses

type OnConflictClause = SqliteOnConflictClause

Configures how this backend supports ON CONFLICT clauses

type InsertWithDefaultKeyword = DoesNotSupportDefaultKeyword

Configures how this backend handles the bare DEFAULT keyword for inserting the default value in a INSERT INTO VALUES clause

type BatchInsertSupport = SqliteBatchInsert

Configures how this backend handles Batch insert statements

type ConcatClause = ConcatWithPipesClause

Configures how this backend handles the Concat clauses in select statements.

type DefaultValueClauseForInsert = AnsiDefaultValueClause

Configures how this backend handles the DEFAULT VALUES clause for insert statements.

type EmptyFromClauseSyntax = AnsiSqlFromClauseSyntax

Configures how this backend handles empty FROM clauses for select statements.

type SelectStatementSyntax = AnsiSqlSelectStatement

Configures how this backend structures SELECT queries

type ExistsSyntax = AnsiSqlExistsSyntax

Configures how this backend handles EXISTS() expressions.

type ArrayComparison = AnsiSqlArrayComparison

Configures how this backend handles IN() and NOT IN() expressions.

impl ToSql<BigInt, Sqlite> for i64

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Binary, Sqlite> for [u8]

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Bool, Sqlite> for bool

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Date, Sqlite> for NaiveDate

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Date, Sqlite> for NaiveDate

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Date, Sqlite> for String

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Date, Sqlite> for str

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Double, Sqlite> for f64

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Float, Sqlite> for f32

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Integer, Sqlite> for i32

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<SmallInt, Sqlite> for i16

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Text, Sqlite> for str

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Time, Sqlite> for NaiveTime

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Time, Sqlite> for NaiveTime

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Time, Sqlite> for String

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Time, Sqlite> for str

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for NaiveDateTime

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for PrimitiveDateTime

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for String

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for str

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl<TZ: TimeZone> ToSql<Timestamptz, Sqlite> for DateTime<TZ>

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Sqlite> for NaiveDateTime

Available on crate feature chrono only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Sqlite> for OffsetDateTime

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Sqlite> for PrimitiveDateTime

Available on crate feature time only.

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Sqlite> for String

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl ToSql<Timestamptz, Sqlite> for str

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Sqlite>) -> Result

See the trait documentation.

impl TypeMetadata for Sqlite

type TypeMetadata = SqliteType

The actual type used to represent metadata.

type MetadataLookup = ()

The type used for runtime lookup of metadata.

impl Copy for Sqlite

impl DieselReserveSpecialization for Sqlite

impl Eq for Sqlite

impl StructuralEq for Sqlite

impl StructuralPartialEq for Sqlite

impl TrustedBackend for Sqlite