path: root/activerecord/test/cases/relation/where_chain_test.rb

require 'cases/helper'
require 'models/post'
require 'models/comment'

module ActiveRecord
  class WhereChainTest < ActiveRecord::TestCase
    fixtures :posts

    def setup
      super
      @name = 'title'
    end

    def test_not_eq
      relation = Post.where.not(title: 'hello')

      assert_equal 1, relation.where_clause.predicates.length

      value = relation.where_clause.predicates.first
      bind  = relation.where_clause.binds.first

      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::NotEqual
      assert_equal 'hello', bind.last
    end

    def test_not_null
      expected = Post.arel_table[@name].not_eq(nil)
      relation = Post.where.not(title: nil)
      assert_equal([expected], relation.where_clause.predicates)
    end

    def test_not_with_nil
      assert_raise ArgumentError do
        Post.where.not(nil)
      end
    end

    def test_not_in
      expected = Post.arel_table[@name].not_in(%w[hello goodbye])
      relation = Post.where.not(title: %w[hello goodbye])
      assert_equal([expected], relation.where_clause.predicates)
    end

    def test_association_not_eq
      expected = Comment.arel_table[@name].not_eq(Arel::Nodes::BindParam.new)
      relation = Post.joins(:comments).where.not(comments: {title: 'hello'})
      assert_equal(expected.to_sql, relation.where_clause.predicates.first.to_sql)
    end

    def test_not_eq_with_preceding_where
      relation = Post.where(title: 'hello').where.not(title: 'world')

      value = relation.where_clause.predicates.first
      bind  = relation.where_clause.binds.first
      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::Equality
      assert_equal 'hello', bind.last

      value = relation.where_clause.predicates.last
      bind  = relation.where_clause.binds.last
      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::NotEqual
      assert_equal 'world', bind.last
    end

    def test_not_eq_with_succeeding_where
      relation = Post.where.not(title: 'hello').where(title: 'world')

      value = relation.where_clause.predicates.first
      bind  = relation.where_clause.binds.first
      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::NotEqual
      assert_equal 'hello', bind.last

      value = relation.where_clause.predicates.last
      bind  = relation.where_clause.binds.last
      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::Equality
      assert_equal 'world', bind.last
    end

    def test_not_eq_with_string_parameter
      expected = Arel::Nodes::Not.new("title = 'hello'")
      relation = Post.where.not("title = 'hello'")
      assert_equal([expected], relation.where_clause.predicates)
    end

    def test_not_eq_with_array_parameter
      expected = Arel::Nodes::Not.new("title = 'hello'")
      relation = Post.where.not(['title = ?', 'hello'])
      assert_equal([expected], relation.where_clause.predicates)
    end

    def test_chaining_multiple
      relation = Post.where.not(author_id: [1, 2]).where.not(title: 'ruby on rails')

      expected = Post.arel_table['author_id'].not_in([1, 2])
      assert_equal(expected, relation.where_clause.predicates[0])

      value = relation.where_clause.predicates[1]
      bind  = relation.where_clause.binds.first

      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::NotEqual
      assert_equal 'ruby on rails', bind.last
    end

    def test_rewhere_with_one_condition
      relation = Post.where(title: 'hello').where(title: 'world').rewhere(title: 'alone')

      assert_equal 1, relation.where_clause.predicates.size
      value = relation.where_clause.predicates.first
      bind = relation.where_clause.binds.first
      assert_bound_ast value, Post.arel_table[@name], Arel::Nodes::Equality
      assert_equal 'alone', bind.last
    end

    def test_rewhere_with_multiple_overwriting_conditions
      relation = Post.where(title: 'hello').where(body: 'world').rewhere(title: 'alone', body: 'again')

      assert_equal 2, relation.where_clause.predicates.size

      value = relation.where_clause.predicates.first
      bind = relation.where_clause.binds.first
      assert_bound_ast value, Post.arel_table['title'], Arel::Nodes::Equality
      assert_equal 'alone', bind.last

      value = relation.where_clause.predicates[1]
      bind = relation.where_clause.binds[1]
      assert_bound_ast value, Post.arel_table['body'], Arel::Nodes::Equality
      assert_equal 'again', bind.last
    end

    def assert_bound_ast value, table, type
      assert_equal table, value.left
      assert_kind_of type, value
      assert_kind_of Arel::Nodes::BindParam, value.right
    end

    def test_rewhere_with_one_overwriting_condition_and_one_unrelated
      relation = Post.where(title: 'hello').where(body: 'world').rewhere(title: 'alone')

      assert_equal 2, relation.where_clause.predicates.size

      value = relation.where_clause.predicates.first
      bind  = relation.where_clause.binds.first

      assert_bound_ast value, Post.arel_table['body'], Arel::Nodes::Equality
      assert_equal 'world', bind.last

      value = relation.where_clause.predicates.second
      bind  = relation.where_clause.binds.second

      assert_bound_ast value, Post.arel_table['title'], Arel::Nodes::Equality
      assert_equal 'alone', bind.last
    end

    def test_rewhere_with_range
      relation = Post.where(comments_count: 1..3).rewhere(comments_count: 3..5)

      assert_equal 1, relation.where_clause.predicates.size
      assert_equal Post.where(comments_count: 3..5), relation
    end

    def test_rewhere_with_infinite_upper_bound_range
      relation = Post.where(comments_count: 1..Float::INFINITY).rewhere(comments_count: 3..5)

      assert_equal 1, relation.where_clause.predicates.size
      assert_equal Post.where(comments_count: 3..5), relation
    end

    def test_rewhere_with_infinite_lower_bound_range
      relation = Post.where(comments_count: -Float::INFINITY..1).rewhere(comments_count: 3..5)

      assert_equal 1, relation.where_clause.predicates.size
      assert_equal Post.where(comments_count: 3..5), relation
    end

    def test_rewhere_with_infinite_range
      relation = Post.where(comments_count: -Float::INFINITY..Float::INFINITY).rewhere(comments_count: 3..5)

      assert_equal 1, relation.where_clause.predicates.size
      assert_equal Post.where(comments_count: 3..5), relation
    end
  end
end