Cleanup for Drupal 8 paragrah translation

paragraph-cleanup.drush

#!/usr/bin/env drush
#<?php // trigger phpStorm syntax
/**
 * @revision: 2
 *
 * @file
 *  Drush script to fix Drupal 8 paragraph content translation.
 *
 *  This script was meant to be run after the following patch was applied to
 *  paragraphs:
 *
 *    https://www.drupal.org/node/2591171#comment-10950967
 *
 *  This will break/remove all existing translations of paragraphs.
 *
 *  Before running this paragraph content is usually empty when a new
 *  node translation is added
 */

/**
 * Parent task that loops over all paragraphs
 */
class AmazeeParagraphFixAllTask {

  public function run() {
    $paragraph_ids = $this->getAllParagraphs();
    foreach($paragraph_ids as $paragraph) {
      $subtask = new AmazeeParagraphFixParagraphTask($paragraph);
      $subtask->run();
    }
  }

  private function getAllParagraphs() {
    $q = db_select('paragraphs_item', 'pi');
    $q->fields('pi', array('id', 'revision_id', 'langcode', 'type'));

    return $q->execute()->fetchAll();
  }

}

/**
 * Paragraph fix task
 */
class AmazeeParagraphFixParagraphTask {

  private $paragraph;

  public function __construct($paragraph) {
    $this->paragraph = $paragraph;
  }

  public function run() {
    echo "\nParagraph: {$this->paragraph->id}.v{$this->paragraph->revision_id} ({$this->paragraph->type})\n";
    $tables = array(
      'paragraphs_item_field_data',
      'paragraphs_item_revision',
      'paragraphs_item_revision_field_data',
    );
    foreach($tables as $table) {
      echo "Invalid records from `{$table}` table removed: " . $this->deletefieldData($table). "\n";
    }
  }

  private function deletefieldData($table) {
    return db_delete($table)
      ->condition('id', $this->paragraph->id)
      ->condition('revision_id', $this->paragraph->revision_id)
      ->condition('langcode', $this->paragraph->langcode, '<>')
      ->execute();
  }

}

echo "Fixing paragraph translations\n\n";
$task = new AmazeeParagraphFixAllTask();
$task->run();