path: root/activerecord/test/cases/arel/nodes/select_core_test.rb

# frozen_string_literal: true

require_relative "../helper"

module Arel
  module Nodes
    class TestSelectCore < Arel::Test
      def test_clone
        core = Arel::Nodes::SelectCore.new
        core.froms       = %w[a b c]
        core.projections = %w[d e f]
        core.wheres      = %w[g h i]

        dolly = core.clone

        assert_equal core.froms, dolly.froms
        assert_equal core.projections, dolly.projections
        assert_equal core.wheres, dolly.wheres

        assert_not_same core.froms, dolly.froms
        assert_not_same core.projections, dolly.projections
        assert_not_same core.wheres, dolly.wheres
      end

      def test_set_quantifier
        core = Arel::Nodes::SelectCore.new
        core.set_quantifier = Arel::Nodes::Distinct.new
        viz = Arel::Visitors::ToSql.new Table.engine.connection_pool
        assert_match "DISTINCT", viz.accept(core, Collectors::SQLString.new).value
      end

      def test_equality_with_same_ivars
        core1 = SelectCore.new
        core1.froms       = %w[a b c]
        core1.projections = %w[d e f]
        core1.wheres      = %w[g h i]
        core1.groups      = %w[j k l]
        core1.windows     = %w[m n o]
        core1.havings     = %w[p q r]
        core1.comment     = Arel::Nodes::Comment.new(["comment"])
        core2 = SelectCore.new
        core2.froms       = %w[a b c]
        core2.projections = %w[d e f]
        core2.wheres      = %w[g h i]
        core2.groups      = %w[j k l]
        core2.windows     = %w[m n o]
        core2.havings     = %w[p q r]
        core2.comment     = Arel::Nodes::Comment.new(["comment"])
        array = [core1, core2]
        assert_equal 1, array.uniq.size
      end

      def test_inequality_with_different_ivars
        core1 = SelectCore.new
        core1.froms       = %w[a b c]
        core1.projections = %w[d e f]
        core1.wheres      = %w[g h i]
        core1.groups      = %w[j k l]
        core1.windows     = %w[m n o]
        core1.havings     = %w[p q r]
        core1.comment     = Arel::Nodes::Comment.new(["comment"])
        core2 = SelectCore.new
        core2.froms       = %w[a b c]
        core2.projections = %w[d e f]
        core2.wheres      = %w[g h i]
        core2.groups      = %w[j k l]
        core2.windows     = %w[m n o]
        core2.havings     = %w[l o l]
        core2.comment     = Arel::Nodes::Comment.new(["comment"])
        array = [core1, core2]
        assert_equal 2, array.uniq.size
        core2.havings     = %w[p q r]
        core2.comment     = Arel::Nodes::Comment.new(["other"])
        array = [core1, core2]
        assert_equal 2, array.uniq.size
      end
    end
  end
end