public function fetchManyForEventId()
{
$data = array('id' => '42', 'person_id' => '44');
$expectedSelect = $this->getSelect('costs');
$expectedSelect->where(['cost_person_id=?' => $data['id']]);
$resultSet = $this->createResultSetFromDataWithPrefix($data, 'cost_');
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($resultSet)->once();
$costModel = $this->costsMapper->createModelFromData($data);
$expectedModelsArray = [$costModel, $costModel, $costModel];
$returnedModelsArray = $this->costsMapper->fetchManyForEventId($data['person_id']);
$this->assertEquals($expectedModelsArray, $returnedModelsArray);
}
public function testFetchManyForContactEmail()
{
$data = array('email' => '*****@*****.**');
$expectedModel = $this->peopleMapper->createModelFromData($data);
/*@var $expectedModel \People\Model\PersonModel */
$expectedSelect = $this->getSelect('people');
$expectedSelect->where->like('person_contact_email', "%{$data['email']}%");
$resultSet = $this->createResultSetFromDataWithPrefix($data, 'person_');
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($resultSet)->once();
$returnedModelsArray = $this->peopleMapper->fetchManyForContactEmail($data['email']);
$this->assertEquals([$expectedModel], $returnedModelsArray);
}
public function testFetchOneForAddress()
{
$addressArray = array('address_1' => '2530 Gilbert Ave', 'address_2' => '', 'city' => 'Missoula', 'state' => 'MT', 'postal_code' => '59801', 'country' => 'USA');
$expectedModel = $this->venuesMapper->createModelFromData($addressArray);
$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->createResultSetFromDataWithPrefix($addressArray, 'venue_');
$this->mockTableGateway->shouldReceive('selectWith')->with($this->compareSqlString($expectedSelect))->andReturn($resultSet)->once();
$returnedModel = $this->venuesMapper->fetchOneForAddress($addressArray);
$this->assertEquals($expectedModel, $returnedModel);
}
