Mercurial > hg > soundsoftware-site
annotate db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1554:e5c9809534a2 feature_1136
Further fix to that
author | Chris Cannam |
---|---|
date | Wed, 13 Jan 2016 11:43:59 +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 |