annotate db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 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 DeleteOrphanTimeEntriesCustomValues < ActiveRecord::Migration
Chris@1517 2 def up
Chris@1517 3 CustomValue.where("customized_type = ? AND NOT EXISTS (SELECT 1 FROM #{TimeEntry.table_name} t WHERE t.id = customized_id)", "TimeEntry").delete_all
Chris@1517 4 end
Chris@1517 5
Chris@1517 6 def down
Chris@1517 7 # nop
Chris@1517 8 end
Chris@1517 9 end