Struct ColumnRef 

pub struct ColumnRef {
    pub table: Option<String>,
    pub name: String,
}

A column reference for dynamic (string-based) queries.

Fields

table: Option<String>

Optional table qualifier.

name: String

Column name.

Implementations

impl ColumnRef

pub fn qualified(table: &str, name: &str) -> Self

Creates a qualified column reference.

pub fn to_sql(&self) -> String

Returns the SQL representation.

pub fn eq<T: ToSqlValue>(self, value: T) -> ExprBuilder

Creates an equality expression.

pub fn not_eq<T: ToSqlValue>(self, value: T) -> ExprBuilder

Creates an inequality expression.

pub fn lt<T: ToSqlValue>(self, value: T) -> ExprBuilder

Creates a less-than expression.

pub fn lt_eq<T: ToSqlValue>(self, value: T) -> ExprBuilder

Creates a less-than-or-equal expression.

pub fn gt<T: ToSqlValue>(self, value: T) -> ExprBuilder

Creates a greater-than expression.

pub fn gt_eq<T: ToSqlValue>(self, value: T) -> ExprBuilder

Creates a greater-than-or-equal expression.

pub fn is_null(self) -> ExprBuilder

Creates an IS NULL expression.

pub fn is_not_null(self) -> ExprBuilder

Creates an IS NOT NULL expression.

pub fn like<T: ToSqlValue>(self, pattern: T) -> ExprBuilder

Creates a LIKE expression.

pub fn not_like<T: ToSqlValue>(self, pattern: T) -> ExprBuilder

Creates a NOT LIKE expression.

pub fn between<T: ToSqlValue, U: ToSqlValue>( self, low: T, high: U, ) -> ExprBuilder

Creates a BETWEEN expression.

pub fn not_between<T: ToSqlValue, U: ToSqlValue>( self, low: T, high: U, ) -> ExprBuilder

Creates a NOT BETWEEN expression.

pub fn in_list<T: ToSqlValue>(self, values: Vec<T>) -> ExprBuilder

Creates an IN expression.

pub fn not_in_list<T: ToSqlValue>(self, values: Vec<T>) -> ExprBuilder

Creates a NOT IN expression.

Trait Implementations

impl Clone for ColumnRef

fn clone(&self) -> ColumnRef

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ColumnRef

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

Formats the value using the given formatter.

impl From<ColumnRef> for ExprBuilder

fn from(col: ColumnRef) -> Self

Converts to this type from the input type.