module RailsConnector
  # The CMS news object
  #
  # This class models the join table between channels and objects.
  # Instances of this class also hold information about validity range.
  # @api public
  class News < CmsBaseModel
    self.primary_key = "news_id"

    belongs_to :object, :class_name => 'Obj', :foreign_key => 'object_id'

    def self.table_name
      "#{table_name_prefix}" "news"
    end

    scope :active, -> { where('? BETWEEN valid_from AND valid_until', Time.now.to_s(:number))}

    scope :for_channel, ->(channel_name) {where(channel_name: channel_name)}
  end
end