Is there a DRY way to pass bind variables to an AR Relation?

Question

I have code like this:

t = "%#{term}%"
where('name like ? or email like ? or postcode like ?', t, t, t)

As you can see it's performing a search across several fields.

Is there a way to avoid the duplicated t? It's making me feel dirty.

Thanks

Crystallization

Answer 1

You can do it with a named placeholder:

where('name LIKE :name OR email LIKE :name OR postcode LIKE :name', :name => t)

This is often the best way to repeat a singular value several times in a query.

Eke

Answer 2

t = "%#{term}%"
where('name || email || postcode like ?', t)

Daft

it's syntactically correct (|| is the string concatenation operator) but it doesn't do the same thing as the original query – Mellen