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.

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

The actual type given to FromSql, with lifetimes applied. This type should not be used directly.

type BindCollector<'a> = SqliteBindCollector<'a>

The concrete BindCollector 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 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Date, Sqlite> for Date

Available on crate feature time only.

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

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

impl FromSql<Time, Sqlite> for Time

Available on crate feature time only.

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

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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: <Sqlite as Backend>::RawValue<'_>) -> Result<Self>

See the trait documentation.

fn from_nullable_sql(bytes: Option<DB::RawValue<'_>>) -> 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<DB::RawValue<'_>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

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 PartialEq 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 Queryable<Binary, Sqlite> for *const [u8]

type Row = *const [u8]

The Rust type you’d like to map from.

fn build(row: Self::Row) -> Result<Self>

Construct an instance of this type

impl Queryable<Text, Sqlite> for *const str

type Row = *const str

The Rust type you’d like to map from.

fn build(row: Self::Row) -> Result<Self>

Construct an instance of this type

impl SqlDialect for Sqlite

type ReturningClause = DoesNotSupportReturningClause

Configures how this backend 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 Date

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

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

See the trait documentation.

impl ToSql<Time, Sqlite> for Time

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

impl StructuralPartialEq for Sqlite