public function testNotBetweenQuery()
{
$this->connection->expects($this->once())->method('createQueryBuilder')->willReturn(new QueryBuilder($this->connection));
$qb = $this->queryHelper->buildSelectQuery('test_table', 'main.*', ['column NOT BETWEEN' => [5, 10]]);
$where = (string) $qb->getQueryPart('where');
$this->assertEquals('`column` NOT BETWEEN :columnGreaterThan AND :columnLessThan', $where);
$this->assertEquals(5, $qb->getParameter(':columnGreaterThan'));
$this->assertEquals(10, $qb->getParameter(':columnLessThan'));
}
public function findOneBy(array $criteria)
{
$qb = $this->queryHelper->buildSelectQuery($this->getTableName(), 'main.*', $criteria);
$qb->setMaxResults(1);
return $this->fetchOne($qb);
}
