[−][src]Module diesel::dsl

Includes various helper types and bare functions which are named too generically to be included in prelude, but are often used when using Diesel.

Re-exports

pub use crate::pg::expression::dsl::*;

Structs

now	Represents the SQL `CURRENT_TIMESTAMP` constant. This is equivalent to the `NOW()` function on backends that support it.
today	Represents the SQL `CURRENT_DATE` constant.

Traits

SqlOrdAggregate

Functions

avg	Represents a SQL `AVG` function. This function can only take types which are Foldable.
count	Creates a SQL `COUNT` expression
count_star	Creates a SQL `COUNT(*)` expression
date	Represents the SQL `DATE` function. The argument should be a Timestamp expression, and the return value will be an expression of type Date.
delete	Creates a `DELETE` statement.
exists	Creates a SQL `EXISTS` expression.
insert_into	Creates an `INSERT` statement for the target table.
insert_or_ignore_into	Creates an `INSERT [OR] IGNORE` statement.
max	Represents a SQL `MAX` function. This function can only take types which are ordered.
min	Represents a SQL `MIN` function. This function can only take types which are ordered.
not	Creates a SQL `NOT` expression
replace_into	Creates a `REPLACE` statement.
select	Creates a bare select statement, with no from clause. Primarily used for testing diesel itself, but likely useful for third party crates as well. The given expressions must be selectable from anywhere.
sql	Use literal SQL in the query builder.
sql_query	Construct a full SQL query using raw SQL.
sum	Represents a SQL `SUM` function. This function can only take types which are Foldable.
update	Creates an `UPDATE` statement.

Type Definitions

And	The return type of `lhs.and(rhs)`
AndNet	The return type of `lsh.and(rhs)`
ArrayContains	The return type of `lhs.contains(rhs)` for array expressions
AsExpr	The type of `Item` when converted to an expression with the same type as `TargetExpr`
AsExprOf	The type of `Item` when converted to an expression of `Type`
Asc	The return type of `expr.asc()`
AtTimeZone	The return type of `expr.at_time_zone(tz)`
Between	The return type of `lhs.between(lower, upper)`
Concat	The return type of `lhs.concat(rhs)`
ContainsNet	The return type of `lsh.contains(rhs)`
ContainsNetLoose	The return type of `lsh.contains_or_eq(rhs)`
Desc	The return type of `expr.desc()`
DifferenceNet	The return type of `lsh.diff(rhs)`
Distinct	Represents the return type of `.distinct()`
DistinctOn	Represents the return type of `.distinct_on(expr)`
Eq	The return type of `lhs.eq(rhs)`
EqAny	The return type of `lhs.eq_any(rhs)`
Escape	The return type of `lhs.escape('x')`
Except	Represents the return type of `.except(rhs)`
ExceptAll	Represents the return type of `.except_all(rhs)`
Filter	Represents the return type of `.filter(predicate)`
Find	Represents the return type of `.find(pk)`
FindBy	Represents the return type of `.filter(lhs.eq(rhs))`
ForKeyShare	Represents the return type of `.for_key_share()`
ForNoKeyUpdate	Represents the return type of `.for_no_key_update()`
ForShare	Represents the return type of `.for_share()`
ForUpdate	Represents the return type of `.for_update()`
GroupBy	Represents the return type of `.group_by(expr)`
Gt	The return type of `lhs.gt(rhs)`
GtEq	The return type of `lhs.ge(rhs)`
ILike	The return type of `lhs.ilike(rhs)`
InnerJoin	Represents the return type of `.inner_join(rhs)`
InnerJoinOn	Represents the return type of `.inner_join(rhs.on(on))`
InnerJoinQuerySource	A query source representing the inner join between two tables. For example, for the inner join between three tables that implement `JoinTo`: `InnerJoinQuerySource<InnerJoinQuerySource<table1, table2>, table3>` Which conveniently lets you omit the exact join condition.
Intersect	Represents the return type of `.intersect(rhs)`
IntersectAll	Represents the return type of `.intersect_all(rhs)`
IntoBoxed	Represents the return type of `.into_boxed::<'a, DB>()`
IsContainedBy	The return type of `lhs.is_contained_by(rhs)`
IsContainedByNet	The return type of `lsh.is_contained_by(rhs)`
IsContainedByNetLoose	The return type of `lsh.is_contained_by_or_eq(rhs)`
IsDistinctFrom	The return type of `lhs.is_distinct_from(rhs)`
IsNotDistinctFrom	The return type of `lhs.is_not_distinct_from(rhs)`
IsNotNull	The return type of `expr.is_not_null()`
IsNull	The return type of `expr.is_null()`
LeftJoin	Represents the return type of `.left_join(rhs)`
LeftJoinOn	Represents the return type of `.left_join(rhs.on(on))`
LeftJoinQuerySource	A query source representing the left outer join between two tables. For example, for the left join between three tables that implement `JoinTo`: `LeftJoinQuerySource<LeftJoinQuerySource<table1, table2>, table3>` Which conveniently lets you omit the exact join condition.
Like	The return type of `lhs.like(rhs)`
Limit	Represents the return type of `.limit()`
Lt	The return type of `lhs.lt(rhs)`
LtEq	The return type of `lhs.le(rhs)`
NeAny	The return type of `lhs.ne_any(rhs)`
NoWait	Represents the return type of `.no_wait()`
NotBetween	The return type of `lhs.not_between(lower, upper)`
NotEq	The return type of `lhs.ne(rhs)`
NotILike	The return type of `lhs.not_ilike(rhs)`
NotLike	The return type of `lhs.not_like(rhs)`
NotSimilarTo	The return type of `lhs.not_similar_to(rhs)`
Nullable	The return type of `expr.nullable()`
NullableSelect	Represents the return type of `.nullable()`
NullsFirst	The return type of `expr.nulls_first()`
NullsLast	The return type of `expr.nulls_last()`
Offset	Represents the return type of `.offset()`
Or	The return type of `lhs.or(rhs)`
OrFilter	Represents the return type of `.or_filter(predicate)`
OrNet	The return type of `lsh.or(rhs)`
Order	Represents the return type of `.order(ordering)`
OverlapsWith	The return type of `lhs.overlaps_with(rhs)`
OverlapsWithNet	The return type of `lhs.overlaps_with(rhs)`
RangeContains	The return type of `lhs.contains(rhs)` for range expressions
Select	Represents the return type of `.select(selection)`
SimilarTo	The return type of `lhs.similar_to(rhs)`
SingleValue	Represents the return type of `.single_value()`
SkipLocked	Represents the return type of `.skip_locked()`
SqlTypeOf	The SQL type of an expression
ThenOrderBy	Represents the return type of `.then_order_by(ordering)`
Union	Represents the return type of `.union(rhs)`
UnionAll	Represents the return type of `.union_all(rhs)`
Update	Represents the return type of `update(lhs).set(rhs)`
avg	The return type of `avg(expr)`
count	The return type of `count(expr)`
count_star	The return type of `count_star()`
date	The return type of `date(expr)`
max	The return type of `max(expr)`
min	The return type of `min(expr)`
not	The return type of `not(expr)`
sum	The return type of `sum(expr)`