Mercurial > hg > soundsoftware-site

diff db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1526:404aa68d4227

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge from live branch
author Chris Cannam
date Thu, 11 Sep 2014 12:46:20 +0100
parents dffacf8a6908
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb	Thu Sep 11 12:46:20 2014 +0100
@@ -0,0 +1,9 @@
+class DeleteOrphanTimeEntriesCustomValues < ActiveRecord::Migration
+  def up
+    CustomValue.where("customized_type = ? AND NOT EXISTS (SELECT 1 FROM #{TimeEntry.table_name} t WHERE t.id = customized_id)", "TimeEntry").delete_all
+  end
+
+  def down
+    # nop
+  end
+end