class Maintenance::ClassGradeCategories::DissociativeJob
  include Sidekiq::Worker

  def perform
    categories_with_no_school.delete_all
    categories_with_no_classroom.delete_all
  end

  private
    def categories_with_no_school
      ClassGradeCategory.left_joins(:school).where(Schools: { SchoolID: nil })
    end

    def categories_with_no_classroom
      ClassGradeCategory.left_joins(:classroom).where(Classes: { ClassID: nil })
    end
end