# frozen_string_literal: true

require "spec_helper"

describe PgSearch::Configuration::Association do
  with_model :Avatar do
    table do |t|
      t.string :url
      t.references :user
    end
  end

  with_model :User do
    table do |t|
      t.string :name
      t.belongs_to :site
    end

    model do
      include PgSearch
      has_one :avatar, :class_name => "Avatar"
      belongs_to :site

      pg_search_scope :with_avatar, :associated_against => { :avatar => :url }
      pg_search_scope :with_site, :associated_against => { :site => :title }
    end
  end

  with_model :Site do
    table do |t|
      t.string :title
    end

    model do
      include PgSearch
      has_many :users, :class_name => "User"

      pg_search_scope :with_users, :associated_against => { :users => :name }
    end
  end

  context "has_one" do
    let(:association) { described_class.new(User, :avatar, :url) }

    describe "#table_name" do
      it "returns the table name for the associated model" do
        expect(association.table_name).to eq Avatar.table_name
      end
    end

    describe "#join" do
      let(:expected_sql) do
        <<-SQL.gsub(/\s+/, ' ').strip
          LEFT OUTER JOIN
            (SELECT model_id AS id,
                    #{column_select} AS #{association.columns.first.alias}
            FROM \"#{User.table_name}\"
            INNER JOIN \"#{association.table_name}\"
            ON \"#{association.table_name}\".\"user_id\" = \"#{User.table_name}\".\"id\") #{association.subselect_alias}
          ON #{association.subselect_alias}.id = model_id
        SQL
      end
      let(:column_select) do
        "\"#{association.table_name}\".\"url\"::text"
      end

      it "returns the correct SQL join" do
        expect(association.join("model_id")).to eq(expected_sql)
      end
    end
  end

  context "belongs_to" do
    let(:association) { described_class.new(User, :site, :title) }

    describe "#table_name" do
      it "returns the table name for the associated model" do
        expect(association.table_name).to eq Site.table_name
      end
    end

    describe "#join" do
      let(:expected_sql) do
        <<-SQL.gsub(/\s+/, ' ').strip
          LEFT OUTER JOIN
            (SELECT model_id AS id,
                    #{column_select} AS #{association.columns.first.alias}
            FROM \"#{User.table_name}\"
            INNER JOIN \"#{association.table_name}\"
            ON \"#{association.table_name}\".\"id\" = \"#{User.table_name}\".\"site_id\") #{association.subselect_alias}
          ON #{association.subselect_alias}.id = model_id
        SQL
      end
      let(:column_select) do
        "\"#{association.table_name}\".\"title\"::text"
      end

      it "returns the correct SQL join" do
        expect(association.join("model_id")).to eq(expected_sql)
      end
    end
  end

  context "has_many" do
    let(:association) { described_class.new(Site, :users, :name) }

    describe "#table_name" do
      it "returns the table name for the associated model" do
        expect(association.table_name).to eq User.table_name
      end
    end

    describe "#join" do
      let(:expected_sql) do
        <<-SQL.gsub(/\s+/, ' ').strip
          LEFT OUTER JOIN
            (SELECT model_id AS id,
                    string_agg(\"#{association.table_name}\".\"name\"::text, ' ') AS #{association.columns.first.alias}
            FROM \"#{Site.table_name}\"
            INNER JOIN \"#{association.table_name}\"
            ON \"#{association.table_name}\".\"site_id\" = \"#{Site.table_name}\".\"id\"
            GROUP BY model_id) #{association.subselect_alias}
          ON #{association.subselect_alias}.id = model_id
        SQL
      end

      it "returns the correct SQL join" do
        expect(association.join("model_id")).to eq(expected_sql)
      end

      describe "#subselect_alias" do
        it "returns a consistent string" do
          subselect_alias = association.subselect_alias
          expect(subselect_alias).to be_a String
          expect(association.subselect_alias).to eq subselect_alias
        end
      end
    end
  end
end