public function testGetMaxResults()
{
$query = new Query();
$query->setMaxResults(10);
$this->assertEquals(10, $query->getMaxResults());
}
/**
* {@inheritdoc}
*/
public function getMaxResults()
{
return $this->query->getMaxResults();
}
/**
* @param Query $query
* @return string
* @SuppressWarnings(PHPMD.NPathComplexity)
*/
protected function combineQueryString(Query $query)
{
$selectString = $query->getQuery();
$fromString = '';
if ($query->getFrom()) {
$fromString .= ' from ' . implode(', ', $query->getFrom());
}
$whereParts = array();
foreach ($query->getOptions() as $whereOptions) {
if (is_array($whereOptions['fieldValue'])) {
$whereOptions['fieldValue'] = '(' . implode(', ', $whereOptions['fieldValue']) . ')';
}
$whereParts[] = sprintf('%s((%s)%s %s %s)', $whereOptions['type'], $whereOptions['fieldType'], $whereOptions['fieldName'], $whereOptions['condition'], $whereOptions['fieldValue']);
}
$whereString = '';
if ($whereParts) {
$whereString .= ' where ' . implode(' ', $whereParts);
}
$orderByString = '';
if ($query->getOrderBy()) {
$orderByString .= ' ' . $query->getOrderBy();
}
if ($query->getOrderDirection()) {
$orderByString .= ' ' . $query->getOrderDirection();
}
if ($orderByString) {
$orderByString = ' order by' . $orderByString;
}
$limitString = '';
if ($query->getMaxResults() && $query->getMaxResults() != Query::INFINITY) {
$limitString = ' limit ' . $query->getMaxResults();
}
$offsetString = '';
if ($query->getFirstResult()) {
$offsetString .= ' offset ' . $query->getFirstResult();
}
return $selectString . $fromString . $whereString . $orderByString . $limitString . $offsetString;
}
/**
* OFFSET keyword
*
* @param Query $query
* @param $inputString
*
* @return string
*/
private function offset(Query $query, $inputString)
{
$offset = $this->getWord($inputString);
$inputString = $this->trimString($inputString, $offset);
$query->setFirstResult($offset);
if (!$query->getMaxResults()) {
$query->setMaxResults(Query::INFINITY);
}
return $inputString;
}
