Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Rake task to create fixtures from test database in Rails 3.1
#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
@goooooouwa

This comment has been minimized.

Copy link

commented Jun 25, 2014

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

@jongillies

This comment has been minimized.

Copy link

commented Jul 18, 2014

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

@Pepan

This comment has been minimized.

Copy link

commented Aug 15, 2014

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])
@allam-matsubara

This comment has been minimized.

Copy link

commented Nov 19, 2015

Great! Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.