/** * Test select() method retrieves all _candidate and related info * * @return void * @covers Candidate::select * @covers Candidate::getData * @covers Candidate::getListOfTimePoints */ public function testSelectRetrievesCandidateInfo() { $this->_setUpTestDoublesForSelectCandidate(); $this->_candidate->select(969664); //validate _candidate Info $this->assertEquals($this->_candidateInfo, $this->_candidate->getData()); //validate list of time points $expectedTimepoints = array(); foreach ($this->_listOfTimePoints as $oneRow) { $expectedTimepoints[] = $oneRow['ID']; } $this->assertEquals($expectedTimepoints, $this->_candidate->getListOfTimePoints()); }
echo "Example: php delete_candidate 608858 SEA0252\n"; die; } else { $DCCID = $argv[1]; $PSCID = $argv[2]; } if ($DB->pselectOne("SELECT COUNT(*) FROM candidate WHERE CandID = :cid AND PSCID = :pid ", array('cid' => $DCCID, 'pid' => $PSCID)) == 0) { echo "The Candid : {$DCCID} AND PSCID : {$PSCID} Doesn't Exist in " . "the database\n"; die; } //Find candidate... $candidate = new Candidate(); $candidate->select($DCCID); //find the candidate with the given DCCID //find sessions $sessions = $candidate->getListOfTimePoints(); if (is_null($sessions) || empty($sessions)) { echo "There are no coressponding session for Candid : {$DCCID} \n"; die; } echo "Dropping all DB entries for candidate DCCID: " . $DCCID . "And PSCID:" . $PSCID . "\n"; //find the test_names and commentIDs $query = "SELECT ID, Test_name, CommentID FROM flag WHERE SessionID in (" . implode(" , ", $sessions) . ")"; $instruments = $DB->pselect($query, array()); //delete the sessions $DB->delete("session", array("CandID" => $DCCID)); //delete each instrument table entry foreach ($instruments as $instrument) { //delete the entry from the instrument table $DB->delete($instrument['Test_name'], array("CommentID" => $instrument['CommentID'])); //delete from flag