Rakefile

# Add your own tasks in files placed in lib/tasks ending in .rake,
# for example lib/tasks/capistrano.rake, and they will automatically be available to Rake.

require(File.join(File.dirname(__FILE__), 'config', 'boot'))

require 'rake'
require 'rake/testtask'
require 'rake/rdoctask'

require 'tasks/rails'


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}/db/migrate/data/2007/#{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