TYPO3 CMS  TYPO3_7-6
TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest Class Reference
Inheritance diagram for TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest:
TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase TYPO3\CMS\Core\Tests\UnitTestCase TYPO3\CMS\Core\Tests\BaseTestCase

Public Member Functions

 compileWhereClauseDoesNotDropClauses ()
 
 trimSqlReallyTrimsAllWhitespaceDataProvider ()
 
 trimSqlReallyTrimsAllWhitespace ($sql, $expected)
 
 getValueReturnsCorrectValuesDataProvider ()
 
 getValueReturnsCorrectValues ($parseString, $comparator, $mode, $expected)
 
 parseSQLDataProvider ()
 
 parseSQL ($sql, $expected)
 
 canExtractPartsOfAQuery ()
 
 canGetIntegerValue ()
 
 canGetStringValue ()
 
 canGetStringValueWithSingleQuote ()
 
 canGetStringValueWithDoubleQuote ()
 
 canGetListOfValues ()
 
 parseWhereClauseReturnsArray ()
 
 canSelectAllFieldsFromPages ()
 
 canParseTruncateTable ()
 
 canParseAndCompileBetweenOperator ()
 
 canParseInsertWithoutSpaceAfterValues ()
 
 canParseInsertWithSpaceAfterValues ()
 
 canParseInsertWithFields ()
 
 canParseExtendedInsert ()
 
 canParseExtendedInsertWithFields ()
 
 canParseIfNullOperator ()
 
 canParseIfNullOperatorWithAdditionalClauses ()
 
 canCompileIfNullOperator ()
 
 canParseCastOperator ()
 
 canCompileCastOperator ()
 
 canParseAlterEngineStatement ()
 
 canParseAlterCharacterSetStatement ()
 
 canParseAlterTableAddKeyStatement ()
 
 canParseAlterTableDropKeyStatement ()
 
 canParseFindInSetStatement ()
 
 canParseSingleQuote ()
 
 parseFromTablesWithInnerJoinReturnsArray ()
 
 parseFromTablesWithLeftOuterJoinReturnsArray ()
 
 parseFromTablesWithRightOuterJoinReturnsArray ()
 
 parseFromTablesWithMultipleJoinsReturnsArray ()
 
 parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray ()
 
 canUseInnerJoinInSelect ()
 
 canUseMultipleInnerJoinsInSelect ()
 
 canParseMultipleJoinConditions ()
 
 canParseMultiJoinConditionsWithStrings ()
 
 canParseMultiJoinConditionsWithStringsAndLeftCast ()
 
 canParseMultiJoinConditionsWithStringsAndRightCast ()
 
 canParseMultipleJoinConditionsWithLessThanOperator ()
 
 indexMayContainALengthRestrictionInCreateTable ()
 
 createTableSupportsDateAndTimeTypes ()
 
 indexMayContainALengthRestrictionInAlterTable ()
 
 canParseUniqueIndexCreation ()
 
 inWhereClauseSupportsSubquery ()
 
 inWhereClauseWithSubqueryIsProperlyCompiled ()
 
 whereClauseSupportsExistsKeyword ()
 
 existsClauseIsProperlyCompiled ()
 
 caseWithBooleanConditionIsSupportedInFields ()
 
 caseWithBooleanConditionIsProperlyCompiled ()
 
 caseWithMultipleWhenIsSupportedInFields ()
 
 caseWithBooleanConditionIsSupportedWithinAggregateFunction ()
 
 caseWithMultipleWhenIsProperlyCompiled ()
 
 locateIsSupported ()
 
 locateWithPositionIsSupported ()
 
 locateWithinCaseIsSupported ()
 
 namedPlaceholderIsSupported ()
 
 questionMarkPlaceholderIsSupported ()
 
 parametersAreReferenced ()
 
 sameParameterIsReferencedInSubquery ()
 
 namedParametersMayBeSafelyReplaced ()
 
 questionMarkParametersMayBeSafelyReplaced ()
 

Protected Member Functions

 setUp ()
 
- 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, $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='')
 

Protected Attributes

 $subject
 
- 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

Test case

Definition at line 22 of file SqlParserTest.php.

Member Function Documentation

◆ canCompileCastOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canCompileCastOperator ( )

◆ canCompileIfNullOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canCompileIfNullOperator ( )

◆ canExtractPartsOfAQuery()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canExtractPartsOfAQuery ( )
Test:

Definition at line 516 of file SqlParserTest.php.

◆ canGetIntegerValue()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetIntegerValue ( )
Test:

Definition at line 533 of file SqlParserTest.php.

◆ canGetListOfValues()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetListOfValues ( )
Test:

Definition at line 580 of file SqlParserTest.php.

◆ canGetStringValue()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetStringValue ( )
Test:
See also
http://forge.typo3.org/issues/21887

Definition at line 545 of file SqlParserTest.php.

