public function test_getQueryToSelect()
 {
     $res = $this->_obj->getQueryToSelect();
     /** @var \Magento\Framework\App\ResourceConnection $resource */
     $resource = \Magento\Framework\App\ObjectManager::getInstance()->get(\Magento\Framework\App\ResourceConnection::class);
     $conn = $resource->getConnection();
     $data = $conn->fetchAll($res);
 }
 public function test_getQueryToSelect()
 {
     /** === Setup Mocks === */
     // $result = $this->_conn->select();
     $mResult = $this->_mockDbSelect(['from', 'joinLeft', 'where']);
     $this->mConn->shouldReceive('select')->once()->andReturn($mResult);
     // ... $this->_resource->getTableName(...)
     $this->mResource->shouldReceive('getTableName');
     /** === Call and asserts  === */
     $res = $this->obj->getQueryToSelect();
     $this->assertTrue($res instanceof \Magento\Framework\DB\Select);
 }
 public function test_getSelectQuery()
 {
     /** === Setup Mocks === */
     // $result = $this->_conn->select();
     $mResult = $this->_mockDbSelect();
     $this->mConn->shouldReceive('select')->once()->andReturn($mResult);
     // $tblStock = [$asStock => $this->_resource->getTableName(Cfg::ENTITY_MAGE_CATALOGINVENTORY_STOCK)];
     // $tblWrhs = [$asWrhs => $this->_resource->getTableName(EntityWarehouse::ENTITY_NAME)];
     $this->mResource->shouldReceive('getTableName')->twice();
     // $result->from($tblStock, $cols);
     $mResult->shouldReceive('from', 'joinLeft');
     /** === Call and asserts  === */
     $this->obj->getQueryToSelect();
 }
 public function test_getQueryToSelect()
 {
     /** === Setup Mocks === */
     // $result = $this->_conn->select();
     $mQuery = $this->_mockDbSelect();
     $this->mConn->shouldReceive('select')->once()->andReturn($mQuery);
     // $tblWrhs = [$asWrhs => $this->_resource->getTableName(EntityWrhsLot::ENTITY_NAME)];
     // $tblOdoo = [$asOdoo => $this->_resource->getTableName(EntityLot::ENTITY_NAME)];
     $this->mResource->shouldReceive('getTableName')->twice();
     // $result->from($tblWrhs, $cols);
     $mQuery->shouldReceive('from')->once();
     // $result->joinLeft($tblOdoo, $on, $cols);
     $mQuery->shouldReceive('joinLeft')->once();
     /** === Call and asserts  === */
     $res = $this->obj->getQueryToSelect();
     $this->assertTrue($res instanceof \Magento\Framework\DB\Select);
 }