Sha256: dab490cc4db2498d108f88f6ee0a68864c3a01791fd58349978959ade312293f

Contents?: true

Size: 1.36 KB

Versions: 17

Compression:

Stored size: 1.36 KB

Contents

class UpdateBackupTables < ActiveRecord::Migration
  def self.up
    change_table :backup do |t|
      t.rename :storage, :type # will use STI from now
      t.string :md5sum
    end
    
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='Backup::Record::FTP' WHERE type='ftp'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='Backup::Record::Local' WHERE type='local'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='Backup::Record::S3' WHERE type='s3'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='Backup::Record::SCP' WHERE type='scp'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='Backup::Record::SFTP' WHERE type='sftp'"
  end

  def self.down
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='ftp' WHERE type='Backup::Record::FTP'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='local' WHERE type='Backup::Record::Local'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='s3' WHERE type='Backup::Record::S3'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='scp' WHERE type='Backup::Record::SCP'"
    ActiveRecord::Base.connection.execute "UPDATE backup SET type='sftp' WHERE type='Backup::Record::SFTP'"
    
    change_table :backup do |t|
      t.rename :type, :storage
      t.remove :md5sum
    end
  end
end

Version data entries

17 entries across 17 versions & 5 rubygems

Version Path
backup-2.4.5.1 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.4.5 generators/backup_update/templates/migrations/update_backup_tables.rb
namxam-backup-2.4.5 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.4.4 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.4.3 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.4.1 generators/backup_update/templates/migrations/update_backup_tables.rb
dmitryv-backup-2.4.0 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.4.0 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.3.3.1 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.3.3 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.3.2 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.3.2.pre3 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.3.2.pre2 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-2.3.2.pre generators/backup_update/templates/migrations/update_backup_tables.rb
backup-wakiki-2.4.1 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-gundua-2.3.1.2 generators/backup_update/templates/migrations/update_backup_tables.rb
backup-gundua-2.3.1.1 generators/backup_update/templates/migrations/update_backup_tables.rb