Ruby on Rails Plugin: CriteriaQuery

Posted by Daniel Butler Thu, 07 Sep 2006 01:00:00 GMT

You’ll like this code:

Person.query.name_like('name').join('address').city_like('city')

… and CriteriaQuery brings it to you (via Max Muermann) as a Ruby on Rails plugin. Head to the README for some useful examples, like this awkward beauty:

  pq = Person.query
  pq.disjunction.first_name_eq(params[:name]).last_name_eq(params[:name]) if params[:name]
  pq.category_id_eq(params[:category]) if params[:category]
  ...
  address = pq.join("address")
  address.state_eq(params[:address[:state]]) if params[:address[:state]]
  ...
  end