You are here

public function Connection::nextId in Drupal 10

Same name in this branch
  1. 10 core/tests/fixtures/database_drivers/custom/fake/Connection.php \Drupal\Driver\Database\fake\Connection::nextId()
  2. 10 core/modules/sqlite/src/Driver/Database/sqlite/Connection.php \Drupal\sqlite\Driver\Database\sqlite\Connection::nextId()
  3. 10 core/modules/pgsql/src/Driver/Database/pgsql/Connection.php \Drupal\pgsql\Driver\Database\pgsql\Connection::nextId()
  4. 10 core/modules/mysql/src/Driver/Database/mysql/Connection.php \Drupal\mysql\Driver\Database\mysql\Connection::nextId()

File

core/modules/mysql/src/Driver/Database/mysql/Connection.php, line 310

Class

Connection
MySQL implementation of \Drupal\Core\Database\Connection.

Namespace

Drupal\mysql\Driver\Database\mysql

Code

public function nextId($existing_id = 0) {
  $this
    ->query('INSERT INTO {sequences} () VALUES ()');
  $new_id = $this
    ->lastInsertId();

  // 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,
    ]);
    $this
      ->query('INSERT INTO {sequences} () VALUES ()');
    $new_id = $this
      ->lastInsertId();
  }
  $this->needsCleanup = TRUE;
  return $new_id;
}