path: root/script/year-review.rb

#!/usr/bin/env ruby
#
# Run with reils runner like this:
#
#     RAILS_ENV=production rails runner script/year-review.rb
#
# Thie ensures it runs in the context of the application.

def normalize(t)
  t.gsub("'", '"')
end

cat = Refinery::Blog::Category.where(:title => "Omtaler").first
start_date = Date.new(Date.today.year, 01, 01)
posts = cat.posts.where("published_at > :date", { :date => start_date })
posts.each do |p|
  puts "'#{normalize(p.title)}', #{p.published_at}, #{p.author.username}, http://heavymetal.no/blog/posts/#{p.slug}"
end