Skip to main content

SqlExpr

Enum SqlExpr 

Source
#[non_exhaustive]
pub enum SqlExpr { UnixTimestamp, UnixTimestampAdd(i64), Now, Coalesce { field: FieldRef, fallback: SqlExprParam, }, Greatest(Vec<ExprOperand>), Least(Vec<ExprOperand>), NullIf { field: FieldRef, value: SqlExprParam, }, Strpos { field: FieldRef, needle: String, }, Lpad { field: FieldRef, length: i64, fill: String, }, Rpad { field: FieldRef, length: i64, fill: String, }, ToChar { field: FieldRef, format: String, }, }
Expand description

受控服务端 SQL 标量表达式。

只能由白名单构造函数创建:渲染进 SQL 文本的是固定函数名与已校验列引用, 动态部分(偏移秒数、格式串、填充串、字面量)一律走绑定参数,调用方无法 注入任意 SQL。

Variants (Non-exhaustive)§

This enum is marked as non-exhaustive
Non-exhaustive enums could have additional variants added in future. Therefore, when matching against variants of non-exhaustive enums, an extra wildcard arm must be added to account for any future variants.
§

UnixTimestamp

服务端当前 Unix 时间戳(秒)。

§

UnixTimestampAdd(i64)

服务端当前 Unix 时间戳加偏移秒数;偏移量以绑定参数传递。

§

Now

服务端当前时间:PostgreSQL now(),MySQL CURRENT_TIMESTAMP。

§

Coalesce

COALESCE(列, 字面量);字面量按 SqlExprParam 的类型绑定。

Fields

§field: FieldRef
§fallback: SqlExprParam
§

Greatest(Vec<ExprOperand>)

GREATEST(操作数...),至少两个操作数。

NULL 语义与方言相关:PostgreSQL 忽略 NULL 操作数(全 NULL 才返回 NULL), MySQL 只要有一个 NULL 操作数就返回 NULL。

§

Least(Vec<ExprOperand>)

LEAST(操作数...),至少两个操作数。

NULL 语义与方言相关:PostgreSQL 忽略 NULL 操作数(全 NULL 才返回 NULL), MySQL 只要有一个 NULL 操作数就返回 NULL。

§

NullIf

NULLIF(列, 字面量);字面量按 SqlExprParam 的类型绑定。

Fields

§field: FieldRef
§

Strpos

strpos(列, 字面量)(MySQL 渲染为等价的 LOCATE(字面量, 列))。

Fields

§field: FieldRef
§needle: String
§

Lpad

lpad(列, 长度, 填充串)。

Fields

§field: FieldRef
§length: i64
§fill: String
§

Rpad

rpad(列, 长度, 填充串)。

Fields

§field: FieldRef
§length: i64
§fill: String
§

ToChar

to_char(列, 格式串)(仅 PostgreSQL;MySQL 渲染返回 DbError::UnsupportedOperator, 因为 PG 格式串与 MySQL DATE_FORMAT 记号不等价)。

Fields

§field: FieldRef
§format: String

Implementations§

Source§

impl SqlExpr

Source

pub fn unix_timestamp() -> Self

服务端当前 Unix 时间戳(秒):MySQL UNIX_TIMESTAMP(), PostgreSQL EXTRACT(EPOCH FROM now())。

Source

pub fn unix_timestamp_add(seconds: i64) -> Self

服务端当前 Unix 时间戳加 seconds 秒;seconds 以绑定参数传递,可正可负。

Source

pub fn now() -> Self

服务端当前时间。

Source

pub fn coalesce(field: &FieldRef, fallback: impl Into<SqlExprParam>) -> Self

COALESCE(field, fallback);fallback 以绑定参数传递,其绑定类型由 SqlExprParam 的 From 推断(&str / i64 / f64 / bool),可用 SqlExprParam::text 强制文本。

Source

pub fn greatest(operands: Vec<ExprOperand>) -> Self

GREATEST(operands...);调用方必须提供至少两个操作数。

