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)
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()
Between	The return type of lhs.between(lower, upper)
Desc	The return type of expr.desc()
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')
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()
Gt	The return type of lhs.gt(rhs)
GtEq	The return type of lhs.ge(rhs)
InnerJoin	Represents the return type of .inner_join(rhs)
InnerJoinOn	Represents the return type of .inner_join(rhs.on(on))
IntoBoxed	Represents the return type of .into_boxed::<'a, DB>()
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))
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)
NotLike	The return type of lhs.not_like(rhs)
Nullable	The return type of expr.nullable()
NullableSelect	Represents the return type of .nullable()
Offset	Represents the return type of .offset()
Or	The return type of lhs.or(rhs)
OrFilter	Represents the return type of .or_filter(predicate)
Order	Represents the return type of .order(ordering)
Select	Represents the return type of .select(selection)
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)
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)