◆ canGetStringValueWithDoubleQuote()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetStringValueWithDoubleQuote ( )
Test:
See also
http://forge.typo3.org/issues/21887

Definition at line 569 of file SqlParserTest.php.

◆ canGetStringValueWithSingleQuote()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetStringValueWithSingleQuote ( )
Test:
See also
http://forge.typo3.org/issues/21887

Definition at line 557 of file SqlParserTest.php.

◆ canParseAlterCharacterSetStatement()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseAlterCharacterSetStatement ( )

◆ canParseAlterEngineStatement()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseAlterEngineStatement ( )

◆ canParseAlterTableAddKeyStatement()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseAlterTableAddKeyStatement ( )

◆ canParseAlterTableDropKeyStatement()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseAlterTableDropKeyStatement ( )

◆ canParseAndCompileBetweenOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseAndCompileBetweenOperator ( )

◆ canParseCastOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseCastOperator ( )
Test:
See also
http://forge.typo3.org/issues/67155

Definition at line 767 of file SqlParserTest.php.

◆ canParseExtendedInsert()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseExtendedInsert ( )

◆ canParseExtendedInsertWithFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseExtendedInsertWithFields ( )

◆ canParseFindInSetStatement()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseFindInSetStatement ( )

◆ canParseIfNullOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseIfNullOperator ( )
Test:
See also
http://forge.typo3.org/issues/17552

Definition at line 721 of file SqlParserTest.php.

◆ canParseIfNullOperatorWithAdditionalClauses()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseIfNullOperatorWithAdditionalClauses ( )
Test:
See also
http://forge.typo3.org/issues/17552

Definition at line 733 of file SqlParserTest.php.

◆ canParseInsertWithFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseInsertWithFields ( )

◆ canParseInsertWithoutSpaceAfterValues()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseInsertWithoutSpaceAfterValues ( )

◆ canParseInsertWithSpaceAfterValues()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseInsertWithSpaceAfterValues ( )

◆ canParseMultiJoinConditionsWithStrings()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseMultiJoinConditionsWithStrings ( )

◆ canParseMultiJoinConditionsWithStringsAndLeftCast()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseMultiJoinConditionsWithStringsAndLeftCast ( )

◆ canParseMultiJoinConditionsWithStringsAndRightCast()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseMultiJoinConditionsWithStringsAndRightCast ( )

◆ canParseMultipleJoinConditions()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseMultipleJoinConditions ( )

◆ canParseMultipleJoinConditionsWithLessThanOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseMultipleJoinConditionsWithLessThanOperator ( )

◆ canParseSingleQuote()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseSingleQuote ( )
Test:
See also
http://forge.typo3.org/issues/27858

Definition at line 869 of file SqlParserTest.php.

◆ canParseTruncateTable()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseTruncateTable ( )

◆ canParseUniqueIndexCreation()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseUniqueIndexCreation ( )
Test:
See also
http://forge.typo3.org/issues/15366

Definition at line 1093 of file SqlParserTest.php.

References $sql.

◆ canSelectAllFieldsFromPages()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canSelectAllFieldsFromPages ( )

◆ canUseInnerJoinInSelect()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canUseInnerJoinInSelect ( )

◆ canUseMultipleInnerJoinsInSelect()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canUseMultipleInnerJoinsInSelect ( )

◆ caseWithBooleanConditionIsProperlyCompiled()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithBooleanConditionIsProperlyCompiled ( )

◆ caseWithBooleanConditionIsSupportedInFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithBooleanConditionIsSupportedInFields ( )
Test:
See also
http://forge.typo3.org/issues/21903

Definition at line 1162 of file SqlParserTest.php.

◆ caseWithBooleanConditionIsSupportedWithinAggregateFunction()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithBooleanConditionIsSupportedWithinAggregateFunction ( )

◆ caseWithMultipleWhenIsProperlyCompiled()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithMultipleWhenIsProperlyCompiled ( )

◆ caseWithMultipleWhenIsSupportedInFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithMultipleWhenIsSupportedInFields ( )
Test:
See also
http://forge.typo3.org/issues/21903

Definition at line 1187 of file SqlParserTest.php.

◆ compileWhereClauseDoesNotDropClauses()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::compileWhereClauseDoesNotDropClauses ( )

Regression test

Test:

Definition at line 50 of file SqlParserTest.php.

◆ createTableSupportsDateAndTimeTypes()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::createTableSupportsDateAndTimeTypes ( )

◆ existsClauseIsProperlyCompiled()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::existsClauseIsProperlyCompiled ( )

◆ getValueReturnsCorrectValues()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::getValueReturnsCorrectValues (   $parseString,
  $comparator,
  $mode,
  $expected 
)
Test:
getValueReturnsCorrectValuesDataProvider
Parameters
string$parseStringthe string to parse
string$comparatorThe comparator used before. If "NOT IN" or "IN" then the value is expected to be a list of values. Otherwise just an integer (un-quoted) or string (quoted)
string$modeThe mode, eg. "INDEX
string$expected

