1 files changed, 18 insertions, 0 deletions
diff --git a/script/year-review.rb b/script/year-review.rb
new file mode 100644
index 0000000..3e25b1d
--- /dev/null
+++ b/script/year-review.rb
@@ -0,0 +1,18 @@
+#!/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