public function testTreeOperations() { $newNode1 = new Tree\Node('abc', 'node1', $this->_tree); $this->_tree->addNode($newNode1); $newNode2 = new Tree\Node('def', 'node2', $this->_tree); $this->_tree->addNode($newNode2, $newNode1); $newNode3 = new Tree\Node('ghi', 'node3', $this->_tree); $this->_tree->addNode($newNode3, $newNode1); $data1 = ['j', 'k', 'l']; $this->_tree->appendChild($data1, $newNode3); $newNode4 = new Tree\Node('mno', 'node4', $this->_tree); $this->_tree->appendChild($newNode4, $newNode3); $this->_tree->removeNode($newNode4); $this->_tree->removeNode($newNode3); $this->_tree->removeNode($newNode2); $this->_tree->removeNode($newNode1); $this->assertEmpty($this->_tree->getNodes()->getNodes()); }
/** * @param Node $node * @return $this * @throws \Exception */ public function removeNode($node) { // For reorder old node branch $dataReorderOld = [$this->_orderField => new \Zend_Db_Expr($this->_conn->quoteIdentifier($this->_orderField) . '-1')]; $conditionReorderOld = $this->_conn->quoteIdentifier($this->_parentField) . '=' . $node->getData($this->_parentField) . ' AND ' . $this->_conn->quoteIdentifier($this->_orderField) . '>' . $node->getData($this->_orderField); $this->_conn->beginTransaction(); try { $condition = $this->_conn->quoteInto("{$this->_idField}=?", $node->getId()); $this->_conn->delete($this->_table, $condition); // Update old node branch $this->_conn->update($this->_table, $dataReorderOld, $conditionReorderOld); $this->_conn->commit(); } catch (\Exception $e) { $this->_conn->rollBack(); throw new \Exception('Can\'t remove tree node'); } parent::removeNode($node); return $this; }