mirror of
https://github.com/openSUSE/osem.git
synced 2026-01-02 19:21:13 -05:00
f8266b29ee
The ChangeVisitIdTypeOfAhoyEventsToInteger from 364be5541 is not very well done.
You can not change the schema without changing possibly existing data.
Ahoy events used some kind of string as `visit_id`. Changing this column
to integrer will just barf up `Mysql2::Error: Truncated incorrect INTEGER value`.
So we need a way for people who are in this situation now to get out of it.
Luckily we completely dropped ahoy events a while ago so we can just delete them.
40 lines
1.2 KiB
Ruby
40 lines
1.2 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
namespace :data do
|
|
desc 'Nullify wrong foreign keys'
|
|
|
|
task nullify_nonexistent_foreign_keys: :environment do
|
|
# Track
|
|
events_track = Event.all.select { |e| e.track_id && Track.find_by(id: e.track_id).nil? }
|
|
nullify_attribute(events_track, 'track_id')
|
|
|
|
# Difficulty level
|
|
events_difficulty_level = Event.all.select { |e| e.difficulty_level_id && DifficultyLevel.find_by(id: e.difficulty_level_id).nil? }
|
|
nullify_attribute(events_difficulty_level, 'difficulty_level_id')
|
|
|
|
# Room
|
|
events_room = Event.all.select { |e| e.room_id && Room.find_by(id: e.room_id).nil? }
|
|
nullify_attribute(events_room, 'room_id')
|
|
end
|
|
|
|
desc 'Drop all ahoy events'
|
|
task drop_all_ahoy_events: :environment do
|
|
class TmpAhoy < ActiveRecord::Base
|
|
self.table_name = 'ahoy_events'
|
|
end
|
|
TmpAhoy.delete_all
|
|
end
|
|
|
|
def nullify_attribute(collection, attribute)
|
|
puts "Will nullify #{attribute} in #{ActionController::Base.helpers.pluralize(collection.length, 'event')}."
|
|
if collection.any?
|
|
puts "IDs: #{collection.map(&:id)}"
|
|
collection.each do |item|
|
|
item.send(attribute+'=', nil)
|
|
item.save!
|
|
end
|
|
puts "Fixed #{attribute}!"
|
|
end
|
|
end
|
|
end
|