Mercurial > hg > soundsoftware-site
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 |