AbstractTestCase Class Reference

TYPO3 7.6

Inheritance diagram for AbstractTestCase:

Protected Member Functions
	cleanSql ($sql)

Detailed Description

Base test case for dbal database tests.

Definition at line 27 of file AbstractTestCase.php.

Member Function Documentation

cleanSql ( $sql )

protected

Clean a parsed SQL query for easier comparison with expected SQL.

Parameters

mixed $sql

Returns: mixed (string or array)

Definition at line 80 of file AbstractTestCase.php.

Referenced by DatabaseConnectionOracleTest\aliasRemappingSupportsNestedSubqueries(), DatabaseConnectionOracleTest\aliasRemappingWithExistsSubqueryDoesNotAffectMainQuery(), DatabaseConnectionOracleTest\aliasRemappingWithInSubqueryDoesNotAffectMainQuery(), DatabaseConnectionPostgresqlTest\alterTableAddFieldWithAutoIncrementIsRemappedToSerialType(), DatabaseConnectionPostgresqlTest\alterTableAddKeyStatementIsRemappedToCreateIndex(), DatabaseConnectionOracleTest\cachingFrameworkQueryIsProperlyQuoted(), DatabaseConnectionOracleTest\cachingFrameworkQueryIsRemapped(), DatabaseConnectionOracleTest\cachingFrameworkQueryIsSupported(), DatabaseConnectionOracleTest\calculatedFieldsAreProperlyQuoted(), SqlParserTest\canCompileCastOperator(), SqlParserTest\canCompileIfNullOperator(), SqlParserTest\canParseAlterCharacterSetStatement(), SqlParserTest\canParseAlterEngineStatement(), SqlParserTest\canParseAlterTableAddKeyStatement(), DatabaseConnectionPostgresqlTest\canParseAlterTableDropKeyStatement(), SqlParserTest\canParseAlterTableDropKeyStatement(), SqlParserTest\canParseAndCompileBetweenOperator(), SqlParserTest\canParseExtendedInsert(), SqlParserTest\canParseExtendedInsertWithFields(), SqlParserTest\canParseFindInSetStatement(), SqlParserTest\canParseInsertWithFields(), SqlParserTest\canParseInsertWithoutSpaceAfterValues(), SqlParserTest\canParseInsertWithSpaceAfterValues(), SqlParserTest\canParseMultiJoinConditionsWithStrings(), SqlParserTest\canParseMultiJoinConditionsWithStringsAndLeftCast(), SqlParserTest\canParseMultiJoinConditionsWithStringsAndRightCast(), SqlParserTest\canParseMultipleJoinConditions(), SqlParserTest\canParseMultipleJoinConditionsWithLessThanOperator(), SqlParserTest\canParseTruncateTable(), DatabaseConnectionMssqlTest\canRemapPidToZero(), SqlParserTest\canSelectAllFieldsFromPages(), SqlParserTest\canUseInnerJoinInSelect(), SqlParserTest\canUseMultipleInnerJoinsInSelect(), DatabaseConnectionOracleTest\caseStatementIsProperlyQuoted(), DatabaseConnectionOracleTest\caseStatementIsProperlyRemapped(), DatabaseConnectionOracleTest\caseStatementWithExternalTableIsProperlyRemapped(), SqlParserTest\caseWithBooleanConditionIsProperlyCompiled(), SqlParserTest\caseWithMultipleWhenIsProperlyCompiled(), DatabaseConnectionOracleTest\concatAfterLikeOperatorIsProperlyQuoted(), DatabaseConnectionOracleTest\concatAfterLikeOperatorIsRemapped(), DatabaseConnectionTest\concatCanBeParsedAfterLikeOperator(), DatabaseConnectionPostgresqlTest\countFieldInOrderByIsInGroupBy(), DatabaseConnectionPostgresqlTest\countFieldInOrderByIsNotInGroupBy(), SqlParserTest\createTableSupportsDateAndTimeTypes(), DatabaseConnectionOracleTest\defaultValueIsProperlyQuotedInCreateTable(), DatabaseConnectionOracleTest\distinctFieldIsProperlyQuoted(), SqlParserTest\existsClauseIsProperlyCompiled(), DatabaseConnectionOracleTest\existsWhereClauseIsProperlyQuoted(), DatabaseConnectionOracleTest\expressionListBracesAreSetCorrectly(), DatabaseConnectionOracleTest\expressionListIsUnchanged(), DatabaseConnectionOracleTest\expressionListWithInIsConcatenatedWithOr(), DatabaseConnectionOracleTest\expressionListWithNotInIsConcatenatedWithAnd(), DatabaseConnectionOracleTest\fieldFromAliasInJoinIsRemapped(), DatabaseConnectionOracleTest\fieldFromAliasIsRemapped(), DatabaseConnectionOracleTest\fieldFromAliasIsRemappedWithoutBeingTricked(), DatabaseConnectionOracleTest\fieldIsMappedOnRightSideOfAJoinCondition(), DatabaseConnectionOracleTest\fieldWithinSqlFunctionIsRemapped(), DatabaseConnectionOracleTest\findInSetFieldIsProperlyRemapped(), DatabaseConnectionMssqlTest\findInSetIsProperlyRemapped(), DatabaseConnectionPostgresqlTest\findInSetIsProperlyRemapped(), DatabaseConnectionOracleTest\findInSetIsProperlyRemapped(), DatabaseConnectionPostgresqlTest\findInSetIsProperlyRemappedWithTableAndFieldIdentifier(), DatabaseConnectionTest\floatNumberCanBeStoredInDatabase(), DatabaseConnectionOracleTest\groupConditionsAreProperlyTransformed(), DatabaseConnectionMssqlTest\IfNullIsProperlyRemapped(), DatabaseConnectionOracleTest\IfNullIsProperlyRemapped(), DatabaseConnectionOracleTest\instrIsUsedForCEOnPages(), SqlParserTest\inWhereClauseWithSubqueryIsProperlyCompiled(), DatabaseConnectionOracleTest\inWhereClauseWithSubqueryIsProperlyQuoted(), DatabaseConnectionTest\likeBinaryOperatorIsKept(), DatabaseConnectionPostgresqlTest\likeBinaryOperatorIsRemappedToLike(), DatabaseConnectionOracleTest\likeBinaryOperatorIsRemoved(), DatabaseConnectionOracleTest\likeIsRemappedAccordingToFieldTypeWithInteger(), DatabaseConnectionOracleTest\likeIsRemappedAccordingToFieldTypeWithString(), DatabaseConnectionPostgresqlTest\likeOperatorIsRemappedToIlike(), DatabaseConnectionPostgresqlTest\limitIsProperlyRemapped(), DatabaseConnectionPostgresqlTest\limitWithSkipIsProperlyRemapped(), DatabaseConnectionOracleTest\listQueryIsProperlyRemapped(), SqlParserTest\locateIsSupported(), DatabaseConnectionMssqlTest\locateStatementIsProperlyQuoted(), DatabaseConnectionOracleTest\locateStatementIsProperlyQuoted(), DatabaseConnectionMssqlTest\locateStatementIsProperlyRemapped(), DatabaseConnectionMssqlTest\locateStatementWithExternalTableIsProperlyRemapped(), DatabaseConnectionMssqlTest\locateStatementWithPositionIsProperlyQuoted(), DatabaseConnectionOracleTest\locateStatementWithPositionIsProperlyQuoted(), SqlParserTest\locateWithinCaseIsSupported(), SqlParserTest\locateWithPositionIsSupported(), DatabaseConnectionTest\maxFunctionAndInOperatorCanBeParsed(), DatabaseConnectionTest\minFunctionAndInOperatorCanBeParsed(), DatabaseConnectionPostgresqlTest\multipleCountFieldsInOrderByAreInGroupBy(), DatabaseConnectionPostgresqlTest\multipleCountFieldsInOrderByAreNotInGroupBy(), DatabaseConnectionOracleTest\multipleExpressiosInWhereClauseAreBracedCorrectly(), DatabaseConnectionOracleTest\multipleInnerJoinsAreProperlyQuoted(), SqlParserTest\namedParametersMayBeSafelyReplaced(), SqlParserTest\namedPlaceholderIsSupported(), DatabaseConnectionPostgresqlTest\notEqualAnsiOperatorCanBeParsed(), DatabaseConnectionTest\notLikeBinaryOperatorIsKept(), DatabaseConnectionPostgresqlTest\notLikeBinaryOperatorIsRemappedToNotLike(), DatabaseConnectionOracleTest\notLikeIsRemappedAccordingToFieldTypeWithInteger(), DatabaseConnectionOracleTest\notLikeIsRemappedAccordingToFieldTypeWithString(), DatabaseConnectionPostgresqlTest\notLikeOperatorIsRemappedToNotIlike(), DatabaseConnectionOracleTest\notNullableColumnsWithDefaultEmptyStringAreCreatedAsNullable(), DatabaseConnectionOracleTest\numericColumnsAreNotQuoted(), DatabaseConnectionTest\positive64BitIntegerIsSupported(), SqlParserTest\questionMarkParametersMayBeSafelyReplaced(), SqlParserTest\questionMarkPlaceholderIsSupported(), DatabaseConnectionOracleTest\remappingDoesNotMixUpAliasesInSubquery(), SqlParserTest\sameParameterIsReferencedInSubquery(), DatabaseConnectionOracleTest\selectQueryIsProperlyQuoted(), DatabaseConnectionMssqlTest\singleQuotesAreProperlyEscaped(), DatabaseConnectionPostgresqlTest\someCountFieldsInOrderByAreNotInGroupBy(), DatabaseConnectionOracleTest\sqlForInsertWithMultipleRowsIsValid(), DatabaseConnectionTest\sqlForInsertWithMultipleRowsIsValid(), DatabaseConnectionOracleTest\sqlHintIsRemoved(), DatabaseConnectionOracleTest\stringsWithinInClauseAreProperlyQuoted(), DatabaseConnectionOracleTest\subqueryIsRemappedForExistsWhereClause(), DatabaseConnectionOracleTest\subqueryIsRemappedForInWhereClause(), DatabaseConnectionOracleTest\tableAndFieldWithinSqlFunctionIsRemapped(), DatabaseConnectionOracleTest\tablesAndFieldsAreRemappedInMultipleJoins(), and DatabaseConnectionOracleTest\truncateQueryIsProperlyQuoted().