Search By Regex Pattern ActiveRecord

Question

Is there a way to search via Regex pattern in ActiveRecord? I have a collection of products. I'll like to search these products based on their sku column meeting a number of patterns.

SKUs having single letters from [A-Z] should be considered premium products SKUs having single letters [A-Z] and a digit[0-9] should be considered standard products SKUs having double letters and a digit [0-9] should be considered flash products

Here is a pseudo-code of what I need:

product.sku ~= /[A-Z]$/  => Premium Products
product.sku ~= /[A-Z][0-9]$/ => Standard Products
product.sku ~= /[A-Z]{2}[0-9]$/ => Flash products

I don't want to use ruby's select filtering. Is this possible via active-record?

“Is this possible via active-record?“ — yes, this is possible if you are using the DB that supports fuzzy searches. — Aleksei Matiushkin
– Aleksei Matiushkin, Commented Jan 28, 2020 at 10:29

Adim · Accepted Answer · 2020-01-28 10:37:50Z

4

If you using a database that supports regex matching, this is possible. E.g: Postgres. I have done some regex search on ActiveRecord using Postgres as DB. You can read up this article

So in your case, you can simply do:

premium_products = Product.where("sku ~ ?", '[A-Z]$')
standard_products = Product.where("sku ~ ?", '[A-Z][0-9]$')
flash_products = Product.where("sku ~ ?", '[A-Z]{2}[0-9]$')

answered Jan 28, 2020 at 10:37

Adim

1,78613 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Search By Regex Pattern ActiveRecord

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related