Chris@17: <?php
Chris@17: 
Chris@17: /**
Chris@17:  * @file
Chris@17:  * Contains database additions to drupal-8.bare.standard.php.gz for testing the
Chris@17:  * upgrade path of https://www.drupal.org/node/2455125.
Chris@17:  */
Chris@17: 
Chris@17: use Drupal\Component\Uuid\Php;
Chris@17: use Drupal\Core\Database\Database;
Chris@17: use Drupal\Core\Serialization\Yaml;
Chris@17: 
Chris@17: $connection = Database::getConnection();
Chris@17: 
Chris@17: $view_file = __DIR__ . '/drupal-8.views-taxonomy-parent-2543726.yml';
Chris@17: $view_config = Yaml::decode(file_get_contents($view_file));
Chris@17: 
Chris@17: $connection->insert('config')
Chris@17:   ->fields(['collection', 'name', 'data'])
Chris@17:   ->values([
Chris@17:     'collection' => '',
Chris@17:     'name' => "views.view.test_taxonomy_parent",
Chris@17:     'data' => serialize($view_config),
Chris@17:   ])
Chris@17:   ->execute();
Chris@17: 
Chris@17: $uuid = new Php();
Chris@17: 
Chris@17: // The root tid.
Chris@17: $tids = [0];
Chris@17: 
Chris@17: for ($i = 0; $i < 4; $i++) {
Chris@17:   $name = $this->randomString();
Chris@17: 
Chris@17:   $tid = $connection->insert('taxonomy_term_data')
Chris@17:     ->fields(['vid', 'uuid', 'langcode'])
Chris@17:     ->values(['vid' => 'tags', 'uuid' => $uuid->generate(), 'langcode' => 'en'])
Chris@17:     ->execute();
Chris@17: 
Chris@17:   $connection->insert('taxonomy_term_field_data')
Chris@17:     ->fields(['tid', 'vid', 'langcode', 'name', 'weight', 'changed', 'default_langcode'])
Chris@17:     ->values(['tid' => $tid, 'vid' => 'tags', 'langcode' => 'en', 'name' => $name, 'weight' => 0, 'changed' => REQUEST_TIME, 'default_langcode' => 1])
Chris@17:     ->execute();
Chris@17: 
Chris@17:   $tids[] = $tid;
Chris@17: }
Chris@17: 
Chris@17: $hierarchy = [
Chris@17:   // Term with tid 1 has terms with tids 2 and 3 as parents.
Chris@17:   1 => [2, 3],
Chris@17:   2 => [3, 0],
Chris@17:   3 => [0],
Chris@17: ];
Chris@17: 
Chris@17: $query = $connection->insert('taxonomy_term_hierarchy')->fields(['tid', 'parent']);
Chris@17: 
Chris@17: foreach ($hierarchy as $tid => $parents) {
Chris@17:   foreach ($parents as $parent) {
Chris@17:     $query->values(['tid' => $tids[$tid], 'parent' => $tids[$parent]]);
Chris@17:   }
Chris@17: }
Chris@17: 
Chris@17: // Insert an extra record with no corresponding term.
Chris@17: // See https://www.drupal.org/project/drupal/issues/2997982
Chris@17: $query->values(['tid' => max($tids) + 1, 'parent' => 0]);
Chris@17: 
Chris@17: $query->execute();