Struct diesel::query_builder::InsertStatement

source · [−]

pub struct InsertStatement<T, U, Op = Insert, Ret = NoReturningClause> { /* private fields */ }

Expand description

A fully constructed insert statement.

The parameters of this struct represent:

T: The table we are inserting into
U: The data being inserted
Op: The operation being performed. The specific types used to represent this are private, but correspond to SQL such as INSERT or REPLACE. You can safely rely on the default type representing INSERT
Ret: The RETURNING clause of the query. The specific types used to represent this are private. You can safely rely on the default type representing a query without a RETURNING clause.

Implementations

source

impl<T, U, C, Op, Ret> InsertStatement<T, InsertFromSelect<U, C>, Op, Ret>

source

pub fn into_columns<C2>(
 self,
 columns: C2
) -> InsertStatement<T, InsertFromSelect<U, C2>, Op, Ret> where
 C2: ColumnList<Table = T> + Expression<SqlType = U::SqlType>,
 U: Query,

Set the column list when inserting from a select statement

See the documentation for insert_into for usage examples.

source

impl<T, U, Op> InsertStatement<T, U, Op>

source

pub fn returning<E>(
 self,
 returns: E
) -> InsertStatement<T, U, Op, ReturningClause<E>> where
 InsertStatement<T, U, Op, ReturningClause<E>>: Query,

Specify what expression is returned after execution of the insert.

Examples

Inserting records:

let inserted_names = diesel::insert_into(users)
    .values(&vec![name.eq("Timmy"), name.eq("Jimmy")])
    .returning(name)
    .get_results(&connection);
assert_eq!(Ok(vec!["Timmy".to_string(), "Jimmy".to_string()]), inserted_names);

Trait Implementations

source

impl<T, U, Op> AsQuery for InsertStatement<T, U, Op, NoReturningClause> where
T: Table,
InsertStatement<T, U, Op, ReturningClause<T::AllColumns>>: Query,

type SqlType = <Self::Query as Query>::SqlType

The SQL type of Self::Query

type Query = InsertStatement<T, U, Op, ReturningClause<T::AllColumns>>

What kind of query does this type represent?

source

fn as_query(self) -> Self::Query

Converts a type which semantically represents a SQL query into the actual query being executed. See the trait level docs for more. Read more

source

impl<T: Clone, U: Clone, Op: Clone, Ret: Clone> Clone for InsertStatement<T, U, Op, Ret>

source

fn clone(&self) -> InsertStatement<T, U, Op, Ret>

Returns a copy of the value. Read more

1.0.0 · source

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

Performs copy-assignment from source. Read more

source

impl<T: Debug, U: Debug, Op: Debug, Ret: Debug> Debug for InsertStatement<T, U, Op, Ret>

source

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

Formats the value using the given formatter. Read more

source

impl<T, U, Op, Ret> Query for InsertStatement<T, U, Op, ReturningClause<Ret>> where
Ret: Expression + SelectableExpression<T> + NonAggregate,

type SqlType = Ret::SqlType

The SQL type that this query represents. Read more

source

impl<T, U, Op, Ret, DB> QueryFragment<DB> for InsertStatement<T, U, Op, Ret> where
 DB: Backend,
 T: Table,
 T::FromClause: QueryFragment<DB>,
 U: QueryFragment<DB> + CanInsertInSingleQuery<DB>,
 Op: QueryFragment<DB>,
 Ret: QueryFragment<DB>,

source

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

Walk over this QueryFragment for all passes. Read more

source

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

Converts this QueryFragment to its SQL representation. Read more

source

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

Serializes all bind parameters in this query. Read more

source

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

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

source

impl<T, U, Op, Ret> QueryId for InsertStatement<T, U, Op, Ret>

type QueryId = ()

A type which uniquely represents Self in a SQL query. Read more

source

const HAS_STATIC_QUERY_ID: bool

Can the SQL generated by Self be uniquely identified by its type? Read more

source

fn query_id() -> Option<TypeId>

Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise. Read more

source

impl<T, U, Op, Ret, Conn> RunQueryDsl<Conn> for InsertStatement<T, U, Op, Ret>

source

fn execute(self, conn: &Conn) -> QueryResult<usize> where
Conn: Connection,
Self: ExecuteDsl<Conn>,

Executes the given command, returning the number of rows affected. Read more

