seed.rake

require 'FileUtils'

namespace :seed do
  desc 'Dump a database to yaml fixtures.  Set environment variables DB
      and DEST to specify the target database and destination path for the
      fixtures.  DB defaults to development and DEST defaults to RAILS_ROOT/
      db/fixtures.'
    task :dump => :environment do
      path = ENV['DEST'] || "#{RAILS_ROOT}/db/fixtures"
      db   = ENV['DB']   || 'development'
      sql  = 'SELECT * FROM %s'

      ActiveRecord::Base.establish_connection(db)
      ActiveRecord::Base.connection.tables.each do |table_name|
        
        i = '000'
        file = "#{path}/#{table_name}.yml"
        FileUtils.touch(file) unless table_name == 'schema_migrations'
        File.open(file, 'wb') do |file|
          file.write ActiveRecord::Base.connection.select_all(sql %
    table_name).inject({}) { |hash, record|
            hash["#{table_name}_#{i.succ!}"] = record
            hash
          }.to_yaml
        end unless table_name == 'schema_migrations'
      end
    end

      # ActiveRecord::Base.connection.select_values('show tables')
      # is mysql specific
      # SQLite:  ActiveRecord::Base.connection.select_values('.table')
      # Postgres
      # table_names = ActiveRecord::Base.connection.select_values(<<-end_sql)
      #    SELECT c.relname
      #    FROM pg_class c
      #      LEFT JOIN pg_roles r     ON r.oid = c.relowner
      #      LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
      #    WHERE c.relkind IN ('r','')
      #      AND n.nspname IN ('myappschema', 'public')
      #      AND pg_table_is_visible(c.oid)
      # end_sql
      
      
  desc "Load seed fixtures (from db/fixtures) into the current environment's database."
    task :load => :environment do
      require 'active_record/fixtures'
      Dir.glob(RAILS_ROOT + '/db/fixtures/*.yml').each do |file|
        Fixtures.create_fixtures('db/fixtures', File.basename(file, '.*'))
      end
    end
end