PHP DatabaseConnection::expects方法代码示例

 /**
  * @test
  */
 public function truncate_multiple_tables_when_configured()
 {
     $configuration = ['truncate' => ['test', 'test2', 'test3']];
     $processor = $this->getMockBuilder(Configuration::class)->disableOriginalConstructor()->getMock();
     $this->connection->expects($this->exactly(3))->method('exec_TRUNCATEquery')->withConsecutive(['test'], ['test2'], ['test3']);
     $this->fixture->execute($processor, $configuration);
 }

 /**
  * Set up
  *
  * @return void
  */
 protected function setUp()
 {
     $this->database = $this->getMock(DatabaseConnection::class, array('exec_SELECTgetSingleRow'));
     $this->database->expects($this->any())->method('exec_SELECTgetSingleRow')->will($this->returnValue(array('uid' => 0, 'parent' => '')));
     $this->treeData = new TreeNode();
     $GLOBALS['TYPO3_DB'] = $this->database;
 }

 /**
  * @test
  */
 public function databaseResultIsUsedWhenNoCachedResultIsPresent()
 {
     $fakeConfiguration = array('select.' => array('checkRootPageId' => true, 'checkLanguage' => true, 'SELECT' => '', 'FROM' => '', 'ADD_WHERE' => '', 'GROUP_BY' => '', 'ORDER_BY' => ''), 'limit');
     $this->configurationMock->expects($this->once())->method('getSearchFrequentSearchesConfiguration')->will($this->returnValue($fakeConfiguration));
     $this->databaseMock->expects($this->once())->method('exec_SELECTgetRows')->will($this->returnValue(array(array('search_term' => 'my search', 'hits' => 22))));
     //we fake that we have no frequent searches in the cache and therefore expect that the database will be queried
     $this->fakeIdentifierNotInCache();
     $frequentTerms = $this->frequentSearchesService->getFrequentSearchTerms();
     $this->assertSame($frequentTerms, array('my search' => 22), 'Could not retrieve frequent search terms');
 }

 /**
  * Checking if parameters bound to the statement by bindValues()
  * are properly replaced in the query.
  *
  * @test
  * @dataProvider parametersAndQueriesDataProvider
  * @param string $query Query with unreplaced markers
  * @param array  $parameters Array of parameters to be replaced in the query
  * @param string $expectedResult Query with all markers replaced
  * @return void
  */
 public function parametersAreReplacedInQueryWhenBoundWithBindValues($query, $parameters, $expectedResult)
 {
     $statement = $this->createPreparedStatement($query);
     $this->databaseStub->expects($this->any())->method('prepare_PREPAREDquery')->with($this->equalTo($expectedResult));
     $statement->bindValues($parameters);
     $statement->execute();
 }

 /**
  * @test
  */
 public function deleteMethodCallsExpectedDatabaseMethodWithRecord()
 {
     $table = 'test';
     $uid = 123;
     $record = array('uid' => 123);
     $mock = $this->getMockServiceInstance(array(), array('exec_DELETEquery'));
     self::$connectionMock->expects($this->once())->method('exec_DELETEquery')->with($table, "uid = '" . $uid . "'");
     $mock->delete($table, $record);
 }

 /**
  * @test
  *
  * @return void
  */
 public function updateQueryCreateValidQuery()
 {
     $this->subject = $this->getAccessibleMock(DatabaseConnection::class, ['fullQuoteStr'], [], '', false);
     $this->subject->expects($this->any())->method('fullQuoteStr')->will($this->returnCallback(function ($data) {
         return '\'' . (string) $data . '\'';
     }));
     $fieldsValues = [$this->testField => 'aTestValue'];
     $queryExpected = "UPDATE {$this->testTable} SET {$this->testField}='aTestValue' WHERE id=1";
     $queryGenerated = $this->subject->UPDATEquery($this->testTable, 'id=1', $fieldsValues);
     $this->assertSame($queryExpected, $queryGenerated);
 }

 /**
  * @test
  */
 public function doesFindByTypeAndTableNameReturnObjects()
 {
     $testUid = rand(1, 1000);
     $testTable = uniqid('sys_collection_');
     $type = \TYPO3\CMS\Core\Collection\RecordCollectionRepository::TYPE_Static;
     $this->databaseMock->expects($this->once())->method('exec_SELECTgetRows')->will($this->returnCallback(array($this, 'getRowsCallback')));
     $this->getRowsCallbackReturnValue = array(array('uid' => $testUid, 'type' => $type, 'table_name' => $this->testTableName), array('uid' => $testUid, 'type' => $type, 'table_name' => $this->testTableName));
     $objects = $this->fixture->findByTypeAndTableName($type, $testTable);
     $this->assertEquals(2, count($objects));
     $this->assertInstanceOf('TYPO3\\CMS\\Core\\Collection\\StaticRecordCollection', $objects[0]);
     $this->assertInstanceOf('TYPO3\\CMS\\Core\\Collection\\StaticRecordCollection', $objects[1]);
 }

 /**
  * @test
  * @param array $tcaFieldConf
  * @dataProvider inputValueCheckDoesNotCallGetDateTimeFormatsForNonDatetimeFieldsDataProvider
  */
 public function inputValueCheckDoesNotCallGetDateTimeFormatsForNonDatetimeFields($tcaFieldConf)
 {
     $this->mockDatabaseConnection->expects($this->never())->method('getDateTimeFormats');
     $this->subject->checkValue_input(array(), '', $tcaFieldConf, array());
 }

 /**
  * @return void
  */
 protected function assertDatabaseWillNeverBeQueried()
 {
     $this->databaseMock->expects($this->never())->method('exec_SELECTgetRows');
 }