rake task to scrub tables

scrubbin.rb

namespace :data do
  desc "scrubs all strings in every table"
  task :scrub => :environment do

    unless Rails.env.development?
      raise "This should only ever be run in development!"
    end

    tables = ActiveRecord::Base.connection.tables - ["schema_migrations"]

    tables.each do |table|

      string_attributes = table.classify.constantize.columns.map {|c| c.name if [:string, :text].include?(c.type) }.compact

      setters = []
      update_string = "UPDATE #{table} SET "
      string_attributes.each do |attribute|
        setters << "#{attribute}=SUBSTRING('#{MyApp::RakeData::HILARIOUS_STRING}',1,LENGTH(#{attribute}))"
      end

      update_string += setters.join(",")

      begin
        ActiveRecord::Base.connection.execute(sql)
        puts "#{table} successfully scrubbed."
      rescue Exception => e
        raise "Failed: #{e}"
      end

    end
  end
end