/** * Delete the given NGI and cascade delete all of the NGI's child entities. * These include Sites, Services, EndpointLocations, Downtimes that will be * orphaned, CertificationStatusLogs and Roles that previously linked to the * deleted owned entities. * * @param \NGI $ngi * @param \User $user - must be an admin user * @param boolean $logNgiSiteServiceInArchives Record the deletion of the ngi, * its child sites and services in the archive tables. * @throws \org\gocdb\services\Exception */ public function deleteNgi(\NGI $ngi, \User $user = null, $logNgiSiteServiceInArchives = true) { require_once __DIR__ . '/../DAOs/SiteDAO.php'; require_once __DIR__ . '/../DAOs/ServiceDAO.php'; require_once __DIR__ . '/../DAOs/NGIDAO.php'; require_once __DIR__ . '/ServiceService.php'; //Check the portal is not in read only mode, throws exception if it is $this->checkPortalIsNotReadOnlyOrUserIsAdmin($user); //Throws exception if user is not an administrator $this->checkUserIsAdmin($user); $this->em->getConnection()->beginTransaction(); try { $ngiDAO = new \NGIDAO(); $ngiDAO->setEntityManager($this->em); $siteDAO = new \SiteDAO(); $siteDAO->setEntityManager($this->em); $serviceDAO = new \ServiceDAO(); $serviceDAO->setEntityManager($this->em); //Archive ngi if ($logNgiSiteServiceInArchives) { $ngiDAO->addNGIToArchive($ngi, $user); } //delete each child site foreach ($ngi->getSites() as $site) { //Archive site if ($logNgiSiteServiceInArchives) { $siteDAO->addSiteToArchive($site, $user); } //delete each child service foreach ($site->getServices() as $service) { //archive the srvice if ($logNgiSiteServiceInArchives) { $serviceDAO->addServiceToArchive($service, $user); } //remove the service (and any downtimes only associated with it) $serviceDAO->removeService($service); } //remove the site $siteDAO->removeSite($site); } //remove the NGI $ngiDAO->removeNGI($ngi); $this->em->flush(); $this->em->getConnection()->commit(); } catch (\Exception $e) { $this->em->getConnection()->rollback(); $this->em->close(); throw $e; } }
public function deleteEndpoint(\EndpointLocation $endpoint, \User $user) { require_once __DIR__ . '/../DAOs/ServiceDAO.php'; //Check the portal is not in read only mode, throws exception if it is $this->checkPortalIsNotReadOnlyOrUserIsAdmin($user); $service = $endpoint->getService(); // check user has permission to edit endpoint's service $this->validateAddEditDeleteActions($user, $service); $this->em->getConnection()->beginTransaction(); try { $serviceDAO = new \ServiceDAO(); $serviceDAO->setEntityManager($this->em); $serviceDAO->removeEndpoint($endpoint); $this->em->flush(); $this->em->getConnection()->commit(); } catch (\Exception $e) { $this->em->getConnection()->rollback(); $this->em->close(); throw $e; } }
/** * Test the <code>$serviceDAO->removeEndpoint($endpoint)</code> method. */ public function testServiceDAORemoveEndpoint() { print __METHOD__ . "\n"; // create a linked entity graph as beow: // // se -----| (1 service) // / | \ | // el1 el2 el3 | (3 endpoints) // | \ | / | // dt0 dt1 ----| (1 downtime) $dt1 = new Downtime(); $dt1->setDescription('downtime description'); $dt1->setSeverity("WARNING"); $dt1->setClassification("UNSCHEDULED"); $dt0 = new Downtime(); $dt0->setDescription('downtime description'); $dt0->setSeverity("WARNING"); $dt0->setClassification("UNSCHEDULED"); $se = TestUtil::createSampleService('service1'); $el1 = TestUtil::createSampleEndpointLocation(); $el2 = TestUtil::createSampleEndpointLocation(); $el3 = TestUtil::createSampleEndpointLocation(); $se->addEndpointLocationDoJoin($el1); $se->addEndpointLocationDoJoin($el2); $se->addEndpointLocationDoJoin($el3); //$se->_addDowntime($dt1); // we don't call this in client code ! $dt1->addEndpointLocation($el1); $dt1->addEndpointLocation($el2); $dt1->addEndpointLocation($el3); $dt1->addService($se); $dt0->addEndpointLocation($el1); //$dt0->addService($se); // note we don't add this relationship for purposes of the test // persist and flush $this->em->persist($se); $this->em->persist($el1); $this->em->persist($el2); $this->em->persist($el3); $this->em->persist($dt1); $this->em->persist($dt0); $this->em->flush(); // create DAO to test $serviceDao = new ServiceDAO(); $serviceDao->setEntityManager($this->em); // remove first endpoint causing dt0 to be orphaned $serviceDao->removeEndpoint($el1); $this->em->flush(); // Assert expected object graph // se -----| (1 service) // | \ | // el2 el3 | (2 endpoints) // | / | // dt0 dt1-----| (2 downtime) // $testConn = $this->getConnection(); $result = $testConn->createQueryTable('results_table', "SELECT * FROM EndpointLocations"); $this->assertTrue($result->getRowCount() == 2); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes"); $this->assertTrue($result->getRowCount() == 2); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes_EndpointLocations"); $this->assertTrue($result->getRowCount() == 2); // Assert expected object graph in ORM Mem $this->assertEquals(1, count($el2->getDowntimes())); $this->assertEquals(1, count($el3->getDowntimes())); $this->assertEquals(2, count($se->getEndpointLocations())); $this->assertEquals(1, count($se->getDowntimes())); $this->assertEquals(2, count($dt1->getEndpointLocations())); $this->assertEquals(1, count($dt1->getServices())); // remove another el $serviceDao->removeEndpoint($el2); $this->em->flush(); // Assert expected object graph in DB // se -----| (1 service) // \ | // el3 | (1 endpoints) // / | // dt0 dt1-----| (2 downtime) // $testConn = $this->getConnection(); $result = $testConn->createQueryTable('results_table', "SELECT * FROM EndpointLocations"); $this->assertTrue($result->getRowCount() == 1); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes"); $this->assertTrue($result->getRowCount() == 2); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes_EndpointLocations"); $this->assertTrue($result->getRowCount() == 1); // Assert expected object graph in ORM Mem $this->assertEquals(1, count($el3->getDowntimes())); $this->assertEquals(1, count($se->getEndpointLocations())); $this->assertEquals(1, count($se->getDowntimes())); $this->assertEquals(1, count($dt1->getEndpointLocations())); $this->assertEquals(1, count($dt1->getServices())); // remove another el $serviceDao->removeEndpoint($el3); $this->em->flush(); // Assert expected object graph in DB // se -----| (1 service) // | // | (1 endpoints) // | // dt0 dt1-----| (2 downtime) // $testConn = $this->getConnection(); $result = $testConn->createQueryTable('results_table', "SELECT * FROM EndpointLocations"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes"); $this->assertTrue($result->getRowCount() == 2); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes_EndpointLocations"); $this->assertTrue($result->getRowCount() == 0); // Assert expected object graph in ORM Mem $this->assertEquals(0, count($se->getEndpointLocations())); $this->assertEquals(1, count($se->getDowntimes())); $this->assertEquals(0, count($dt1->getEndpointLocations())); $this->assertEquals(1, count($dt1->getServices())); }
/** * Delete both Services but not the ngi * @see testRolesCascadeDelete_OnOwnedEntityDeletion1 */ public function testRolesCascadeDelete_OnOwnedEntityDeletion2() { print __METHOD__ . "\n"; include __DIR__ . '/resources/sampleFixtureData1.php'; $siteDAO = new SiteDAO(); $serviceDAO = new ServiceDAO(); $ngiDAO = new NGIDAO(); $siteDAO->setEntityManager($this->em); $serviceDAO->setEntityManager($this->em); $ngiDAO->setEntityManager($this->em); // ordering of removal is NOT significant here ! $serviceDAO->removeService($service1); $serviceDAO->removeService($service2); $siteDAO->removeSite($site1); $siteDAO->removeSite($site2); //$ngiDAO->removeNGI($ngi); // don't remove NGI $this->em->flush(); // Need to clear the identity map (all objects become detached) so that // when we re-fetch the user, it will be looked from db not served by entity map $this->em->clear(); // Need to re-fetch the user from the DB again, if don't, then user already // has his eargerly fetched roles present in UserProxy object $userWithRoles = $this->em->find("User", $userId); // user should have 2 remaining roles still from ngi $this->assertEquals(2, count($userWithRoles->getRoles())); $testConn = $this->getConnection(); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Roles"); $this->assertTrue($result->getRowCount() == 2); $result = $testConn->createQueryTable('results_table', "SELECT * FROM NGIs"); $this->assertTrue($result->getRowCount() == 1); }
/** * Test the ServiceDAO->removeService(); * Impt: A cascade=remove is configured between Service and EndpointLocation * so that when a Service is removed, its associated ELs are also removed. * <p> * Note, no cascade remove behaviour is configured between EndpointLocation and * Downtime because we need to have fine-grained programmatic control over * which downtimes are deleted when a service EL is deleted (i.e. we only * want to delete those DTs that exclusively link to one EL only and which * would subsequently be orphaned). We do this managed deletion of DTs in ServiceDAO->removeService(); */ public function testServiceDAO_removeService() { print __METHOD__ . "\n"; include __DIR__ . '/resources/sampleFixtureData1.php'; // Impt: When deleting a service, we can't rely solely on the // 'onDelete=cascade' defined on the 'EndpointLocation->service' // to correctly cascade-delete the EL. This is because downtimes can also be linked // to the EL. Therefore, if we don't invoke an $em->remove() on the EL // (either via cascade="remove" or manually invoking em->remove() on each EL), // Doctrine will not have flagged the EL as removed and so will not automatically delete the // relevant row(s) in 'DOWNTIMES_ENDPOINTLOCATIONS' join table. // This would cause a FK integrity/violation constraint exception // on the 'DOWNTIMES_ENDPOINTLOCATIONS.ENDPOINTLOCATION_ID' FK column. // This is why we need to do a managed delete using the ServiceDAO $serviceDao = new ServiceDAO(); $serviceDao->setEntityManager($this->em); $serviceDao->removeService($service1); $this->em->flush(); // use DB connection to check data has been deleted $con = $this->getConnection(); $result = $con->createQueryTable('results_table', "SELECT * FROM EndpointLocations"); $this->assertTrue($result->getRowCount() == 0); $result = $con->createQueryTable('results_table', "SELECT * FROM Downtimes"); $this->assertTrue($result->getRowCount() == 0); }