dbOracleTest Class Reference

Inheritance diagram for dbOracleTest:

Collaboration diagram for dbOracleTest:

List of all members.

Public Member Functions
	setUp ()
	tearDown ()
	configurationIsUsingAdodbAndDriverOci8 ()
	tablesWithMappingAreDetected ()
	sqlHintIsRemoved ()
	canCompileInsertWithFields ()
	canCompileExtendedInsert ()
	sqlForInsertWithMultipleRowsIsValid ()
	groupConditionsAreProperlyTransformed ()
	selectQueryIsProperlyQuoted ()
	truncateQueryIsProperlyQuoted ()
	distinctFieldIsProperlyQuoted ()
	multipleInnerJoinsAreProperlyQuoted ()
	stringsWithinInClauseAreProperlyQuoted ()
	concatAfterLikeOperatorIsProperlyQuoted ()
	cachingFrameworkQueryIsProperlyQuoted ()
	calculatedFieldsAreProperlyQuoted ()
	numericColumnsAreNotQuoted ()
	tablesAndFieldsAreRemappedInMultipleJoins ()
	fieldWithinSqlFunctionIsRemapped ()
	tableAndFieldWithinSqlFunctionIsRemapped ()
	concatAfterLikeOperatorIsRemapped ()
	fieldIsMappedOnRightSideOfAJoinCondition ()
	fieldFromAliasIsRemapped ()
	fieldFromAliasIsRemappedWithoutBeingTricked ()
	aliasRemappingDoesNotAlterFurtherQueries ()
	fieldFromAliasInJoinIsRemapped ()
	aliasRemappingWithInSubqueryDoesNotAffectMainQuery ()
	aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery ()
	aliasRemappingSupportsNestedSubqueries ()
	remappingDoesNotMixUpAliasesInSubquery ()
	likeIsRemappedAccordingToFieldType ()
	notLikeIsRemappedAccordingToFieldType ()
	instrIsUsedForCEOnPages ()
	notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable ()
	defaultValueIsProperlyQuotedInCreateTable ()
	inWhereClauseWithSubqueryIsProperlyQuoted ()
	subqueryIsRemappedForInWhereClause ()
	cachingFrameworkQueryIsSupported ()
	cachingFrameworkQueryIsRemapped ()
	existsWhereClauseIsProperlyQuoted ()
	subqueryIsRemappedForExistsWhereClause ()
	caseStatementIsProperlyQuoted ()
	caseStatementIsProperlyRemapped ()
	caseStatementWithExternalTableIsProperlyRemapped ()
	locateStatementIsProperlyQuoted ()
	locateStatementWithPositionIsProperlyQuoted ()
	IfNullIsProperlyRemapped ()
	findInSetIsProperlyRemapped ()
	findInSetFieldIsProperlyRemapped ()
	listQueryIsProperlyRemapped ()
	likeBinaryOperatorIsRemoved ()
Protected Attributes
	$db
	$dbalConfig
Private Member Functions
	cleanSql ($sql)

---

Detailed Description

Definition at line 39 of file dbOracleTest.php.

---

Member Function Documentation

dbOracleTest::aliasRemappingDoesNotAlterFurtherQueries

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 517 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::aliasRemappingSupportsNestedSubqueries

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 614 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 591 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::aliasRemappingWithInSubqueryDoesNotAffectMainQuery

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 568 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::cachingFrameworkQueryIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12231

Definition at line 329 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::cachingFrameworkQueryIsRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12800

Definition at line 889 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::cachingFrameworkQueryIsSupported

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12800

Definition at line 867 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::calculatedFieldsAreProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12231

Definition at line 345 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::canCompileExtendedInsert

(

)

Test:

http://bugs.typo3.org/view.php?id=13209

Definition at line 169 of file dbOracleTest.php.

References $GLOBALS, and t3lib_div\trimExplode().

dbOracleTest::canCompileInsertWithFields

(

)

Test:

Definition at line 147 of file dbOracleTest.php.

References $GLOBALS.

dbOracleTest::caseStatementIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=13135

Definition at line 976 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::caseStatementIsProperlyRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=13135

Definition at line 994 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::caseStatementWithExternalTableIsProperlyRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=13135

Definition at line 1017 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::cleanSql

(

$

sql

)

[private]

Cleans a SQL query.

Parameters:

mixed

$sql

Returns:

mixed (string or array)

Definition at line 93 of file dbOracleTest.php.

Referenced by aliasRemappingDoesNotAlterFurtherQueries(), aliasRemappingSupportsNestedSubqueries(), aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery(), aliasRemappingWithInSubqueryDoesNotAffectMainQuery(), cachingFrameworkQueryIsProperlyQuoted(), cachingFrameworkQueryIsRemapped(), cachingFrameworkQueryIsSupported(), calculatedFieldsAreProperlyQuoted(), caseStatementIsProperlyQuoted(), caseStatementIsProperlyRemapped(), caseStatementWithExternalTableIsProperlyRemapped(), concatAfterLikeOperatorIsProperlyQuoted(), concatAfterLikeOperatorIsRemapped(), defaultValueIsProperlyQuotedInCreateTable(), distinctFieldIsProperlyQuoted(), existsWhereClauseIsProperlyQuoted(), fieldFromAliasInJoinIsRemapped(), fieldFromAliasIsRemapped(), fieldFromAliasIsRemappedWithoutBeingTricked(), fieldIsMappedOnRightSideOfAJoinCondition(), fieldWithinSqlFunctionIsRemapped(), findInSetFieldIsProperlyRemapped(), findInSetIsProperlyRemapped(), groupConditionsAreProperlyTransformed(), IfNullIsProperlyRemapped(), instrIsUsedForCEOnPages(), inWhereClauseWithSubqueryIsProperlyQuoted(), likeBinaryOperatorIsRemoved(), likeIsRemappedAccordingToFieldType(), listQueryIsProperlyRemapped(), locateStatementIsProperlyQuoted(), locateStatementWithPositionIsProperlyQuoted(), multipleInnerJoinsAreProperlyQuoted(), notLikeIsRemappedAccordingToFieldType(), notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable(), numericColumnsAreNotQuoted(), remappingDoesNotMixUpAliasesInSubquery(), selectQueryIsProperlyQuoted(), sqlForInsertWithMultipleRowsIsValid(), sqlHintIsRemoved(), stringsWithinInClauseAreProperlyQuoted(), subqueryIsRemappedForExistsWhereClause(), subqueryIsRemappedForInWhereClause(), tableAndFieldWithinSqlFunctionIsRemapped(), tablesAndFieldsAreRemappedInMultipleJoins(), and truncateQueryIsProperlyQuoted().

dbOracleTest::concatAfterLikeOperatorIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12515

Remarks:

Remapping is not expected here

Definition at line 313 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::concatAfterLikeOperatorIsRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12515

Remarks:

Remapping is expected here

Definition at line 439 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::configurationIsUsingAdodbAndDriverOci8

(

)

Test:

Definition at line 106 of file dbOracleTest.php.

References $GLOBALS.

dbOracleTest::defaultValueIsProperlyQuotedInCreateTable

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=11142

http://bugs.typo3.org/view.php?id=12670

Definition at line 793 of file dbOracleTest.php.

References $GLOBALS, and cleanSql().

dbOracleTest::distinctFieldIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=2438

Definition at line 265 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::existsWhereClauseIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12758

Definition at line 924 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::fieldFromAliasInJoinIsRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 544 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::fieldFromAliasIsRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 478 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::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://bugs.typo3.org/view.php?id=14372

Definition at line 499 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::fieldIsMappedOnRightSideOfAJoinCondition

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=5708

Definition at line 459 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::fieldWithinSqlFunctionIsRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=6953

Definition at line 400 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::findInSetFieldIsProperlyRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14985

Definition at line 1102 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::findInSetIsProperlyRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14985

Definition at line 1088 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::groupConditionsAreProperlyTransformed

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=15535

Definition at line 215 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::IfNullIsProperlyRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=6196

Definition at line 1074 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::instrIsUsedForCEOnPages

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14479

Definition at line 707 of file dbOracleTest.php.

References $GLOBALS, and cleanSql().

dbOracleTest::inWhereClauseWithSubqueryIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12758

Definition at line 835 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::likeBinaryOperatorIsRemoved

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12535

Definition at line 1134 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::likeIsRemappedAccordingToFieldType

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14479

Definition at line 663 of file dbOracleTest.php.

References $GLOBALS, and cleanSql().

dbOracleTest::listQueryIsProperlyRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14818

Definition at line 1120 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::locateStatementIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=13134

Definition at line 1040 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::locateStatementWithPositionIsProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=13134

Definition at line 1057 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::multipleInnerJoinsAreProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=10411

Remarks:

Remapping is not expected here

Definition at line 280 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::notLikeIsRemappedAccordingToFieldType

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=15253

Definition at line 685 of file dbOracleTest.php.

References $GLOBALS, and cleanSql().

dbOracleTest::notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12670

Definition at line 744 of file dbOracleTest.php.

References $GLOBALS, and cleanSql().

dbOracleTest::numericColumnsAreNotQuoted

(

)

Test:

http://bugs.typo3.org/view.php?id=13422

Definition at line 360 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::remappingDoesNotMixUpAliasesInSubquery

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=14372

Definition at line 640 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::selectQueryIsProperlyQuoted

(

)

Test:

Definition at line 239 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::setUp

(

)

Prepares the environment before running a test.

Definition at line 54 of file dbOracleTest.php.

References $GLOBALS, BaseTestCase\buildAccessibleProxy(), and FakeDbConnection\connect().

dbOracleTest::sqlForInsertWithMultipleRowsIsValid

(

)

Test:

http://bugs.typo3.org/view.php?id=12858

Definition at line 190 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::sqlHintIsRemoved

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12897

Definition at line 134 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::stringsWithinInClauseAreProperlyQuoted

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=6198

Definition at line 297 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::subqueryIsRemappedForExistsWhereClause

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12758

Definition at line 946 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::subqueryIsRemappedForInWhereClause

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=12758

Definition at line 849 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::tableAndFieldWithinSqlFunctionIsRemapped

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=6953

Definition at line 418 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::tablesAndFieldsAreRemappedInMultipleJoins

(

)

Test:

See also:

http://bugs.typo3.org/view.php?id=10411

Remarks:

Remapping is expected here

Definition at line 379 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

dbOracleTest::tablesWithMappingAreDetected

(

)

Test:

Definition at line 116 of file dbOracleTest.php.

References $GLOBALS.

dbOracleTest::tearDown

(

)

Cleans up the environment after running a test.

Definition at line 78 of file dbOracleTest.php.

References $GLOBALS.

dbOracleTest::truncateQueryIsProperlyQuoted

(

)

Test:

http://bugs.typo3.org/view.php?id=13504

Definition at line 255 of file dbOracleTest.php.

References $GLOBALS, $query, and cleanSql().

---

Member Data Documentation

dbOracleTest::$db [protected]

Definition at line 44 of file dbOracleTest.php.

dbOracleTest::$dbalConfig [protected]

Definition at line 49 of file dbOracleTest.php.

---

The documentation for this class was generated from the following file:

• typo3/sysext/dbal/tests/dbOracleTest.php