# frozen_string_literal: true

require 'spec_helper'

describe 'Query Rewriter' do
  context 'when bulk updating' do
    let!(:account) { Account.create!(name: 'Test Account') }
    let!(:project) { Project.create(name: 'Project 1', account: account) }
    let!(:manager) { Manager.create(name: 'Manager', project: project, account: account) }

    it 'updates the records' do
      expect do
        MultiTenant.with(account) do
          Project.joins(:manager).update_all(name: 'New Name')
        end
      end.to change { project.reload.name }.from('Project 1').to('New Name')
    end

    it 'updates the records without a current tenant' do
      expect do
        Project.joins(:manager).update_all(name: 'New Name')
      end.to change { project.reload.name }.from('Project 1').to('New Name')
    end

    it 'update the record' do
      expect do
        MultiTenant.with(account) do
          project.update(name: 'New Name')
        end
      end.to change { project.reload.name }.from('Project 1').to('New Name')
    end

    it 'update the record without a current tenant' do
      expect do
        project.update(name: 'New Name')
      end.to change { project.reload.name }.from('Project 1').to('New Name')
    end
  end

  context 'when bulk deleting' do
    let!(:account) { Account.create!(name: 'Test Account') }
    let!(:project1) { Project.create(name: 'Project 1', account: account) }
    let!(:project2) { Project.create(name: 'Project 2', account: account) }
    let!(:project3) { Project.create(name: 'Project 3', account: account) }
    let!(:manager1) { Manager.create(name: 'Manager 1', project: project1, account: account) }
    let!(:manager2) { Manager.create(name: 'Manager 2', project: project2, account: account) }

    it 'delete_all the records' do
      expect do
        MultiTenant.with(account) do
          Project.joins(:manager).delete_all
        end
      end.to change { Project.count }.from(3).to(1)
    end

    it 'delete_all the records without a current tenant' do
      expect do
        Project.joins(:manager).delete_all
      end.to change { Project.count }.from(3).to(1)
    end

    it 'delete the record' do
      expect do
        MultiTenant.with(account) do
          project1.delete
          Project.delete(project2.id)
        end
      end.to change { Project.count }.from(3).to(1)
    end

    it 'delete the record without a current tenant' do
      expect do
        project1.delete
        Project.delete(project2.id)
      end.to change { Project.count }.from(3).to(1)
    end

    it 'destroy the record' do
      expect do
        MultiTenant.with(account) do
          project1.destroy
          Project.destroy(project2.id)
        end
      end.to change { Project.count }.from(3).to(1)
    end

    it 'destroy the record without a current tenant' do
      expect do
        project1.destroy
        Project.destroy(project2.id)
      end.to change { Project.count }.from(3).to(1)
    end
  end

  context 'when update without arel' do
    it 'can call method' do
      expect do
        ActiveRecord::Base.connection.update('SELECT 1')
      end.not_to raise_error
    end
  end

  context 'when joining with a model with a default scope' do
    let!(:account) { Account.create!(name: 'Test Account') }

    it 'fetches only records within the default scope' do
      alive = Domain.create(name: 'alive', account: account)
      deleted = Domain.create(name: 'deleted', deleted: true, account: account)
      page_in_alive_domain = Page.create(name: 'alive', account: account, domain: alive)
      Page.create(name: 'deleted', account: account, domain: deleted)

      expect(
        MultiTenant.with(account) do
          Page.joins(:domain).pluck(:id)
        end
      ).to eq([page_in_alive_domain.id])
    end
  end
end