FactoryGirl 等で作成したデータを Insert文に変換する

create_insert_into.rb

def create_insert_into(model_class)
  model_class.all.each do |record|
    print "insert into #{model_class.table_name} values ("
    model_class.columns.each_with_index do |col, idx|
      print ", " unless idx == 0
      print "#{sql record.public_send(col.name)}"
    end
    puts ");"
  end
end

def sql(data)
  case data
  when DateTime, Time
    "'#{data.to_s(:db)}'"
  when TrueClass
    "'1'"
  when FalseClass
    "'0'"
  when NilClass
    "NULL"
  else
    "'#{data}'"
  end
end

# Usage
FactoryGirl.create(:table_name)
create_insert_into(TableName)    # => insert into values('data1', 'data2', ...);