Rake task to create fixtures from test database in Rails 3.1

fixtures.rake

#put in lib/tasks/fixtures.rake
namespace :db do 
  namespace :fixtures do 
    desc 'Create YAML test fixtures from data in an existing database. 
    Defaults to development database. Set RAILS_ENV to override.' 
    task :dump => :environment do 
      sql = "SELECT * FROM %s" 
      skip_tables = ["schema_migrations"] 
      ActiveRecord::Base.establish_connection(:development) 
      (ActiveRecord::Base.connection.tables - skip_tables).each do |table_name| 
      #("users").each do |table_name| 
        i = "000" 
        File.open(Rails.root.to_s + "/test/fixtures/#{table_name}.yml", 'w') do |file| 
          data = ActiveRecord::Base.connection.select_all(sql % table_name) 
          file.write data.inject({}) { |hash, record| 
          hash["#{table_name}_#{i.succ!}"] = record 
          hash 
          }.to_yaml 
        end 
      end 
    end 
  end 
end 

this line #("users").each do |table_name| probably should be: #["users"].each do |table_name|, since string doesn't have each method.

Awesome! Just what I was looking for!!!! Thanks!

this lines can be improved for better database resolution

sql = "SELECT * FROM %s.%s"

data = ActiveRecord::Base.connection.select_all(sql % [ActiveRecord::Base.connection.current_database,table_name])

Great! Thanks!