Database Truncation

database_truncator.rb

# frozen-string-literal: true

class DatabaseTruncator
  def self.truncate
    skipped = 'schema_migrations'

    ActiveRecord::Base.establish_connection
    ActiveRecord::Base.connection.tables.each do |table|
      puts "Truncating #{table}"
      ActiveRecord::Base.connection.execute("TRUNCATE #{table} CASCADE") unless skipped.include?(table) # rubocop:disable Metrics/LineLength
    end
  end
end

db.rake

namespace :db do
  desc 'Truncate all tables, except schema_migrations (customizable)'
  task :truncate, [:tables] => 'db:load_config' do |_t, args|
    require 'database_truncator'
    DatabaseTruncator.truncate
    puts 'Database truncated'
  end