TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest Class Reference

Inheritance diagram for TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest:

Public Member Functions
	setUp ()
	canExtractPartsOfAQuery ()
	canGetIntegerValue ()
	canGetStringValue ()
	canGetStringValueWithSingleQuote ()
	canGetStringValueWithDoubleQuote ()
	canGetListOfValues ()
	parseWhereClauseReturnsArray ()
	canSelectAllFieldsFromPages ()
	canParseTruncateTable ()
	canParseAndCompileBetweenOperator ()
	canParseInsertWithoutSpaceAfterValues ()
	canParseInsertWithSpaceAfterValues ()
	canParseInsertWithFields ()
	canParseExtendedInsert ()
	canParseExtendedInsertWithFields ()
	canParseIfNullOperator ()
	canParseIfNullOperatorWithAdditionalClauses ()
	canCompileIfNullOperator ()
	canParseCastOperator ()
	canCompileCastOperator ()
	canParseAlterEngineStatement ()
	canParseAlterCharacterSetStatement ()
	canParseFindInSetStatement ()
	canParseSingleQuote ()
	parseFromTablesWithInnerJoinReturnsArray ()
	parseFromTablesWithLeftOuterJoinReturnsArray ()
	parseFromTablesWithRightOuterJoinReturnsArray ()
	parseFromTablesWithMultipleJoinsReturnsArray ()
	parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray ()
	canUseInnerJoinInSelect ()
	canUseMultipleInnerJoinsInSelect ()
	canParseMultipleJoinConditions ()
	canParseMultiJoinConditionsWithStrings ()
	canParseMultipleJoinConditionsWithLessThanOperator ()
	indexMayContainALengthRestrictionInCreateTable ()
	indexMayContainALengthRestrictionInAlterTable ()
	canParseUniqueIndexCreation ()
	inWhereClauseSupportsSubquery ()
	inWhereClauseWithSubqueryIsProperlyCompiled ()
	whereClauseSupportsExistsKeyword ()
	existsClauseIsProperlyCompiled ()
	caseWithBooleanConditionIsSupportedInFields ()
	caseWithBooleanConditionIsProperlyCompiled ()
	caseWithMultipleWhenIsSupportedInFields ()
	caseWithMultipleWhenIsProperlyCompiled ()
	locateIsSupported ()
	locateWithPositionIsSupported ()
	locateWithinCaseIsSupported ()
	namedPlaceholderIsSupported ()
	questionMarkPlaceholderIsSupported ()
	parametersAreReferenced ()
	sameParameterIsReferencedInSubquery ()
	namedParametersMayBeSafelyReplaced ()
	questionMarkParametersMayBeSafelyReplaced ()

Protected Attributes
	$subject
Protected Attributes inherited from TYPO3\CMS\Core\Tests\UnitTestCase
	$backupGlobalsBlacklist = array('TYPO3_LOADED_EXT')
Protected Attributes inherited from TYPO3\CMS\Core\Tests\BaseTestCase
	$backupGlobals = TRUE
	$backupStaticAttributes = FALSE

Additional Inherited Members
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, array $methods=array(), array $arguments=array(), $mockClassName='', $callOriginalConstructor=TRUE, $callOriginalClone=TRUE, $callAutoload=TRUE)
	getAccessibleMockForAbstractClass ( $originalClassName, array $arguments=array(), $mockClassName='', $callOriginalConstructor=TRUE, $callOriginalClone=TRUE, $callAutoload=TRUE)
	buildAccessibleProxy ($className)
	callInaccessibleMethod ($object, $name)
	inject ($target, $name, $dependency)
	getUniqueId ($prefix='')

Detailed Description

This file is part of the TYPO3 CMS project.

It is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License, either version 2 of the License, or any later version.

For the full copyright and license information, please read the LICENSE.txt file that was distributed with this source code.

The TYPO3 project - inspiring people to share! Test case

Definition at line 20 of file SqlParserTest.php.

Member Function Documentation

canCompileCastOperator()

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

(

)

Test:

See also

http://forge.typo3.org/issues/67155

Definition at line 287 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canCompileIfNullOperator()

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

(

)

Test:

See also

http://forge.typo3.org/issues/17552

Definition at line 262 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canExtractPartsOfAQuery()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canExtractPartsOfAQuery

