A rails migration for creating and reverting a hypertable

create_hypertable_migration.rb

class ActionsHypertable < ActiveRecord::Migration[7.0]
  def change
    @table_name = 'actions'
    @time_column = 'created_at'
    reversible do |dir|
      dir.up do
        execute <<-SQL
          SELECT create_hypertable('#{@table_name}', '#{@time_column}', if_not_exists => TRUE, migrate_data => TRUE);
        SQL
      end
      dir.down do
        execute <<-SQL
        CREATE TABLE pg_#{@table_name} (LIKE #{@table_name} INCLUDING ALL); -- duplicate table structure
        INSERT INTO pg_#{@table_name} (SELECT * FROM #{@table_name}); -- copy all data
        DROP TABLE #{@table_name}; -- drops hypertable
        ALTER TABLE pg_#{@table_name} RENAME TO #{@table_name}; -- now a regular postgres table again
        SQL
      end
    end
  end
end