‪TYPO3CMS  11.5
TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest Class Reference
Inheritance diagram for TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest:

Public Member Functions

 andXReturnType ()
 
 orXReturnType ()
 
 eqQuotesIdentifier ()
 
 neqQuotesIdentifier ()
 
 ltQuotesIdentifier ()
 
 lteQuotesIdentifier ()
 
 gtQuotesIdentifier ()
 
 gteQuotesIdentifier ()
 
 isNullQuotesIdentifier ()
 
 isNotNullQuotesIdentifier ()
 
 likeQuotesIdentifier ()
 
 notLikeQuotesIdentifier ()
 
 inWithStringQuotesIdentifier ()
 
 inWithArrayQuotesIdentifier ()
 
 notInWithStringQuotesIdentifier ()
 
 notInWithArrayQuotesIdentifier ()
 
 inSetThrowsExceptionWithEmptyValue ()
 
 inSetThrowsExceptionWithInvalidValue ()
 
 inSetForMySQL ()
 
 inSetForPostgreSQL ()
 
 inSetForPostgreSQLWithColumn ()
 
 inSetForSQLite ()
 
 inSetForSQLiteWithQuoteCharactersInValue ()
 
 inSetForSQLiteThrowsExceptionOnPositionalPlaceholder ()
 
 inSetForSQLiteThrowsExceptionOnNamedPlaceholder ()
 
 inSetForMssql ()
 
 notInSetThrowsExceptionWithEmptyValue ()
 
 notInSetThrowsExceptionWithInvalidValue ()
 
 notInSetForMySQL ()
 
 notInSetForPostgreSQL ()
 
 notInSetForPostgreSQLWithColumn ()
 
 notInSetForSQLite ()
 
 notInSetForSQLiteWithQuoteCharactersInValue ()
 
 notInSetForSQLiteThrowsExceptionOnPositionalPlaceholder ()
 
 notInSetForSQLiteThrowsExceptionOnNamedPlaceholder ()
 
 notInSetForMssql ()
 
 defaultBitwiseAnd ()
 
 bitwiseAndForOracle ()
 
 maxQuotesIdentifier ()
 
 minQuotesIdentifier ()
 
 sumQuotesIdentifier ()
 
 avgQuotesIdentifier ()
 
 countQuotesIdentifier ()
 
 lengthQuotesIdentifier ()
 
 trimQuotesIdentifierWithDefaultValues ()
 
array trimQuotesIdentifierDataProvider ()
 
 trimQuotesIdentifier (int $position, string $char, string $expected)
 
 literalQuotesValue ()
 

Protected Member Functions

 setUp ()
 

Protected Attributes

ObjectProphecy $connectionProphecy
 
ExpressionBuilder $subject
 
string $testTable = 'testTable'
 

Detailed Description

Definition at line 30 of file ExpressionBuilderTest.php.

Member Function Documentation

◆ andXReturnType()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::andXReturnType ( )
Test:

Definition at line 56 of file ExpressionBuilderTest.php.

◆ avgQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::avgQuotesIdentifier ( )
Test:

Definition at line 709 of file ExpressionBuilderTest.php.

References $args.

◆ bitwiseAndForOracle()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::bitwiseAndForOracle ( )
Test:

Definition at line 641 of file ExpressionBuilderTest.php.

References $args.

◆ countQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::countQuotesIdentifier ( )
Test:

Definition at line 726 of file ExpressionBuilderTest.php.

References $args.

◆ defaultBitwiseAnd()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::defaultBitwiseAnd ( )
Test:

Definition at line 625 of file ExpressionBuilderTest.php.

References $args.

◆ eqQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::eqQuotesIdentifier ( )
Test:

Definition at line 78 of file ExpressionBuilderTest.php.

◆ gteQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::gteQuotesIdentifier ( )
Test:

Definition at line 133 of file ExpressionBuilderTest.php.

◆ gtQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::gtQuotesIdentifier ( )
Test:

Definition at line 122 of file ExpressionBuilderTest.php.

◆ inSetForMssql()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForMssql ( )
Test:

Definition at line 400 of file ExpressionBuilderTest.php.

References $args.

◆ inSetForMySQL()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForMySQL ( )
Test:

Definition at line 260 of file ExpressionBuilderTest.php.

References $args.

◆ inSetForPostgreSQL()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForPostgreSQL ( )

◆ inSetForPostgreSQLWithColumn()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForPostgreSQLWithColumn ( )
Test:

Definition at line 301 of file ExpressionBuilderTest.php.

References $args.

◆ inSetForSQLite()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForSQLite ( )
Test:

Definition at line 321 of file ExpressionBuilderTest.php.

References $args.

◆ inSetForSQLiteThrowsExceptionOnNamedPlaceholder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForSQLiteThrowsExceptionOnNamedPlaceholder ( )
Test:

Definition at line 383 of file ExpressionBuilderTest.php.

◆ inSetForSQLiteThrowsExceptionOnPositionalPlaceholder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForSQLiteThrowsExceptionOnPositionalPlaceholder ( )
Test:

Definition at line 366 of file ExpressionBuilderTest.php.

◆ inSetForSQLiteWithQuoteCharactersInValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetForSQLiteWithQuoteCharactersInValue ( )
Test:

Definition at line 343 of file ExpressionBuilderTest.php.

References $args.

◆ inSetThrowsExceptionWithEmptyValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetThrowsExceptionWithEmptyValue ( )
Test:

Definition at line 240 of file ExpressionBuilderTest.php.

◆ inSetThrowsExceptionWithInvalidValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inSetThrowsExceptionWithInvalidValue ( )
Test:

