Struct StrCol 

pub struct StrCol<T> { /* private fields */ }

A String-typed column.

Implementations

impl<T> StrCol<T>

pub const fn new(name: &'static str) -> Self

pub fn eq<S: Into<String>>(&self, val: S) -> Predicate<T>

SQL =.

Examples

use umbral_core::orm::Post;
use umbral_core::orm::post::post;

let _ = Post::objects().filter(post::TITLE.eq("Hello world"));

pub fn ne<S: Into<String>>(&self, val: S) -> Predicate<T>

SQL <>.

pub fn like<S: Into<String>>(&self, pattern: S) -> Predicate<T>

SQL LIKE (case-sensitive).

Examples

use umbral_core::orm::Post;
use umbral_core::orm::post::post;

let _ = Post::objects().filter(post::TITLE.like("Hello%"));

pub fn ilike<S: Into<String>>(&self, pattern: S) -> Predicate<T>

Case-insensitive LIKE via UPPER(col) LIKE UPPER(pattern) for portability across backends without a native ILIKE.

Examples

use umbral_core::orm::Post;
use umbral_core::orm::post::post;

let _ = Post::objects().filter(post::TITLE.ilike("hello%"));

pub fn contains<S: Into<String>>(&self, substring: S) -> Predicate<T>

SQL LIKE '%val%' substring containment.

Examples

use umbral_core::orm::Post;
use umbral_core::orm::post::post;

let _ = Post::objects().filter(post::TITLE.contains("rust"));

pub fn icontains<S: Into<String>>(&self, substring: S) -> Predicate<T>

Case-insensitive substring containment via UPPER(col) LIKE UPPER('%val%').

SQLite’s LIKE is already ASCII-case-insensitive, so contains and icontains may return the same rows there. The contract is “emit LIKE”; backend case-sensitivity differs.

Examples

use umbral_core::orm::Post;
use umbral_core::orm::post::post;

let _ = Post::objects().filter(post::TITLE.icontains("rust"));

pub fn startswith<S: Into<String>>(&self, prefix: S) -> Predicate<T>

SQL LIKE 'val%' — prefix match. Mirrors the REST filter parser’s __startswith lookup.

Examples

use umbral_core::orm::Post;
use umbral_core::orm::post::post;

let _ = Post::objects().filter(post::TITLE.startswith("intro"));

pub fn istartswith<S: Into<String>>(&self, prefix: S) -> Predicate<T>

Case-insensitive prefix match via UPPER(col) LIKE UPPER('val%').

pub fn asc(&self) -> OrderExpr<T>

SQL ORDER BY ... ASC.

pub fn desc(&self) -> OrderExpr<T>

SQL ORDER BY ... DESC.

Trait Implementations

impl<T> FColExt<T> for StrCol<T>

fn eq_f(&self, expr: FExpr) -> Predicate<T>

WHERE <col> = <expr>.

fn ne_f(&self, expr: FExpr) -> Predicate<T>

WHERE <col> <> <expr>.

impl<T> StrColExt<T> for StrCol<T>

fn lower(&self) -> ColExpr<T>

LOWER(col) — case-insensitive comparison primitive.

fn upper(&self) -> ColExpr<T>

UPPER(col).

fn length(&self) -> ColExpr<T>

LENGTH(col) — character count of the stored value.

fn trim(&self) -> ColExpr<T>

TRIM(col) — strip leading/trailing whitespace before comparing, so name.trim().eq("ada") matches a stored " ada ".

fn coalesce<V: Into<Value>>(&self, default: V) -> ColExpr<T>

COALESCE(col, default) — substitute default when the column is NULL, so a nullable column compares as the fallback. Mostly paired with NullableStrCol.

fn concat<V: Into<Value>>(&self, suffix: V) -> ColExpr<T>

col || suffix — append suffix (the standard SQL concatenation operator, which both backends accept) before comparing.