annotate .svn/pristine/d1/d1fe1a10e719bee9e65cf063fc9ec9a0c05f2327.svn-base @ 1628:9c5f8e24dadc live tip

Quieten this cron script
author Chris Cannam
date Tue, 25 Aug 2020 11:38:49 +0100
parents 261b3d9a4903
children
rev   line source
Chris@1464 1 class AddProjectsTrackersUniqueIndex < ActiveRecord::Migration
Chris@1464 2 def self.up
Chris@1464 3 remove_duplicates
Chris@1464 4 add_index :projects_trackers, [:project_id, :tracker_id], :name => :projects_trackers_unique, :unique => true
Chris@1464 5 end
Chris@1464 6
Chris@1464 7 def self.down
Chris@1464 8 remove_index :projects_trackers, :name => :projects_trackers_unique
Chris@1464 9 end
Chris@1464 10
Chris@1464 11 # Removes duplicates in projects_trackers table
Chris@1464 12 def self.remove_duplicates
Chris@1464 13 Project.all.each do |project|
Chris@1464 14 ids = project.trackers.collect(&:id)
Chris@1464 15 unless ids == ids.uniq
Chris@1464 16 project.trackers.clear
Chris@1464 17 project.tracker_ids = ids.uniq
Chris@1464 18 end
Chris@1464 19 end
Chris@1464 20 end
Chris@1464 21 end