class Category < ActiveRecord::Base
  has_and_belongs_to_many :posts
  has_and_belongs_to_many :special_posts, class_name: "Post"
  has_and_belongs_to_many :other_posts, class_name: "Post"
  has_and_belongs_to_many :posts_with_authors_sorted_by_author_id, -> { includes(:authors).order("authors.id") }, class_name: "Post"

  has_and_belongs_to_many :select_testing_posts,
                          -> { select "posts.*, 1 as correctness_marker" },
                          class_name: "Post",
                          foreign_key: "category_id",
                          association_foreign_key: "post_id"

  has_and_belongs_to_many :post_with_conditions,
                          -> { where title: "Yet Another Testing Title" },
                          class_name: "Post"

  has_and_belongs_to_many :popular_grouped_posts, -> { group("posts.type").having("sum(comments.post_id) > 2").includes(:comments) }, class_name: "Post"
  has_and_belongs_to_many :posts_grouped_by_title, -> { group("title").select("title") }, class_name: "Post"

  def self.what_are_you
    "a category..."
  end

  has_many :categorizations
  has_many :special_categorizations
  has_many :post_comments, through: :posts, source: :comments

  has_many :authors, through: :categorizations
  has_many :authors_with_select, -> { select "authors.*, categorizations.post_id" }, through: :categorizations, source: :author

  scope :general, -> { where(name: "General") }
end

class SpecialCategory < Category
end
