noesya/osuny

# == Schema Information
#
# Table name: communication_website_connections
#
#  id                   :uuid             not null, primary key
#  direct_source_type   :string           indexed => [direct_source_id]
#  indirect_object_type :string           not null, indexed => [indirect_object_id]
#  created_at           :datetime         not null
#  updated_at           :datetime         not null
#  direct_source_id     :uuid             indexed => [direct_source_type]
#  indirect_object_id   :uuid             not null, indexed => [indirect_object_type]
#  university_id        :uuid             not null, indexed
#  website_id           :uuid             not null, indexed
#
# Indexes
#
#  index_communication_website_connections_on_object         (indirect_object_type,indirect_object_id)
#  index_communication_website_connections_on_source         (direct_source_type,direct_source_id)
#  index_communication_website_connections_on_university_id  (university_id)
#  index_communication_website_connections_on_website_id     (website_id)
#
# Foreign Keys
#
#  fk_rails_728034883b  (website_id => communication_websites.id)
#  fk_rails_bd1ac8383b  (university_id => universities.id)
#
class Communication::Website::Connection < ApplicationRecord
  belongs_to :university
  belongs_to :website, class_name: "Communication::Website"
  belongs_to :indirect_object, polymorphic: true
  belongs_to :direct_source, polymorphic: true

  scope :for_object, -> (object) { where(indirect_object: object) }
  scope :in_website, -> (website) { where(website: website) }
  scope :ordered, -> (language = nil) { order(updated_at: :desc) }

  def self.websites_for(object)
    for_object(object).distinct(:website).collect(&:website).uniq
  end

  def self.delete_useless_connections(connections, dependencies)
    deletable_connection_ids = []
    connections.find_each do |connection|
      deletable_connection_ids << connection.id if connection.obsolete_in?(dependencies)
    end
    # On utilise delete_all pour supprimer les connexions obsolètes en une unique requête DELETE FROM
    # Cependant, on peut le faire car les connexions n'ont pas de callback.
    # Dans le cas où on en rajoute au destroy, il faut repasser sur un appel de destroy sur chaque
    connections.where(id: deletable_connection_ids).delete_all
  end

  def to_s
    "#{id.split('-').first}"
  end

  # On passe les dépendances pour ne pas les recharger et préserver la RAM
  def obsolete_in?(dependencies)
    !dependencies.detect do |dependency|
      dependency.class.name == indirect_object_type &&
      dependency.id == indirect_object_id
    end
  end

end