TYPO3  7.6
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
DatabaseConnectionOracleTest Class Reference
Inheritance diagram for DatabaseConnectionOracleTest:
AbstractTestCase

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 AbstractTestCase
 cleanSql ($sql)
 

Protected Attributes

 $subject
 

Detailed Description

Test case

Definition at line 20 of file DatabaseConnectionOracleTest.php.

Member Function Documentation

aliasRemappingSupportsNestedSubqueries ( )
aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery ( )
aliasRemappingWithInSubqueryDoesNotAffectMainQuery ( )
cachingFrameworkQueryIsProperlyQuoted ( )
cachingFrameworkQueryIsRemapped ( )
cachingFrameworkQueryIsSupported ( )
calculatedFieldsAreProperlyQuoted ( )
canCompileExtendedInsert ( )
Test:

Definition at line 152 of file DatabaseConnectionOracleTest.php.

canCompileInsertWithFields ( )
Test:

Definition at line 132 of file DatabaseConnectionOracleTest.php.

caseStatementIsProperlyQuoted ( )
caseStatementIsProperlyRemapped ( )
caseStatementWithExternalTableIsProperlyRemapped ( )
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 AbstractTestCase\cleanSql().

concatAfterLikeOperatorIsRemapped ( )
Test:
See Also
http://forge.typo3.org/issues/21502
Remarks
Remapping is expected here

Definition at line 395 of file DatabaseConnectionOracleTest.php.

References AbstractTestCase\cleanSql().

defaultValueIsProperlyQuotedInCreateTable ( )
distinctFieldIsProperlyQuoted ( )
existsWhereClauseIsProperlyQuoted ( )
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 AbstractTestCase\cleanSql().

expressionListIsUnchanged ( )
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 AbstractTestCase\cleanSql().

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 AbstractTestCase\cleanSql().

fieldFromAliasInJoinIsRemapped ( )
fieldFromAliasIsRemapped ( )
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 AbstractTestCase\cleanSql().

fieldIsMappedOnRightSideOfAJoinCondition ( )
fieldWithinSqlFunctionIsRemapped ( )
findInSetFieldIsProperlyRemapped ( )
findInSetIsProperlyRemapped ( )
groupConditionsAreProperlyTransformed ( )
IfNullIsProperlyRemapped ( )
instrIsUsedForCEOnPages ( )
inWhereClauseWithSubqueryIsProperlyQuoted ( )
likeBinaryOperatorIsRemoved ( )
likeIsRemappedAccordingToFieldTypeWithInteger ( )
likeIsRemappedAccordingToFieldTypeWithString ( )
listQueryIsProperlyRemapped ( )
locateStatementIsProperlyQuoted ( )
locateStatementWithPositionIsProperlyQuoted ( )
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 AbstractTestCase\cleanSql().

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 AbstractTestCase\cleanSql().

notLikeIsRemappedAccordingToFieldTypeWithInteger ( )
notLikeIsRemappedAccordingToFieldTypeWithString ( )
notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable ( )
numericColumnsAreNotQuoted ( )
Test:

Definition at line 305 of file DatabaseConnectionOracleTest.php.

References AbstractTestCase\cleanSql().

remappingDoesNotMixUpAliasesInSubquery ( )
runningADOdbDriverReturnsTrueWithOci8ForOci8DefaultDriverConfiguration ( )
Test:

Definition at line 113 of file DatabaseConnectionOracleTest.php.

selectQueryIsProperlyQuoted ( )
Test:

Definition at line 210 of file DatabaseConnectionOracleTest.php.

References AbstractTestCase\cleanSql().

setUp ( )
protected

Prepare a DatabaseConnection subject ready to parse oracle queries

Returns
void

Definition at line 32 of file DatabaseConnectionOracleTest.php.

sqlForInsertWithMultipleRowsIsValid ( )
Test:

Definition at line 172 of file DatabaseConnectionOracleTest.php.

References AbstractTestCase\cleanSql().

sqlHintIsRemoved ( )
stringsWithinInClauseAreProperlyQuoted ( )
subqueryIsRemappedForExistsWhereClause ( )
subqueryIsRemappedForInWhereClause ( )
tableAndFieldWithinSqlFunctionIsRemapped ( )
tablesAndFieldsAreRemappedInMultipleJoins ( )
Test:
See Also
http://forge.typo3.org/issues/19999
Remarks
Remapping is expected here

Definition at line 320 of file DatabaseConnectionOracleTest.php.

References AbstractTestCase\cleanSql().

tablesAreUnmappedInAdminGetTables ( )
truncateQueryIsProperlyQuoted ( )
Test:

Definition at line 220 of file DatabaseConnectionOracleTest.php.

References AbstractTestCase\cleanSql().

Member Data Documentation

$subject
protected

Definition at line 25 of file DatabaseConnectionOracleTest.php.