Enum Operator 

#[non_exhaustive]
pub enum Operator {
    Eq,
    Ne,
    Gt,
    Gte,
    Lt,
    Lte,
    In,
    NotIn,
    Regex,
    Like,
    ILike,
    StartsWith,
    EndsWith,
    Contains,
    Between,
}

SQL comparison operators.

Variants (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.

Eq

Equal: =

Ne

Not equal: !=

Gt

Greater than: >

Gte

Greater than or equal: >=

Lt

Less than: <

Lte

Less than or equal: <=

In

In array: IN or = ANY

NotIn

Not in array: NOT IN or != ALL

Regex

Regex match: ~ (Postgres) or LIKE (SQLite)

Like

Pattern match: LIKE

ILike

Case-insensitive pattern match: ILIKE (Postgres) or LIKE (SQLite)

StartsWith

String starts with: LIKE $1 || '%'

EndsWith

String ends with: LIKE '%' || $1

Contains

String contains: LIKE '%' || $1 || '%'

Between

Between two values: BETWEEN $1 AND $2

Implementations

impl Operator

pub fn from_mongo(s: &str) -> Option<Self>

Parse from Mongo-style operator string (e.g., “$eq”, “$gte”).

Accepts both with and without the $ prefix.

Example

use mik_sql::Operator;

assert_eq!(Operator::from_mongo("$eq"), Some(Operator::Eq));
assert_eq!(Operator::from_mongo("gte"), Some(Operator::Gte));
assert_eq!(Operator::from_mongo("$unknown"), None);

Trait Implementations

impl Clone for Operator

fn clone(&self) -> Operator

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Operator

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

Formats the value using the given formatter.

impl PartialEq for Operator

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

Tests for self and other values to be equal, and is used by ==.

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

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Copy for Operator

impl Eq for Operator

impl StructuralPartialEq for Operator