(

)

Test:

Definition at line 43 of file SqlParserTest.php.

canGetIntegerValue()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetIntegerValue

(

)

Test:

Definition at line 59 of file SqlParserTest.php.

References $result.

canGetListOfValues()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetListOfValues

(

)

Test:

Definition at line 102 of file SqlParserTest.php.

References $result.

canGetStringValue()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetStringValue

(

)

Test:

See also

http://forge.typo3.org/issues/21887

Definition at line 70 of file SqlParserTest.php.

References $result.

canGetStringValueWithDoubleQuote()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetStringValueWithDoubleQuote

(

)

Test:

See also

http://forge.typo3.org/issues/21887

Definition at line 92 of file SqlParserTest.php.

References $result.

canGetStringValueWithSingleQuote()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canGetStringValueWithSingleQuote

(

)

Test:

See also

http://forge.typo3.org/issues/21887

Definition at line 81 of file SqlParserTest.php.

References $result.

canParseAlterCharacterSetStatement()

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

(

)

Test:

See also

http://forge.typo3.org/issues/22731

Definition at line 315 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseAlterEngineStatement()

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

(

)

Test:

See also

http://forge.typo3.org/issues/22695

Definition at line 301 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseAndCompileBetweenOperator()

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

(

)

Test:

See also

http://forge.typo3.org/issues/22049

Definition at line 149 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseCastOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseCastOperator

(

)

Test:

See also

http://forge.typo3.org/issues/67155

Definition at line 276 of file SqlParserTest.php.

References $result.

canParseExtendedInsert()

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

(

)

Test:

Definition at line 204 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseExtendedInsertWithFields()

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

(

)

Test:

Definition at line 217 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseFindInSetStatement()

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

(

)

Test:

See also

http://forge.typo3.org/issues/23087

Definition at line 329 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseIfNullOperator()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseIfNullOperator

(

)

Test:

See also

http://forge.typo3.org/issues/17552

Definition at line 233 of file SqlParserTest.php.

References $result.

canParseIfNullOperatorWithAdditionalClauses()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseIfNullOperatorWithAdditionalClauses

(

)

Test:

See also

http://forge.typo3.org/issues/17552

Definition at line 244 of file SqlParserTest.php.

References $result.

canParseInsertWithFields()

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

(

)

Test:

Definition at line 189 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseInsertWithoutSpaceAfterValues()

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

(

)

Test:

Definition at line 163 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseInsertWithSpaceAfterValues()

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

(

)

Test:

Definition at line 176 of file SqlParserTest.php.

References $result, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseMultiJoinConditionsWithStrings()

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

(

)

Test:

See also

http://forge.typo3.org/issues/67385

Definition at line 446 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseMultipleJoinConditions()

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

(

)

Test:

See also

http://forge.typo3.org/issues/22501

Definition at line 434 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseMultipleJoinConditionsWithLessThanOperator()

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

(

)

Test:

See also

http://forge.typo3.org/issues/22501

Definition at line 458 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseSingleQuote()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseSingleQuote

(

)

Test:

See also

http://forge.typo3.org/issues/27858

Definition at line 343 of file SqlParserTest.php.

References $result.

canParseTruncateTable()

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

(

)

Test:

Definition at line 138 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canParseUniqueIndexCreation()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::canParseUniqueIndexCreation

(

)

Test:

See also

http://forge.typo3.org/issues/15366

Definition at line 510 of file SqlParserTest.php.

References $sql.

canSelectAllFieldsFromPages()

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

(

)

Test:

Definition at line 128 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canUseInnerJoinInSelect()

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

(

)

Test:

Definition at line 411 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

canUseMultipleInnerJoinsInSelect()

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

(

)

Test:

Definition at line 422 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

caseWithBooleanConditionIsProperlyCompiled()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21903

Definition at line 585 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

caseWithBooleanConditionIsSupportedInFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithBooleanConditionIsSupportedInFields

(

)

Test:

See also

http://forge.typo3.org/issues/21903

Definition at line 574 of file SqlParserTest.php.

References $result.

caseWithMultipleWhenIsProperlyCompiled()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21903

Definition at line 608 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

caseWithMultipleWhenIsSupportedInFields()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::caseWithMultipleWhenIsSupportedInFields

