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 :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
