‪TYPO3CMS  10.4
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest Class Reference
Inheritance diagram for TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest:

Public Member Functions

 exprReturnsExpressionBuilderForConnection ()
 
 getTypeDelegatesToConcreteQueryBuilder ()
 
 getStateDelegatesToConcreteQueryBuilder ()
 
 getSQLDelegatesToConcreteQueryBuilder ()
 
 setParameterDelegatesToConcreteQueryBuilder ()
 
 setParametersDelegatesToConcreteQueryBuilder ()
 
 getParametersDelegatesToConcreteQueryBuilder ()
 
 getParameterDelegatesToConcreteQueryBuilder ()
 
 getParameterTypesDelegatesToConcreteQueryBuilder ()
 
 getParameterTypeDelegatesToConcreteQueryBuilder ()
 
 setFirstResultDelegatesToConcreteQueryBuilder ()
 
 getFirstResultDelegatesToConcreteQueryBuilder ()
 
 setMaxResultsDelegatesToConcreteQueryBuilder ()
 
 getMaxResultsDelegatesToConcreteQueryBuilder ()
 
 addDelegatesToConcreteQueryBuilder ()
 
 countBuildsExpressionAndCallsSelect ()
 
 selectQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
array quoteIdentifiersForSelectDataProvider ()
 
 quoteIdentifiersForSelect ($identifier, $expectedResult)
 
 quoteIdentifiersForSelectWithInvalidAlias ()
 
 selectDoesNotQuoteStarPlaceholder ()
 
 addSelectQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 addSelectDoesNotQuoteStarPlaceholder ()
 
 selectLiteralDirectlyDelegatesToConcreteQueryBuilder ()
 
 addSelectLiteralDirectlyDelegatesToConcreteQueryBuilder ()
 
 deleteQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 updateQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 insertQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 fromQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 joinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 innerJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 leftJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 rightJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 setQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 setWithoutNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 whereDelegatesToConcreteQueryBuilder ()
 
 andWhereDelegatesToConcreteQueryBuilder ()
 
 orWhereDelegatesToConcreteQueryBuilder ()
 
 groupByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 addGroupByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 setValueQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 setValueWithoutNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 valuesQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 valuesWithoutNamedParametersQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ()
 
 havingDelegatesToConcreteQueryBuilder ()
 
 andHavingDelegatesToConcreteQueryBuilder ()
 
 orHavingDelegatesToConcreteQueryBuilder ()
 
 orderByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 addOrderByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ()
 
 getQueryPartDelegatesToConcreteQueryBuilder ()
 
 getQueryPartsDelegatesToConcreteQueryBuilder ()
 
 resetQueryPartsDelegatesToConcreteQueryBuilder ()
 
 resetQueryPartDelegatesToConcreteQueryBuilder ()
 
 createNamedParameterDelegatesToConcreteQueryBuilder ()
 
 createPositionalParameterDelegatesToConcreteQueryBuilder ()
 
 queryRestrictionsAreAddedForSelectOnExecute ()
 
 queryRestrictionsAreAddedForCountOnExecute ()
 
 queryRestrictionsAreReevaluatedOnSettingsChangeForGetSQL ()
 
 queryRestrictionsAreReevaluatedOnSettingsChangeForExecute ()
 
 getQueriedTablesReturnsSameTableTwiceForInnerJoin ()
 
array unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatformsDataProvider ()
 
 unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatforms (string $platform, string $quoteChar, string $input, string $expected)
 
 cloningQueryBuilderClonesConcreteQueryBuilder ()
 
 changingClonedQueryBuilderDoesNotInfluenceSourceOne ()
 
 settingRestrictionContainerWillAddAdditionalRestrictionsFromConstructor ()
 
 settingRestrictionContainerWillAddAdditionalRestrictionsFromConfiguration ()
 
 settingRestrictionContainerWillNotAddAdditionalRestrictionsFromConfigurationIfNotDisabled ()
 
 resettingToDefaultRestrictionContainerWillAddAdditionalRestrictionsFromConfiguration ()
 
 setWithNamedParameterPassesGivenTypeToCreateNamedParameter ($input, int $type)
 
 createNamedParameterInput ()
 
 castFieldToTextTypeDataProvider ()
 
 castFieldToTextType (AbstractPlatform $platform, string $expectation)
 
 limitRestrictionsToTablesLimitsRestrictionsInTheContainerToTheGivenTables ()
 
 restrictionsCanStillBeRemovedAfterTheyHaveBeenLimitedToTables ()
 
 restrictionsAreAppliedInJoinConditionForLeftJoins ()
 
 restrictionsAreAppliedInJoinConditionForRightJoins ()
 

Protected Member Functions

 setUp ()
 

Protected Attributes

Connection Prophecy Prophecy ObjectProphecy $connection
 
AbstractPlatform $platform
 
QueryBuilder $subject
 
Doctrine DBAL Query QueryBuilder Prophecy Prophecy ObjectProphecy $concreteQueryBuilder
 

Detailed Description

Test case

Definition at line 42 of file QueryBuilderTest.php.

Member Function Documentation

◆ addDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::addDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 252 of file QueryBuilderTest.php.

◆ addGroupByQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::addGroupByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 712 of file QueryBuilderTest.php.

◆ addOrderByQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::addOrderByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 847 of file QueryBuilderTest.php.

◆ addSelectDoesNotQuoteStarPlaceholder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::addSelectDoesNotQuoteStarPlaceholder ( )
Test:

Definition at line 427 of file QueryBuilderTest.php.

◆ addSelectLiteralDirectlyDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::addSelectLiteralDirectlyDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 458 of file QueryBuilderTest.php.

◆ addSelectQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::addSelectQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 409 of file QueryBuilderTest.php.

◆ andHavingDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::andHavingDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 808 of file QueryBuilderTest.php.

◆ andWhereDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::andWhereDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 673 of file QueryBuilderTest.php.

◆ castFieldToTextType()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::castFieldToTextType ( AbstractPlatform  $platform,
string  $expectation 
)
Test:
‪@dataProvider castFieldToTextTypeDataProvider
Parameters
AbstractPlatform$platform
string$expectation

Definition at line 1460 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$concreteQueryBuilder, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$platform, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, and TYPO3\CMS\Core\Database\Query\QueryBuilder\castFieldToTextType().

◆ castFieldToTextTypeDataProvider()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::castFieldToTextTypeDataProvider ( )

Definition at line 1427 of file QueryBuilderTest.php.

◆ changingClonedQueryBuilderDoesNotInfluenceSourceOne()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::changingClonedQueryBuilderDoesNotInfluenceSourceOne ( )
Test:

