Struct Filter

pub struct Filter {
    pub column: String,
    pub operator: Operator,
    pub value: FilterValue,
}

Individual filter condition

Represents a single comparison operation between a column and a value. Provides convenient constructor methods for common comparison operations.

Examples

use libsql_orm::{Filter, Value};

// Basic comparisons
let eq_filter = Filter::eq("status", "active");
let gt_filter = Filter::gt("age", 18i64);
let like_filter = Filter::like("name", "%john%");

// Range and list operations
let between_filter = Filter::between("score", 80, 100);
let in_filter = Filter::in_values("role", vec!["admin", "user"]);
let null_filter = Filter::is_null("deleted_at");

Fields

column: String

Column name

operator: Operator

Operator

value: FilterValue

Value(s) to compare against

Implementations

impl Filter

pub fn new( column: impl Into<String>, operator: Operator, value: FilterValue, ) -> Self

Create a new filter

pub fn new_simple( column: impl Into<String>, operator: Operator, value: impl Into<Value>, ) -> Self

Create a new filter with a simple value

pub fn eq(column: impl Into<String>, value: impl Into<Value>) -> Self

Create an equality filter

pub fn ne(column: impl Into<String>, value: impl Into<Value>) -> Self

Create a not-equal filter

pub fn lt(column: impl Into<String>, value: impl Into<Value>) -> Self

Create a less-than filter

pub fn le(column: impl Into<String>, value: impl Into<Value>) -> Self

Create a less-than-or-equal filter

pub fn gt(column: impl Into<String>, value: impl Into<Value>) -> Self

Create a greater-than filter

pub fn ge(column: impl Into<String>, value: impl Into<Value>) -> Self

Create a greater-than-or-equal filter

pub fn like(column: impl Into<String>, pattern: impl Into<String>) -> Self

Create a LIKE filter

pub fn not_like(column: impl Into<String>, pattern: impl Into<String>) -> Self

Create a NOT LIKE filter

pub fn in_values( column: impl Into<String>, values: Vec<impl Into<Value>>, ) -> Self

Create an IN filter

pub fn not_in_values( column: impl Into<String>, values: Vec<impl Into<Value>>, ) -> Self

Create a NOT IN filter

pub fn is_null(column: impl Into<String>) -> Self

Create an IS NULL filter

pub fn is_not_null(column: impl Into<String>) -> Self

Create an IS NOT NULL filter

pub fn between( column: impl Into<String>, min: impl Into<Value>, max: impl Into<Value>, ) -> Self

Create a BETWEEN filter

pub fn not_between( column: impl Into<String>, min: impl Into<Value>, max: impl Into<Value>, ) -> Self

Create a NOT BETWEEN filter

Trait Implementations

impl Clone for Filter

fn clone(&self) -> Filter

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Filter

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Filter

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for Filter

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.