$qb = $conn->createQueryBuilder()
->select('u')
->from('users', 'u')
->where('u.id = :user_id1 OR u.id = :user_id2')
->setParameters(array(
':user_id1' => 1,
':user_id2' => 2
));
public setParameters ( array $params, array $types = [] ) | ||
$params | array | The query parameters to set. |
$types | array | The query parameters types to set. |
/** * @internal */ private function incorporateDbalQueryBuilder(QueryBuilder $qb, FilterInterface $filter) { $criteria = $this->getFilteringCriteria($filter); // extraindo os rootAliases, pois o DBAL\QueryBuilder não tem $fromPart = $qb->getQueryPart('from'); $rootAliases = array(); foreach ($fromPart as $part) { $rootAliases[] = $part['alias']; } $visitor = new DbalQueryExpressionVisitor($qb->getConnection(), $rootAliases, $this->fieldMap); if ($whereExpression = $criteria->getWhereExpression()) { $qb->andWhere($visitor->dispatch($whereExpression)); $qb->setParameters($visitor->getParameters()); } if ($criteria->getOrderings()) { foreach ($criteria->getOrderings() as $sort => $order) { $qb->addOrderBy($visitor->getFieldName($sort), $order); } } if (($firstResult = $criteria->getFirstResult()) !== null) { $qb->setFirstResult($firstResult); } if (($maxResults = $criteria->getMaxResults()) !== null) { $qb->setMaxResults($maxResults); } }
/** * @test */ public function setParametersDelegatesToConcreteQueryBuilder() { $this->concreteQueryBuilder->setParameters(Argument::exact(['aField' => 'aValue']), Argument::exact([]))->shouldBeCalled()->willReturn($this->subject); $this->subject->setParameters(['aField' => 'aValue']); }
/** * Sets a collection of query parameters for the query being constructed. * * <code> * $qb = $conn->getQueryBuilder() * ->select('u') * ->from('users', 'u') * ->where('u.id = :user_id1 OR u.id = :user_id2') * ->setParameters(array( * ':user_id1' => 1, * ':user_id2' => 2 * )); * </code> * * @param array $params The query parameters to set. * @param array $types The query parameters types to set. * * @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance. */ public function setParameters(array $params, array $types = array()) { $this->queryBuilder->setParameters($params, $types); return $this; }
/** * Sets a collection of query parameters for the query being constructed. * * @param array $params The query parameters to set. * @param array $types The query parameters types to set. * * @return QueryBuilder This QueryBuilder instance. */ public function setParameters(array $params, array $types = []) : QueryBuilder { $this->concreteQueryBuilder->setParameters($params, $types); return $this; }
/** * Sets a collection of query parameters for the query being constructed. * * @param array $params The query parameters to set. * @param array $types The query parameters types to set. * * @return self */ public function setParameters(array $params, array $types = []) { $this->qb->setParameters($params, $types); return $this; }
/** * paramTypes is private, we need to redefine setParameters * to access it * * @param array $params * @param array $types * * @return $this */ public function setParameters(array $params, array $types = array()) { $this->paramTypes = $types; return parent::setParameters($params, $types); }