Chris@0: <?php
Chris@0: 
Chris@0: /**
Chris@0:  * @file
Chris@0:  * Partial database to mimic the installation of the update_test_schema module.
Chris@0:  */
Chris@0: 
Chris@0: use Drupal\Core\Database\Database;
Chris@0: 
Chris@0: $connection = Database::getConnection();
Chris@0: 
Chris@0: // Create the table.
Chris@0: $connection->schema()->createTable('update_test_schema_table', [
Chris@0:   'fields' => [
Chris@0:     'a' => [
Chris@0:       'type' => 'int',
Chris@0:       'not null' => TRUE,
Chris@0:       'size' => 'normal',
Chris@0:     ],
Chris@0:     'b' => [
Chris@0:       'type' => 'blob',
Chris@0:       'not null' => FALSE,
Chris@0:       'size' => 'normal',
Chris@0:     ],
Chris@0:   ],
Chris@0: ]);
Chris@0: 
Chris@0: // Set the schema version.
Chris@0: $connection->merge('key_value')
Chris@0:   ->condition('collection', 'system.schema')
Chris@0:   ->condition('name', 'update_test_schema')
Chris@0:   ->fields([
Chris@0:     'collection' => 'system.schema',
Chris@0:     'name' => 'update_test_schema',
Chris@0:     'value' => 'i:8000;',
Chris@0:   ])
Chris@0:   ->execute();
Chris@0: 
Chris@0: // Update core.extension.
Chris@0: $extensions = $connection->select('config')
Chris@0:   ->fields('config', ['data'])
Chris@0:   ->condition('collection', '')
Chris@0:   ->condition('name', 'core.extension')
Chris@0:   ->execute()
Chris@0:   ->fetchField();
Chris@0: $extensions = unserialize($extensions);
Chris@0: $extensions['module']['update_test_schema'] = 8000;
Chris@0: $connection->update('config')
Chris@0:   ->fields([
Chris@0:     'data' => serialize($extensions),
Chris@0:   ])
Chris@0:   ->condition('collection', '')
Chris@0:   ->condition('name', 'core.extension')
Chris@0:   ->execute();