export-comments.rb

#!/usr/bin/env ruby

$:.unshift "#{File.dirname(__FILE__)}/lib"

require 'environment'
require 'configuration'
require 'mysql'
require 'csv'

conf = Configuration.new

db = Mysql.real_connect(conf.database_host, conf.database_user, conf.database_password, conf.database_name)

res = db.query("select comments.*, comments.body as comment_body, epobject.body as hansard_body, hdate from comments, epobject, hansard where hansard.epobject_id = epobject.epobject_id and comments.epobject_id = epobject.epobject_id")

outfile = File.open('exported-comments.csv', 'wb')
CSV::Writer.generate(outfile) do |csv|
  res.each_hash do |row|
    csv << [row["comment_id"], row["user_id"], row["visible"], row["modflagged"], row["posted"], row["hdate"], row["comment_body"], row["hansard_body"][0..300]]
  end
end
outfile.close

db.query("DELETE FROM comments")