‪TYPO3CMS  ‪main
QueryParserTest.php
Go to the documentation of this file.
1 <?php
2 
3 declare(strict_types=1);
4 
5 /*
6  * This file is part of the TYPO3 CMS project.
7  *
8  * It is free software; you can redistribute it and/or modify it under
9  * the terms of the GNU General Public License, either version 2
10  * of the License, or any later version.
11  *
12  * For the full copyright and license information, please read the
13  * LICENSE.txt file that was distributed with this source code.
14  *
15  * The TYPO3 project - inspiring people to share!
16  */
17 
19 
20 use PHPUnit\Framework\Attributes\Test;
23 use TYPO3\TestingFramework\Core\Functional\FunctionalTestCase;
30 
31 final class ‪QueryParserTest extends FunctionalTestCase
32 {
33  protected array ‪$testExtensionsToLoad = [
34  'typo3/sysext/extbase/Tests/Functional/Fixtures/Extensions/blog_example',
35  ];
36 
37  protected function ‪setUp(): void
38  {
39  parent::setUp();
40  $this->importCSVDataSet(__DIR__ . '/Fixtures/QueryParserTestImport.csv');
41  $request = (new ‪ServerRequest())->withAttribute('applicationType', ‪SystemEnvironmentBuilder::REQUESTTYPE_BE);
42  ‪$GLOBALS['TYPO3_REQUEST'] = $request;
43  }
44 
45  #[Test]
47  {
48  $query = $this->get(PostRepository::class)->createQuery();
49  $query->matching(
50  $query->logicalAnd(
51  $query->equals('blog', 3),
52  $query->logicalOr(
53  $query->equals('tags.name', 'Tag12'),
54  $query->equals('author.tags.name', 'TagForAuthor1')
55  )
56  )
57  );
58  self::assertCount(3, $query->execute()->toArray());
59  }
60 
64  #[Test]
66  {
67  $query = $this->get(PostRepository::class)->createQuery();
68  $query->matching(
69  $query->equals('tags.name', 'Tag12')
70  );
71  self::assertCount(2, $query->execute()->toArray());
72  }
73 
77  #[Test]
79  {
80  $query = $this->get(AdministratorRepository::class)->createQuery();
81  $query->matching(
82  $query->equals('usergroup.title', 'Group A')
83  );
84  self::assertCount(2, $query->execute()->toArray());
85  }
86 
90  #[Test]
92  {
93  $query = $this->get(PostRepository::class)->createQuery();
94  $query->matching(
95  $query->equals('author.firstname', 'Author')
96  );
97  // there are 16 post in total, 2 without author, 1 hidden, 1 deleted => 12 posts
98  self::assertCount(12, $query->execute()->toArray());
99  }
100 
101  #[Test]
102  public function ‪orReturnsExpectedResult(): void
103  {
104  $query = $this->get(PostRepository::class)->createQuery();
105  $query->matching(
106  $query->logicalOr(
107  $query->equals('tags.name', 'Tag12'),
108  $query->equals('tags.name', 'Tag11')
109  )
110  );
111  self::assertCount(2, $query->execute()->toArray());
112  }
113 
114  #[Test]
116  {
117  $query = $this->get(PostRepository::class)->createQuery();
118  $query->matching(
119  $query->logicalAnd(
120  $query->equals('blog', 3),
121  $query->equals('tags.name', 'Tag12'),
122  $query->equals('author.tags.name', 'TagForAuthor1')
123  )
124  );
125  self::assertCount(1, $query->execute()->toArray());
126  }
127 
128  #[Test]
130  {
131  $query = $this->get(AdministratorRepository::class)->createQuery();
132  self::assertCount(2, $query->matching($query->contains('usergroup', 1))->execute());
133  }
134 
135  #[Test]
137  {
138  $query = $this->get(PostRepository::class)->createQuery();
139  $post = $query->matching($query->equals('uid', 1))->execute()->current();
140  self::assertCount(3, $post->getCategories());
141  }
142 
143  #[Test]
145  {
146  $query = $this->get(BlogRepository::class)->createQuery();
148  $blog = $query->matching($query->logicalOr(
149  $query->like('description', '%w/o%'),
150  $query->like('posts.title', '%w/o%'),
151  ))->execute()->current();
152  self::assertSame(7, $blog->getUid());
153  }
154 
155  #[Test]
156  public function ‪queryForPersonSalutationEnum(): void
157  {
158  $query = $this->get(PersonRepository::class)->createQuery();
159  $person = $query->matching($query->equals('salutation', Salutation::MR))->execute()->getFirst();
160  self::assertSame(4, $person->getUid());
161  }
162 }
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryWithRelationHasManyWithoutParentKeyFieldNameReturnsExpectedResult
‪queryWithRelationHasManyWithoutParentKeyFieldNameReturnsExpectedResult()
Definition: QueryParserTest.php:78
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryWithMultipleRelationsToIdenticalTablesReturnsExpectedResultForOrQuery
‪queryWithMultipleRelationsToIdenticalTablesReturnsExpectedResultForOrQuery()
Definition: QueryParserTest.php:46
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryForPersonSalutationEnum
‪queryForPersonSalutationEnum()
Definition: QueryParserTest.php:156
‪TYPO3Tests\BlogExample\Domain\Repository\PersonRepository
Definition: PersonRepository.php:29
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryWithMultipleRelationsToIdenticalTablesReturnsExpectedResultForAndQuery
‪queryWithMultipleRelationsToIdenticalTablesReturnsExpectedResultForAndQuery()
Definition: QueryParserTest.php:115
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryWithFindInSetReturnsExpectedResult
‪queryWithFindInSetReturnsExpectedResult()
Definition: QueryParserTest.php:129
‪TYPO3\CMS\Core\Core\SystemEnvironmentBuilder
Definition: SystemEnvironmentBuilder.php:41
‪TYPO3Tests\BlogExample\Domain\Model\Enum\Salutation
‪Salutation
Definition: Salutation.php:21
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\orReturnsExpectedResult
‪orReturnsExpectedResult()
Definition: QueryParserTest.php:102
‪TYPO3\CMS\Core\Core\SystemEnvironmentBuilder\REQUESTTYPE_BE
‪const REQUESTTYPE_BE
Definition: SystemEnvironmentBuilder.php:45
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryForBlogsAndPostsWithNoPostsShowsBlogRecord
‪queryForBlogsAndPostsWithNoPostsShowsBlogRecord()
Definition: QueryParserTest.php:144
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryForPostWithCategoriesReturnsPostWithCategories
‪queryForPostWithCategoriesReturnsPostWithCategories()
Definition: QueryParserTest.php:136
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest
Definition: QueryParserTest.php:32
‪TYPO3\CMS\Core\Http\ServerRequest
Definition: ServerRequest.php:39
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence
Definition: AddTest.php:18
‪TYPO3Tests\BlogExample\Domain\Repository\AdministratorRepository
Definition: AdministratorRepository.php:27
‪TYPO3Tests\BlogExample\Domain\Model\Blog
Definition: Blog.php:30
‪$GLOBALS
‪$GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['adminpanel']['modules']
Definition: ext_localconf.php:25
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\$testExtensionsToLoad
‪array $testExtensionsToLoad
Definition: QueryParserTest.php:33
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\setUp
‪setUp()
Definition: QueryParserTest.php:37
‪TYPO3Tests\BlogExample\Domain\Repository\BlogRepository
Definition: BlogRepository.php:29
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryWithRelationHasAndBelongsToManyReturnsExpectedResult
‪queryWithRelationHasAndBelongsToManyReturnsExpectedResult()
Definition: QueryParserTest.php:65
‪TYPO3Tests\BlogExample\Domain\Repository\PostRepository
Definition: PostRepository.php:32
‪TYPO3\CMS\Extbase\Tests\Functional\Persistence\QueryParserTest\queryWithRelationHasOneAndHasAndBelongsToManyWithoutParentKeyFieldNameReturnsExpectedResult
‪queryWithRelationHasOneAndHasAndBelongsToManyWithoutParentKeyFieldNameReturnsExpectedResult()
Definition: QueryParserTest.php:91