TYPO3 CMS  TYPO3_7-6
TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest Class Reference
Inheritance diagram for TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest:
TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase TYPO3\CMS\Core\Tests\UnitTestCase TYPO3\CMS\Core\Tests\BaseTestCase

Public Member Functions

 runningADOdbDriverReturnsTrueWithOci8ForOci8DefaultDriverConfiguration ()
 
 sqlHintIsRemoved ()
 
 canCompileInsertWithFields ()
 
 canCompileExtendedInsert ()
 
 sqlForInsertWithMultipleRowsIsValid ()
 
 groupConditionsAreProperlyTransformed ()
 
 selectQueryIsProperlyQuoted ()
 
 truncateQueryIsProperlyQuoted ()
 
 distinctFieldIsProperlyQuoted ()
 
 multipleInnerJoinsAreProperlyQuoted ()
 
 stringsWithinInClauseAreProperlyQuoted ()
 
 concatAfterLikeOperatorIsProperlyQuoted ()
 
 cachingFrameworkQueryIsProperlyQuoted ()
 
 calculatedFieldsAreProperlyQuoted ()
 
 numericColumnsAreNotQuoted ()
 
 tablesAndFieldsAreRemappedInMultipleJoins ()
 
 tablesAreUnmappedInAdminGetTables ()
 
 fieldWithinSqlFunctionIsRemapped ()
 
 tableAndFieldWithinSqlFunctionIsRemapped ()
 
 concatAfterLikeOperatorIsRemapped ()
 
 fieldIsMappedOnRightSideOfAJoinCondition ()
 
 fieldFromAliasIsRemapped ()
 
 fieldFromAliasIsRemappedWithoutBeingTricked ()
 
 fieldFromAliasInJoinIsRemapped ()
 
 aliasRemappingWithInSubqueryDoesNotAffectMainQuery ()
 
 aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery ()
 
 aliasRemappingSupportsNestedSubqueries ()
 
 remappingDoesNotMixUpAliasesInSubquery ()
 
 likeIsRemappedAccordingToFieldTypeWithString ()
 
 likeIsRemappedAccordingToFieldTypeWithInteger ()
 
 notLikeIsRemappedAccordingToFieldTypeWithString ()
 
 notLikeIsRemappedAccordingToFieldTypeWithInteger ()
 
 instrIsUsedForCEOnPages ()
 
 notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable ()
 
 defaultValueIsProperlyQuotedInCreateTable ()
 
 inWhereClauseWithSubqueryIsProperlyQuoted ()
 
 subqueryIsRemappedForInWhereClause ()
 
 cachingFrameworkQueryIsSupported ()
 
 cachingFrameworkQueryIsRemapped ()
 
 existsWhereClauseIsProperlyQuoted ()
 
 subqueryIsRemappedForExistsWhereClause ()
 
 caseStatementIsProperlyQuoted ()
 
 caseStatementIsProperlyRemapped ()
 
 caseStatementWithExternalTableIsProperlyRemapped ()
 
 locateStatementIsProperlyQuoted ()
 
 locateStatementWithPositionIsProperlyQuoted ()
 
 IfNullIsProperlyRemapped ()
 
 findInSetIsProperlyRemapped ()
 
 findInSetFieldIsProperlyRemapped ()
 
 listQueryIsProperlyRemapped ()
 
 likeBinaryOperatorIsRemoved ()
 
 expressionListWithNotInIsConcatenatedWithAnd ()
 
 expressionListWithInIsConcatenatedWithOr ()
 
 expressionListIsUnchanged ()
 
 expressionListBracesAreSetCorrectly ()
 
 multipleExpressiosInWhereClauseAreBracedCorrectly ()
 

Protected Member Functions

 setUp ()
 
- Protected Member Functions inherited from TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase
 cleanSql ($sql)
 
- Protected Member Functions inherited from TYPO3\CMS\Core\Tests\UnitTestCase
 tearDown ()
 
- Protected Member Functions inherited from TYPO3\CMS\Core\Tests\BaseTestCase
 getAccessibleMock ( $originalClassName, $methods=[], array $arguments=[], $mockClassName='', $callOriginalConstructor=true, $callOriginalClone=true, $callAutoload=true)
 
 getAccessibleMockForAbstractClass ( $originalClassName, array $arguments=[], $mockClassName='', $callOriginalConstructor=true, $callOriginalClone=true, $callAutoload=true, $mockedMethods=[])
 
 buildAccessibleProxy ($className)
 
 callInaccessibleMethod ($object, $name)
 
 inject ($target, $name, $dependency)
 
 getUniqueId ($prefix='')
 

