public function testFetchOneForEmailAndSecurityKey()
{
$data = array('email' => '*****@*****.**', 'security_key' => 'udKdSEiRgIF3T11q6S5o8MmW07NlAS6P');
$expectedSelect = $this->getSelect('member_password_resets');
$expectedSelect->where(['mpr_email = ?' => $data['email'], 'mpr_security_key = ?' => $data['security_key']]);
$expectedMemberPasswordResetModel = $this->getMockMemberPasswordResetsMapper()->createModelFromData($data);
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($this->createResultSetFromDataWithPrefix($data, 'mpr_'))->once();
$returnedModel = $this->memberPasswordResetsMapper->fetchOneForEmailAndSecurityKey($data['email'], $data['security_key']);
$this->assertEquals($expectedMemberPasswordResetModel, $returnedModel);
}
public function testFetchManyForEventIdNoneFound()
{
$data = array('id' => '45', 'person_id' => '34');
$expectedSelect = $this->getSelect('costs');
$expectedSelect->where(['cost_person_id=?' => $data['person_id']]);
$resultSet = $this->createEmptyResultSet();
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($resultSet)->once();
$returnedModelsArray = $this->costsMapper->fetchManyForEventId($data['person_id']);
$this->assertEquals([], $returnedModelsArray);
}
public function testFetchManyForContactEmailNoneFound()
{
$data = array('email' => '*****@*****.**');
$expectedSelect = $this->getSelect('people');
$expectedSelect->where->like('person_contact_email', "%{$data['email']}%");
$resultSet = $this->createEmptyResultSet();
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($resultSet)->once();
$returnedModelsArray = $this->peopleMapper->fetchManyForContactEmail($data['email']);
$this->assertEquals([], $returnedModelsArray);
}
public function testFetchOneForAddressNoneFound()
{
$addressArray = array('address_1' => '2530 Gilbert Ave', 'address_2' => '', 'city' => 'Missoula', 'state' => 'MT', 'postal_code' => '59801', 'country' => 'USA');
$expectedSelect = $this->getSelect('venues');
$expectedSelect->where(array('venue_address_1' => $addressArray['address_1'], 'venue_city' => $addressArray['city'], 'venue_state' => $addressArray['state'], 'venue_postal_code' => $addressArray['postal_code'], 'venue_country' => $addressArray['country']));
$resultSet = $this->createEmptyResultSet();
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($resultSet)->once();
$returnedModel = $this->venuesMapper->fetchOneForAddress($addressArray);
$this->assertEquals(null, $returnedModel);
}