regex_match

[kassio]

Hello guys.. I'm understand that not Areal#matches intention to match with a regexp(#61), but would be interesting if areal offer that with other method(I don't know, something like Areal#regex_match).

Have some situations where we need search with a regexp, e.g. search for some file content_type.

The column: ['image/png', 'image/jpeg', 'image/gif', 'application/pdf', 'application/x-shockwave-flash']

And I want to select only images and flashs file. Would be interesting use:

table[column].regex_match('.(image|flash).').

Thank's

[stevecj]

I just got a code spike working for doing that in PostgreSQL and MySQL. I hope to have proper code for that up in the stevecj/farel project soon.

[sfsekaran]

That would be really useful. I look forward to it :)

[rafaelfranca]

Pull request are welcome, if you wan to discuss this feature more send an email to the Rails Core mailing list.

Closing since it is a feature request and we don't take feature requests in the issues tracker.

[jaredbeck]

There's a matches_regexp method now (

arel/lib/arel/predications.rb

Line 126 in 208fe36

def matches_regexp other, case_sensitive = true

).

[nimmolo]

lol "Arel is a private API" is Rails-speak for "We don't feel like documenting this, and then having to answer a flood of questions. But just between you and me, it's the only way to write a portable query"...

Thank you @jaredbeck. The amount of time i've wasted trying to track down documentation of Arel methods and forgetting to just read the class Predications! 🤌 che palle