Handling heroku_ext change

README.md

per https://twitter.com/searls/status/1559543920673144834 -> https://blog.testdouble.com/posts/2022-08-15-migrating-postgres-extensions-to-the-heroku_ext_schema/

database_tasks_ext.rb

require "active_record"
require "active_record/tasks/database_tasks"
module HackDatabaseTasks
  def dump_schema(db_config, format = ActiveRecord.schema_format) # :nodoc:
    super.tap do
      filename = schema_dump_path(db_config, format)
      path = "db/structure.sql"
      next unless filename.include?(path)
      IO.write(filename, File.open(filename) { |f|
        f.read.gsub "CREATE SCHEMA heroku_ext;", <<~SQL.chomp
          -- WARNING: CUSTOM HACK!
          -- Add "IF NOT EXISTS" to only create schema if not created by Heroku
          CREATE SCHEMA IF NOT EXISTS heroku_ext;
        SQL
      })
    end
  end
end
ActiveRecord::Tasks::DatabaseTasks.prepend(HackDatabaseTasks)