How to construct a query without triggering it with activeRecord?

Question

I have this code:

def build_query(options)
  query = User
  query = query.where('first_condition')
  query = query.where('second_condition')
  query = query.where('items.category_id = ?', category) if (options[:category])
  if options[:location]
    query = query.where('users.location = ?', options[:location])
  end
  query = query.order('users.current_sign_in_at DESC')
  query = query.limit(MAX_RESULTS)
  return query
end

Unfortunately, a request is trigerred each time I do query = query.where(...)

I could just chain all where clauses (where().where()...), but then how do I keep my ifs ?

Is there a way to tell ActiveRecord not to trigger the query ?

Oleg Haidul · Accepted Answer · 2013-09-17 10:14:24Z

2

You can collect all conditions in conditions variable:

conditions = {}
conditions.merge('first_condition') if ...
conditions.merge('second_condition') if ...
# snip

User.where(conditions).order('users.current_sign_in_at DESC').limit(MAX_RESULTS)

answered Sep 17, 2013 at 10:14

Oleg Haidul

3,7421 gold badge24 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

How to construct a query without triggering it with 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