Dump those fixtures

I hate testing/debugging a rails application on "unreal" data. At the same time I find writing fixtures by hand is a big pain. I wrote this rake task to dump all the data in fixtures folder by (rake test:fixtures:dump) on a production environment, bring it to development environment and do a rake test:fixtures:load

desc "Dump all the data from DB to fixtures in YML format"
namespace :db do
  namespace :fixtures do
    task :dump => :environment do
      require 'active_record/fixtures'
      ActiveRecord::Base.establish_connection(Rails.env)
      base_dir = ENV['FIXTURES_PATH'] ? File.join(Rails.root, ENV['FIXTURES_PATH']) : File.join(Rails.root, 'test', 'fixtures')
      fixtures_dir = ENV['FIXTURES_DIR'] ? File.join(base_dir, ENV['FIXTURES_DIR']) : base_dir

      Dir.entries(File.join(RAILS_ROOT, "app", "models")).each{|filename|
        if /\.rb$/.match(filename)
          model = Kernel.const_get(filename.gsub(".rb", "").camelcase)
          if model.ancestors.include?(ActiveRecord::Base) and model.table_exists?
            puts "Dumping #{model}"
            file = File.open(File.join("test", "fixtures", model.table_name+".yml"), "w")
            counter = 1
            model.find_in_batches(:batch_size => 5000){|rows|
              rows.each{|row|
                file.puts "#{counter}:"
                file.puts row.attributes.to_yaml.split("\n")[1..-1].collect{|x| "\s\s"+x}.join("\n")
                counter+=1
              }
            }
            file.close
            puts " -- Created a file with #{counter} rows"
          end
        end
      }
    end
  end
end

Shootout: Jruby1.3.1 vs Ruby1.8.7 vs Ruby1.9.2 vs Python2.6 vs Java6

Click on the image to view it clearly

Jruby is the fastest among Jruby, Ruby and Python. Benchmark program was a fractal geometry program posted here.

Language	Time for 100 iterations	times slower than java with -server
java –server	0.18	1
Ruby1.8	7.78	44.07
Ruby1.9.2	4.2	23.78
Jruby	2.5	14.16
Jruby1.3.1—sever	2.31	13.1
java	0.18	1.01
python	3.04	17.21