discourse/db/migrate/20250710074447_clear_backup_frequency_if_disabled.rb
David Taylor 1d5d9646c6
DEV: Promote old post-deploy migrations to pre-deploy (#38595)
This promotes all post-migrations which existed in `v2026.1` to regular
pre-deploy migrations. We do this after each stable/esr release to
reduce the probability of pre/post deploy timing issues.
2026-03-13 19:09:30 +00:00

27 lines
694 B
Ruby

# frozen_string_literal: true
class ClearBackupFrequencyIfDisabled < ActiveRecord::Migration[7.2]
def up
execute <<~SQL
INSERT INTO site_settings (name, data_type, value, created_at, updated_at)
SELECT 'backup_frequency', 3, NULL, 'NOW()', 'NOW()'
WHERE EXISTS (
SELECT 1
FROM site_settings
WHERE name = 'automatic_backups_enabled'
AND VALUE = 'f'
LIMIT 1
)
ON CONFLICT (name) DO UPDATE SET value = NULL, updated_at = 'NOW()';
SQL
execute <<~SQL
DELETE FROM site_settings
WHERE name = 'automatic_backups_enabled';
SQL
end
def down
raise ActiveRecord::IrreversibleMigration
end
end