Protected Attributes

 $subject
 
- Protected Attributes inherited from TYPO3\CMS\Core\Tests\UnitTestCase
 $backupGlobalsBlacklist = ['TYPO3_LOADED_EXT']
 
 $testFilesToDelete = []
 
- Protected Attributes inherited from TYPO3\CMS\Core\Tests\BaseTestCase
 $backupGlobals = true
 
 $backupStaticAttributes = false
 

Detailed Description

Test case

Definition at line 20 of file DatabaseConnectionOracleTest.php.

Member Function Documentation

◆ aliasRemappingSupportsNestedSubqueries()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::aliasRemappingSupportsNestedSubqueries ( )

◆ aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery ( )

◆ aliasRemappingWithInSubqueryDoesNotAffectMainQuery()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::aliasRemappingWithInSubqueryDoesNotAffectMainQuery ( )

◆ cachingFrameworkQueryIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::cachingFrameworkQueryIsProperlyQuoted ( )

◆ cachingFrameworkQueryIsRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::cachingFrameworkQueryIsRemapped ( )

◆ cachingFrameworkQueryIsSupported()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::cachingFrameworkQueryIsSupported ( )

◆ calculatedFieldsAreProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::calculatedFieldsAreProperlyQuoted ( )

◆ canCompileExtendedInsert()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::canCompileExtendedInsert ( )
Test:

Definition at line 152 of file DatabaseConnectionOracleTest.php.

◆ canCompileInsertWithFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::canCompileInsertWithFields ( )
Test:

Definition at line 132 of file DatabaseConnectionOracleTest.php.

◆ caseStatementIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::caseStatementIsProperlyQuoted ( )

◆ caseStatementIsProperlyRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::caseStatementIsProperlyRemapped ( )

◆ caseStatementWithExternalTableIsProperlyRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::caseStatementWithExternalTableIsProperlyRemapped ( )

◆ concatAfterLikeOperatorIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::concatAfterLikeOperatorIsProperlyQuoted ( )
Test:
See also
http://forge.typo3.org/issues/21502
Remarks
Remapping is not expected here

Definition at line 270 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

◆ concatAfterLikeOperatorIsRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::concatAfterLikeOperatorIsRemapped ( )

◆ defaultValueIsProperlyQuotedInCreateTable()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::defaultValueIsProperlyQuotedInCreateTable ( )

◆ distinctFieldIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::distinctFieldIsProperlyQuoted ( )

◆ existsWhereClauseIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::existsWhereClauseIsProperlyQuoted ( )

◆ expressionListBracesAreSetCorrectly()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::expressionListBracesAreSetCorrectly ( )
Test:

$expectedWhere: "uid" = 1981 AND ( "uid" IN (1,2,3,4,...,1000) OR "uid" IN (1001,1002,...,1250) ) OR "uid" = 42

Definition at line 1064 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql(), and TYPO3\CMS\Core\Tests\BaseTestCase\getAccessibleMock().

◆ expressionListIsUnchanged()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::expressionListIsUnchanged ( )

◆ expressionListWithInIsConcatenatedWithOr()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::expressionListWithInIsConcatenatedWithOr ( )
Test:

$expectedWhere: ( "uid" IN (1,2,3,4,...,1000) OR "uid" IN (1001,1002,...,1250) )

Definition at line 1016 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql(), and TYPO3\CMS\Core\Tests\BaseTestCase\getAccessibleMock().

◆ expressionListWithNotInIsConcatenatedWithAnd()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::expressionListWithNotInIsConcatenatedWithAnd ( )
Test:

$expectedWhere: ( "uid" NOT IN (1,2,3,4,...,1000) AND "uid" NOT IN (1001,1002,...,1250) )

Definition at line 984 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql(), and TYPO3\CMS\Core\Tests\BaseTestCase\getAccessibleMock().

◆ fieldFromAliasInJoinIsRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::fieldFromAliasInJoinIsRemapped ( )

◆ fieldFromAliasIsRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::fieldFromAliasIsRemapped ( )

◆ fieldFromAliasIsRemappedWithoutBeingTricked()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::fieldFromAliasIsRemappedWithoutBeingTricked ( )

Trick here is that we already have a mapping for both table tt_news and table tt_news_cat (see tests/fixtures/oci8.config.php) which is used as alias name.

Test:
See also
http://forge.typo3.org/issues/22640

Definition at line 454 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

◆ fieldIsMappedOnRightSideOfAJoinCondition()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::fieldIsMappedOnRightSideOfAJoinCondition ( )

◆ fieldWithinSqlFunctionIsRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::fieldWithinSqlFunctionIsRemapped ( )

◆ findInSetFieldIsProperlyRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::findInSetFieldIsProperlyRemapped ( )

◆ findInSetIsProperlyRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::findInSetIsProperlyRemapped ( )

◆ groupConditionsAreProperlyTransformed()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::groupConditionsAreProperlyTransformed ( )

◆ IfNullIsProperlyRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::IfNullIsProperlyRemapped ( )

◆ instrIsUsedForCEOnPages()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::instrIsUsedForCEOnPages ( )

◆ inWhereClauseWithSubqueryIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::inWhereClauseWithSubqueryIsProperlyQuoted ( )

◆ likeBinaryOperatorIsRemoved()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::likeBinaryOperatorIsRemoved ( )

◆ likeIsRemappedAccordingToFieldTypeWithInteger()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::likeIsRemappedAccordingToFieldTypeWithInteger ( )

◆ likeIsRemappedAccordingToFieldTypeWithString()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::likeIsRemappedAccordingToFieldTypeWithString ( )

◆ listQueryIsProperlyRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::listQueryIsProperlyRemapped ( )

◆ locateStatementIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::locateStatementIsProperlyQuoted ( )

◆ locateStatementWithPositionIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::locateStatementWithPositionIsProperlyQuoted ( )

◆ multipleExpressiosInWhereClauseAreBracedCorrectly()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::multipleExpressiosInWhereClauseAreBracedCorrectly ( )
Test:

$expectedWhere: "uid" = 1981 AND ( "uid" IN (1,2,3,4,...,1000) OR "uid" IN (1001,1002,...,1250) ) OR "uid" = 42 AND ( "uid" NOT IN (1,2,3,4,...,1000) AND "uid" NOT IN (1001) )

Definition at line 1096 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql(), and TYPO3\CMS\Core\Tests\BaseTestCase\getAccessibleMock().

◆ multipleInnerJoinsAreProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::multipleInnerJoinsAreProperlyQuoted ( )
Test:
See also
http://forge.typo3.org/issues/19999
Remarks
Remapping is not expected here

Definition at line 243 of file DatabaseConnectionOracleTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

◆ notLikeIsRemappedAccordingToFieldTypeWithInteger()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::notLikeIsRemappedAccordingToFieldTypeWithInteger ( )

◆ notLikeIsRemappedAccordingToFieldTypeWithString()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::notLikeIsRemappedAccordingToFieldTypeWithString ( )

◆ notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable ( )

◆ numericColumnsAreNotQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::numericColumnsAreNotQuoted ( )

◆ remappingDoesNotMixUpAliasesInSubquery()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::remappingDoesNotMixUpAliasesInSubquery ( )

◆ runningADOdbDriverReturnsTrueWithOci8ForOci8DefaultDriverConfiguration()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::runningADOdbDriverReturnsTrueWithOci8ForOci8DefaultDriverConfiguration ( )
Test:

Definition at line 113 of file DatabaseConnectionOracleTest.php.

◆ selectQueryIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::selectQueryIsProperlyQuoted ( )

◆ setUp()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::setUp ( )
protected

Prepare a DatabaseConnection subject ready to parse oracle queries

Returns
void

Definition at line 32 of file DatabaseConnectionOracleTest.php.

◆ sqlForInsertWithMultipleRowsIsValid()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::sqlForInsertWithMultipleRowsIsValid ( )

◆ sqlHintIsRemoved()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::sqlHintIsRemoved ( )

◆ stringsWithinInClauseAreProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::stringsWithinInClauseAreProperlyQuoted ( )

◆ subqueryIsRemappedForExistsWhereClause()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::subqueryIsRemappedForExistsWhereClause ( )

◆ subqueryIsRemappedForInWhereClause()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::subqueryIsRemappedForInWhereClause ( )

◆ tableAndFieldWithinSqlFunctionIsRemapped()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::tableAndFieldWithinSqlFunctionIsRemapped ( )

◆ tablesAndFieldsAreRemappedInMultipleJoins()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::tablesAndFieldsAreRemappedInMultipleJoins ( )

◆ tablesAreUnmappedInAdminGetTables()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::tablesAreUnmappedInAdminGetTables ( )

◆ truncateQueryIsProperlyQuoted()

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::truncateQueryIsProperlyQuoted ( )

Member Data Documentation

◆ $subject

TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest::$subject
protected

Definition at line 25 of file DatabaseConnectionOracleTest.php.