PHP Zend_Db_Select::expects方法代码示例

 protected function setUp()
 {
     $this->storeManager = $this->getMock('Magento\\Store\\Model\\StoreManagerInterface');
     $this->select = $this->getMock('Zend_Db_Select', ['from', 'where'], [], '', false);
     $this->adapter = $this->getMock('Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql', ['select', 'prepareSqlCondition', 'quoteIdentifier'], [], '', false);
     $this->resource = $this->getMockForAbstractClass('Magento\\Framework\\Model\\Resource\\Db\\AbstractDb', [], '', false, true, true, ['getReadConnection', '__wakeup', 'getMainTable', 'getTable']);
     $this->select->expects($this->any())->method('where')->will($this->returnSelf());
     $this->adapter->expects($this->any())->method('select')->will($this->returnValue($this->select));
     $this->adapter->expects($this->any())->method('quoteIdentifier')->will($this->returnArgument(0));
     $this->resource->expects($this->any())->method('getReadConnection')->will($this->returnValue($this->adapter));
     $this->resource->expects($this->any())->method('getMainTable')->will($this->returnValue('test_main_table'));
     $this->resource->expects($this->any())->method('getTable')->with('test_main_table')->will($this->returnValue('test_main_table'));
     $this->collection = (new ObjectManager($this))->getObject('Magento\\UrlRewrite\\Model\\Resource\\UrlRewriteCollection', ['storeManager' => $this->storeManager, 'resource' => $this->resource]);
 }

 /**
  * @param mixed $ignoreData
  * @param 'string' $ignoreSql
  * @dataProvider ignoresDataProvider
  * @return void
  */
 public function testAddStoreFilter($ignoreData, $ignoreSql)
 {
     $typeId = 1;
     $subjectId = 2;
     $subtype = 3;
     $limit = 0;
     $stores = [1, 2];
     $this->resourceMock->expects($this->once())->method('getCurrentStoreIds')->willReturn($stores);
     $this->selectMock->expects($this->at(0))->method('where')->with('event_type_id = ?', $typeId);
     $this->selectMock->expects($this->at(1))->method('where')->with('subject_id = ?', $subjectId);
     $this->selectMock->expects($this->at(2))->method('where')->with('subtype = ?', $subtype);
     $this->selectMock->expects($this->at(3))->method('where')->with('store_id IN(?)', $stores);
     $this->selectMock->expects($this->at(4))->method('where')->with($ignoreSql, $ignoreData);
     $this->collection->addRecentlyFiler($typeId, $subjectId, $subtype, $ignoreData, $limit);
 }

 /**
  * @param array $storeIds
  * @param array $parameters
  * @dataProvider storesDataProvider
  * @return void
  */
 public function testSetStoreIds($storeIds, $parameters)
 {
     $this->dbMock->expects($this->any())->method('getIfNullSql')->willReturn('text');
     $this->selectMock->expects($this->once())->method('columns')->with($parameters)->willReturnSelf();
     $this->collection->setStoreIds($storeIds);
 }

 /**
  * @dataProvider addExpressionFieldToSelectDataProvider
  */
 public function testAddExpressionFieldToSelect($alias, $expression, $fields, $expected)
 {
     $this->selectMock->expects($this->once())->method('columns')->with($expected);
     $this->assertTrue($this->uut->addExpressionFieldToSelect($alias, $expression, $fields) instanceof Uut);
 }

 public function testSetIdFilter()
 {
     $this->connectionMock->expects($this->once())->method('prepareSqlCondition')->with('main_table.option_id', ['in' => 1])->will($this->returnValue('main_table.option_id IN (1)'));
     $this->selectMock->expects($this->once())->method('where')->with('main_table.option_id IN (1)', null, 'TYPE_CONDITION')->will($this->returnSelf());
     $this->assertEquals($this->model, $this->model->setIdFilter(1));
 }