/**
* test grabbing all Requests
**/
public function testGetAllValidRequests()
{
// count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("request");
// create a new Request and insert to into mySQL
$request = new Request(null, $this->requestor->getUserId(), $this->admin->getUserId(), $this->VALID_REQUESTTIMESTAMP, $this->VALID_REQUESTACTIONTIMESTAMP, $this->requestApprove, $this->VALID_REQUESTREQUESTORTEXT, $this->VALID_REQUESTADMINTEXT);
$request->insert($this->getPDO());
// grab the data from mySQL and enforce the fields match our expectations
$results = Request::getAllRequests($this->getPDO());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("request"));
$this->assertCount(1, $results);
$this->assertContainsOnlyInstancesOf("Edu\\Cnm\\TimeCrunchers\\Request", $results);
// grab the result from the array and validate it
$pdoRequest = $results[0];
$this->assertEquals($pdoRequest->getRequestRequestorId(), $this->requestor->getUserId());
$this->assertEquals($pdoRequest->getRequestAdminId(), $this->admin->getUserId());
$this->assertEquals($pdoRequest->getRequestTimeStamp(), $this->VALID_REQUESTTIMESTAMP);
$this->assertEquals($pdoRequest->getRequestActionTimeStamp(), $this->VALID_REQUESTACTIONTIMESTAMP);
$this->assertEquals($pdoRequest->getRequestApprove(), $this->requestApprove);
$this->assertEquals($pdoRequest->getRequestRequestorText(), $this->VALID_REQUESTREQUESTORTEXT2);
$this->assertEquals($pdoRequest->getRequestAdminText(), $this->VALID_REQUESTADMINTEXT);
}
/**
* test inserting a Access and regrabbing it from mySQL
**/
public function testGetValidUserByUserId()
{
//count the number of rows and save it for later
$numRows = $this->getConnection()->getRowCount("user");
//create a new $user and insert into mySQL
$user = new User(null, $this->company->getCompanyId(), $this->crew->getCrewId(), $this->access->getAccessId(), $this->VALID_USERPHONE, $this->VALID_USERFIRSTNAME, $this->VALID_USERLASTNAME, $this->VALID_USEREMAIL, $this->VALID_USERACTIVATION, $this->VALID_USERHASH, $this->VALID_USERSALT);
$user->insert($this->getPDO());
//grab from the mySQL and enforce the fields match our expectations
$pdoUser = User::getUserByUserId($this->getPDO(), $user->getUserId());
$this->assertEquals($numRows + 1, $this->getConnection()->getRowCount("user"));
$this->assertEquals($pdoUser->getUserCompanyId(), $this->company->getCompanyId());
$this->assertEquals($pdoUser->getUserCrewId(), $this->crew->getCrewId());
$this->assertEquals($pdoUser->getUserAccessId(), $this->access->getAccessId());
$this->assertSame($pdoUser->getUserPhone(), $this->VALID_USERPHONE);
$this->assertSame($pdoUser->getUserFirstName(), $this->VALID_USERFIRSTNAME);
$this->assertSame($pdoUser->getUserLastName(), $this->VALID_USERLASTNAME);
$this->assertSame($pdoUser->getUserEmail(), $this->VALID_USEREMAIL);
$this->assertEquals($pdoUser->getUserActivation(), $this->VALID_USERACTIVATION);
$this->assertEquals($pdoUser->getUserHash(), $this->VALID_USERHASH);
$this->assertEquals($pdoUser->getUserSalt(), $this->VALID_USERSALT);
}
