Mercurial > hg > soundsoftware-site
view .svn/pristine/8c/8c1df4d73d6e3117c24c3c76b9007e79ab4c6eb2.svn-base @ 1013:b98f60a6d231 live
Avoid crashing out with weird event types that don't give us a proper author record
author | Chris Cannam |
---|---|
date | Mon, 12 Nov 2012 14:55:11 +0000 |
parents | cbb26bc654de |
children |
line wrap: on
line source
class SetTopicAuthorsAsWatchers < ActiveRecord::Migration def self.up # Sets active users who created/replied a topic as watchers of the topic # so that the new watch functionality at topic level doesn't affect notifications behaviour Message.connection.execute("INSERT INTO #{Watcher.table_name} (watchable_type, watchable_id, user_id)" + " SELECT DISTINCT 'Message', COALESCE(m.parent_id, m.id), m.author_id" + " FROM #{Message.table_name} m, #{User.table_name} u" + " WHERE m.author_id = u.id AND u.status = 1") end def self.down # Removes all message watchers Watcher.delete_all("watchable_type = 'Message'") end end