2b03be1f01
Drop partitions: archived_record_2025_04 archived_record_2025_05 archived_record_2025_06 Create partitions: archived_record_2026_06 archived_record_2026_07 archived_record_2026_08
17 lines
462 B
Ruby
17 lines
462 B
Ruby
# frozen_string_literal: true
|
|
|
|
Sequel.migration do
|
|
change do
|
|
Array.new(3) { |i| Date.new(2025, 4, 1).next_month(i) }.each do |month|
|
|
drop_table("archived_record_#{month.strftime("%Y_%m")}")
|
|
end
|
|
|
|
Array.new(3) { |i| Date.new(2026, 6, 1).next_month(i) }.each do |month|
|
|
create_table("archived_record_#{month.strftime("%Y_%m")}", partition_of: :archived_record) do
|
|
from month
|
|
to month.next_month
|
|
end
|
|
end
|
|
end
|
|
end
|