NULL 语义与方言相关:PostgreSQL 忽略 NULL,MySQL 任一 NULL 即返回 NULL。

Source

pub fn least(operands: Vec<ExprOperand>) -> Self

LEAST(operands...);调用方必须提供至少两个操作数。

NULL 语义与方言相关:PostgreSQL 忽略 NULL,MySQL 任一 NULL 即返回 NULL。

Source

pub fn nullif(field: &FieldRef, value: impl Into<SqlExprParam>) -> Self

NULLIF(field, value);value 以绑定参数传递,绑定类型规则同 SqlExpr::coalesce。

Source

pub fn strpos(field: &FieldRef, needle: impl Into<String>) -> Self

strpos(field, needle);needle 以绑定参数传递。

Source

pub fn lpad(field: &FieldRef, length: i64, fill: impl Into<String>) -> Self

lpad(field, length, fill);长度与填充串以绑定参数传递。

Source

pub fn rpad(field: &FieldRef, length: i64, fill: impl Into<String>) -> Self

rpad(field, length, fill);长度与填充串以绑定参数传递。

Source

pub fn to_char(field: &FieldRef, format: impl Into<String>) -> Self

to_char(field, format);仅 PostgreSQL 支持。PostgreSQL 的格式记号 (YYYY-MM-DD)与 MySQL DATE_FORMAT(%Y-%m-%d)不等价,因此 MySQL 渲染返回 DbError::UnsupportedOperator。

Trait Implementations§

Source§

impl Clone for SqlExpr

Source§

fn clone(&self) -> Self

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

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

Performs copy-assignment from source. Read more
Source§

impl Debug for SqlExpr

Source§

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

Formats the value using the given formatter. Read more
Source§

impl Eq for SqlExpr

Source§

impl PartialEq for SqlExpr

Source§

fn eq(&self, other: &Self) -> bool

Equality operator ==. Read more
1.0.0 (const: unstable) · Source§

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=. Read more
Source§

impl StructuralPartialEq for SqlExpr

Auto Trait Implementations§

Blanket Implementations§

Source§

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

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

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

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

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

Source§

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

Mutably borrows from an owned value. Read more
Source§

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

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<Q, K> Equivalent<K> for Q
where Q: Eq + ?Sized, K: Borrow<Q> + ?Sized,

Source§

fn equivalent(&self, key: &K) -> bool

Compare self to key and return true if they are equal.
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T> Instrument for T

Source§

fn instrument(self, span: Span) -> Instrumented<Self> ⓘ

Instruments this type with the provided Span, returning an Instrumented wrapper. Read more
Source§

fn in_current_span(self) -> Instrumented<Self> ⓘ

Instruments this type with the current Span, returning an Instrumented wrapper. Read more
Source§

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

Source§

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> IntoEither for T

Source§

fn into_either(self, into_left: bool) -> Either<Self, Self> ⓘ

Converts self into a Left variant of Either<Self, Self> if into_left is true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

fn into_either_with<F>(self, into_left: F) -> Either<Self, Self> ⓘ
where F: FnOnce(&Self) -> bool,

Converts self into a Left variant of Either<Self, Self> if into_left(&self) returns true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

impl<T> Same for T

Source§

type Output = T

Should always be Self
Source§

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

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

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

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

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

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

Source§

type Error = !

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, !>

Performs the conversion.
Source§

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

Source§

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

The type returned in the event of a conversion error.
Source§

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

Performs the conversion.
Source§

impl<V, T> VZip<V> for T
where V: MultiLane<T>,

Source§

fn vzip(self) -> V

Source§

impl<T> WithSubscriber for T

Source§

fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self> ⓘ
where S: Into<Dispatch>,

Attaches the provided Subscriber to this type, returning a WithDispatch wrapper. Read more
Source§

fn with_current_subscriber(self) -> WithDispatch<Self> ⓘ

Attaches the current default Subscriber to this type, returning a WithDispatch wrapper. Read more