Trait rocket_db_pools::diesel::prelude::EscapeExpressionMethods

pub trait EscapeExpressionMethods: Sized {
    // Required method
    fn escape(
        self,
        _character: char,
    ) -> Grouped<Escape<Self::TextExpression, <String as AsExpression<Text>>::Expression>>;
}

Adds the escape method to LIKE and NOT LIKE. This is used to specify the escape character for the pattern.

By default, the escape character is \ on most backends. On SQLite, there is no default escape character.

Example

let users_with_percent = users.select(name)
    .filter(name.like("%😀%%").escape('😀'))
    .load(connection);
let users_without_percent = users.select(name)
    .filter(name.not_like("%a%%").escape('a'))
    .load(connection);
assert_eq!(Ok(vec![String::from("Ha%%0r")]), users_with_percent);
assert_eq!(Ok(vec![String::from("Sean"), String::from("Tess")]), users_without_percent);

Required Methods

fn escape( self, _character: char, ) -> Grouped<Escape<Self::TextExpression, <String as AsExpression<Text>>::Expression>>

See the trait documentation.

Object Safety

This trait is not object safe.

Implementors