‪TYPO3CMS  ‪main
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 ()
 
 likeReturnsExpectedDataSets (string $searchWord, array $expectedRows, array $excludePlatforms)
 
 likeWithWildcardValueCanBeMatched (string $searchWord, array $expectedRows, array $excludePlatforms)
 
 notLikeWithWildcardValueCanBeMatched (string $searchWord, array $expectedRows, array $excludePlatforms)
 
 notLikeReturnsExpectedDataSets (string $searchWord, array $expectedRows, array $excludePlatforms)
 
 ensureThatExpectedQuoteCharUsedInUnquoteIsValid ()
 
 concatReturnsExpectedResult (int $pageId, array $expectedRow)
 
 castVarcharReturnsExpectedResult (int $pageId, string $field, array $fields, int $length, string $asIdentifier, int $expectedLength, array $expectedRow)
 
 castIntReturnsExpectedResult ()
 
 repeatReturnsExpectedResult (int|string $numberOfRepeats, string $repeatValue, string $expectedRepeatAsString)
 
 repeatWithValueExpressionReturnsExpectedResult (int|string $numberOfRepeats, string $repeatValue, string $expectedRepeatAsString)
 
 spaceReturnsCorrectNumberOfSpaces (int|string $numberOfSpaces, string $expectedSpacesString)
 
 leftReturnsExpectedResult (int|string $length, string $value, string $expectedValue)
 
 rightReturnsExpectedResult (int|string $length, string $value, string $expectedValue)
 
 leftPadReturnsExpectedResult (string $value, int|string $length, string $paddingValue, string $expectedValue)
 
 leftPadWithValueSubexpressionReturnsExpectedResult (array $value, int|string $length, string $paddingValue, string $expectedValue)
 
 rightPadReturnsExpectedResult (string $value, int|string $length, string $paddingValue, string $expectedValue)
 
 rightPadReturnsWithQuotedAliasExpectedResult (string $value, int|string $length, string $paddingValue, string $expectedValue)
 
 rightPadWithValueSubexpressionReturnsExpectedResult (array $value, int|string $length, string $paddingValue, string $expectedValue)
 
 rightPadWithValueSubexpressionWithQuotedAliasReturnsExpectedResult (array $value, int|string $length, string $paddingValue, string $expectedValue)
 
 leftPadWithEmptyStringPaddingValueThrowsInvalidArgumentException ()
 
 leftPadWithMultiCharacterPaddingValueThrowsInvalidArgumentException ()
 
 rightPadWithEmptyStringPaddingValueThrowsInvalidArgumentException ()
 
 rightPadWithMultiCharacterPaddingValueThrowsInvalidArgumentException ()
 

Static Public Member Functions

static likeReturnsExpectedDataSetsDataProvider ()
 
static notLikeReturnsExpectedDataSetsDataProvider ()
 
static likeWithWildcardValueCanBeMatchedDataProvider ()
 
static notLikeWithWildcardValueCanBeMatchedDataProvider ()
 
static concatReturnsExpectedResultDataProvider ()
 
static castVarcharReturnsExpectedResultDataProvider ()
 
static repeatReturnsExpectedResultDataProvider ()
 
static spaceReturnsCorrectNumberOfSpacesDataProvider ()
 
static leftReturnsExpectedResultDataProvider ()
 
static rightReturnsExpectedResultDataProvider ()
 
static leftPadReturnsExpectedResultDataProvider ()
 
static leftPadWithValueSubexpressionReturnsExpectedResultDataProvider ()
 
static rightPadReturnsExpectedResultDataProvider ()
 
static rightPadWithValueSubexpressionReturnsExpectedResultDataProvider ()
 

Protected Attributes

array $testExtensionsToLoad
 

Detailed Description

Definition at line 27 of file ExpressionBuilderTest.php.

Member Function Documentation

◆ castIntReturnsExpectedResult()

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

◆ castVarcharReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::castVarcharReturnsExpectedResult ( int  $pageId,
string  $field,
array  $fields,
int  $length,
string  $asIdentifier,
int  $expectedLength,
array  $expectedRow 
)

◆ castVarcharReturnsExpectedResultDataProvider()

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

Definition at line 1017 of file ExpressionBuilderTest.php.

◆ concatReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::concatReturnsExpectedResult ( int  $pageId,
array  $expectedRow 
)

◆ concatReturnsExpectedResultDataProvider()

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

Definition at line 942 of file ExpressionBuilderTest.php.

◆ ensureThatExpectedQuoteCharUsedInUnquoteIsValid()

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

◆ inSetReturnsExpectedDataSets()

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

Definition at line 103 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsIfValueContainsBracket()

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

Definition at line 208 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard()

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

Definition at line 348 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord()

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

Definition at line 313 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsIfValueContainsClosingBracket()

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

Definition at line 243 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsIfValueContainsLikeWildcard()

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

Definition at line 173 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket()

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

Definition at line 278 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsWithColumn()

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

Definition at line 34 of file ExpressionBuilderTest.php.

◆ inSetReturnsExpectedDataSetsWithInts()

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

Definition at line 138 of file ExpressionBuilderTest.php.

◆ leftPadReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::leftPadReturnsExpectedResult ( string  $value,
int|string  $length,
string  $paddingValue,
string  $expectedValue 
)

◆ leftPadReturnsExpectedResultDataProvider()

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

