migrate_to_is_paranoid.rb

class MoveToParanoid < ActiveRecord::Migration
	def self.up
		classes_with_active = Dir['app/models/*'].collect do |f,o|
			n = File.basename(f,'.rb')
			m = n.classify.constantize
			if m.respond_to?('column_names')
				m.reset_column_information
				m.column_names.include?('active') and m
			end or nil
		end.compact

		classes_with_active.each do |c|
			add_column c.table_name, :deleted_at, :timestamp
			c.update_all [ 'deleted_at = ?', Time.current ], [ 'active = ?', false ]
			remove_column c.table_name, :active
		end
		
		
	end

	def self.down
		classes_with_paranoid = Dir['app/models/*'].collect do |f,o|
			n = File.basename(f,'.rb')
			m = n.classify.constantize
			if m.respond_to?('column_names')
				m.reset_column_information
				m.column_names.include?('deleted_at') and m
			end or nil
		end.compact
		
		
		classes_with_paranoid.each do |c|
			add_column c.table_name, :active, :boolean, :default => true
			c.update_all_with_destroyed [ 'active = ?', true ], 'deleted_at IS NULL'
			c.update_all_with_destroyed [ 'active = ?', false ], 'deleted_at IS NOT NULL'
			remove_column c.table_name, :deleted_at
		end
		
	end
end