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