db_data_import_export.rake

namespace :db do
  namespace :data do
    desc "Load data into current environment"
    task :load => [:environment, 'db:drop', 'db:create'] do
      db = ActiveRecord::Base.configurations[RAILS_ENV]
      %x( mysql -u #{db['username']} --password=#{db['password']} #{db['database']} < "#{RAILS_ROOT}/db/dump/data.sql" )  
    end

    desc "Dump current database schema and data to file"
    task :dump => :environment do
      db = ActiveRecord::Base.configurations[RAILS_ENV]
      %x( mysqldump -u #{db['username']} --password=#{db['password']} #{db['database']} > "#{RAILS_ROOT}/db/dump/data.sql" )  
    end
  end
end