public function comparisonData()
{
$cb = new CriteriaBuilder();
$qb = new QueryBuilder();
return array(array($cb->eq('field', 'value'), $qb->eq('o.field', ':field'), new Parameter('field', 'value')), array($cb->neq('field', 'value'), $qb->neq('o.field', ':field'), new Parameter('field', 'value')), array($cb->eq('field', null), $qb->isNull('o.field')), array($cb->neq('field', null), $qb->isNotNull('o.field')), array($cb->isNull('field'), $qb->isNull('o.field')), array($cb->gt('field', 'value'), $qb->gt('o.field', ':field'), new Parameter('field', 'value')), array($cb->gte('field', 'value'), $qb->gte('o.field', ':field'), new Parameter('field', 'value')), array($cb->lt('field', 'value'), $qb->lt('o.field', ':field'), new Parameter('field', 'value')), array($cb->lte('field', 'value'), $qb->lte('o.field', ':field'), new Parameter('field', 'value')), array($cb->in('field', array('value')), $qb->in('o.field', ':field'), new Parameter('field', array('value'))), array($cb->notIn('field', array('value')), $qb->notIn('o.field', ':field'), new Parameter('field', array('value'))), array($cb->eq('object.field', 'value'), $qb->eq('o.object.field', ':object_field'), new Parameter('object_field', 'value')));
}
public function testWalkNotInComparison()
{
$closure = $this->visitor->walkComparison($this->builder->notIn("foo", array(1, 2, 3)));
$this->assertFalse($closure(new TestObject(1)));
$this->assertFalse($closure(new TestObject(2)));
$this->assertTrue($closure(new TestObject(0)));
$this->assertTrue($closure(new TestObject(4)));
}
function it_builds_not_in(CollectionsExpressionBuilder $expressionBuilder)
{
$this->notIn('o.foo', ['value']);
$expressionBuilder->notIn('o.foo', ['value'])->shouldHaveBeenCalled();
}
public function testNotIn()
{
$expr = $this->builder->notIn("a", array("b"));
$this->assertInstanceOf('Doctrine\\Common\\Collections\\Expr\\Comparison', $expr);
$this->assertEquals(Comparison::NIN, $expr->getOperator());
}
/**
* {@inheritdoc}
*/
public function notIn($field, array $values)
{
return $this->expressionBuilder->notIn($field, $values);
}
public function provideComparisons()
{
$builder = new ExpressionBuilder();
return array(array($builder->eq('field', 'value'), array('field' => 'value')), array($builder->contains('field', 'value'), array('field' => new \MongoRegex('/value/'))), array($builder->gt('field', 'value'), array('field' => array('$gt' => 'value'))), array($builder->gte('field', 'value'), array('field' => array('$gte' => 'value'))), array($builder->in('field', array(1, 2)), array('field' => array('$in' => array(1, 2)))), array($builder->isNull('field'), array('field' => null)), array($builder->lt('field', 'value'), array('field' => array('$lt' => 'value'))), array($builder->lte('field', 'value'), array('field' => array('$lte' => 'value'))), array($builder->neq('field', 'value'), array('field' => array('$ne' => 'value'))), array($builder->notIn('field', array(1, 2)), array('field' => array('$nin' => array(1, 2)))));
}