source

fn load(self, conn: &Conn) -> QueryResult<Vec> where
Self: LoadQuery<Conn, U>,

Executes the given query, returning a Vec with the returned rows. Read more

source

fn get_result(self, conn: &Conn) -> QueryResult where
Self: LoadQuery<Conn, U>,

Runs the command, and returns the affected row. Read more

source

fn get_results(self, conn: &Conn) -> QueryResult<Vec> where
Self: LoadQuery<Conn, U>,

Runs the command, returning an Vec with the affected rows. Read more

source

fn first(self, conn: &Conn) -> QueryResult where
Self: LimitDsl,
Limit<Self>: LoadQuery<Conn, U>,

Attempts to load a single record. Read more

source

impl<T: Copy, U: Copy, Op: Copy, Ret: Copy> Copy for InsertStatement<T, U, Op, Ret>

Auto Trait Implementations

impl<T, U, Op, Ret> RefUnwindSafe for InsertStatement<T, U, Op, Ret> where
 Op: RefUnwindSafe,
 Ret: RefUnwindSafe,
 T: RefUnwindSafe,
 U: RefUnwindSafe,

impl<T, U, Op, Ret> Send for InsertStatement<T, U, Op, Ret> where
 Op: Send,
 Ret: Send,
 T: Send,
 U: Send,

impl<T, U, Op, Ret> Sync for InsertStatement<T, U, Op, Ret> where
 Op: Sync,
 Ret: Sync,
 T: Sync,
 U: Sync,

impl<T, U, Op, Ret> Unpin for InsertStatement<T, U, Op, Ret> where
 Op: Unpin,
 Ret: Unpin,
 T: Unpin,
 U: Unpin,

impl<T, U, Op, Ret> UnwindSafe for InsertStatement<T, U, Op, Ret> where
 Op: UnwindSafe,
 Ret: UnwindSafe,
 T: UnwindSafe,
 U: UnwindSafe,

Blanket Implementations

source

impl<T> Any for T where
T: 'static + ?Sized,

source

pub fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more

source

impl<T> AsQuery for T where
T: Query,

type SqlType = <Self as Query>::SqlType

The SQL type of Self::Query

type Query = Self

What kind of query does this type represent?

source

fn as_query(self) -> Self::Query

Converts a type which semantically represents a SQL query into the actual query being executed. See the trait level docs for more. Read more

source

impl<T> Borrow<T> for T where
T: ?Sized,

const: unstable · source

pub fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more

source

impl<T> BorrowMut<T> for T where
T: ?Sized,

const: unstable · source

pub fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more

source

impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T where
 Conn: Connection<Backend = DB>,
 DB: Backend,
 T: QueryFragment<DB> + QueryId,

source

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

Execute this command

source

impl<T> From<T> for T

const: unstable · source

pub fn from(t: T) -> T

Returns the argument unchanged.

source

impl<T, U> Into for T where
U: From<T>,

const: unstable · source

pub fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

source

impl<T> IntoSql for T

source

fn into_sql<T>(self) -> AsExprOf<Self, T> where
Self: AsExpression<T> + Sized,

Convert self to an expression for Diesel’s query builder. Read more

source

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where
&'a Self: AsExpression<T>,

Convert &self to an expression for Diesel’s query builder. Read more

source

impl<T> ToOwned for T where
T: Clone,

type Owned = T

The resulting type after obtaining ownership.

source

pub fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more

source

pub fn clone_into(&self, target: &mut T)

🔬 This is a nightly-only experimental API. (toowned_clone_into)

Uses borrowed data to replace owned data, usually by cloning. Read more

source

impl<T, U> TryFrom for T where
U: Into<T>,

type Error = Infallible

The type returned in the event of a conversion error.

const: unstable · source

pub fn try_from(value: U) -> Result<T, <T as TryFrom>::Error>

Performs the conversion.

source

impl<T, U> TryInto for T where
U: TryFrom<T>,

type Error = >::Error

The type returned in the event of a conversion error.

const: unstable · source

pub fn try_into(self) -> Result<U, >::Error>

Performs the conversion.

Struct diesel::query_builder::InsertStatement

Implementations

impl<T, U, C, Op, Ret> InsertStatement<T, InsertFromSelect<U, C>, Op, Ret>

