Struct diesel::sqlite::Sqlite

pub struct Sqlite;

The SQLite backend

Trait Implementations

impl Backend for Sqlite

type QueryBuilder = SqliteQueryBuilder

The concrete QueryBuilder implementation for this backend.

type BindCollector = RawBytesBindCollector<Sqlite>

The concrete BindCollector implementation for this backend.

type ByteOrder = NativeEndian

What byte order is used to transmit integers?

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 Copy for Sqlite

impl Debug for Sqlite

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

Formats the value using the given formatter.

impl Eq for Sqlite

impl<'a, T, U, Op, C> ExecuteDsl<C, Sqlite> for InsertStatement<T, BatchInsert<'a, U, T>, Op> where
    C: Connection<Backend = Sqlite>,
    &'a U: Insertable<T>,
    InsertStatement<T, <&'a U as Insertable<T>>::Values, Op>: QueryFragment<Sqlite>,
    T: Copy,
    Op: Copy, 

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

Execute this command

impl<T, U, Op, C> ExecuteDsl<C, Sqlite> for InsertStatement<T, OwnedBatchInsert<ValuesClause<U, T>, T>, Op> where
    C: Connection<Backend = Sqlite>,
    InsertStatement<T, ValuesClause<U, T>, Op>: QueryFragment<Sqlite>,
    T: Copy,
    Op: Copy, 

fn execute(query: Self, conn: &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

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 *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<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

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

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 *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<Timestamp, Sqlite> for NaiveDateTime

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 *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<'a> HasRawValue<'a> for Sqlite

type RawValue = SqliteValue<'a>

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(_: &()) -> SqliteType

Fetch the metadata for the given type

impl HasSqlType<Binary> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Bool> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Date> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Double> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Float> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Integer> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Numeric> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<SmallInt> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Text> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Time> for Sqlite

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

Fetch the metadata for the given type

impl HasSqlType<Timestamp> for Sqlite

fn metadata(_: &()) -> 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, 

Feeds a slice of this type into the given [Hasher].

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, 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, 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<'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 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 ==.

#[must_use]fn ne(&self, other: &Rhs) -> bool

This method tests for !=.

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 QueryFragment<Sqlite> for LimitOffsetClause<NoLimitClause, NoOffsetClause>

fn walk_ast(&self, _out: AstPass<'_, Sqlite>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds(
    &self,
    out: &mut DB::BindCollector,
    metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>

Is this query safe to store in the prepared statement cache?

impl<L> QueryFragment<Sqlite> for LimitOffsetClause<LimitClause<L>, NoOffsetClause> where
    LimitClause<L>: QueryFragment<Sqlite>, 

fn walk_ast(&self, out: AstPass<'_, Sqlite>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds(
    &self,
    out: &mut DB::BindCollector,
    metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>

Is this query safe to store in the prepared statement cache?

impl<O> QueryFragment<Sqlite> for LimitOffsetClause<NoLimitClause, OffsetClause<O>> where
    OffsetClause<O>: QueryFragment<Sqlite>, 

fn walk_ast(&self, out: AstPass<'_, Sqlite>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds(
    &self,
    out: &mut DB::BindCollector,
    metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>

Is this query safe to store in the prepared statement cache?

impl<L, O> QueryFragment<Sqlite> for LimitOffsetClause<LimitClause<L>, OffsetClause<O>> where
    LimitClause<L>: QueryFragment<Sqlite>,
    OffsetClause<O>: QueryFragment<Sqlite>, 

fn walk_ast(&self, out: AstPass<'_, Sqlite>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds(
    &self,
    out: &mut DB::BindCollector,
    metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>

Is this query safe to store in the prepared statement cache?

impl<'a> QueryFragment<Sqlite> for BoxedLimitOffsetClause<'a, Sqlite>

fn walk_ast(&self, out: AstPass<'_, Sqlite>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds(
    &self,
    out: &mut DB::BindCollector,
    metadata_lookup: &DB::MetadataLookup
) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self) -> QueryResult<bool>

Is this query safe to store in the prepared statement cache?

impl StructuralEq for Sqlite

impl StructuralPartialEq for Sqlite

impl SupportsOnConflictClause for Sqlite

impl ToSql<Bool, Sqlite> for bool

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

See the trait documentation.

impl ToSql<Date, Sqlite> for NaiveDate

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

See the trait documentation.

impl ToSql<Date, Sqlite> for str

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

See the trait documentation.

impl ToSql<Date, Sqlite> for String

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

See the trait documentation.

impl ToSql<Time, Sqlite> for NaiveTime

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

See the trait documentation.

impl ToSql<Time, Sqlite> for str

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

See the trait documentation.

impl ToSql<Time, Sqlite> for String

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

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for NaiveDateTime

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

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for str

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

See the trait documentation.

impl ToSql<Timestamp, Sqlite> for String

fn to_sql<W: Write>(&self, out: &mut Output<'_, W, 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 UsesAnsiSavepointSyntax for Sqlite