where

Used to build WHERE clauses for SQL queries.

Where clauses are used to filter rows in a table.

Also used to build HAVING clauses for SQL queries, because they work the same way as WHERE clauses, but are used to filter rows after GROUP BY has been applied.

Compatibility

SQLite does not support ANY, ALL and SIMILAR TO.

Functions

and

</>

pub fn and(wheres whrs: List(Where)) -> Where

between

</>

pub fn between(
  value_a vl_a: WhereValue,
  value_b vl_b: WhereValue,
  value_c vl_c: WhereValue,
) -> Where

col

</>

pub fn col(name: String) -> WhereValue

eq

</>

pub fn eq(
  value_a vl_a: WhereValue,
  value_b vl_b: WhereValue,
) -> Where

eq_all_query

</>

pub fn eq_all_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

eq_any_query

</>

pub fn eq_any_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

exists_in_query

</>

pub fn exists_in_query(sub_query qry: Query) -> Where

float

</>

pub fn float(v vl: Float) -> WhereValue

fragment

</>

pub fn fragment(fragment frgmt: Fragment) -> Where

fragment_value

</>

pub fn fragment_value(fragment frgmt: Fragment) -> WhereValue

gt

</>

pub fn gt(
  value_a vl_a: WhereValue,
  value_b vl_b: WhereValue,
) -> Where

gt_all_query

</>

pub fn gt_all_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

gt_any_query

</>

pub fn gt_any_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

gte

</>

pub fn gte(
  value_a vl_a: WhereValue,
  value_b vl_b: WhereValue,
) -> Where

gte_all_query

</>

pub fn gte_all_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

gte_any_query

</>

pub fn gte_any_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

ilike

</>

pub fn ilike(
  value vl: WhereValue,
  pattern pttrn: String,
) -> Where

ILIKE is the same as LIKE but case-insensitive.

in

</>

pub fn in(
  value vl: WhereValue,
  values vals: List(WhereValue),
) -> Where

int

</>

pub fn int(v vl: Int) -> WhereValue

is_bool

</>

pub fn is_bool(value vl: WhereValue, bool b: Bool) -> Where

is_false

</>

pub fn is_false(value vl: WhereValue) -> Where

is_not

</>

pub fn is_not(value vl: WhereValue, bool b: Bool) -> Where

is_not_bool

</>

pub fn is_not_bool(value vl: WhereValue, bool b: Bool) -> Where

is_not_null

</>

pub fn is_not_null(value vl: WhereValue) -> Where

is_null

</>

pub fn is_null(value vl: WhereValue) -> Where

is_true

</>

pub fn is_true(value vl: WhereValue) -> Where

like

</>

pub fn like(value vl: WhereValue, pattern pttrn: String) -> Where

lt

</>

pub fn lt(
  value_a vl_a: WhereValue,
  value_b vl_b: WhereValue,
) -> Where

lt_all_query

</>

pub fn lt_all_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

lt_any_query

</>

pub fn lt_any_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

lte

</>

pub fn lte(
  value_a vl_a: WhereValue,
  value_b vl_b: WhereValue,
) -> Where

lte_all_query

</>

pub fn lte_all_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

lte_any_query

</>

pub fn lte_any_query(
  value vl: WhereValue,
  sub_query qry: Query,
) -> Where

NOTICE: Not supported by SQLite.

not

</>

pub fn not(where whr: Where) -> Where

or

</>

pub fn or(wheres whrs: List(Where)) -> Where

similar_to

</>

pub fn similar_to(
  value vl: WhereValue,
  to pttrn: String,
) -> Where

NOTICE: Not supported by SQLite.

string

</>

pub fn string(v vl: String) -> WhereValue

xor

</>

pub fn xor(wheres whrs: List(Where)) -> Where