Skip to content

Instantly share code, notes, and snippets.

@calebhaye
Created January 8, 2013 07:01
Show Gist options
  • Save calebhaye/4481873 to your computer and use it in GitHub Desktop.
Save calebhaye/4481873 to your computer and use it in GitHub Desktop.
Create YAML test fixtures from data in an existing database.
desc 'Create YAML test fixtures from data in an existing database.
Defaults to development database. Set RAILS_ENV to override.'
task :extract_fixtures => :environment do
sql = "SELECT * FROM %s"
skip_tables = ["schema_info"]
ActiveRecord::Base.establish_connection
(ActiveRecord::Base.connection.tables - skip_tables).each do |table_name|
i = "000"
File.open("#{Rails.root}/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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment