function DatabaseUpdateTestCase::testExpressionUpdate

Test updating with expressions.

File

modules/simpletest/tests/database_test.test, line 927

Class

DatabaseUpdateTestCase

Update builder tests.

Code

function testExpressionUpdate() {
  // Set age = 1 for a single row for this test to work.
  db_update('test')->condition('id', 1)
    ->fields(array(
    'age' => 1,
  ))
    ->execute();
  // Ensure that expressions are handled properly. This should set every
  // record's age to a square of itself. The number of affected rows returned
  // by db_update() will vary across different database engines and versions:
  // - MySQL / InnoDB: changed rows only
  // - MySQL / MyISAM: changed rows only
  // - PostgreSQL: all rows matched by the query
  // - SQLite: changed rows only (see workaround in UpdateQuery_sqlite)
  // All database engines will change only three of the four records in the
  // table since 1*1 = 1. However, the pgsql driver will return the number of
  // rows matched rather than the number changed.
  // @see https://www.drupal.org/project/drupal/issues/805858
  // @see https://www.drupal.org/project/drupal/issues/3264471
  $connection = Database::getConnection()->getConnectionOptions();
  $expected_rows = 3;
  if ($connection['driver'] === 'pgsql') {
    $expected_rows++;
  }
  $num_rows = db_update('test')->expression('age', 'age * age')
    ->execute();
  $this->assertIdentical($num_rows, $expected_rows, 'Number of affected rows are returned.');
  $saved_name = db_query('SELECT name FROM {test} WHERE age = :age', array(
    ':age' => pow(26, 2),
  ))->fetchField();
  $this->assertIdentical('Paul', $saved_name, 'Successfully updated values using an algebraic expression.');
}