/** * Delete the parent NGI and ensure all sites, servcies, endponts and downtimes * are deleted leaving only the orphan dowmtime. */ public function testNgiService_removeNgi() { print __METHOD__ . "\n"; include __DIR__ . '/resources/sampleFixtureData4.php'; $adminUser = TestUtil::createSampleUser('some', 'admin', '/some/admin'); $adminUser->setAdmin(TRUE); $this->em->persist($adminUser); $ngiService = new org\gocdb\services\NGI(); $ngiService->setEntityManager($this->em); $ngiService->deleteNgi($ngi, $adminUser, FALSE); // 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() == 1); // orphanDT $result = $con->createQueryTable('results_table', "SELECT * FROM Sites"); $this->assertTrue($result->getRowCount() == 0); // site2 }
/** * Test the NGI service deleteNGI() method which recursively deletes child * sites and services, roles etc. */ public function testNgiService_deleteNgi() { print __METHOD__ . "\n"; include __DIR__ . '/resources/sampleFixtureData1.php'; // create an admin user (required to call the NGI service) $adminUser = TestUtil::createSampleUser('some', 'admin', '/some/admin'); $adminUser->setAdmin(TRUE); $this->em->persist($adminUser); // Now delete the ngi using the NGI service. $ngiService = new org\gocdb\services\NGI(); $ngiService->setEntityManager($this->em); $ngiService->deleteNgi($ngi, $adminUser, FALSE); // since we deleted the NGI, we expect an empty DB ! $result = $testConn->createQueryTable('results_table', "SELECT * FROM Roles"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM NGIs"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Sites"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Services"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM Downtimes"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM EndpointLocations"); $this->assertTrue($result->getRowCount() == 0); $result = $testConn->createQueryTable('results_table', "SELECT * FROM CertificationStatusLogs"); $this->assertTrue($result->getRowCount() == 0); }
public function testNgiService_removeNgi() { print __METHOD__ . "\n"; include __DIR__ . '/resources/sampleFixtureData1.php'; $adminUser = TestUtil::createSampleUser('some', 'admin', '/some/admin'); $adminUser->setAdmin(TRUE); $this->em->persist($adminUser); $ngiService = new org\gocdb\services\NGI(); $ngiService->setEntityManager($this->em); $ngiService->deleteNgi($ngi, $adminUser, FALSE); }