Contents

module ActiverecordAnyOf
  # Returns a new relation, which includes results matching any of conditions
  # passed as parameters. You can think of it as a sql <tt>OR</tt> implementation.
  #
  # Each #any_of parameter is the same set you would have passed to #where :
  #
  #    Client.any_of("orders_count = '2'", ["name = ?", 'Joe'], {email: '[e-mail]'})
  #
  # You can as well pass #any_of to other relations :
  #
  #    Client.where("orders_count = '2'").any_of({ email: '[e-mail]' }, { email: '[e-mail]' })
  #
  # And with associations :
  #
  #    User.find(1).posts.any_of({published: false}, "user_id IS NULL")
  #
  # The best part is that #any_of accepts other relations as parameter, to help compute
  # dynamic <tt>OR</tt> queries :
  #
  #    banned_users = User.where(banned: true)
  #    unconfirmed_users = User.where("confirmed_at IS NULL")
  #    unactive_users = User.any_of(banned_users, unconfirmed_users)
  def any_of(*queries)
    queries_bind_values = []
    queries = queries.map do |query|
      query = where(query) if [String, Hash].any? { |type| query.kind_of?(type) }
      query = where(*query) if query.kind_of?(Array)
      queries_bind_values += query.bind_values if query.bind_values.any?
      query.arel.constraints.reduce(:and)
    end

    if ActiveRecord::Base.connection.supports_statement_cache?
      where([queries.reduce(:or).to_sql, *queries_bind_values.map { |v| v[1] }])
    else
      relation = where(queries.reduce(:or))
      relation.bind_values += queries_bind_values
      relation
    end
  end
end

if Rails.version >= '4'
  module ActiverecordAnyOfDelegation
    delegate :any_of, to: :all
  end
else
  module ActiverecordAnyOfDelegation
    delegate :any_of, to: :scoped
  end
end

ActiveRecord::Relation.send(:include, ActiverecordAnyOf)
ActiveRecord::Base.send(:extend, ActiverecordAnyOfDelegation)

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
activerecord_any_of-0.0.1	lib/activerecord_any_of.rb