Definition at line 250 of file ExpressionBuilderTest.php.

◆ inWithArrayQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inWithArrayQuotesIdentifier ( )
Test:

Definition at line 207 of file ExpressionBuilderTest.php.

◆ inWithStringQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::inWithStringQuotesIdentifier ( )
Test:

Definition at line 196 of file ExpressionBuilderTest.php.

◆ isNotNullQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::isNotNullQuotesIdentifier ( )
Test:

Definition at line 155 of file ExpressionBuilderTest.php.

◆ isNullQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::isNullQuotesIdentifier ( )
Test:

Definition at line 144 of file ExpressionBuilderTest.php.

◆ lengthQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::lengthQuotesIdentifier ( )
Test:

Definition at line 743 of file ExpressionBuilderTest.php.

References $args.

◆ likeQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::likeQuotesIdentifier ( )
Test:

Definition at line 166 of file ExpressionBuilderTest.php.

References $args.

◆ literalQuotesValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::literalQuotesValue ( )
Test:

Definition at line 847 of file ExpressionBuilderTest.php.

◆ lteQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::lteQuotesIdentifier ( )
Test:

Definition at line 111 of file ExpressionBuilderTest.php.

◆ ltQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::ltQuotesIdentifier ( )
Test:

Definition at line 100 of file ExpressionBuilderTest.php.

◆ maxQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::maxQuotesIdentifier ( )
Test:

Definition at line 658 of file ExpressionBuilderTest.php.

References $args.

◆ minQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::minQuotesIdentifier ( )
Test:

Definition at line 675 of file ExpressionBuilderTest.php.

References $args.

◆ neqQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::neqQuotesIdentifier ( )
Test:

Definition at line 89 of file ExpressionBuilderTest.php.

◆ notInSetForMssql()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForMssql ( )
Test:

Definition at line 592 of file ExpressionBuilderTest.php.

References $args.

◆ notInSetForMySQL()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForMySQL ( )
Test:

Definition at line 452 of file ExpressionBuilderTest.php.

References $args.

◆ notInSetForPostgreSQL()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForPostgreSQL ( )

◆ notInSetForPostgreSQLWithColumn()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForPostgreSQLWithColumn ( )
Test:

Definition at line 493 of file ExpressionBuilderTest.php.

References $args.

◆ notInSetForSQLite()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForSQLite ( )
Test:

Definition at line 513 of file ExpressionBuilderTest.php.

References $args.

◆ notInSetForSQLiteThrowsExceptionOnNamedPlaceholder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForSQLiteThrowsExceptionOnNamedPlaceholder ( )
Test:

Definition at line 575 of file ExpressionBuilderTest.php.

◆ notInSetForSQLiteThrowsExceptionOnPositionalPlaceholder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForSQLiteThrowsExceptionOnPositionalPlaceholder ( )
Test:

Definition at line 558 of file ExpressionBuilderTest.php.

◆ notInSetForSQLiteWithQuoteCharactersInValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetForSQLiteWithQuoteCharactersInValue ( )
Test:

Definition at line 535 of file ExpressionBuilderTest.php.

References $args.

◆ notInSetThrowsExceptionWithEmptyValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetThrowsExceptionWithEmptyValue ( )
Test:

Definition at line 432 of file ExpressionBuilderTest.php.

◆ notInSetThrowsExceptionWithInvalidValue()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInSetThrowsExceptionWithInvalidValue ( )
Test:

Definition at line 442 of file ExpressionBuilderTest.php.

◆ notInWithArrayQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInWithArrayQuotesIdentifier ( )
Test:

Definition at line 229 of file ExpressionBuilderTest.php.

◆ notInWithStringQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notInWithStringQuotesIdentifier ( )
Test:

Definition at line 218 of file ExpressionBuilderTest.php.

◆ notLikeQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::notLikeQuotesIdentifier ( )
Test:

Definition at line 181 of file ExpressionBuilderTest.php.

References $args.

◆ orXReturnType()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::orXReturnType ( )
Test:

Definition at line 67 of file ExpressionBuilderTest.php.

◆ setUp()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::setUp ( )
protected

Create a new database connection mock object for every test.

Definition at line 43 of file ExpressionBuilderTest.php.

◆ sumQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::sumQuotesIdentifier ( )
Test:

Definition at line 692 of file ExpressionBuilderTest.php.

References $args.

◆ trimQuotesIdentifier()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::trimQuotesIdentifier ( int  $position,
string  $char,
string  $expected 
)
Parameters
int$position
string$char
string$expected
Test:
‪@dataProvider trimQuotesIdentifierDataProvider

Definition at line 817 of file ExpressionBuilderTest.php.

References $args.

◆ trimQuotesIdentifierDataProvider()

array TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::trimQuotesIdentifierDataProvider ( )
Returns
‪array

Definition at line 783 of file ExpressionBuilderTest.php.

◆ trimQuotesIdentifierWithDefaultValues()

TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::trimQuotesIdentifierWithDefaultValues ( )
Test:

Definition at line 760 of file ExpressionBuilderTest.php.

References $args.

Member Data Documentation

◆ $connectionProphecy

ObjectProphecy TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::$connectionProphecy
protected

Definition at line 34 of file ExpressionBuilderTest.php.

◆ $subject

ExpressionBuilder TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::$subject
protected

Definition at line 36 of file ExpressionBuilderTest.php.

◆ $testTable

string TYPO3\CMS\Core\Tests\Unit\Database\Query\Expression\ExpressionBuilderTest::$testTable = 'testTable'
protected

Definition at line 38 of file ExpressionBuilderTest.php.