(

)

Test:

See also

http://forge.typo3.org/issues/21903

Definition at line 597 of file SqlParserTest.php.

References $result.

existsClauseIsProperlyCompiled()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21688

Definition at line 559 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

indexMayContainALengthRestrictionInAlterTable()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::indexMayContainALengthRestrictionInAlterTable

(

)

Test:

See also

http://forge.typo3.org/issues/21730

Definition at line 500 of file SqlParserTest.php.

References $result.

indexMayContainALengthRestrictionInCreateTable()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::indexMayContainALengthRestrictionInCreateTable

(

)

Test:

See also

http://forge.typo3.org/issues/16689

Definition at line 473 of file SqlParserTest.php.

References $result.

inWhereClauseSupportsSubquery()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::inWhereClauseSupportsSubquery

(

)

Test:

See also

http://forge.typo3.org/issues/21688

Definition at line 525 of file SqlParserTest.php.

References $result.

inWhereClauseWithSubqueryIsProperlyCompiled()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21688

Definition at line 536 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

locateIsSupported()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21902

Definition at line 620 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

locateWithinCaseIsSupported()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21902

http://forge.typo3.org/issues/21903

Definition at line 644 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

locateWithPositionIsSupported()

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

(

)

Test:

See also

http://forge.typo3.org/issues/21902

Definition at line 632 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

namedParametersMayBeSafelyReplaced()

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

(

)

Test:

See also

http://forge.typo3.org/issues/23374

Definition at line 711 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

namedPlaceholderIsSupported()

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

(

)

Test:

See also

http://forge.typo3.org/issues/23374

Definition at line 659 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

parametersAreReferenced()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parametersAreReferenced

(

)

Test:

See also

http://forge.typo3.org/issues/23374

Definition at line 683 of file SqlParserTest.php.

References $sql.

parseFromTablesWithInnerJoinReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithInnerJoinReturnsArray

(

)

Test:

Definition at line 356 of file SqlParserTest.php.

References $result.

parseFromTablesWithLeftOuterJoinReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithLeftOuterJoinReturnsArray

(

)

Test:

Definition at line 367 of file SqlParserTest.php.

References $result.

parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray

(

)

Test:

See also

http://forge.typo3.org/issues/21555

Definition at line 401 of file SqlParserTest.php.

References $result.

parseFromTablesWithMultipleJoinsReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithMultipleJoinsReturnsArray

(

)

Test:

Definition at line 390 of file SqlParserTest.php.

References $result.

parseFromTablesWithRightOuterJoinReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseFromTablesWithRightOuterJoinReturnsArray

(

)

Test:

See also

http://forge.typo3.org/issues/21555

Definition at line 379 of file SqlParserTest.php.

References $result.

parseWhereClauseReturnsArray()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::parseWhereClauseReturnsArray

(

)

Test:

Definition at line 118 of file SqlParserTest.php.

References $result.

questionMarkParametersMayBeSafelyReplaced()

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

(

)

Test:

See also

http://forge.typo3.org/issues/23374

Definition at line 726 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

questionMarkPlaceholderIsSupported()

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

(

)

Test:

See also

http://forge.typo3.org/issues/23374

Definition at line 671 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

sameParameterIsReferencedInSubquery()

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

(

)

Test:

See also

http://forge.typo3.org/issues/23374

Definition at line 696 of file SqlParserTest.php.

References $result, $sql, and TYPO3\CMS\Dbal\Tests\Unit\Database\AbstractTestCase\cleanSql().

setUp()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::setUp

(

)

Prepares the environment before running a test.

Definition at line 30 of file SqlParserTest.php.

References TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest\$subject, and TYPO3\CMS\Core\Tests\BaseTestCase\getAccessibleMock().

whereClauseSupportsExistsKeyword()

TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest::whereClauseSupportsExistsKeyword

(

)

Test:

See also

http://forge.typo3.org/issues/21688

Definition at line 548 of file SqlParserTest.php.

References $result.

Member Data Documentation

$subject

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

protected

Definition at line 25 of file SqlParserTest.php.

Referenced by TYPO3\CMS\Dbal\Tests\Unit\Database\SqlParserTest\setUp().