Struct ssql::ColExpr

pub struct ColExpr { /* private fields */ }

Column Expression

Implementations

impl ColExpr

pub fn eq(self, other: &dyn ToSql) -> FilterExpr<'_>

generate filter expression checking whether this column equals to a value.

let query = Person::query().filter(
    Person::col("id")?.eq(&5)
)?;

SQL: ... WHERE person.id = 5

pub fn neq(self, other: &dyn ToSql) -> FilterExpr<'_>

generate filter expression checking whether this column not equals to a value.

let query = Person::query().filter(
    Person::col("id")?.neq(&5)
)?;

SQL: ... WHERE person.id <> 5

pub fn lt(self, other: &dyn ToSql) -> FilterExpr<'_>

generate filter expression checking whether this column is less than a value.

let query = Person::query().filter(
    Person::col("email")?.lt(&5)
)?;

SQL: ... WHERE person.id < 5

pub fn lt_eq(self, other: &dyn ToSql) -> FilterExpr<'_>

generate filter expression checking whether this column is less or equal than a value.

let query = Person::query().filter(
    Person::col("email")?.lt_eq(&5)
)?;

SQL: ... WHERE person.id <= 5

pub fn gt(self, other: &dyn ToSql) -> FilterExpr<'_>

generate filter expression checking whether this column is greater than a value.

let query = Person::query().filter(
    Person::col("email")?.gt(&5)
)?;

SQL: ... WHERE person.id > 5

pub fn gt_eq(self, other: &dyn ToSql) -> FilterExpr<'_>

generate filter expression checking whether this column is greater or equal than a value.

let query = Person::query().filter(
    Person::col("email")?.gt_eq(&5)
)?;

SQL: ... WHERE person.id >= 5

pub fn is_null<'b>(self) -> FilterExpr<'b>

generate filter expression checking whether this column is null.

let query = Person::query().filter(
    Person::col("email")?.is_null()
)?;

SQL: **... WHERE person.email IS NULL**

pub fn is_not_null<'b>(self) -> FilterExpr<'b>

generate filter expression checking whether this column is not null.

let query = Person::query().filter(
    Person::col("email")?.is_not_null()
)?;

SQL: ... WHERE person.email IS NOT NULL

pub fn contains<'b>(self, other: &'b str) -> FilterExpr<'b>

generate filter expression checking whether a char column contains a given str.

let query = Person::query().filter(
    Person::col("email")?.contains("gmail")
)?;

SQL: ... WHERE person.email LIKE '%gmail%'

pub fn startswith<'b>(self, other: &'b str) -> FilterExpr<'b>

generate filter expression checking whether a char column starts with a given str.

let query = Person::query().filter(
    Person::col("email")?.startswith("john")
)?;

SQL: ... WHERE person.email LIKE 'john%'

pub fn endswith<'b>(self, other: &'b str) -> FilterExpr<'b>

generate filter expression checking whether a char column ends with a given str.

let query = Person::query().filter(
    Person::col("email")?.endswith("gmail.com")
)?;

SQL: ... WHERE person.email LIKE '%gmail.com'

pub fn is_in(self, ls: &[impl ToSql]) -> FilterExpr<'_>

generate filter expression checking whether a value in a given list.

let query = Person::query().filter(
    Person::col("id")?.is_in(&[3,4,5,6,7])
)?;

SQL: ... WHERE person.id IN (3,4,5,6,7)

pub fn is_in_ref<'b>(self, ls: &[&'b dyn ToSql]) -> FilterExpr<'b>

generate filter expression checking whether a value in a given list. This method allows for providing different types of args.

let query = Person::query().filter(
    Person::col("email")?.is_in_ref(&[&3, &"4", &5])
)?;

SQL: ... WHERE person.id IN (3,'4',5)

pub fn between<'b>( self, start: &'b dyn ToSql, end: &'b dyn ToSql ) -> FilterExpr<'b>

generate filter expression checking whether a value between a range.

let query = Person::query().filter(
    Person::col("email")?.between(&3, &7)
)?;

SQL: ... WHERE person.id BETWEEN 3 AND 7