The actual table struct
This is the type which provides the base methods of the query
builder, such as .select and .filter.
Represents table_name.*, which is sometimes necessary
for efficient count queries. It cannot be used in place of
all_columns
Performs copy-assignment from source. Read more
Formats the value using the given formatter. Read more
impl QuerySource for table | |
[+]
type FromClause = Identifier<'static>
The type returned by from_clause
The type returned by default_selection
[−]
The actual FROM clause of this type. This is typically only called in QueryFragment implementations. Read more
The default select clause of this type, which should be used if no select clause was explicitly specified. This should always be a tuple of all the desired columns, not star Read more
impl<Left, Right, Kind> JoinTo<Join<Left, Right, Kind>> for table where
Join<Left, Right, Kind>: JoinTo<table>, | |
[+]
type FromClause = Join<Left, Right, Kind>
type OnClause = <Join<Left, Right, Kind> as JoinTo<table>>::OnClause
fn join_target(
rhs: Join<Left, Right, Kind>
) -> (Self::FromClause, Self::OnClause) | |
impl<Join, On> JoinTo<JoinOn<Join, On>> for table where
JoinOn<Join, On>: JoinTo<table>, | |
[+]
impl<F, S, D, W, O, L, Of, G> JoinTo<SelectStatement<F, S, D, W, O, L, Of, G, NoLockingClause>> for table where
SelectStatement<F, S, D, W, O, L, Of, G>: JoinTo<table>, | |
[+]
type FromClause = SelectStatement<F, S, D, W, O, L, Of, G>
type OnClause = <SelectStatement<F, S, D, W, O, L, Of, G> as JoinTo<table>>::OnClause
fn join_target(
rhs: SelectStatement<F, S, D, W, O, L, Of, G>
) -> (Self::FromClause, Self::OnClause) | |
impl<'a, QS, ST, DB> JoinTo<BoxedSelectStatement<'a, QS, ST, DB>> for table where
BoxedSelectStatement<'a, QS, ST, DB>: JoinTo<table>, | |
[+]
type FromClause = BoxedSelectStatement<'a, QS, ST, DB>
type OnClause = <BoxedSelectStatement<'a, QS, ST, DB> as JoinTo<table>>::OnClause
fn join_target(
rhs: BoxedSelectStatement<'a, QS, ST, DB>
) -> (Self::FromClause, Self::OnClause) | |
[+]
type Table = Self
The table this type is associated with.
fn table() -> Self::Table | |
[−]
Returns the table this type is associated with.
The type returned by primary_key
The type returned by all_columns
[−]
Returns the primary key of this table. Read more
Returns a tuple of all columns belonging to this table.
The VALUES clause to insert these records Read more
fn insert_into(
self,
table: T
) -> InsertStatement<T, Self::Values, Insert, NoReturningClause> | |
[−]
[+]
The VALUES clause to insert these records Read more
fn insert_into(
self,
table: T
) -> InsertStatement<T, Self::Values, Insert, NoReturningClause> | |
[−]
impl<T> Insertable<T> for table where
<table as AsQuery>::Query: Insertable<T>, | |
[+]
type Values = <<table as AsQuery>::Query as Insertable<T>>::Values
The VALUES clause to insert these records Read more
fn values(self) -> Self::Values | |
[−]
fn insert_into(
self,
table: T
) -> InsertStatement<T, Self::Values, Insert, NoReturningClause> | |
[−]
impl<'a, T> Insertable<T> for &'a table where
table: Insertable<T>, | |
[+]
type Values = <table as Insertable<T>>::Values
The VALUES clause to insert these records Read more
fn values(self) -> Self::Values | |
[−]
fn insert_into(
self,
table: T
) -> InsertStatement<T, Self::Values, Insert, NoReturningClause> | |
[−]
impl IntoUpdateTarget for table | |
[+]
type WhereClause = <Self::Query as IntoUpdateTarget>::WhereClause
What is the WHERE clause of this target?
[−]
Decomposes self into the table and where clause.
type Count = Once
How many times does Self appear in QS?
impl AppearsInFromClause<table> for () | |
type Count = Never
How many times does Self appear in QS?
[+]
The SQL type of Self::Query
type Query = SelectStatement<Self>
What kind of query does this type represent?
[−]
Converts a type which semantically represents a SQL query into the actual query being executed. See the trait level docs for more. Read more
[+]
A type which uniquely represents Self in a SQL query. Read more
Can the SQL generated by Self be uniquely identified by its type? Read more
Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise. Read more
Creates owned data from borrowed data, usually by cloning. Read more
🔬 This is a nightly-only experimental API. (toowned_clone_into)
recently added
Uses borrowed data to replace owned data, usually by cloning. Read more
🔬 This is a nightly-only experimental API. (try_from)
The type returned in the event of a conversion error.
🔬 This is a nightly-only experimental API. (try_from)
Immutably borrows from an owned value. Read more
Mutably borrows from an owned value. Read more
🔬 This is a nightly-only experimental API. (try_from)
The type returned in the event of a conversion error.
🔬 This is a nightly-only experimental API. (try_from)
[−]
🔬 This is a nightly-only experimental API. (get_type_id)
this method will likely be replaced by an associated static
impl<T> JoinOnDsl for T where
T: QuerySource, | |
[−]
fn on<On>(self, on: On) -> OnClauseWrapper<Self, On> | |
[−]
See the trait documentation.
impl<Lhs, Rhs, On> JoinTo for Lhs where
Lhs: Table, | |
[−]
fn join_target(
rhs: OnClauseWrapper<Rhs, On>
) -> (<Lhs as JoinTo<OnClauseWrapper<Rhs, On>>>::FromClause, <Lhs as JoinTo<OnClauseWrapper<Rhs, On>>>::OnClause) | |
[−]
fn into_sql<T>(self) -> Self::Expression where
Self: AsExpression<T>, | |
[−]
Convert self to an expression for Diesel's query builder. Read more
fn as_sql<'a, T>(&'a self) -> <&'a Self as AsExpression<T>>::Expression where
&'a Self: AsExpression<T>, | |
[−]
Convert &self to an expression for Diesel's query builder. Read more
impl<T, Expr> GroupByDsl for T where
Expr: Expression,
T: Table + AsQuery,
<T as AsQuery>::Query: GroupByDsl<Expr>, | |
[−]
type Output = <<T as AsQuery>::Query as GroupByDsl<Expr>>::Output
The type returned by .group_by
fn group_by(self, expr: Expr) -> <T as GroupByDsl<Expr>>::Output | |
[−]
See the trait documentation.
impl<T, Conn> RunQueryDsl for T where
T: Table, | |
[−]
fn execute(self, conn: &Conn) -> Result<usize, Error> where
Conn: Connection,
Self: ExecuteDsl<Conn, <Conn as Connection>::Backend>, | |
[−]
Executes the given command, returning the number of rows affected. Read more
fn load<U>(self, conn: &Conn) -> Result<Vec<U>, Error> where
Self: LoadQuery<Conn, U>, | |
[−]
Executes the given query, returning a Vec with the returned rows. Read more
fn get_result<U>(self, conn: &Conn) -> Result<U, Error> where
Self: LoadQuery<Conn, U>, | |
[−]
Runs the command, and returns the affected row. Read more
[−]
Runs the command, returning an Vec with the affected rows. Read more
fn first<U>(self, conn: &Conn) -> Result<U, Error> where
Self: LimitDsl,
Self::Output: LoadQuery<Conn, U>, | |
[−]
impl<T> QueryDsl for T where
T: Table, | |
[−]
fn distinct(self) -> Self::Output where
Self: DistinctDsl, | |
[−]
Adds the DISTINCT keyword to a query. Read more
fn select<Selection>(self, selection: Selection) -> Self::Output where
Selection: Expression,
Self: SelectDsl<Selection>, | |
[−]
fn count(self) -> Self::Output where
Self: SelectDsl<CountStar>, | |
[−]
Get the count of a query. This is equivalent to .select(count_star()) Read more
fn inner_join<Rhs>(self, rhs: Rhs) -> Self::Output where
Self: JoinWithImplicitOnClause<Rhs, Inner>, | |
[−]
Join two tables using a SQL INNER JOIN. Read more
fn left_outer_join<Rhs>(self, rhs: Rhs) -> Self::Output where
Self: JoinWithImplicitOnClause<Rhs, LeftOuter>, | |
[−]
Join two tables using a SQL LEFT OUTER JOIN. Read more
fn left_join<Rhs>(self, rhs: Rhs) -> Self::Output where
Self: JoinWithImplicitOnClause<Rhs, LeftOuter>, | |
[−]
fn filter<Predicate>(self, predicate: Predicate) -> Self::Output where
Self: FilterDsl<Predicate>, | |
[−]
Adds to the WHERE clause of a query. Read more
fn or_filter<Predicate>(self, predicate: Predicate) -> Self::Output where
Self: OrFilterDsl<Predicate>, | |
[−]
Adds to the WHERE clause of a query using OR Read more
fn find<PK>(self, id: PK) -> Self::Output where
Self: FindDsl<PK>, | |
[−]
Attempts to find a single record from the given table by primary key. Read more
fn order<Expr>(self, expr: Expr) -> Self::Output where
Expr: Expression,
Self: OrderDsl<Expr>, | |
[−]
fn order_by<Expr>(self, expr: Expr) -> Self::Output where
Expr: Expression,
Self: OrderDsl<Expr>, | |
[−]
fn then_order_by<Order>(self, order: Order) -> Self::Output where
Self: ThenOrderDsl<Order>, | |
[−]
Appends to the ORDER BY clause of this SQL query. Read more
fn limit(self, limit: i64) -> Self::Output where
Self: LimitDsl, | |
[−]
Sets the limit clause of the query. Read more
fn offset(self, offset: i64) -> Self::Output where
Self: OffsetDsl, | |
[−]
Sets the offset clause of the query. Read more
fn for_update(self) -> Self::Output where
Self: ForUpdateDsl, | |
[−]
Adds FOR UPDATE to the end of the select statement. Read more
[−]
Adds FOR NO KEY UPDATE to the end of the select statement. Read more
fn for_share(self) -> Self::Output where
Self: LockingDsl<ForShare>, | |
[−]
Adds FOR SHARE to the end of the select statement. Read more
fn for_key_share(self) -> Self::Output where
Self: LockingDsl<ForKeyShare>, | |
[−]
Adds FOR KEY SHARE to the end of the select statement. Read more
fn skip_locked(self) -> Self::Output where
Self: ModifyLockDsl<SkipLocked>, | |
[−]
Adds SKIP LOCKED to the end of a FOR UPDATE clause. Read more
fn no_wait(self) -> Self::Output where
Self: ModifyLockDsl<NoWait>, | |
[−]
Adds NOWAIT to the end of a FOR UPDATE clause. Read more
fn into_boxed<'a, DB>(self) -> Self::Output where
DB: Backend,
Self: BoxedDsl<'a, DB>, | |
[−]
Boxes the pieces of a query into a single type. Read more
fn single_value(self) -> Self::Output where
Self: SingleValueDsl, | |
[−]
Wraps this select statement in parenthesis, allowing it to be used as an expression. Read more