Mercurial > hg > soundsoftware-site

annotate db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1557:9d6d2f696782 feature_1136

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add date stamps
author Chris Cannam
date Thu, 14 Jan 2016 08:12:29 +0000
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