# frozen_string_literal: true

module DatabaseHelpers
  # In order to directly work with views using factories,
  # we can swapout the view for a table of identical structure.
  def swapout_view_for_table(view)
    ActiveRecord::Base.connection.execute(<<~SQL)
      CREATE TABLE #{view}_copy (LIKE #{view});
      DROP VIEW #{view};
      ALTER TABLE #{view}_copy RENAME TO #{view};
    SQL
  end
end