TYPO3 CMS  TYPO3_7-6
Protected Member Functions | List of all members
TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase Class Reference
Inheritance diagram for TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase:
TYPO3\CMS\Core\Tests\UnitTestCase TYPO3\CMS\Core\Tests\BaseTestCase TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionMssqlTest TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionOracleTest TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionPostgresqlTest TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseConnectionTest TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseSpecificsTest TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest TYPO3\CMS\Dbal\Tests\Unit\Database\DatabaseSpecificsPostgresqlTest

Protected Member Functions

 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='')
 

Additional Inherited Members

- 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

Base test case for dbal database tests.

Definition at line 27 of file AbstractTestCase.php.

Member Function Documentation

◆ cleanSql()

TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase::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 79 of file AbstractTestCase.php.

References $sql.

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