diff options
author | Matthew Draper <matthew@trebex.net> | 2014-06-23 11:42:46 +0800 |
---|---|---|
committer | Sean Griffin <sean@thoughtbot.com> | 2015-01-28 13:35:55 -0700 |
commit | b0b37942d729b6bdcd2e3178eda7fa1de203b3d0 (patch) | |
tree | cbf5e9fe861b6093166213b322e3d5f6bf0c8156 /activerecord/lib/active_record/relation/query_methods.rb | |
parent | 56a3d5ec9183a9bcbf140d4102d45e3928f2617a (diff) | |
download | rails-b0b37942d729b6bdcd2e3178eda7fa1de203b3d0.tar.gz rails-b0b37942d729b6bdcd2e3178eda7fa1de203b3d0.tar.bz2 rails-b0b37942d729b6bdcd2e3178eda7fa1de203b3d0.zip |
Added #or to ActiveRecord::Relation
Post.where('id = 1').or(Post.where('id = 2'))
# => SELECT * FROM posts WHERE (id = 1) OR (id = 2)
[Matthew Draper & Gael Muller]
Diffstat (limited to 'activerecord/lib/active_record/relation/query_methods.rb')
-rw-r--r-- | activerecord/lib/active_record/relation/query_methods.rb | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/activerecord/lib/active_record/relation/query_methods.rb b/activerecord/lib/active_record/relation/query_methods.rb index 0078b0f32e..78ee8b4580 100644 --- a/activerecord/lib/active_record/relation/query_methods.rb +++ b/activerecord/lib/active_record/relation/query_methods.rb @@ -582,6 +582,65 @@ module ActiveRecord unscope(where: conditions.keys).where(conditions) end + # Returns a new relation, which is the logical union of this relation and the one passed as an + # argument. + # + # The two relations must be structurally compatible: they must be scoping the same model, and + # they must differ only by +where+ (if no +group+ has been defined) or +having+ (if a +group+ is + # present). Neither relation may have a +limit+, +offset+, or +uniq+ set. + # + # Post.where("id = 1").or(Post.where("id = 2")) + # # SELECT `posts`.* FROM `posts` WHERE (('id = 1' OR 'id = 2')) + # + def or(other) + spawn.or!(other) + end + + def or!(other) + combining = group_values.any? ? :having : :where + + unless structurally_compatible?(other, combining) + raise ArgumentError, 'Relation passed to #or must be structurally compatible' + end + + unless other.is_a?(NullRelation) + left_values = send("#{combining}_values") + right_values = other.send("#{combining}_values") + + common = left_values & right_values + mine = left_values - common + theirs = right_values - common + + if mine.any? && theirs.any? + mine = mine.map { |x| String === x ? Arel.sql(x) : x } + theirs = theirs.map { |x| String === x ? Arel.sql(x) : x } + + mine = [Arel::Nodes::And.new(mine)] if mine.size > 1 + theirs = [Arel::Nodes::And.new(theirs)] if theirs.size > 1 + + common << Arel::Nodes::Or.new(mine.first, theirs.first) + end + + send("#{combining}_values=", common) + end + + self + end + + def structurally_compatible?(other, allowed_to_vary) + Relation::SINGLE_VALUE_METHODS.all? do |name| + send("#{name}_value") == other.send("#{name}_value") + end && + (Relation::MULTI_VALUE_METHODS - [allowed_to_vary, :extending]).all? do |name| + send("#{name}_values") == other.send("#{name}_values") + end && + (extending_values - [NullRelation]) == (other.extending_values - [NullRelation]) && + !limit_value && + !offset_value && + !uniq_value + end + private :structurally_compatible? + # Allows to specify a HAVING clause. Note that you can't use HAVING # without also specifying a GROUP clause. # |