pub fn into_columns<C2>( self, columns: C2) -> InsertStatement<T, InsertFromSelect<U, C2>, Op, Ret> where C2: ColumnList<Table = T> + Expression<SqlType = U::SqlType>, U: Query,

impl<T, U, Op> InsertStatement<T, U, Op>

pub fn returning<E>( self, returns: E) -> InsertStatement<T, U, Op, ReturningClause<E>> where InsertStatement<T, U, Op, ReturningClause<E>>: Query,

Trait Implementations

impl<T, U, Op> AsQuery for InsertStatement<T, U, Op, NoReturningClause> where T: Table, InsertStatement<T, U, Op, ReturningClause<T::AllColumns>>: Query,

type SqlType = <Self::Query as Query>::SqlType

type Query = InsertStatement<T, U, Op, ReturningClause<T::AllColumns>>

fn as_query(self) -> Self::Query

impl<T: Clone, U: Clone, Op: Clone, Ret: Clone> Clone for InsertStatement<T, U, Op, Ret>

fn clone(&self) -> InsertStatement<T, U, Op, Ret>

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

impl<T: Debug, U: Debug, Op: Debug, Ret: Debug> Debug for InsertStatement<T, U, Op, Ret>

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

impl<T, U, Op, Ret> Query for InsertStatement<T, U, Op, ReturningClause<Ret>> where Ret: Expression + SelectableExpression<T> + NonAggregate,

type SqlType = Ret::SqlType

impl<T, U, Op, Ret, DB> QueryFragment<DB> for InsertStatement<T, U, Op, Ret> where DB: Backend, T: Table, T::FromClause: QueryFragment<DB>, U: QueryFragment<DB> + CanInsertInSingleQuery<DB>, Op: QueryFragment<DB>, Ret: QueryFragment<DB>,

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

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

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

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

impl<T, U, Op, Ret> QueryId for InsertStatement<T, U, Op, Ret>

type QueryId = ()

const HAS_STATIC_QUERY_ID: bool

fn query_id() -> Option<TypeId>

impl<T, U, Op, Ret, Conn> RunQueryDsl<Conn> for InsertStatement<T, U, Op, Ret>

fn execute(self, conn: &Conn) -> QueryResult<usize> where Conn: Connection, Self: ExecuteDsl<Conn>,

fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where Self: LoadQuery<Conn, U>,

fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where Self: LoadQuery<Conn, U>,

fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where Self: LoadQuery<Conn, U>,

fn first<U>(self, conn: &Conn) -> QueryResult<U> where Self: LimitDsl, Limit<Self>: LoadQuery<Conn, U>,

impl<T: Copy, U: Copy, Op: Copy, Ret: Copy> Copy for InsertStatement<T, U, Op, Ret>

Auto Trait Implementations

impl<T, U, Op, Ret> RefUnwindSafe for InsertStatement<T, U, Op, Ret> where Op: RefUnwindSafe, Ret: RefUnwindSafe, T: RefUnwindSafe, U: RefUnwindSafe,

impl<T, U, Op, Ret> Send for InsertStatement<T, U, Op, Ret> where Op: Send, Ret: Send, T: Send, U: Send,

impl<T, U, Op, Ret> Sync for InsertStatement<T, U, Op, Ret> where Op: Sync, Ret: Sync, T: Sync, U: Sync,

impl<T, U, Op, Ret> Unpin for InsertStatement<T, U, Op, Ret> where Op: Unpin, Ret: Unpin, T: Unpin, U: Unpin,

impl<T, U, Op, Ret> UnwindSafe for InsertStatement<T, U, Op, Ret> where Op: UnwindSafe, Ret: UnwindSafe, T: UnwindSafe, U: UnwindSafe,

Blanket Implementations

impl<T> Any for T where T: 'static + ?Sized,

pub fn type_id(&self) -> TypeId

impl<T> AsQuery for T where T: Query,

type SqlType = <Self as Query>::SqlType

type Query = Self

fn as_query(self) -> Self::Query

impl<T> Borrow<T> for T where T: ?Sized,

pub fn borrow(&self) -> &T

impl<T> BorrowMut<T> for T where T: ?Sized,

pub fn borrow_mut(&mut self) -> &mut T

impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T where Conn: Connection<Backend = DB>, DB: Backend, T: QueryFragment<DB> + QueryId,

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

