Simple Archive for Rails

archive.rb

class Archive < ActiveRecord::Base
  #model will be read only!

  def self.posts
    Post.where('published = ? and published_date >= ? and published_date <= ?', true, Date.civil(a.year, a.month, 1), Date.civil(a.year, a.month, -1))
  end
  
end

archive_migration.rb

class CreateArchives < ActiveRecord::Migration
  def up
    #this view can be modified easily to archive what you are trying to organize by month/year etc.
    ActiveRecord::Base.connection.execute "create view archives as select date_trunc('month',created_at) as archive, count(*) as check_in_count from check_ins GROUP BY date_trunc('month',created_at);"
  end

  def down
    ActiveRecord::Base.connection.execute 'drop view archives'
  end
end