TYPO3 CMS  TYPO3_6-2
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

 setUp ()
 
 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 Attributes

 $subject
 
- Protected Attributes inherited from TYPO3\CMS\Core\Tests\UnitTestCase
 $backupGlobalsBlacklist = array('TYPO3_LOADED_EXT')
 
- Protected Attributes inherited from TYPO3\CMS\Core\Tests\BaseTestCase
 $backupGlobals = TRUE
 
 $backupStaticAttributes = FALSE
 

Additional Inherited Members

- 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, array $methods=array(), array $arguments=array(), $mockClassName='', $callOriginalConstructor=TRUE, $callOriginalClone=TRUE, $callAutoload=TRUE)
 
 getAccessibleMockForAbstractClass ( $originalClassName, array $arguments=array(), $mockClassName='', $callOriginalConstructor=TRUE, $callOriginalClone=TRUE, $callAutoload=TRUE)
 
 buildAccessibleProxy ($className)
 
 callInaccessibleMethod ($object, $name)
 
 inject ($target, $name, $dependency)
 
 getUniqueId ($prefix='')
 

Detailed Description

This file is part of the TYPO3 CMS project.

It is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License, either version 2 of the License, or any later version.

For the full copyright and license information, please read the LICENSE.txt file that was distributed with this source code.

The TYPO3 project - inspiring people to share! 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 148 of file DatabaseConnectionOracleTest.php.

◆ canCompileInsertWithFields()

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

Definition at line 129 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 256 of file DatabaseConnectionOracleTest.php.

References $result, and 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 1007 of file DatabaseConnectionOracleTest.php.

References $result, 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 961 of file DatabaseConnectionOracleTest.php.

References $result, 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 930 of file DatabaseConnectionOracleTest.php.

References $result, 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 429 of file DatabaseConnectionOracleTest.php.

References $result, and 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 1038 of file DatabaseConnectionOracleTest.php.

References $result, 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 231 of file DatabaseConnectionOracleTest.php.

References $result, and 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 112 of file DatabaseConnectionOracleTest.php.

◆ selectQueryIsProperlyQuoted()

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

◆ setUp()

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

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.