<?php

require_once __DIR__ . '/core/vendor/autoload.php';
require_once __DIR__ . '/core/includes/bootstrap.inc';

use Drupal\Core\Entity\FieldableDatabaseStorageController;

drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

/** @var \Drupal\Core\Entity\EntityManagerInterface $entity_manager */
$entity_manager = \Drupal::service('entity.manager');
/** @var \Drupal\Core\Extension\ModuleHandlerInterface $module_handler */
$module_handler = \Drupal::service('module_handler');

function recursive_ksort(&$value) {
  if (is_array($value)) {
    ksort($value);
    array_walk($value, 'recursive_ksort');
  }
};

$old_schema = array();
$new_schema = array();
foreach ($entity_manager->getDefinitions() as $entity_type => $entity_info) {
  if (!$entity_info->hasControllerClass('storage')) {
    continue;
  }
  $storage_controller = $entity_manager->getStorageController($entity_type);
  if (!($storage_controller instanceof FieldableDatabaseStorageController)) {
    continue;
  }

  $provider = $entity_info->getProvider();
  $module = $module_handler->moduleExists($provider) ? $provider : 'system';

  $tables = array();
  $tables[] = $entity_info->getBaseTable();
  foreach ($tables as $table) {
    $old_schema[$entity_type][$table] = drupal_get_schema_unprocessed($module, $table);
  }

  $new_schema[$entity_type] = $storage_controller->getSchema();
}

recursive_ksort($old_schema);
recursive_ksort($new_schema);

file_put_contents('/tmp/old_schema.txt', var_export($old_schema, TRUE));
file_put_contents('/tmp/new_schema.txt', var_export($new_schema, TRUE));

exec('diff -up /tmp/old_schema.txt /tmp/new_schema.txt', $output);
foreach ($output as $line) {
  print "$line\n";
}