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));
}
