TYPO3  7.6
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
SqlParserTest Class Reference
Inheritance diagram for SqlParserTest:
AbstractTestCase

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 AbstractTestCase
 cleanSql ($sql)
 

Protected Attributes

 $subject
 

Detailed Description

Test case

Definition at line 22 of file SqlParserTest.php.

Member Function Documentation

canCompileCastOperator ( )
canCompileIfNullOperator ( )
canExtractPartsOfAQuery ( )
Test:

Definition at line 516 of file SqlParserTest.php.

canGetIntegerValue ( )
Test:

Definition at line 533 of file SqlParserTest.php.

canGetListOfValues ( )
Test:

Definition at line 580 of file SqlParserTest.php.

canGetStringValue ( )
Test:
See Also
http://forge.typo3.org/issues/21887

Definition at line 545 of file SqlParserTest.php.

canGetStringValueWithDoubleQuote ( )
Test:
See Also
http://forge.typo3.org/issues/21887

Definition at line 569 of file SqlParserTest.php.

canGetStringValueWithSingleQuote ( )
Test:
See Also
http://forge.typo3.org/issues/21887

Definition at line 557 of file SqlParserTest.php.

canParseAlterCharacterSetStatement ( )
canParseAlterEngineStatement ( )
canParseAlterTableAddKeyStatement ( )
canParseAlterTableDropKeyStatement ( )
canParseAndCompileBetweenOperator ( )
canParseCastOperator ( )
Test:
See Also
http://forge.typo3.org/issues/67155

Definition at line 767 of file SqlParserTest.php.

canParseExtendedInsert ( )
Test:

Definition at line 690 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canParseExtendedInsertWithFields ( )
Test:

Definition at line 704 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canParseFindInSetStatement ( )
canParseIfNullOperator ( )
Test:
See Also
http://forge.typo3.org/issues/17552

Definition at line 721 of file SqlParserTest.php.

canParseIfNullOperatorWithAdditionalClauses ( )
Test:
See Also
http://forge.typo3.org/issues/17552

Definition at line 733 of file SqlParserTest.php.

canParseInsertWithFields ( )
Test:

Definition at line 674 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canParseInsertWithoutSpaceAfterValues ( )
Test:

Definition at line 646 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canParseInsertWithSpaceAfterValues ( )
Test:

Definition at line 660 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canParseMultiJoinConditionsWithStrings ( )
canParseMultiJoinConditionsWithStringsAndLeftCast ( )
canParseMultiJoinConditionsWithStringsAndRightCast ( )
canParseMultipleJoinConditions ( )
canParseMultipleJoinConditionsWithLessThanOperator ( )
canParseSingleQuote ( )
Test:
See Also
http://forge.typo3.org/issues/27858

Definition at line 869 of file SqlParserTest.php.

canParseTruncateTable ( )
Test:

Definition at line 619 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canParseUniqueIndexCreation ( )
Test:
See Also
http://forge.typo3.org/issues/15366

Definition at line 1093 of file SqlParserTest.php.

canSelectAllFieldsFromPages ( )
Test:

Definition at line 608 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canUseInnerJoinInSelect ( )
Test:

Definition at line 943 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

canUseMultipleInnerJoinsInSelect ( )
Test:

Definition at line 955 of file SqlParserTest.php.

References AbstractTestCase\cleanSql().

caseWithBooleanConditionIsProperlyCompiled ( )
caseWithBooleanConditionIsSupportedInFields ( )
Test:
See Also
http://forge.typo3.org/issues/21903

Definition at line 1162 of file SqlParserTest.php.

caseWithBooleanConditionIsSupportedWithinAggregateFunction ( )
caseWithMultipleWhenIsProperlyCompiled ( )
caseWithMultipleWhenIsSupportedInFields ( )
Test:
See Also
http://forge.typo3.org/issues/21903

Definition at line 1187 of file SqlParserTest.php.

compileWhereClauseDoesNotDropClauses ( )

Regression test

Test:

Definition at line 50 of file SqlParserTest.php.

createTableSupportsDateAndTimeTypes ( )
existsClauseIsProperlyCompiled ( )
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 ( )

Data provider for getValueReturnsCorrectValues

See Also
getValueReturnsCorrectValues

Definition at line 177 of file SqlParserTest.php.

indexMayContainALengthRestrictionInAlterTable ( )
Test:
See Also
http://forge.typo3.org/issues/21730

Definition at line 1082 of file SqlParserTest.php.

indexMayContainALengthRestrictionInCreateTable ( )
Test:
See Also
http://forge.typo3.org/issues/16689

Definition at line 1036 of file SqlParserTest.php.

inWhereClauseSupportsSubquery ( )
Test:
See Also
http://forge.typo3.org/issues/21688

Definition at line 1109 of file SqlParserTest.php.

inWhereClauseWithSubqueryIsProperlyCompiled ( )
locateIsSupported ( )
locateWithinCaseIsSupported ( )
locateWithPositionIsSupported ( )
namedParametersMayBeSafelyReplaced ( )
namedPlaceholderIsSupported ( )
parametersAreReferenced ( )
Test:
See Also
http://forge.typo3.org/issues/23374

Definition at line 1292 of file SqlParserTest.php.

parseFromTablesWithInnerJoinReturnsArray ( )
Test:

Definition at line 883 of file SqlParserTest.php.

parseFromTablesWithLeftOuterJoinReturnsArray ( )
Test:

Definition at line 895 of file SqlParserTest.php.

parseFromTablesWithMultipleJoinsAndParenthesesReturnsArray ( )
Test:
See Also
http://forge.typo3.org/issues/21555

Definition at line 932 of file SqlParserTest.php.

parseFromTablesWithMultipleJoinsReturnsArray ( )
Test:

Definition at line 920 of file SqlParserTest.php.

parseFromTablesWithRightOuterJoinReturnsArray ( )
Test:
See Also
http://forge.typo3.org/issues/21555

Definition at line 908 of file SqlParserTest.php.

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.

parseSQLDataProvider ( )

Data provider for parseSQL

See Also
parseSQL

Definition at line 214 of file SqlParserTest.php.

parseWhereClauseReturnsArray ( )
Test:

Definition at line 597 of file SqlParserTest.php.

questionMarkParametersMayBeSafelyReplaced ( )
questionMarkPlaceholderIsSupported ( )
sameParameterIsReferencedInSubquery ( )
setUp ( )
protected

Prepares the environment before running a test.

Definition at line 32 of file SqlParserTest.php.

References SqlParserTest\$subject, and GeneralUtility\makeInstance().

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.

trimSqlReallyTrimsAllWhitespaceDataProvider ( )

Data provider for trimSqlReallyTrimsAllWhitespace

See Also
trimSqlReallyTrimsAllWhitespace

Definition at line 144 of file SqlParserTest.php.

whereClauseSupportsExistsKeyword ( )
Test:
See Also
http://forge.typo3.org/issues/21688

Definition at line 1134 of file SqlParserTest.php.

Member Data Documentation

$subject
protected

Definition at line 27 of file SqlParserTest.php.

Referenced by SqlParserTest\setUp().