Definition at line 1415 of file ExpressionBuilderTest.php.

◆ leftPadWithEmptyStringPaddingValueThrowsInvalidArgumentException()

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

◆ leftPadWithMultiCharacterPaddingValueThrowsInvalidArgumentException()

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

◆ leftPadWithValueSubexpressionReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::leftPadWithValueSubexpressionReturnsExpectedResult ( array  $value,
int|string  $length,
string  $paddingValue,
string  $expectedValue 
)

◆ leftPadWithValueSubexpressionReturnsExpectedResultDataProvider()

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

Definition at line 1456 of file ExpressionBuilderTest.php.

◆ leftReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::leftReturnsExpectedResult ( int|string  $length,
string  $value,
string  $expectedValue 
)

◆ leftReturnsExpectedResultDataProvider()

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

Definition at line 1309 of file ExpressionBuilderTest.php.

◆ likeReturnsExpectedDataSets()

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

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 713 of file ExpressionBuilderTest.php.

◆ likeReturnsExpectedDataSetsDataProvider()

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

Definition at line 635 of file ExpressionBuilderTest.php.

◆ likeWithWildcardValueCanBeMatched()

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

Definition at line 810 of file ExpressionBuilderTest.php.

◆ likeWithWildcardValueCanBeMatchedDataProvider()

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

Definition at line 781 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSets()

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

Definition at line 514 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsIfValueContainsBracket()

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

Definition at line 566 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundLikeWildcard()

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

Definition at line 622 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsIfValueContainsBracketsAroundWord()

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

Definition at line 608 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsIfValueContainsClosingBracket()

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

Definition at line 580 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsIfValueContainsLikeWildcard()

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

Definition at line 552 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsIfValueContainsOpeningAndClosingBracket()

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

Definition at line 594 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsWithColumn()

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

Definition at line 383 of file ExpressionBuilderTest.php.

◆ notInSetReturnsExpectedDataSetsWithInts()

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

Definition at line 538 of file ExpressionBuilderTest.php.

◆ notLikeReturnsExpectedDataSets()

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

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 906 of file ExpressionBuilderTest.php.

◆ notLikeReturnsExpectedDataSetsDataProvider()

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

Definition at line 739 of file ExpressionBuilderTest.php.

◆ notLikeWithWildcardValueCanBeMatched()

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

Definition at line 873 of file ExpressionBuilderTest.php.

◆ notLikeWithWildcardValueCanBeMatchedDataProvider()

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

Definition at line 836 of file ExpressionBuilderTest.php.

◆ repeatReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::repeatReturnsExpectedResult ( int|string  $numberOfRepeats,
string  $repeatValue,
string  $expectedRepeatAsString 
)

◆ repeatReturnsExpectedResultDataProvider()

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

Definition at line 1110 of file ExpressionBuilderTest.php.

◆ repeatWithValueExpressionReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::repeatWithValueExpressionReturnsExpectedResult ( int|string  $numberOfRepeats,
string  $repeatValue,
string  $expectedRepeatAsString 
)

◆ rightPadReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::rightPadReturnsExpectedResult ( string  $value,
int|string  $length,
string  $paddingValue,
string  $expectedValue 
)

◆ rightPadReturnsExpectedResultDataProvider()

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

Definition at line 1498 of file ExpressionBuilderTest.php.

◆ rightPadReturnsWithQuotedAliasExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::rightPadReturnsWithQuotedAliasExpectedResult ( string  $value,
int|string  $length,
string  $paddingValue,
string  $expectedValue 
)

◆ rightPadWithEmptyStringPaddingValueThrowsInvalidArgumentException()

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

◆ rightPadWithMultiCharacterPaddingValueThrowsInvalidArgumentException()

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

◆ rightPadWithValueSubexpressionReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::rightPadWithValueSubexpressionReturnsExpectedResult ( array  $value,
int|string  $length,
string  $paddingValue,
string  $expectedValue 
)

◆ rightPadWithValueSubexpressionReturnsExpectedResultDataProvider()

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

Definition at line 1560 of file ExpressionBuilderTest.php.

◆ rightPadWithValueSubexpressionWithQuotedAliasReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::rightPadWithValueSubexpressionWithQuotedAliasReturnsExpectedResult ( array  $value,
int|string  $length,
string  $paddingValue,
string  $expectedValue 
)

◆ rightReturnsExpectedResult()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::rightReturnsExpectedResult ( int|string  $length,
string  $value,
string  $expectedValue 
)

◆ rightReturnsExpectedResultDataProvider()

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

Definition at line 1362 of file ExpressionBuilderTest.php.

◆ spaceReturnsCorrectNumberOfSpaces()

TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::spaceReturnsCorrectNumberOfSpaces ( int|string  $numberOfSpaces,
string  $expectedSpacesString 
)

◆ spaceReturnsCorrectNumberOfSpacesDataProvider()

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

Definition at line 1274 of file ExpressionBuilderTest.php.

Member Data Documentation

◆ $testExtensionsToLoad

array TYPO3\CMS\Core\Tests\Functional\Database\Query\Expression\ExpressionBuilderTest::$testExtensionsToLoad
protected
Initial value:
= [
'typo3/sysext/core/Tests/Functional/Database/Fixtures/Extensions/test_expressionbuilder',
]

Definition at line 29 of file ExpressionBuilderTest.php.