namespace Drupal\KernelTests\Core\Database;
use Drupal\Core\Database\Database;
+use Drupal\Core\Database\Query\Condition;
use Drupal\Core\Database\RowCountException;
use Drupal\user\Entity\User;
$query = db_select('test');
$query->addField('test', 'job');
$query->condition('name', 'Paul');
- $query->condition(db_or()->condition('age', 26)->condition('age', 27));
+ $query->condition((new Condition('OR'))->condition('age', 26)->condition('age', 27));
$job = $query->execute()->fetchField();
$this->assertEqual($job, 'Songwriter', 'Correct data retrieved.');
public function testJoinConditionObject() {
// Same test as testDefaultJoin, but with a Condition object.
$query = db_select('test_task', 't');
- $join_cond = db_and()->where('t.pid = p.id');
+ $join_cond = (new Condition('AND'))->where('t.pid = p.id');
$people_alias = $query->join('test', 'p', $join_cond);
$name_field = $query->addField($people_alias, 'name', 'name');
$query->addField('t', 'task', 'task');
// Test a condition object that creates placeholders.
$t1_name = 'John';
$t2_name = 'George';
- $join_cond = db_and()
+ $join_cond = (new Condition('AND'))
->condition('t1.name', $t1_name)
->condition('t2.name', $t2_name);
$query = db_select('test', 't1');