feedback-3.x-dev/tests/fixtures/update/feedback-10000.php
tests/fixtures/update/feedback-10000.php
<?php
/**
* @file
* Contains database additions for Feedback schema version 10000.
*/
// phpcs:disable
// cspell:disable
use Drupal\Core\Database\Database;
$connection = Database::getConnection();
$extensions = $connection->select('config')
->fields('config', ['data'])
->condition('collection', '')
->condition('name', 'core.extension')
->execute()
->fetchField();
$extensions = unserialize($extensions);
$extensions['module']['feedback'] = 10000;
$connection->update('config')
->fields(['data' => serialize($extensions)])
->condition('collection', '')
->condition('name', 'core.extension')
->execute();
$connection->insert('config')
->fields([
'collection',
'name',
'data',
])
->values([
'collection' => '',
'name' => 'core.entity_form_display.feedback_message.2nd_feedback.default',
'data' => 'a:10:{s:4:"uuid";s:36:"3b4d40f6-4a70-4dcc-9af6-b6fee6a3a619";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:1:{s:6:"config";a:2:{i:0;s:43:"feedback.feedback_message_type.2nd_feedback";i:1;s:62:"field.field.feedback_message.2nd_feedback.field_submitter_name";}}s:2:"id";s:37:"feedback_message.2nd_feedback.default";s:16:"targetEntityType";s:16:"feedback_message";s:6:"bundle";s:12:"2nd_feedback";s:4:"mode";s:7:"default";s:7:"content";a:3:{s:20:"field_submitter_name";a:5:{s:4:"type";s:16:"string_textfield";s:6:"weight";i:11;s:6:"region";s:7:"content";s:8:"settings";a:2:{s:4:"size";i:60;s:11:"placeholder";s:0:"";}s:20:"third_party_settings";a:0:{}}s:8:"langcode";a:5:{s:4:"type";s:15:"language_select";s:6:"weight";i:10;s:6:"region";s:7:"content";s:8:"settings";a:1:{s:14:"include_locked";b:1;}s:20:"third_party_settings";a:0:{}}s:7:"user_id";a:5:{s:4:"type";s:29:"entity_reference_autocomplete";s:6:"weight";i:5;s:6:"region";s:7:"content";s:8:"settings";a:4:{s:14:"match_operator";s:8:"CONTAINS";s:11:"match_limit";i:10;s:4:"size";i:60;s:11:"placeholder";s:0:"";}s:20:"third_party_settings";a:0:{}}}s:6:"hidden";a:0:{}}',
])
->values([
'collection' => '',
'name' => 'core.entity_form_display.feedback_message.default_feedback.default',
'data' => 'a:11:{s:4:"uuid";s:36:"be2fcf9e-e719-41f6-b3b8-b3fecbbdeaba";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:2:{s:6:"config";a:2:{i:0;s:47:"feedback.feedback_message_type.default_feedback";i:1;s:50:"field.field.feedback_message.default_feedback.body";}s:6:"module";a:1:{i:0;s:4:"text";}}s:5:"_core";a:1:{s:19:"default_config_hash";s:43:"k963TnHx0hvCg_8cpZTz71AtslvJ1PKokRhPYLFSdfo";}s:2:"id";s:41:"feedback_message.default_feedback.default";s:16:"targetEntityType";s:16:"feedback_message";s:6:"bundle";s:16:"default_feedback";s:4:"mode";s:7:"default";s:7:"content";a:2:{s:4:"body";a:5:{s:6:"weight";i:1;s:8:"settings";a:2:{s:4:"rows";i:5;s:11:"placeholder";s:0:"";}s:20:"third_party_settings";a:0:{}s:4:"type";s:13:"text_textarea";s:6:"region";s:7:"content";}s:8:"langcode";a:5:{s:4:"type";s:15:"language_select";s:6:"weight";i:0;s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:6:"region";s:7:"content";}}s:6:"hidden";a:2:{s:4:"path";b:1;s:7:"user_id";b:1;}}',
])
->values([
'collection' => '',
'name' => 'core.entity_view_display.feedback_message.2nd_feedback.default',
'data' => 'a:10:{s:4:"uuid";s:36:"dcd6e428-b61d-482c-b109-abe318da1883";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:2:{s:6:"config";a:2:{i:0;s:43:"feedback.feedback_message_type.2nd_feedback";i:1;s:62:"field.field.feedback_message.2nd_feedback.field_submitter_name";}s:6:"module";a:1:{i:0;s:4:"user";}}s:2:"id";s:37:"feedback_message.2nd_feedback.default";s:16:"targetEntityType";s:16:"feedback_message";s:6:"bundle";s:12:"2nd_feedback";s:4:"mode";s:7:"default";s:7:"content";a:3:{s:20:"field_submitter_name";a:6:{s:4:"type";s:6:"string";s:5:"label";s:5:"above";s:8:"settings";a:1:{s:14:"link_to_entity";b:0;}s:20:"third_party_settings";a:0:{}s:6:"weight";i:5;s:6:"region";s:7:"content";}s:4:"link";a:6:{s:4:"type";s:8:"uri_link";s:5:"label";s:6:"inline";s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:6:"weight";i:4;s:6:"region";s:7:"content";}s:7:"user_id";a:6:{s:4:"type";s:6:"author";s:5:"label";s:6:"hidden";s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:6:"weight";i:0;s:6:"region";s:7:"content";}}s:6:"hidden";a:0:{}}',
])
->values([
'collection' => '',
'name' => 'core.entity_view_display.feedback_message.default_feedback.default',
'data' => 'a:11:{s:4:"uuid";s:36:"15822aa0-ab77-4ace-8c23-fa7f99ba0922";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:2:{s:6:"config";a:2:{i:0;s:47:"feedback.feedback_message_type.default_feedback";i:1;s:50:"field.field.feedback_message.default_feedback.body";}s:6:"module";a:2:{i:0;s:4:"text";i:1;s:4:"user";}}s:5:"_core";a:1:{s:19:"default_config_hash";s:43:"l-qMZ_mH-qCu5uHUZpTcUvWpIw4py2aeqraFkPm8j0w";}s:2:"id";s:41:"feedback_message.default_feedback.default";s:16:"targetEntityType";s:16:"feedback_message";s:6:"bundle";s:16:"default_feedback";s:4:"mode";s:7:"default";s:7:"content";a:4:{s:4:"body";a:6:{s:6:"weight";i:2;s:5:"label";s:5:"above";s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:4:"type";s:12:"text_default";s:6:"region";s:7:"content";}s:4:"link";a:6:{s:5:"label";s:6:"inline";s:6:"weight";i:4;s:6:"region";s:7:"content";s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:4:"type";s:8:"uri_link";}s:4:"path";a:6:{s:4:"type";s:8:"uri_link";s:6:"weight";i:1;s:5:"label";s:6:"inline";s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:6:"region";s:7:"content";}s:7:"user_id";a:6:{s:5:"label";s:6:"inline";s:4:"type";s:6:"author";s:6:"weight";i:0;s:8:"settings";a:0:{}s:20:"third_party_settings";a:0:{}s:6:"region";s:7:"content";}}s:6:"hidden";a:0:{}}',
])
->values([
'collection' => '',
'name' => 'feedback.feedback_message_type.2nd_feedback',
'data' => 'a:7:{s:4:"uuid";s:36:"708e25ae-262f-4e49-8bdf-0455a768f22a";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:0:{}s:2:"id";s:12:"2nd_feedback";s:5:"label";s:12:"2nd Feedback";s:15:"success_message";s:19:"Thank you very much";}',
])
->values([
'collection' => '',
'name' => 'feedback.feedback_message_type.default_feedback',
'data' => 'a:8:{s:4:"uuid";s:36:"cd85e4b6-5ec8-400f-8e8e-9f9169a530fc";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:0:{}s:5:"_core";a:1:{s:19:"default_config_hash";s:43:"Q6p13JAqUWUx_XZg4chUrZph6YEKl4JZYaDUxr18nbM";}s:2:"id";s:16:"default_feedback";s:5:"label";s:16:"Default Feedback";s:15:"success_message";s:28:"Thank you for your feedback.";}',
])
->values([
'collection' => '',
'name' => 'field.field.feedback_message.2nd_feedback.field_submitter_name',
'data' => 'a:16:{s:4:"uuid";s:36:"07843bae-6883-40f0-bed6-8657bd04e479";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:1:{s:6:"config";a:2:{i:0;s:43:"feedback.feedback_message_type.2nd_feedback";i:1;s:51:"field.storage.feedback_message.field_submitter_name";}}s:2:"id";s:50:"feedback_message.2nd_feedback.field_submitter_name";s:10:"field_name";s:20:"field_submitter_name";s:11:"entity_type";s:16:"feedback_message";s:6:"bundle";s:12:"2nd_feedback";s:5:"label";s:9:"Your name";s:11:"description";s:0:"";s:8:"required";b:0;s:12:"translatable";b:0;s:13:"default_value";a:0:{}s:22:"default_value_callback";s:0:"";s:8:"settings";a:0:{}s:10:"field_type";s:6:"string";}',
])
->values([
'collection' => '',
'name' => 'field.field.feedback_message.default_feedback.body',
'data' => 'a:17:{s:4:"uuid";s:36:"eb4fecbd-7008-48e3-86f7-a89164738081";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:2:{s:6:"config";a:2:{i:0;s:47:"feedback.feedback_message_type.default_feedback";i:1;s:35:"field.storage.feedback_message.body";}s:6:"module";a:1:{i:0;s:4:"text";}}s:5:"_core";a:1:{s:19:"default_config_hash";s:43:"HOXyTTMcq3UkUSI8ATPLwReTg-xhaQ22h08Fo5mfxEQ";}s:2:"id";s:38:"feedback_message.default_feedback.body";s:10:"field_name";s:4:"body";s:11:"entity_type";s:16:"feedback_message";s:6:"bundle";s:16:"default_feedback";s:5:"label";s:7:"Message";s:11:"description";s:0:"";s:8:"required";b:1;s:12:"translatable";b:0;s:13:"default_value";a:0:{}s:22:"default_value_callback";s:0:"";s:8:"settings";a:1:{s:15:"allowed_formats";a:0:{}}s:10:"field_type";s:9:"text_long";}',
])
->values([
'collection' => '',
'name' => 'field.storage.feedback_message.body',
'data' => 'a:17:{s:4:"uuid";s:36:"7ea4392f-2cdf-4fe5-ba54-254eba8f1e29";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:1:{s:6:"module";a:2:{i:0;s:8:"feedback";i:1;s:4:"text";}}s:5:"_core";a:1:{s:19:"default_config_hash";s:43:"-t5-IYNCIRzAnew7NikTVk1vc7SepyQ6FfzGg5sE1EQ";}s:2:"id";s:21:"feedback_message.body";s:10:"field_name";s:4:"body";s:11:"entity_type";s:16:"feedback_message";s:4:"type";s:9:"text_long";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"locked";b:0;s:11:"cardinality";i:1;s:12:"translatable";b:1;s:7:"indexes";a:0:{}s:22:"persist_with_no_fields";b:0;s:14:"custom_storage";b:0;}',
])
->values([
'collection' => '',
'name' => 'field.storage.feedback_message.field_submitter_name',
'data' => 'a:16:{s:4:"uuid";s:36:"b8c9f3fd-08b1-46b5-8381-1254ef53c48f";s:8:"langcode";s:2:"en";s:6:"status";b:1;s:12:"dependencies";a:1:{s:6:"module";a:1:{i:0;s:8:"feedback";}}s:2:"id";s:37:"feedback_message.field_submitter_name";s:10:"field_name";s:20:"field_submitter_name";s:11:"entity_type";s:16:"feedback_message";s:4:"type";s:6:"string";s:8:"settings";a:3:{s:10:"max_length";i:255;s:14:"case_sensitive";b:0;s:8:"is_ascii";b:0;}s:6:"module";s:4:"core";s:6:"locked";b:0;s:11:"cardinality";i:1;s:12:"translatable";b:1;s:7:"indexes";a:0:{}s:22:"persist_with_no_fields";b:0;s:14:"custom_storage";b:0;}',
])
->execute();
$connection->schema()->createTable('feedback_message', [
'fields' => [
'id' => [
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
],
'type' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '32',
],
'uuid' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '128',
],
'langcode' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '12',
],
'user_id' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'link' => [
'type' => 'varchar',
'not null' => FALSE,
'length' => '2048',
],
'status' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
],
'created' => [
'type' => 'int',
'not null' => FALSE,
'size' => 'normal',
],
'changed' => [
'type' => 'int',
'not null' => FALSE,
'size' => 'normal',
],
],
'primary key' => [
'id',
],
'unique keys' => [
'feedback_message_field__uuid__value' => [
'uuid',
],
],
'indexes' => [
'feedback_message_field__type__target_id' => [
'type',
],
'feedback_message_field__user_id__target_id' => [
'user_id',
],
],
'mysql_character_set' => 'utf8mb4',
]);
$connection->insert('feedback_message')
->fields([
'id',
'type',
'uuid',
'langcode',
'user_id',
'link',
'status',
'created',
'changed',
])
->values([
'id' => '1',
'type' => 'default_feedback',
'uuid' => 'd86aa2ec-cef2-497e-87f7-53631fcdfcec',
'langcode' => 'en',
'user_id' => '1',
'link' => 'internal:/admin/structure/block/list/stark?block-placement=stark-feedbackblock',
'status' => '1',
'created' => '1729394703',
'changed' => '1729394703',
])
->values([
'id' => '2',
'type' => '2nd_feedback',
'uuid' => 'b36036e5-88d9-48ed-a3fa-9d8a9ae4e334',
'langcode' => 'en',
'user_id' => '1',
'link' => 'internal:/admin/structure/block/list/stark?block-placement=stark-feedbackblock',
'status' => '1',
'created' => '1729394911',
'changed' => '1729394911',
])
->execute();
$connection->schema()->createTable('feedback_message__body', [
'fields' => [
'bundle' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '128',
'default' => '',
],
'deleted' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
],
'entity_id' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'revision_id' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'langcode' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '32',
'default' => '',
],
'delta' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'body_value' => [
'type' => 'text',
'not null' => TRUE,
'size' => 'big',
],
'body_format' => [
'type' => 'varchar_ascii',
'not null' => FALSE,
'length' => '255',
],
],
'primary key' => [
'entity_id',
'deleted',
'delta',
'langcode',
],
'indexes' => [
'bundle' => [
'bundle',
],
'revision_id' => [
'revision_id',
],
'body_format' => [
'body_format',
],
],
'mysql_character_set' => 'utf8mb4',
]);
$connection->insert('feedback_message__body')
->fields([
'bundle',
'deleted',
'entity_id',
'revision_id',
'langcode',
'delta',
'body_value',
'body_format',
])
->values([
'bundle' => 'default_feedback',
'deleted' => '0',
'entity_id' => '1',
'revision_id' => '1',
'langcode' => 'en',
'delta' => '0',
'body_value' => 'Default Feedback, message 1',
'body_format' => 'plain_text',
])
->execute();
$connection->schema()->createTable('feedback_message__field_submitter_name', [
'fields' => [
'bundle' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '128',
'default' => '',
],
'deleted' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
],
'entity_id' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'revision_id' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'langcode' => [
'type' => 'varchar_ascii',
'not null' => TRUE,
'length' => '32',
'default' => '',
],
'delta' => [
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
],
'field_submitter_name_value' => [
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
],
],
'primary key' => [
'entity_id',
'deleted',
'delta',
'langcode',
],
'indexes' => [
'bundle' => [
'bundle',
],
'revision_id' => [
'revision_id',
],
],
'mysql_character_set' => 'utf8mb4',
]);
$connection->insert('feedback_message__field_submitter_name')
->fields([
'bundle',
'deleted',
'entity_id',
'revision_id',
'langcode',
'delta',
'field_submitter_name_value',
])
->values([
'bundle' => '2nd_feedback',
'deleted' => '0',
'entity_id' => '2',
'revision_id' => '2',
'langcode' => 'en',
'delta' => '0',
'field_submitter_name_value' => 'Lorem Ipsum',
])
->execute();
$connection->insert('key_value')
->fields([
'collection',
'name',
'value',
])
->values([
'collection' => 'config.entity.key_store.entity_form_display',
'name' => 'uuid:3b4d40f6-4a70-4dcc-9af6-b6fee6a3a619',
'value' => 'a:1:{i:0;s:62:"core.entity_form_display.feedback_message.2nd_feedback.default";}',
])
->values([
'collection' => 'config.entity.key_store.entity_form_display',
'name' => 'uuid:be2fcf9e-e719-41f6-b3b8-b3fecbbdeaba',
'value' => 'a:1:{i:0;s:66:"core.entity_form_display.feedback_message.default_feedback.default";}',
])
->values([
'collection' => 'config.entity.key_store.entity_view_display',
'name' => 'uuid:15822aa0-ab77-4ace-8c23-fa7f99ba0922',
'value' => 'a:1:{i:0;s:66:"core.entity_view_display.feedback_message.default_feedback.default";}',
])
->values([
'collection' => 'config.entity.key_store.entity_view_display',
'name' => 'uuid:dcd6e428-b61d-482c-b109-abe318da1883',
'value' => 'a:1:{i:0;s:62:"core.entity_view_display.feedback_message.2nd_feedback.default";}',
])
->values([
'collection' => 'config.entity.key_store.feedback_message_type',
'name' => 'uuid:708e25ae-262f-4e49-8bdf-0455a768f22a',
'value' => 'a:1:{i:0;s:43:"feedback.feedback_message_type.2nd_feedback";}',
])
->values([
'collection' => 'config.entity.key_store.feedback_message_type',
'name' => 'uuid:cd85e4b6-5ec8-400f-8e8e-9f9169a530fc',
'value' => 'a:1:{i:0;s:47:"feedback.feedback_message_type.default_feedback";}',
])
->values([
'collection' => 'config.entity.key_store.field_config',
'name' => 'uuid:07843bae-6883-40f0-bed6-8657bd04e479',
'value' => 'a:1:{i:0;s:62:"field.field.feedback_message.2nd_feedback.field_submitter_name";}',
])
->values([
'collection' => 'config.entity.key_store.field_config',
'name' => 'uuid:eb4fecbd-7008-48e3-86f7-a89164738081',
'value' => 'a:1:{i:0;s:50:"field.field.feedback_message.default_feedback.body";}',
])
->values([
'collection' => 'config.entity.key_store.field_storage_config',
'name' => 'uuid:1eb48bbb-34de-4b41-908f-e5aac3099b68',
'value' => 'a:1:{i:0;s:23:"field.storage.node.body";}',
])
->values([
'collection' => 'config.entity.key_store.field_storage_config',
'name' => 'uuid:7ea4392f-2cdf-4fe5-ba54-254eba8f1e29',
'value' => 'a:1:{i:0;s:35:"field.storage.feedback_message.body";}',
])
->values([
'collection' => 'config.entity.key_store.field_storage_config',
'name' => 'uuid:b8c9f3fd-08b1-46b5-8381-1254ef53c48f',
'value' => 'a:1:{i:0;s:51:"field.storage.feedback_message.field_submitter_name";}',
])
->values([
'collection' => 'entity.definitions.bundle_field_map',
'name' => 'feedback_message',
'value' => 'a:2:{s:4:"body";a:2:{s:4:"type";s:9:"text_long";s:7:"bundles";a:1:{s:16:"default_feedback";s:16:"default_feedback";}}s:20:"field_submitter_name";a:2:{s:4:"type";s:6:"string";s:7:"bundles";a:1:{s:12:"2nd_feedback";s:12:"2nd_feedback";}}}',
])
->values([
'collection' => 'entity.definitions.installed',
'name' => 'feedback_message.entity_type',
'value' => 'O:36:"Drupal\Core\Entity\ContentEntityType":41:{s:5:"