diff options
Diffstat (limited to 'db/migrate/20200721212401_backfill_account_id_on_conversations.rb')
-rw-r--r-- | db/migrate/20200721212401_backfill_account_id_on_conversations.rb | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/db/migrate/20200721212401_backfill_account_id_on_conversations.rb b/db/migrate/20200721212401_backfill_account_id_on_conversations.rb deleted file mode 100644 index 595fd8e52..000000000 --- a/db/migrate/20200721212401_backfill_account_id_on_conversations.rb +++ /dev/null @@ -1,15 +0,0 @@ -class BackfillAccountIdOnConversations < ActiveRecord::Migration[5.2] - disable_ddl_transaction! - - def up - Rails.logger.info('Backfilling owners of conversation threads...') - safety_assured do - Conversation.left_outer_joins(:statuses).where(statuses: { id: nil }).in_batches.destroy_all - execute('UPDATE conversations SET account_id = s.account_id FROM (SELECT account_id, conversation_id FROM statuses WHERE NOT reply) AS s WHERE conversations.id = s.conversation_id') - end - end - - def down - true - end -end |