function Connection::nextId

Overrides Connection::nextId

File

core/lib/Drupal/Core/Database/Driver/mysql/Connection.php, line 580

Class

Connection

MySQL implementation of <a href="/api/drupal/core%21lib%21Drupal%21Core%21Database%21Connection.php/class/Connection/8.9.x" title="Base Database API class." class="local">\Drupal\Core\Database\Connection</a>.

Namespace

Code

public function nextId($existing_id = 0) {
    $new_id = $this->query('INSERT INTO {sequences} () VALUES ()', [], [
        'return' => Database::RETURN_INSERT_ID,
    ]);
    // This should only happen after an import or similar event.
    if ($existing_id >= $new_id) {
        // If we INSERT a value manually into the sequences table, on the next
        // INSERT, MySQL will generate a larger value. However, there is no way
        // of knowing whether this value already exists in the table. MySQL
        // provides an INSERT IGNORE which would work, but that can mask problems
        // other than duplicate keys. Instead, we use INSERT ... ON DUPLICATE KEY
        // UPDATE in such a way that the UPDATE does not do anything. This way,
        // duplicate keys do not generate errors but everything else does.
        $this->query('INSERT INTO {sequences} (value) VALUES (:value) ON DUPLICATE KEY UPDATE value = value', [
            ':value' => $existing_id,
        ]);
        $new_id = $this->query('INSERT INTO {sequences} () VALUES ()', [], [
            'return' => Database::RETURN_INSERT_ID,
        ]);
    }
    $this->needsCleanup = TRUE;
    return $new_id;
}