discourse-adplugin/db/migrate/20250721192556_enable_adplugin_if_already_installed.rb

# frozen_string_literal: true

class EnableAdpluginIfAlreadyInstalled < ActiveRecord::Migration[7.2]
  def up
    installed_at = DB.query_single(<<~SQL)&.first
      SELECT created_at FROM schema_migration_details WHERE version='20190603112536'
    SQL

    if installed_at && installed_at < 1.hour.ago
      # The plugin was installed before we changed it to be disabled-by-default
      # Therefore, if there is no existing database value, enable the plugin
      execute <<~SQL
        INSERT INTO site_settings(name, data_type, value, created_at, updated_at)
        VALUES('discourse_adplugin_enabled', 5, 't', NOW(), NOW())
        ON CONFLICT (name) DO NOTHING
      SQL
    end
  end

  def down
    raise ActiveRecord::IrreversibleMigration
  end
end