TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest Class Reference

Inheritance diagram for TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest:

Public Member Functions
	inSetReturnsExpectedDataSetsWithColumn ()
	inSetReturnsExpectedDataSets ()
	inSetReturnsExpectedDataSetsWithInts ()
	inSetReturnsExpectedDataSetsIfValueContainsLikeWildcard ()
	inSetReturnsExpectedDataSetsIfValueContainsBracket ()
	inSetReturnsExpectedDataSetsIfValueContainsClosingBracket ()
	inSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket ()
	inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord ()
	inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard ()
	notInSetReturnsExpectedDataSetsWithColumn ()
	notInSetReturnsExpectedDataSets ()
	notInSetReturnsExpectedDataSetsWithInts ()
	notInSetReturnsExpectedDataSetsIfValueContainsLikeWildcard ()
	notInSetReturnsExpectedDataSetsIfValueContainsBracket ()
	notInSetReturnsExpectedDataSetsIfValueContainsClosingBracket ()
	notInSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket ()
	notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord ()
	notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard ()
	likeReturnsExpectedDataSetsDataProvider ()
	likeReturnsExpectedDataSets (string $searchWord, array $expectedRows, array $excludePlatforms)
	notLikeReturnsExpectedDataSetsDataProvider ()
	likeWithWildcardValueCanBeMatched (string $searchWord, array $expectedRows, array $excludePlatforms)
	notLikeWithWildcardValueCanBeMatched (string $searchWord, array $expectedRows, array $excludePlatforms)
	notLikeReturnsExpectedDataSets (string $searchWord, array $expectedRows, array $excludePlatforms)

Static Public Member Functions
static	likeWithWildcardValueCanBeMatchedDataProvider ()
static	notLikeWithWildcardValueCanBeMatchedDataProvider ()

Protected Member Functions
	ensureRowsUidAsInteger (array $rows)

Protected Attributes
	$testExtensionsToLoad

Detailed Description

Definition at line 24 of file ExpressionBuilderTest.php.

Member Function Documentation

ensureRowsUidAsInteger()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::ensureRowsUidAsInteger ( array  $rows )

protected

Definition at line 987 of file ExpressionBuilderTest.php.

Referenced by TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\likeReturnsExpectedDataSets(), TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\likeWithWildcardValueCanBeMatched(), TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\notLikeReturnsExpectedDataSets(), and TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\notLikeWithWildcardValueCanBeMatched().

inSetReturnsExpectedDataSets()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSets

(

)

Test:

Definition at line 104 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsIfValueContainsBracket()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsIfValueContainsBracket

(

)

Test:

Definition at line 215 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard

(

)

Test:

Definition at line 363 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord

(

)

Test:

Definition at line 326 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsIfValueContainsClosingBracket()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsIfValueContainsClosingBracket

(

)

Test:

Definition at line 252 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsIfValueContainsLikeWildcard()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsIfValueContainsLikeWildcard

(

)

Test:

Definition at line 178 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket

(

)

Test:

Definition at line 289 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsWithColumn()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsWithColumn

(

)

Test:

Definition at line 33 of file ExpressionBuilderTest.php.

inSetReturnsExpectedDataSetsWithInts()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::inSetReturnsExpectedDataSetsWithInts

(

)

Test:

Definition at line 141 of file ExpressionBuilderTest.php.

likeReturnsExpectedDataSets()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::likeReturnsExpectedDataSets	(	string	$searchWord,
		array	$expectedRows,
		array	$excludePlatforms
	)

Test:

‪@dataProvider likeReturnsExpectedDataSetsDataProvider Note: SQLite does not properly work with non-ascii letters as search word for case-insensitive matching, UPPER() and LOWER() have the same issue, it only works with ascii letters. See: https://www.sqlite.org/src/doc/trunk/ext/icu/README.txt

Definition at line 751 of file ExpressionBuilderTest.php.

References TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\ensureRowsUidAsInteger().

likeReturnsExpectedDataSetsDataProvider()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::likeReturnsExpectedDataSetsDataProvider

(

)

Definition at line 673 of file ExpressionBuilderTest.php.

likeWithWildcardValueCanBeMatched()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::likeWithWildcardValueCanBeMatched	(	string	$searchWord,
		array	$expectedRows,
		array	$excludePlatforms
	)

Test:

‪@dataProvider likeWithWildcardValueCanBeMatchedDataProvider

Definition at line 853 of file ExpressionBuilderTest.php.

References TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\ensureRowsUidAsInteger().

likeWithWildcardValueCanBeMatchedDataProvider()

static TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::likeWithWildcardValueCanBeMatchedDataProvider ( )

static

Definition at line 822 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSets()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSets

(

)

Test:

Definition at line 538 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsIfValueContainsBracket()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsIfValueContainsBracket

(

)

Test:

Definition at line 596 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard

(

)

Test:

Definition at line 660 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord

(

)

Test:

Definition at line 644 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsIfValueContainsClosingBracket()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsIfValueContainsClosingBracket

(

)

Test:

Definition at line 612 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsIfValueContainsLikeWildcard()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsIfValueContainsLikeWildcard

(

)

Test:

Definition at line 580 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket

(

)

Test:

Definition at line 628 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsWithColumn()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsWithColumn

(

)

notInSet tests, as they reverse the tests from above, only the count() logic is used to avoid too many result arrays to be defined.

Test:

Definition at line 405 of file ExpressionBuilderTest.php.

notInSetReturnsExpectedDataSetsWithInts()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notInSetReturnsExpectedDataSetsWithInts

(

)

Test:

Definition at line 564 of file ExpressionBuilderTest.php.

notLikeReturnsExpectedDataSets()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notLikeReturnsExpectedDataSets	(	string	$searchWord,
		array	$expectedRows,
		array	$excludePlatforms
	)

Test:

‪@dataProvider notLikeReturnsExpectedDataSetsDataProvider Note: SQLite does not properly work with non-ascii letters as search word for case-insensitive matching, UPPER() and LOWER() have the same issue, it only works with ascii letters. See: https://www.sqlite.org/src/doc/trunk/ext/icu/README.txt

Definition at line 957 of file ExpressionBuilderTest.php.

References TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\ensureRowsUidAsInteger().

notLikeReturnsExpectedDataSetsDataProvider()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notLikeReturnsExpectedDataSetsDataProvider

(

)

Definition at line 780 of file ExpressionBuilderTest.php.

notLikeWithWildcardValueCanBeMatched()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notLikeWithWildcardValueCanBeMatched	(	string	$searchWord,
		array	$expectedRows,
		array	$excludePlatforms
	)

Test:

‪@dataProvider notLikeWithWildcardValueCanBeMatchedDataProvider

Definition at line 921 of file ExpressionBuilderTest.php.

References TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest\ensureRowsUidAsInteger().

notLikeWithWildcardValueCanBeMatchedDataProvider()

static TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::notLikeWithWildcardValueCanBeMatchedDataProvider ( )

static

Definition at line 882 of file ExpressionBuilderTest.php.

Member Data Documentation

$testExtensionsToLoad

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::$testExtensionsToLoad

protected

Initial value:

= array( 
        'typo3/sysext/core/Tests/Functional/Database/Fixtures/Extensions/test_expressionbuilder',
     )

Definition at line 26 of file ExpressionBuilderTest.php.