Mercurial > hg > soundsoftware-site
annotate db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1621:3a510bf6a9bc
Merge from live branch
| author | Chris Cannam |
|---|---|
| date | Fri, 13 Jul 2018 10:44:33 +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 |