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'))); }
/** * {@inheritdoc} */ protected function doWalkComparison($fieldName, $operator, $placeholder) { switch ($operator) { case Comparison::IN: return $this->expr->in($fieldName, $placeholder); case Comparison::NIN: return $this->expr->notIn($fieldName, $placeholder); case Comparison::EQ: case Comparison::IS: if ($placeholder === null) { return $this->expr->isNull($fieldName); } return $this->expr->eq($fieldName, $placeholder); case Comparison::NEQ: if ($placeholder === null) { return $this->expr->isNotNull($fieldName); } return $this->expr->neq($fieldName, $placeholder); case Comparison::CONTAINS: return $this->expr->like($fieldName, $placeholder); default: $operator = self::convertComparisonOperator($operator); if ($operator) { return new Expr\Comparison($fieldName, $operator, $placeholder); } throw new \RuntimeException("Unknown comparison operator: " . $operator); } }
function it_does_not_try_to_join_attributes_when_finding_full_products_with_empty_attributes($em, QueryBuilder $queryBuilder, Expr $expr, AbstractQuery $query) { $expr->in('p.id', [42])->shouldBeCalled()->willReturn('product where clause'); $expr->in('a.id', Argument::any())->shouldNotBeCalled(); $queryBuilder->select(Argument::any())->shouldBeCalled()->willReturn($queryBuilder); $queryBuilder->addSelect(Argument::any())->shouldBeCalled()->willReturn($queryBuilder); $queryBuilder->from(Argument::any(), Argument::any())->shouldBeCalled()->willReturn($queryBuilder); $queryBuilder->leftJoin(Argument::any(), Argument::any())->shouldBeCalled()->willReturn($queryBuilder); $queryBuilder->where('product where clause')->shouldBeCalled()->willReturn($queryBuilder); $queryBuilder->andWhere(Argument::any())->shouldNotBeCalled(); $em->createQueryBuilder()->willReturn($queryBuilder); $query->execute()->shouldBeCalled(); $queryBuilder->expr()->willReturn($expr); $queryBuilder->getQuery()->willReturn($query); $this->getFullProducts([42]); }
/** * {@inheritDoc} */ public function walkComparison(Comparison $comparison) { $parameterName = str_replace('.', '_', $comparison->getField()); $parameter = new Parameter($parameterName, $this->walkValue($comparison->getValue())); $placeholder = ':' . $parameterName; switch ($comparison->getOperator()) { case Comparison::IN: $this->parameters[] = $parameter; return $this->expr->in($this->rootAlias . '.' . $comparison->getField(), $placeholder); case Comparison::NIN: $this->parameters[] = $parameter; return $this->expr->notIn($this->rootAlias . '.' . $comparison->getField(), $placeholder); case Comparison::EQ: case Comparison::IS: if ($this->walkValue($comparison->getValue()) === null) { return $this->expr->isNull($this->rootAlias . '.' . $comparison->getField()); } $this->parameters[] = $parameter; return $this->expr->eq($this->rootAlias . '.' . $comparison->getField(), $placeholder); case Comparison::NEQ: if ($this->walkValue($comparison->getValue()) === null) { return $this->expr->isNotNull($this->rootAlias . '.' . $comparison->getField()); } $this->parameters[] = $parameter; return $this->expr->neq($this->rootAlias . '.' . $comparison->getField(), $placeholder); default: $operator = self::convertComparisonOperator($comparison->getOperator()); if ($operator) { $this->parameters[] = $parameter; return new Expr\Comparison($this->rootAlias . '.' . $comparison->getField(), $operator, $placeholder); } throw new \RuntimeException("Unknown comparison operator: " . $comparison->getOperator()); } }
function it_adds_a_in_filter_on_a_field_in_the_query($qb, Expr $expr) { $qb->getRootAlias()->willReturn('f'); $qb->leftJoin('f.family', 'filterfamily')->willReturn($qb); $qb->andWhere('filterfamily.id IN (1, 2)')->willReturn($qb); $expr->in('filterfamily.id', [1, 2])->willReturn('filterfamily.id IN (1, 2)'); $qb->expr()->willReturn($expr); $this->addFieldFilter('family', 'IN', [1, 2]); }
function it_adds_a_in_filter_on_a_field_in_the_query($qb, Expr $expr) { $qb->getRootAlias()->willReturn('f'); $qb->leftJoin('f.groups', Argument::any())->willReturn($qb); $qb->andWhere('filtergroups.id IN (1, 2)')->willReturn($qb); $expr->in(Argument::any(), [1, 2])->willReturn('filtergroups.id IN (1, 2)'); $qb->expr()->willReturn($expr); $this->addFieldFilter('groups', 'IN', [1, 2]); }
/** * {@inheritDoc} */ public function walkComparison(Comparison $comparison) { if (!isset($this->queryAliases[0])) { throw new QueryException('No aliases are set before invoking walkComparison().'); } $field = $this->queryAliases[0] . '.' . $comparison->getField(); foreach ($this->queryAliases as $alias) { if (strpos($comparison->getField() . '.', $alias . '.') === 0) { $field = $comparison->getField(); break; } } $parameterName = str_replace('.', '_', $comparison->getField()); foreach ($this->parameters as $parameter) { if ($parameter->getName() === $parameterName) { $parameterName .= '_' . count($this->parameters); break; } } $parameter = new Parameter($parameterName, $this->walkValue($comparison->getValue())); $placeholder = ':' . $parameterName; switch ($comparison->getOperator()) { case Comparison::IN: $this->parameters[] = $parameter; return $this->expr->in($field, $placeholder); case Comparison::NIN: $this->parameters[] = $parameter; return $this->expr->notIn($field, $placeholder); case Comparison::EQ: case Comparison::IS: if ($this->walkValue($comparison->getValue()) === null) { return $this->expr->isNull($field); } $this->parameters[] = $parameter; return $this->expr->eq($field, $placeholder); case Comparison::NEQ: if ($this->walkValue($comparison->getValue()) === null) { return $this->expr->isNotNull($field); } $this->parameters[] = $parameter; return $this->expr->neq($field, $placeholder); case Comparison::CONTAINS: $parameter->setValue('%' . $parameter->getValue() . '%', $parameter->getType()); $this->parameters[] = $parameter; return $this->expr->like($field, $placeholder); default: $operator = self::convertComparisonOperator($comparison->getOperator()); if ($operator) { $this->parameters[] = $parameter; return new Expr\Comparison($field, $operator, $placeholder); } throw new \RuntimeException("Unknown comparison operator: " . $comparison->getOperator()); } }
/** * {@inheritdoc} */ public function in($x, $y) { return $this->expr->in($x, $y); }
/** * {@inheritdoc} */ public function in($x, $y, $withParam = false) { return $this->expr->in($x, $withParam ? ':' . $y : $y); }
/** * Builds the orm expression. * * @param string $property * @param string $operator * @param string $parameter * @return Expr\Comparison|Expr\Func */ public static function buildExpression($property, $operator, $parameter = null) { self::isValid($operator, true); $expr = new Expr(); switch (intval($operator)) { case self::NOT_EQUAL: return $expr->neq($property, $parameter); case self::LOWER_THAN: return $expr->lt($property, $parameter); case self::LOWER_THAN_OR_EQUAL: return $expr->lte($property, $parameter); case self::GREATER_THAN: return $expr->gt($property, $parameter); case self::GREATER_THAN_OR_EQUAL: return $expr->gte($property, $parameter); case self::IN: return $expr->in($property, $parameter); case self::NOT_IN: return $expr->notIn($property, $parameter); case self::LIKE: return $expr->like($property, $parameter); case self::NOT_LIKE: return $expr->notLike($property, $parameter); case self::START_WITH: return $expr->like($property, $parameter); case self::NOT_START_WITH: return $expr->notLike($property, $parameter); case self::END_WITH: return $expr->like($property, $parameter); case self::NOT_END_WITH: return $expr->notLike($property, $parameter); case self::IS_NULL: return $expr->isNull($property); case self::IS_NOT_NULL: return $expr->isNotNull($property); default: return $expr->eq($property, $parameter); } }
public function testInLiteralExpr() { $this->assertEquals("u.type IN('foo', 'bar')", (string) $this->_expr->in('u.type', array('foo', 'bar'))); }