Definition at line 203 of file SqlParserTest.php.

◆ getValueReturnsCorrectValuesDataProvider()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::getValueReturnsCorrectValuesDataProvider ( )

Data provider for getValueReturnsCorrectValues

See also
getValueReturnsCorrectValues

Definition at line 177 of file SqlParserTest.php.

◆ indexMayContainALengthRestrictionInAlterTable()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::indexMayContainALengthRestrictionInAlterTable ( )
Test:
See also
http://forge.typo3.org/issues/21730

Definition at line 1082 of file SqlParserTest.php.

◆ indexMayContainALengthRestrictionInCreateTable()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::indexMayContainALengthRestrictionInCreateTable ( )
Test:
See also
http://forge.typo3.org/issues/16689

Definition at line 1036 of file SqlParserTest.php.

◆ inWhereClauseSupportsSubquery()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::inWhereClauseSupportsSubquery ( )
Test:
See also
http://forge.typo3.org/issues/21688

Definition at line 1109 of file SqlParserTest.php.

◆ inWhereClauseWithSubqueryIsProperlyCompiled()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::inWhereClauseWithSubqueryIsProperlyCompiled ( )

◆ locateIsSupported()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::locateIsSupported ( )

◆ locateWithinCaseIsSupported()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::locateWithinCaseIsSupported ( )

◆ locateWithPositionIsSupported()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::locateWithPositionIsSupported ( )

◆ namedParametersMayBeSafelyReplaced()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::namedParametersMayBeSafelyReplaced ( )

◆ namedPlaceholderIsSupported()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::namedPlaceholderIsSupported ( )

◆ parametersAreReferenced()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parametersAreReferenced ( )
Test:
See also
http://forge.typo3.org/issues/23374

Definition at line 1292 of file SqlParserTest.php.

References $sql.

◆ parseFromTablesWithInnerJoinReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithInnerJoinReturnsArray ( )
Test:

Definition at line 883 of file SqlParserTest.php.

◆ parseFromTablesWithLeftOuterJoinReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithLeftOuterJoinReturnsArray ( )
Test:

Definition at line 895 of file SqlParserTest.php.

◆ parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray ( )
Test:
See also
http://forge.typo3.org/issues/21555

Definition at line 932 of file SqlParserTest.php.

◆ parseFromTablesWithMultipleJoinsReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithMultipleJoinsReturnsArray ( )
Test:

Definition at line 920 of file SqlParserTest.php.

◆ parseFromTablesWithRightOuterJoinReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithRightOuterJoinReturnsArray ( )
Test:
See also
http://forge.typo3.org/issues/21555

Definition at line 908 of file SqlParserTest.php.

◆ parseSQL()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseSQL (   $sql,
  $expected 
)
Test:
parseSQLDataProvider
Parameters
string$sqlThe SQL to trim
array$expectedThe expected trimmed SQL with single space at the end

Definition at line 507 of file SqlParserTest.php.

References $sql.

◆ parseSQLDataProvider()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseSQLDataProvider ( )

Data provider for parseSQL

See also
parseSQL

Definition at line 214 of file SqlParserTest.php.

◆ parseWhereClauseReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseWhereClauseReturnsArray ( )
Test:

Definition at line 597 of file SqlParserTest.php.

◆ questionMarkParametersMayBeSafelyReplaced()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::questionMarkParametersMayBeSafelyReplaced ( )

◆ questionMarkPlaceholderIsSupported()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::questionMarkPlaceholderIsSupported ( )

◆ sameParameterIsReferencedInSubquery()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::sameParameterIsReferencedInSubquery ( )

◆ setUp()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::setUp ( )
protected

◆ trimSqlReallyTrimsAllWhitespace()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::trimSqlReallyTrimsAllWhitespace (   $sql,
  $expected 
)
Test:
trimSqlReallyTrimsAllWhitespaceDataProvider
Parameters
string$sqlThe SQL to trim
string$expectedThe expected trimmed SQL with single space at the end

Definition at line 166 of file SqlParserTest.php.

References $sql.

◆ trimSqlReallyTrimsAllWhitespaceDataProvider()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::trimSqlReallyTrimsAllWhitespaceDataProvider ( )

Data provider for trimSqlReallyTrimsAllWhitespace

See also
trimSqlReallyTrimsAllWhitespace

Definition at line 144 of file SqlParserTest.php.

◆ whereClauseSupportsExistsKeyword()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::whereClauseSupportsExistsKeyword ( )
Test:
See also
http://forge.typo3.org/issues/21688

Definition at line 1134 of file SqlParserTest.php.

Member Data Documentation

◆ $subject

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::$subject
protected