annotate .svn/pristine/fd/fd9cfecdc53ee6ce77b107732eb9cf31666cd8fa.svn-base @ 1628:9c5f8e24dadc live tip

Quieten this cron script
author Chris Cannam
date Tue, 25 Aug 2020 11:38:49 +0100
parents dffacf8a6908
children
rev   line source
Chris@1517 1 class SetDefaultRepositories < ActiveRecord::Migration
Chris@1517 2 def self.up
Chris@1517 3 Repository.update_all(["is_default = ?", false])
Chris@1517 4 # Sets the last repository as default in case multiple repositories exist for the same project
Chris@1517 5 Repository.connection.select_values("SELECT r.id FROM #{Repository.table_name} r" +
Chris@1517 6 " WHERE r.id = (SELECT max(r1.id) FROM #{Repository.table_name} r1 WHERE r1.project_id = r.project_id)").each do |i|
Chris@1517 7 Repository.where(["id = ?", i]).update_all(["is_default = ?", true])
Chris@1517 8 end
Chris@1517 9 end
Chris@1517 10
Chris@1517 11 def self.down
Chris@1517 12 Repository.update_all(["is_default = ?", false])
Chris@1517 13 end
Chris@1517 14 end