public function go()
{
// Tree Option
$this->newVersion->setFromOldVersion($this->oldVersion);
// As we call flush in this function, make sure new version will definetly be part of that.
$this->doctrine->persist($this->newVersion);
// repos
$nodeRepo = $this->doctrine->getRepository('QuestionKeyBundle:Node');
$nodeOptionRepo = $this->doctrine->getRepository('QuestionKeyBundle:NodeOption');
$libraryContentRepo = $this->doctrine->getRepository('QuestionKeyBundle:LibraryContent');
$nodeHasLibraryContentRepo = $this->doctrine->getRepository('QuestionKeyBundle:NodeHasLibraryContent');
$treeStartingNodeRepo = $this->doctrine->getRepository('QuestionKeyBundle:TreeVersionStartingNode');
// Library Content
$libraryContents = array();
foreach ($libraryContentRepo->findByTreeVersion($this->oldVersion) as $libraryContent) {
$libraryContents[$libraryContent->getPublicId()] = new LibraryContent();
$libraryContents[$libraryContent->getPublicId()]->setTitleAdmin($libraryContent->getTitleAdmin());
$libraryContents[$libraryContent->getPublicId()]->setBodyHTML($libraryContent->getBodyHTML());
$libraryContents[$libraryContent->getPublicId()]->setBodyText($libraryContent->getBodyText());
$libraryContents[$libraryContent->getPublicId()]->setTreeVersion($this->newVersion);
$libraryContents[$libraryContent->getPublicId()]->setPublicId($libraryContent->getPublicId());
$this->doctrine->persist($libraryContents[$libraryContent->getPublicId()]);
}
// Nodes
$nodes = $nodeRepo->findByTreeVersion($this->oldVersion);
$newNodes = array();
foreach ($nodes as $node) {
$newNodes[$node->getId()] = new Node();
$newNodes[$node->getId()]->setTreeVersion($this->newVersion);
$newNodes[$node->getId()]->setTitle($node->getTitle());
$newNodes[$node->getId()]->setBodyText($node->getBodyText());
$newNodes[$node->getId()]->setBodyHTML($node->getBodyHTML());
$newNodes[$node->getId()]->setPublicId($node->getPublicId());
$newNodes[$node->getId()]->setFromOldVersion($node);
$this->doctrine->persist($newNodes[$node->getId()]);
$sort = 0;
foreach ($libraryContentRepo->findForNode($node) as $oldLibraryContent) {
// We create a NodeHasLibraryContent record directly instead of using
// $nodeHasLibraryContentRepo->addLibraryContentToNode($libraryContents[$oldLibraryContent->getPublicId()], $newNodes[$node->getId()]);
// because it's much more efficient in DB queries. Also, given some records might not have saved I'm not sure addLibraryContentToNode() would find the correct sort values anyway.
$nodeHasLibraryContent = new NodeHasLibraryContent();
$nodeHasLibraryContent->setLibraryContent($libraryContents[$oldLibraryContent->getPublicId()]);
$nodeHasLibraryContent->setNode($newNodes[$node->getId()]);
$nodeHasLibraryContent->setSort($sort++);
$this->doctrine->persist($nodeHasLibraryContent);
}
}
// Node Options
$nodeOptions = $nodeOptionRepo->findAllNodeOptionsForTreeVersion($this->oldVersion);
foreach ($nodeOptions as $nodeOption) {
$newNodeOption = new NodeOption();
$newNodeOption->setTreeVersion($this->newVersion);
$newNodeOption->setNode($newNodes[$nodeOption->getNode()->getId()]);
$newNodeOption->setDestinationNode($newNodes[$nodeOption->getDestinationNode()->getId()]);
$newNodeOption->setTitle($nodeOption->getTitle());
$newNodeOption->setBodyHTML($nodeOption->getBodyHTML());
$newNodeOption->setBodyText($nodeOption->getBodyText());
$newNodeOption->setSort($nodeOption->getSort());
$newNodeOption->setPublicId($nodeOption->getPublicId());
$newNodeOption->setFromOldVersion($nodeOption);
$this->doctrine->persist($newNodeOption);
}
// Tree Start
$treeStartingNode = $treeStartingNodeRepo->findOneByTreeVersion($this->oldVersion);
if ($treeStartingNode) {
// we have to flush at this point otherwise when we try and persist at the next stage you get an error.
$this->doctrine->flush();
$newTreeVersionStartingNode = new TreeVersionStartingNode();
$newTreeVersionStartingNode->setTreeVersion($this->newVersion);
$newTreeVersionStartingNode->setNode($newNodes[$treeStartingNode->getNode()->getId()]);
$this->doctrine->persist($newTreeVersionStartingNode);
}
// final flush
$this->doctrine->flush();
}
