Mercurial > hg > soundsoftware-site
annotate db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1622:f3144e23ca1d live
Don't try to use cgitb, it just causes problems with Apache CGI interface
| author | Chris Cannam |
|---|---|
| date | Fri, 10 Aug 2018 11:22:30 +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 |