/** * test inserting a Crew and re-grabbing it form mySQL **/ public function testGetValidCrewByCrewId() { //count the number of rows and save it for later $numRows = $this->getConnection()->getRowCount("crew"); //create a new Crew and insert it into mySQL $crew = new Crew(null, $this->company->getCompanyId(), $this->VALID_CREWLOCATION); $crew->insert($this->getPDO()); //edit the crew and update it in mySQL $crew->update($this->getPDO()); //grab the data from mySQL and enforce the fields match our expectations $pdoCrew = Crew::getCrewByCrewId($this->getPDO(), $crew->getCrewId()); $this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("crew")); $this->assertEquals($pdoCrew->getCrewCompanyId(), $this->company->getCompanyId()); }