function _menu_link_content_post_update_make_menu_link_content_revisionable__fix_default_langcode

Fixes recoverable data integrity issues in the "default_langcode" field.

@internal

Parameters

array $sandbox: The update sandbox array.

Return value

bool TRUE if the operation was finished, FALSE otherwise.

File

core/modules/menu_link_content/menu_link_content.post_update.php, line 146

Code

function _menu_link_content_post_update_make_menu_link_content_revisionable__fix_default_langcode(array &$sandbox) {
    if (!empty($sandbox['data_fix']['default_langcode']['finished'])) {
        return TRUE;
    }
    $storage = \Drupal::entityTypeManager()->getStorage('menu_link_content');
    if (!$storage instanceof MenuLinkContentStorage) {
        return TRUE;
    }
    elseif (!isset($sandbox['data_fix']['default_langcode']['last_id'])) {
        $sandbox['data_fix']['default_langcode'] = [
            'last_id' => 0,
            'processed' => 0,
        ];
    }
    $database = \Drupal::database();
    $data_table_name = 'menu_link_content_data';
    $last_id = $sandbox['data_fix']['default_langcode']['last_id'];
    $limit = Settings::get('update_sql_batch_size', 200);
    // Detect records in the data table matching the base table language, but
    // having the "default_langcode" flag set to with 0, which is not supported.
    $query = $database->select($data_table_name, 'd');
    $query->leftJoin('menu_link_content', 'b', 'd.id = b.id AND d.langcode = b.langcode AND d.default_langcode = 0');
    $result = $query->fields('d', [
        'id',
        'langcode',
    ])
        ->condition('d.id', $last_id, '>')
        ->isNotNull('b.id')
        ->orderBy('d.id')
        ->range(0, $limit)
        ->execute();
    foreach ($result as $record) {
        $sandbox['data_fix']['default_langcode']['last_id'] = $record->id;
        // We need to exclude any menu link already having also a data table record
        // with the "default_langcode" flag set to 1, because this is a data
        // integrity issue that cannot be fixed automatically. However the latter
        // will not make the update fail.
        $has_default_langcode = (bool) $database->select($data_table_name, 'd')
            ->fields('d', [
            'id',
        ])
            ->condition('d.id', $record->id)
            ->condition('d.default_langcode', 1)
            ->range(0, 1)
            ->execute()
            ->fetchField();
        if ($has_default_langcode) {
            continue;
        }
        $database->update($data_table_name)
            ->fields([
            'default_langcode' => 1,
        ])
            ->condition('id', $record->id)
            ->condition('langcode', $record->langcode)
            ->execute();
        $sandbox['data_fix']['default_langcode']['processed']++;
        \Drupal::logger('update')->warning('The menu link with ID @id had data integrity issues and was restored.', [
            '@id' => $record->id,
        ]);
    }
    $finished = $sandbox['data_fix']['default_langcode']['last_id'] === $last_id;
    $sandbox['data_fix']['default_langcode']['finished'] = $finished;
    return $finished;
}