/**
* Test for getVersion() method
*
* @return void
*/
public function testGetVersion()
{
$model = $this->objectManager->create('Magento\\Framework\\Mview\\View\\Changelog', ['resource' => $this->resource]);
$model->setViewId('test_view_id_2');
$model->create();
$this->assertEquals(0, $model->getVersion());
$changelogName = $this->resource->getTableName($model->getName());
$this->connection->insert($changelogName, [$model->getColumnName() => mt_rand(1, 200)]);
$this->assertEquals($this->connection->lastInsertId($changelogName, 'version_id'), $model->getVersion());
$model->drop();
}
/**
* @param Node $data
* @param Node $parentNode
* @param Node $prevNode
* @return Node
*/
public function appendChild($data, $parentNode, $prevNode = null)
{
$orderSelect = $this->_conn->select();
$orderSelect->from($this->_table, new \Zend_Db_Expr('MAX(' . $this->_conn->quoteIdentifier($this->_orderField) . ')'))->where($this->_conn->quoteIdentifier($this->_parentField) . '=' . $parentNode->getId());
$order = $this->_conn->fetchOne($orderSelect);
$data[$this->_parentField] = $parentNode->getId();
$data[$this->_levelField] = $parentNode->getData($this->_levelField) + 1;
$data[$this->_orderField] = $order + 1;
$this->_conn->insert($this->_table, $data);
$data[$this->_idField] = $this->_conn->lastInsertId();
return parent::appendChild($data, $parentNode, $prevNode);
}
/**
* Create $total Magento customers with emails "customer_$i[at]test.com" and save mapping to MageId into
* $this->_testMageCustomers & $this->_testMageCustomersReverted
*
* ATTENTION: There is warning "Test method "_createMageCustomers" in test class "..." is not public."
* in case of method's visibility is 'protected' (after $total argument was added).
*
* @param int $total total count of the Magento customers to be created.
*/
protected function _createMageCustomers($total = 13)
{
$tbl = $this->_resource->getTableName(Cfg::ENTITY_MAGE_CUSTOMER);
for ($i = 1; $i <= $total; $i++) {
$email = "customer_{$i}@test.com";
$this->_conn->insert($tbl, [Cfg::E_CUSTOMER_A_EMAIL => $email]);
$id = $this->_conn->lastInsertId($tbl);
$this->_mapCustomerMageIdByIndex[$i] = $id;
$this->_mapCustomerIndexByMageId[$id] = $i;
$this->_logger->debug("New Magento customer #{$i} is added with ID={$id} ({$email}).");
}
$this->_logger->debug("Total {$total} customer were added to Magento.");
}
/**
* Clear table and add root element
*
* @param array $data
* @return string
*/
public function clear($data = [])
{
// clearing table
$this->_db->query('TRUNCATE ' . $this->_table);
// prepare data for root element
$data[$this->_pid] = 0;
$data[$this->_left] = 1;
$data[$this->_right] = 2;
$data[$this->_level] = 0;
try {
$this->_db->insert($this->_table, $data);
} catch (\PDOException $e) {
echo $e->getMessage();
}
return $this->_db->lastInsertId();
}
/**
* Retrieve next value
*
* @return string
*/
public function getNextValue()
{
$this->adapter->insert($this->meta->getSequenceTable(), []);
$this->lastIncrementId = $this->adapter->lastInsertId($this->meta->getSequenceTable());
return $this->getCurrentValue();
}