Definition at line 1249 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$concreteQueryBuilder, $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\add(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\getRestrictions(), TYPO3\CMS\Core\Database\Query\QueryBuilder\getSQL(), TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\removeAll(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ cloningQueryBuilderClonesConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::cloningQueryBuilderClonesConcreteQueryBuilder ( )
Test:

Definition at line 1240 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject.

◆ countBuildsExpressionAndCallsSelect()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::countBuildsExpressionAndCallsSelect ( )
Test:

Definition at line 264 of file QueryBuilderTest.php.

◆ createNamedParameterDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::createNamedParameterDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 910 of file QueryBuilderTest.php.

◆ createNamedParameterInput()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::createNamedParameterInput ( )

Definition at line 1405 of file QueryBuilderTest.php.

◆ createPositionalParameterDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::createPositionalParameterDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 922 of file QueryBuilderTest.php.

◆ deleteQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::deleteQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:
Todo:
‪: Test with alias

Definition at line 473 of file QueryBuilderTest.php.

◆ exprReturnsExpressionBuilderForConnection()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::exprReturnsExpressionBuilderForConnection ( )
Test:

Definition at line 82 of file QueryBuilderTest.php.

◆ fromQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::fromQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:
Todo:
‪: Test with alias

Definition at line 520 of file QueryBuilderTest.php.

◆ getFirstResultDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getFirstResultDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 216 of file QueryBuilderTest.php.

◆ getMaxResultsDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getMaxResultsDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 240 of file QueryBuilderTest.php.

◆ getParameterDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getParameterDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 168 of file QueryBuilderTest.php.

◆ getParametersDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getParametersDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 156 of file QueryBuilderTest.php.

◆ getParameterTypeDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getParameterTypeDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 192 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Database\Connection\PARAM_STR.

◆ getParameterTypesDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getParameterTypesDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 180 of file QueryBuilderTest.php.

◆ getQueriedTablesReturnsSameTableTwiceForInnerJoin()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getQueriedTablesReturnsSameTableTwiceForInnerJoin ( )
Test:

Definition at line 1152 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject.

◆ getQueryPartDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getQueryPartDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 862 of file QueryBuilderTest.php.

◆ getQueryPartsDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getQueryPartsDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 874 of file QueryBuilderTest.php.

◆ getSQLDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getSQLDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 118 of file QueryBuilderTest.php.

◆ getStateDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getStateDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 106 of file QueryBuilderTest.php.

◆ getTypeDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::getTypeDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 94 of file QueryBuilderTest.php.

◆ groupByQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::groupByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 697 of file QueryBuilderTest.php.

◆ havingDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::havingDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 796 of file QueryBuilderTest.php.

◆ innerJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::innerJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 556 of file QueryBuilderTest.php.

◆ insertQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::insertQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 504 of file QueryBuilderTest.php.

◆ joinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::joinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 535 of file QueryBuilderTest.php.

◆ leftJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::leftJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 577 of file QueryBuilderTest.php.

◆ limitRestrictionsToTablesLimitsRestrictionsInTheContainerToTheGivenTables()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::limitRestrictionsToTablesLimitsRestrictionsInTheContainerToTheGivenTables ( )
Test:

Definition at line 1480 of file QueryBuilderTest.php.

References $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\leftJoin(), TYPO3\CMS\Core\Database\Query\QueryBuilder\limitRestrictionsToTables(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ orderByQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::orderByQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 832 of file QueryBuilderTest.php.

◆ orHavingDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::orHavingDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 820 of file QueryBuilderTest.php.

◆ orWhereDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::orWhereDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 685 of file QueryBuilderTest.php.

◆ queryRestrictionsAreAddedForCountOnExecute()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::queryRestrictionsAreAddedForCountOnExecute ( )
Test:

Definition at line 986 of file QueryBuilderTest.php.

References $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\count(), TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ queryRestrictionsAreAddedForSelectOnExecute()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::queryRestrictionsAreAddedForSelectOnExecute ( )
Test:

Definition at line 934 of file QueryBuilderTest.php.

References $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ queryRestrictionsAreReevaluatedOnSettingsChangeForExecute()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::queryRestrictionsAreReevaluatedOnSettingsChangeForExecute ( )
Test:

Definition at line 1086 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$concreteQueryBuilder, $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\add(), TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\getRestrictions(), TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\removeAll(), TYPO3\CMS\Core\Database\Query\QueryBuilder\resetRestrictions(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ queryRestrictionsAreReevaluatedOnSettingsChangeForGetSQL()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::queryRestrictionsAreReevaluatedOnSettingsChangeForGetSQL ( )
Test:

Definition at line 1039 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$concreteQueryBuilder, $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\add(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\getRestrictions(), TYPO3\CMS\Core\Database\Query\QueryBuilder\getSQL(), TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\removeAll(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ quoteIdentifiersForSelect()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::quoteIdentifiersForSelect (   $identifier,
  $expectedResult 
)
Test:
‪@dataProvider quoteIdentifiersForSelectDataProvider
Parameters
string$identifier
string$expectedResult

Definition at line 358 of file QueryBuilderTest.php.

References $args, and TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$platform.

◆ quoteIdentifiersForSelectDataProvider()

array TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::quoteIdentifiersForSelectDataProvider ( )
Returns
‪array

Definition at line 294 of file QueryBuilderTest.php.

◆ quoteIdentifiersForSelectWithInvalidAlias()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::quoteIdentifiersForSelectWithInvalidAlias ( )
Test:

Definition at line 374 of file QueryBuilderTest.php.

References $args, and TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$platform.

◆ resetQueryPartDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::resetQueryPartDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 898 of file QueryBuilderTest.php.

◆ resetQueryPartsDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::resetQueryPartsDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 886 of file QueryBuilderTest.php.

◆ resettingToDefaultRestrictionContainerWillAddAdditionalRestrictionsFromConfiguration()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::resettingToDefaultRestrictionContainerWillAddAdditionalRestrictionsFromConfiguration ( )
Test:

Definition at line 1369 of file QueryBuilderTest.php.

◆ restrictionsAreAppliedInJoinConditionForLeftJoins()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::restrictionsAreAppliedInJoinConditionForLeftJoins ( )
Test:

Definition at line 1596 of file QueryBuilderTest.php.

References $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\leftJoin(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ restrictionsAreAppliedInJoinConditionForRightJoins()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::restrictionsAreAppliedInJoinConditionForRightJoins ( )
Test:

Definition at line 1652 of file QueryBuilderTest.php.

References $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\rightJoin(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ restrictionsCanStillBeRemovedAfterTheyHaveBeenLimitedToTables()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::restrictionsCanStillBeRemovedAfterTheyHaveBeenLimitedToTables ( )
Test:

Definition at line 1538 of file QueryBuilderTest.php.

References $GLOBALS, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\getRestrictions(), TYPO3\CMS\Core\Database\Query\QueryBuilder\leftJoin(), TYPO3\CMS\Core\Database\Query\QueryBuilder\limitRestrictionsToTables(), TYPO3\CMS\Core\Database\Query\Restriction\QueryRestrictionContainerInterface\removeByType(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

◆ rightJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::rightJoinQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 601 of file QueryBuilderTest.php.

◆ selectDoesNotQuoteStarPlaceholder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::selectDoesNotQuoteStarPlaceholder ( )
Test:

Definition at line 392 of file QueryBuilderTest.php.

◆ selectLiteralDirectlyDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::selectLiteralDirectlyDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 444 of file QueryBuilderTest.php.

◆ selectQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::selectQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 276 of file QueryBuilderTest.php.

◆ setFirstResultDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setFirstResultDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 204 of file QueryBuilderTest.php.

◆ setMaxResultsDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setMaxResultsDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 228 of file QueryBuilderTest.php.

◆ setParameterDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setParameterDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 132 of file QueryBuilderTest.php.

◆ setParametersDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setParametersDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 144 of file QueryBuilderTest.php.

◆ setQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 627 of file QueryBuilderTest.php.

◆ settingRestrictionContainerWillAddAdditionalRestrictionsFromConfiguration()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::settingRestrictionContainerWillAddAdditionalRestrictionsFromConfiguration ( )
Test:

Definition at line 1331 of file QueryBuilderTest.php.

References $GLOBALS.

◆ settingRestrictionContainerWillAddAdditionalRestrictionsFromConstructor()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::settingRestrictionContainerWillAddAdditionalRestrictionsFromConstructor ( )
Test:

Definition at line 1310 of file QueryBuilderTest.php.

◆ settingRestrictionContainerWillNotAddAdditionalRestrictionsFromConfigurationIfNotDisabled()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::settingRestrictionContainerWillNotAddAdditionalRestrictionsFromConfigurationIfNotDisabled ( )
Test:

Definition at line 1350 of file QueryBuilderTest.php.

References $GLOBALS.

◆ setUp()

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

Create a new database connection mock object for every test.

Definition at line 63 of file QueryBuilderTest.php.

◆ setValueQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setValueQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 727 of file QueryBuilderTest.php.

◆ setValueWithoutNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setValueWithoutNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 745 of file QueryBuilderTest.php.

◆ setWithNamedParameterPassesGivenTypeToCreateNamedParameter()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setWithNamedParameterPassesGivenTypeToCreateNamedParameter (   $input,
int  $type 
)
Test:
‪@dataProvider createNamedParameterInput
Parameters
mixed$input
int$type

Definition at line 1394 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$concreteQueryBuilder, TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject, TYPO3\CMS\Core\Database\Query\QueryBuilder\getParameterType(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\set().

◆ setWithoutNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::setWithoutNamedParameterQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 645 of file QueryBuilderTest.php.

◆ unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatforms()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatforms ( string  $platform,
string  $quoteChar,
string  $input,
string  $expected 
)
Test:
‪@dataProvider unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatformsDataProvider
Parameters
string$platform
string$quoteChar
string$input
string$expected

Definition at line 1226 of file QueryBuilderTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$platform, and TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\$subject.

◆ unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatformsDataProvider()

array TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatformsDataProvider ( )
Returns
‪array

Definition at line 1188 of file QueryBuilderTest.php.

◆ updateQuotesIdentifierAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::updateQuotesIdentifierAndDelegatesToConcreteQueryBuilder ( )
Test:
Todo:
‪: Test with alias

Definition at line 489 of file QueryBuilderTest.php.

◆ valuesQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::valuesQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 760 of file QueryBuilderTest.php.

◆ valuesWithoutNamedParametersQuotesIdentifiersAndDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::valuesWithoutNamedParametersQuotesIdentifiersAndDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 781 of file QueryBuilderTest.php.

◆ whereDelegatesToConcreteQueryBuilder()

TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::whereDelegatesToConcreteQueryBuilder ( )
Test:

Definition at line 661 of file QueryBuilderTest.php.

Member Data Documentation

◆ $concreteQueryBuilder

Doctrine DBAL Query QueryBuilder Prophecy Prophecy ObjectProphecy TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::$concreteQueryBuilder
protected

Definition at line 58 of file QueryBuilderTest.php.

Referenced by TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\castFieldToTextType(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\changingClonedQueryBuilderDoesNotInfluenceSourceOne(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\queryRestrictionsAreReevaluatedOnSettingsChangeForExecute(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\queryRestrictionsAreReevaluatedOnSettingsChangeForGetSQL(), and TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\setWithNamedParameterPassesGivenTypeToCreateNamedParameter().

◆ $connection

Connection Prophecy Prophecy ObjectProphecy TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::$connection
protected

Definition at line 46 of file QueryBuilderTest.php.

◆ $platform

AbstractPlatform TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::$platform
protected

Definition at line 50 of file QueryBuilderTest.php.

Referenced by TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\castFieldToTextType(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\quoteIdentifiersForSelect(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\quoteIdentifiersForSelectWithInvalidAlias(), and TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatforms().

◆ $subject

QueryBuilder TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest::$subject
protected

Definition at line 54 of file QueryBuilderTest.php.

Referenced by TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\castFieldToTextType(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\changingClonedQueryBuilderDoesNotInfluenceSourceOne(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\cloningQueryBuilderClonesConcreteQueryBuilder(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\getQueriedTablesReturnsSameTableTwiceForInnerJoin(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\limitRestrictionsToTablesLimitsRestrictionsInTheContainerToTheGivenTables(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\queryRestrictionsAreAddedForCountOnExecute(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\queryRestrictionsAreAddedForSelectOnExecute(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\queryRestrictionsAreReevaluatedOnSettingsChangeForExecute(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\queryRestrictionsAreReevaluatedOnSettingsChangeForGetSQL(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\restrictionsAreAppliedInJoinConditionForLeftJoins(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\restrictionsAreAppliedInJoinConditionForRightJoins(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\restrictionsCanStillBeRemovedAfterTheyHaveBeenLimitedToTables(), TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\setWithNamedParameterPassesGivenTypeToCreateNamedParameter(), and TYPO3\CMS\Core\Tests\Unit\Database\Query\QueryBuilderTest\unquoteSingleIdentifierUnquotesCorrectlyOnDifferentPlatforms().