/** * {@inheritdoc} */ public function count() { $this->criteriaBuilder->setLimit(null); $this->criteriaBuilder->setOffset(null); $sqlPart = $this->criteriaBuilder->toSqlPart(); $countSql = 'SELECT COUNT(*) cnt FROM (' . $sqlPart->getSql() . ') AS v'; $st = $this->queryContainer->getConnection()->prepare($countSql); $st->execute($sqlPart->getParameters()); return $st->fetchColumn(); }
/** * @return void */ protected function ensureCollectorColumnsAreSelected() { $sql = sprintf($this->criteriaBuilder->getSqlTemplate(), CollectorConfig::COLLECTOR_TOUCH_ID, CollectorConfig::COLLECTOR_RESOURCE_ID, CollectorConfig::COLLECTOR_STORAGE_KEY, CollectorConfig::COLLECTOR_SEARCH_KEY); $this->criteriaBuilder->sql($sql); }