Enum JsonFilter 

pub enum JsonFilter {
    Equals(JsonPath, Value),
    NotEquals(JsonPath, Value),
    Contains(String, Value),
    ContainedBy(String, Value),
    HasAnyKey(String, Vec<String>),
    HasAllKeys(String, Vec<String>),
    HasKey(String, String),
    GreaterThan(JsonPath, Value),
    LessThan(JsonPath, Value),
    Exists(JsonPath),
    IsNull(JsonPath),
    IsNotNull(JsonPath),
    ArrayContains(JsonPath, Value),
    PathMatch(String, String),
}

A JSON filter operation.

Variants

Equals(JsonPath, Value)

Check if path equals a value.

NotEquals(JsonPath, Value)

Check if path does not equal a value.

Contains(String, Value)

Check if JSON contains another JSON value (PostgreSQL @>).

ContainedBy(String, Value)

Check if JSON is contained by another JSON value (PostgreSQL <@).

HasAnyKey(String, Vec<String>)

Check if any of the keys exist (PostgreSQL ?|).

HasAllKeys(String, Vec<String>)

Check if all of the keys exist (PostgreSQL ?&).

HasKey(String, String)

Check if a key exists (PostgreSQL ?).

GreaterThan(JsonPath, Value)

Check if path value is greater than.

LessThan(JsonPath, Value)

Check if path value is less than.

Exists(JsonPath)

Check if path exists.

IsNull(JsonPath)

Check if path is null.

IsNotNull(JsonPath)

Check if path is not null.

ArrayContains(JsonPath, Value)

Check if array contains value.

PathMatch(String, String)

Check value using JSONPath predicate (PostgreSQL @?).

Implementations

impl JsonFilter

pub fn equals(path: JsonPath, value: impl Into<JsonValue>) -> Self

Create an equals filter.

pub fn contains(column: impl Into<String>, value: impl Into<JsonValue>) -> Self

Create a contains filter.

pub fn has_key(column: impl Into<String>, key: impl Into<String>) -> Self

Create a has key filter.

pub fn exists(path: JsonPath) -> Self

Create an exists filter.

pub fn to_postgres_sql(&self) -> (String, Vec<FilterValue>)

Generate PostgreSQL SQL for this filter.

pub fn to_mysql_sql(&self) -> (String, Vec<FilterValue>)

Generate MySQL SQL for this filter.

pub fn to_sql( &self, db_type: DatabaseType, ) -> QueryResult<(String, Vec<FilterValue>)>

Generate SQL for the specified database.

Trait Implementations

impl Clone for JsonFilter

fn clone(&self) -> JsonFilter

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for JsonFilter

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for JsonFilter

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for JsonFilter

fn eq(&self, other: &JsonFilter) -> 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 Serialize for JsonFilter

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for JsonFilter