How to match against a text in an case-insensitive way in v2?

[real-felix]

Everything is in the title. I want to be able to do this: WHERE name ILIKE '%joe%' with the condition trait.

I have this:

Condition::all().add(Column::Name.contains("joe"));

And I see that there is this: sea_query::Func::lower but I cannot figure out how to "connect" them together. The doc isn't helping me either, I don't really understand the example from Func::lower.

[Huliiiiii]

This is the current workaround
Column::Name.into_expr().ilike("%joe%")

[real-felix]

It's something I use quite a bit, so I created an extension (because why not):

use sea_orm::{prelude::*, sea_query::extension::postgres::PgExpr};

pub trait ColumnExt {
    fn icontains(&self, s: &str) -> Expr;
}

impl<T> ColumnExt for T
where
    T: ColumnTrait,
{
    fn icontains(&self, s: &str) -> Expr {
        self.into_expr().ilike(format!("%{}%", s.trim()))
    }
}

sea_orm::Condition::all()
    .add_option(self.id.map(|id| Column::Id.eq(id)))
    .add_option(self.email.map(|email| Column::Email.icontains(&email)))
    .add_option(self.name.map(|name| Column::Name.icontains(&name)))

[tyt2y3]

thank you. that's a good sugguest! I've added ILIKE in 440c4a4.
I am still considering on icontains, may be we could think of a more self-explanatory name? how about ci_contains (ci stands for case-insensitive)?