Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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_info"]
- ActiveRecord::Base.establish_connection(:development)
- (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
- desc 'Create YAML fixtures from data in an existing database.
- Defaults to development database. Set RAILS_ENV to override.'
- task :dump_mysql_migration => :environment do
- sql = "SELECT * FROM %s"
- skip_tables = ["schema_info"]
- ActiveRecord::Base.establish_connection(:development)
- (ActiveRecord::Base.connection.tables - skip_tables).each do |table_name|
- i = "000"
- File.open("#{RAILS_ROOT}/fixtures/mysql_migration/#{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
Add Comment
Please, Sign In to add comment