/**
* @test
*/
public function betweenSetsBoundariesCorrectly()
{
$query = $this->postRepository->createQuery();
$query->setOrderings(array('uid' => QueryInterface::ORDER_ASCENDING));
$query->matching($query->between('uid', 3, 5));
$result = array_map(function ($row) {
return $row['uid'];
}, $query->execute(true));
$this->assertEquals(array(3, 4, 5), $result);
}
/**
* @test
*/
public function inConditionWorksWithLazyObjectStorageOnSecondCall()
{
$blog = $this->blogRepository->findByUid(1);
$this->assertInstanceOf('\\TYPO3\\CMS\\Extbase\\Persistence\\Generic\\LazyObjectStorage', $blog->getPosts());
$inQuery = $this->postRepository->createQuery();
$inQuery->matching($inQuery->in('uid', $blog->getPosts()));
$this->assertSame(10, $inQuery->count());
$newInQuery = $this->postRepository->createQuery();
$newInQuery->matching($newInQuery->in('uid', $blog->getPosts()));
$this->assertSame(10, $newInQuery->count());
}
/**
* @test
*/
public function equalsCorrectlyHandlesCaseSensivity()
{
$query = $this->postRepository->createQuery();
$query->matching($query->equals('title', 'PoSt1', FALSE));
$this->assertSame(2, $query->count());
}
/**
* Test if count works with subproperties in multiple left join.
*
* @test
*/
public function subpropertyInMultipleLeftJoinCountTest()
{
$query = $this->postRepository->createQuery();
$query->matching($query->logicalOr($query->equals('tags.uid', 1), $query->equals('tags.uid', 2)));
$this->assertSame(10, $query->count());
}