LIKE and ILIKE

[fabfianda]

Thanks for the lib, I'm enjoying using it a lot.

One question, though.
I don't seem to find a way to express a LIKE or ILIKE query.

If not supported directly, as it seems, what would be the best workaround?

Thanks

[ocharles]

Hi @fabfianda, thanks for the kind words! LIKE and ILIKE are not currently provided by Rel8, but probably should be. In the meantime, you can add:

like, ilike :: Expr Text -> Expr Text -> Expr Bool
like = dbFunction "LIKE"
ilike = dbFunction "ILIKE"

[fabfianda]

oh wow, excellent lib with excellent support XD

[fabfianda]

Follow up:
dbFunction (actually named 'function' at least in 1.1.0) was giving me an SQL "function ilike(character varying, text) does not exist" error.

I solved by doing this instead:

like, ilike :: Expr Text -> Expr Text -> Expr Bool
like = binaryOperator "LIKE"
ilike = binaryOperator "ILIKE"

So now I can happily have functions like this:

type Pattern = Text
articlesNamedLike :: Pattern -> Query (Article Expr)
articlesNamedLike pattern = do
        article <- allArticles
        where_ $ (articleName article) `like` (lit pattern)
        return article

[ocharles]

Oh sorry, you're exactly right - you want binaryOperator, not dbFunction