impl<T> From<T> for T

pub fn from(t: T) -> T

impl<T, U> Into<U> for T where U: From<T>,

pub fn into(self) -> U

impl<T> IntoSql for T

fn into_sql<T>(self) -> AsExprOf<Self, T> where Self: AsExpression<T> + Sized,

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where &'a Self: AsExpression<T>,

impl<T> ToOwned for T where T: Clone,

type Owned = T

pub fn to_owned(&self) -> T

pub fn clone_into(&self, target: &mut T)

impl<T, U> TryFrom<U> for T where U: Into<T>,

type Error = Infallible

pub fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

impl<T, U> TryInto<U> for T where U: TryFrom<T>,

type Error = <U as TryFrom<T>>::Error

pub fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

pub fn into_columns<C2>(
self,
columns: C2
) -> InsertStatement<T, InsertFromSelect<U, C2>, Op, Ret> where
C2: ColumnList<Table = T> + Expression<SqlType = U::SqlType>,
U: Query,

pub fn returning<E>(
self,
returns: E
) -> InsertStatement<T, U, Op, ReturningClause<E>> where
InsertStatement<T, U, Op, ReturningClause<E>>: Query,

impl<T, U, Op> AsQuery for InsertStatement<T, U, Op, NoReturningClause> where
T: Table,
InsertStatement<T, U, Op, ReturningClause<T::AllColumns>>: Query,

impl<T, U, Op, Ret> Query for InsertStatement<T, U, Op, ReturningClause<Ret>> where
Ret: Expression + SelectableExpression<T> + NonAggregate,

impl<T, U, Op, Ret, DB> QueryFragment<DB> for InsertStatement<T, U, Op, Ret> where
DB: Backend,
T: Table,
T::FromClause: QueryFragment<DB>,
U: QueryFragment<DB> + CanInsertInSingleQuery<DB>,
Op: QueryFragment<DB>,
Ret: QueryFragment<DB>,

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

fn execute(self, conn: &Conn) -> QueryResult<usize> where
Conn: Connection,
Self: ExecuteDsl<Conn>,

fn load<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,

fn get_result<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LoadQuery<Conn, U>,

fn get_results<U>(self, conn: &Conn) -> QueryResult<Vec<U>> where
Self: LoadQuery<Conn, U>,

fn first<U>(self, conn: &Conn) -> QueryResult<U> where
Self: LimitDsl,
Limit<Self>: LoadQuery<Conn, U>,

impl<T, U, Op, Ret> RefUnwindSafe for InsertStatement<T, U, Op, Ret> where
Op: RefUnwindSafe,
Ret: RefUnwindSafe,
T: RefUnwindSafe,
U: RefUnwindSafe,

impl<T, U, Op, Ret> Send for InsertStatement<T, U, Op, Ret> where
Op: Send,
Ret: Send,
T: Send,
U: Send,

impl<T, U, Op, Ret> Sync for InsertStatement<T, U, Op, Ret> where
Op: Sync,
Ret: Sync,
T: Sync,
U: Sync,

impl<T, U, Op, Ret> Unpin for InsertStatement<T, U, Op, Ret> where
Op: Unpin,
Ret: Unpin,
T: Unpin,
U: Unpin,

impl<T, U, Op, Ret> UnwindSafe for InsertStatement<T, U, Op, Ret> where
Op: UnwindSafe,
Ret: UnwindSafe,
T: UnwindSafe,
U: UnwindSafe,

impl<T> Any for T where
T: 'static + ?Sized,

impl<T> AsQuery for T where
T: Query,

impl<T> Borrow<T> for T where
T: ?Sized,

impl<T> BorrowMut<T> for T where
T: ?Sized,

impl<Conn, DB, T> ExecuteDsl<Conn, DB> for T where
Conn: Connection<Backend = DB>,
DB: Backend,
T: QueryFragment<DB> + QueryId,

impl<T, U> Into<U> for T where
U: From<T>,

fn into_sql<T>(self) -> AsExprOf<Self, T> where
Self: AsExpression<T> + Sized,

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where
&'a Self: AsExpression<T>,

impl<T> ToOwned for T where
T: Clone,

impl<T, U> TryFrom<U> for T where
U: Into<T>,

impl<T, U> TryInto<U> for T where
U: TryFrom<T>,