Mercurial > hg > soundsoftware-site

view db/migrate/20131218183023_delete_orphan_time_entries_custom_values.rb @ 1545:f81fcbde7eaf feature_1136

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge
author Chris Cannam <chris.cannam@soundsoftware.ac.uk>
date Tue, 12 Jan 2016 15:14:36 +0000
parents dffacf8a6908
children
line wrap: on
line source
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