Files
simple-aircraft-manager-rails/db/migrate/20261106170000_rename_squawk_attachment_to_attachments.rb
rickyandClaude Opus 5.5 ef542ee2a5 Squawks: multiple attachments, in-app photo viewer, downloads
Existing single attachments migrate to the new list. Photos open in a
full-screen viewer (swipe/arrow keys); every file has a download link.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-11-06 09:51:04 -05:00

17 lines
786 B
Ruby

# Squawks go from one attachment to many; keep the files already uploaded.
class RenameSquawkAttachmentToAttachments < ActiveRecord::Migration[8.1]
def up
execute "UPDATE active_storage_attachments SET name = 'attachments' WHERE record_type = 'Squawk' AND name = 'attachment'"
end
def down
# Only the first file per squawk fits back into a single attachment.
execute <<~SQL
DELETE FROM active_storage_attachments
WHERE record_type = 'Squawk' AND name = 'attachments'
AND id NOT IN (SELECT MIN(id) FROM active_storage_attachments WHERE record_type = 'Squawk' AND name = 'attachments' GROUP BY record_id)
SQL
execute "UPDATE active_storage_attachments SET name = 'attachment' WHERE record_type = 'Squawk' AND name = 'attachments'"
end
end