/** * Build the count of filtered query * * @return QueryBuilder */ public function getFilteredCountQuery() { $this->buildFilteredQuery(); $this->currentQueryBuilder->select('COUNT(DISTINCT ' . $this->getDistinct() . ')'); $this->currentQueryBuilder->resetQueryPart('orderBy'); return $this->currentQueryBuilder; }
/** * @test */ public function resetQueryPartDelegatesToConcreteQueryBuilder() { $this->concreteQueryBuilder->resetQueryPart('select')->shouldBeCalled()->willReturn($this->subject); $this->subject->resetQueryPart('select'); }
public function testResetQueryPart() { $qb = new QueryBuilder($this->conn); $qb->select('u.*')->from('users', 'u')->where('u.name = ?'); $this->assertEquals('SELECT u.* FROM users u WHERE u.name = ?', (string) $qb); $qb->resetQueryPart('where'); $this->assertEquals('SELECT u.* FROM users u', (string) $qb); }
/** * Resets a single SQL part. * * @param string $queryPartName * * @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance. */ public function resetQueryPart($queryPartName) { $this->queryBuilder->resetQueryPart($queryPartName); return $this; }
/** * Resets a single SQL part. * * @param string $queryPartName * * @return QueryBuilder This QueryBuilder instance. */ public function resetQueryPart($queryPartName) : QueryBuilder { $this->concreteQueryBuilder->resetQueryPart($queryPartName); return $this; }