Contents

DATABASE_SETTINGS_FILE = 'config/database.yml'
database_settings = YAML.load(File.read(DATABASE_SETTINGS_FILE))
database_username = database_settings['development']['username']
database_password = database_settings['development']['password']
database_name = database_settings['development']['database']

namespace :comfypress do
  namespace :backup do
    namespace :development do
      desc 'save DB to sql dump'
      task :db do
        FileUtils.mkdir_p 'backups/'
        FileUtils.rm 'backups/development_dump.sql', :force => true
        # puts 'deleted backups/development_dump.sql'
        `mysqldump -u #{database_username} -p#{database_password} #{database_name} > backups/development_dump.sql`
        # puts 'created development dump backups/development_dump.sql'
      end

      desc 'backup all uploads'
      task :uploads do
        FileUtils.mkdir_p 'backups/system'
        FileUtils.rm_rf 'backups/system/*'
        # puts 'removed old backups/system/*'
        FileUtils.cp_r 'public/system/', 'backups/'
        # puts 'copied files from public/system to backups/'
      end
    end
  end

  namespace :load_backup do
    namespace :development do
      desc 'loads DB from sql dump'
      task :db do
        `mysql -u #{database_username} -p#{database_password} #{database_name} < backups/development_dump.sql`
        # puts 'loaded development database'
      end

      desc 'loads files from backup'
      task :uploads do
        FileUtils.cp_r 'backups/system/', 'public/'
        # puts 'copied files from backups/system public/'
      end
    end
  end
end

Version data entries

2 entries across 1 versions & 1 rubygems

Version	Path
comfypress-0.1.4	db/lib/tasks/backup.rake
comfypress-0.1.4	lib/tasks/backup.rake