TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest Class Reference

Inheritance diagram for TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest:

Public Member Functions
	setUpAndReturnDatabaseStubReturnsMockObjectOfDatabaseConnection ()
	createPreparedStatementReturnsInstanceOfPreparedStatementClass ()
	parametersAndQueriesDataProvider ()
	parametersAreReplacedByQuestionMarkInQueryByCallingExecute ($query, $parameters, $expectedResult)
	parametersAreReplacedInQueryWhenBoundWithBindValues ($query, $parameters, $expectedResult)
	invalidParameterTypesPassedToBindValueThrowsExceptionDataProvider ()
	invalidParameterTypesPassedToBindValueThrowsException ($parameter, $type)
	passingInvalidMarkersThrowsExceptionDataProvider ()
	passingInvalidMarkersThrowsException ($query, $parameters)

Protected Member Functions
	setUp ()
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
	$databaseStub
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

Private Member Functions
	setUpAndReturnDatabaseStub ()
	createPreparedStatement ($query)

Detailed Description

Test case

Definition at line 20 of file PreparedStatementTest.php.

Member Function Documentation

createPreparedStatement()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::createPreparedStatement (   $query )

private

Create an object fo the subject to be tested.

Parameters

string

$query

Returns

Definition at line 66 of file PreparedStatementTest.php.

Referenced by TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\createPreparedStatementReturnsInstanceOfPreparedStatementClass(), TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\invalidParameterTypesPassedToBindValueThrowsException(), TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\parametersAreReplacedByQuestionMarkInQueryByCallingExecute(), TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\parametersAreReplacedInQueryWhenBoundWithBindValues(), and TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\passingInvalidMarkersThrowsException().

createPreparedStatementReturnsInstanceOfPreparedStatementClass()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::createPreparedStatementReturnsInstanceOfPreparedStatementClass

(

)

Test:

Returns

void

Definition at line 88 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\createPreparedStatement().

invalidParameterTypesPassedToBindValueThrowsException()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::invalidParameterTypesPassedToBindValueThrowsException	(		$parameter,
			$type
	)

Checking if an exception is thrown if invalid parameters are provided vor bindValue().

Test:

invalidParameterTypesPassedToBindValueThrowsExceptionDataProvider

Parameters

mixed	$parameter	Parameter to be replaced in the query
int	$type	Type of the parameter value

Returns

void

Definition at line 183 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\createPreparedStatement().

invalidParameterTypesPassedToBindValueThrowsExceptionDataProvider()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::invalidParameterTypesPassedToBindValueThrowsExceptionDataProvider

(

)

Data Provider with invalid parameters.

See also

invalidParameterTypesPassedToBindValueThrowsException

Returns

array

Definition at line 157 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Database\PreparedStatement\PARAM_BOOL, TYPO3\CMS\Core\Database\PreparedStatement\PARAM_INT, and TYPO3\CMS\Core\Database\PreparedStatement\PARAM_NULL.

parametersAndQueriesDataProvider()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::parametersAndQueriesDataProvider

(

)

Data Provider for two tests, providing sample queries, parameters and expected result queries.

See also

parametersAreReplacedInQueryByCallingExecute

parametersAreReplacedInQueryWhenBoundWithBindValues

Returns

array

Definition at line 103 of file PreparedStatementTest.php.

parametersAreReplacedByQuestionMarkInQueryByCallingExecute()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::parametersAreReplacedByQuestionMarkInQueryByCallingExecute	(		$query,
			$parameters,
			$expectedResult
	)

Checking if calling execute() with parameters, they are properly replaced in the query.

Test:

parametersAndQueriesDataProvider

Parameters

string	$query	Query with unreplaced markers
array	$parameters	Array of parameters to be replaced in the query
string	$expectedResult	Query with all markers replaced

Returns

void

Definition at line 125 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\createPreparedStatement().

parametersAreReplacedInQueryWhenBoundWithBindValues()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::parametersAreReplacedInQueryWhenBoundWithBindValues	(		$query,
			$parameters,
			$expectedResult
	)

Checking if parameters bound to the statement by bindValues() are properly replaced in the query.

Test:

parametersAndQueriesDataProvider

Parameters

string	$query	Query with unreplaced markers
array	$parameters	Array of parameters to be replaced in the query
string	$expectedResult	Query with all markers replaced

Returns

void

Definition at line 143 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\createPreparedStatement().

passingInvalidMarkersThrowsException()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::passingInvalidMarkersThrowsException	(		$query,
			$parameters
	)

Checks if an exception is thrown, if parameter have invalid marker named.

Test:

passingInvalidMarkersThrowsExceptionDataProvider

Parameters

string	$query	Query with unreplaced markers
array	$parameters	Array of parameters to be replaced in the query

Returns

void

Definition at line 216 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\createPreparedStatement().

passingInvalidMarkersThrowsExceptionDataProvider()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::passingInvalidMarkersThrowsExceptionDataProvider

(

)

Data Provider for invalid marker names.

See also

passingInvalidMarkersThrowsExeption

Returns

array

Definition at line 195 of file PreparedStatementTest.php.

setUp()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::setUp ( )

protected

Create a new database mock object for every test and backup the original global database object.

Returns

void

Definition at line 33 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\setUpAndReturnDatabaseStub().

setUpAndReturnDatabaseStub()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::setUpAndReturnDatabaseStub ( )

private

Set up the stub to be able to get the result of the prepared statement.

Returns

Definition at line 46 of file PreparedStatementTest.php.

References $GLOBALS, and TYPO3\CMS\Core\Tests\BaseTestCase\getAccessibleMock().

Referenced by TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\setUp(), and TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\setUpAndReturnDatabaseStubReturnsMockObjectOfDatabaseConnection().

setUpAndReturnDatabaseStubReturnsMockObjectOfDatabaseConnection()

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::setUpAndReturnDatabaseStubReturnsMockObjectOfDatabaseConnection

(

)

Test:

Returns

void

Definition at line 79 of file PreparedStatementTest.php.

References TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest\setUpAndReturnDatabaseStub().

Member Data Documentation

$databaseStub

TYPO3\CMS\Core\Tests\Unit\Database\PreparedStatementTest::$databaseStub

protected

Definition at line 25 of file PreparedStatementTest.php.