<?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 ignore_keys(&$value) {
  $keys_to_ignore = array('description', 'default', 'not null', 'size', 'unsigned');
  if (is_array($value)) {
    $value = array_diff_key($value, array_flip($keys_to_ignore));
    array_walk($value, 'ignore_keys');
  }
}

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_id => $entity_type) {
  if (strpos($entity_type_id, 'entity_test') === FALSE) {
    continue;
  }

  if (!$entity_type->hasControllerClass('storage')) {
    continue;
  }
  $storage_controller = $entity_manager->getStorageController($entity_type_id);
  if (!($storage_controller instanceof FieldableDatabaseStorageController)) {
    continue;
  }

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

  $tables = array();
  $tables[] = $entity_type->getBaseTable();
  $tables[] = $entity_type->getDataTable();
  $tables[] = $entity_type->getRevisionTable();
  $tables[] = $entity_type->getRevisionDataTable();
  $tables = array_filter($tables);
  foreach ($tables as $table) {
    $old_schema[$entity_type_id][$table] = drupal_get_schema_unprocessed($module, $table);
  }

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

ignore_keys($old_schema);
ignore_keys($new_schema);

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

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

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