gistfile1.rb

  desc "Removes all tables from the current database"
  task(:wipe => :environment) do
    conf = ActiveRecord::Base.configurations
    tables = `psql #{conf[RAILS_ENV]["database"]} #{conf[RAILS_ENV]["username"]} -c "\\d" -A | grep table`.split("\n").collect{|l| l.split('|')[1]}
    tables.each do |table|
      if system("psql #{conf[RAILS_ENV]["database"]} #{conf[RAILS_ENV]["username"]} -c \"DROP TABLE #{table}\"")
        puts "Dropped table #{table}"
      else
        puts "ERROR: Couldn't drop #{table}"
      end
    end
  end