public function testFetchSingleByIdResult() { $data = array(array('id' => 42, 'firstname' => 'Manfred', 'lastname' => 'Mustermann', 'street' => 'Am Testen 123', 'postcode' => '54321', 'city' => 'Musterhausen', 'country' => 'de')); $mockDbStatement = $this->getMock('Zend\\Db\\Adapter\\Driver\\StatementInterface'); $mockDbStatement->expects($this->any())->method('execute')->will($this->returnValue($data)); $mockDbDriver = $this->getMock('Zend\\Db\\Adapter\\Driver\\DriverInterface'); $mockDbDriver->expects($this->any())->method('createStatement')->will($this->returnValue($mockDbStatement)); $mockDbAdapter = $this->getMock('Zend\\Db\\Adapter\\Adapter', null, array($mockDbDriver)); $customerTable = new CustomerTable($mockDbAdapter); $customerEntity = $customerTable->fetchSingleById(42); $this->assertInstanceOf('Customer\\Entity\\CustomerEntity', $customerEntity); $this->assertSame($data[0]['id'], $customerEntity->getId()); $this->assertSame($data[0]['firstname'], $customerEntity->getFirstname()); $this->assertSame($data[0]['lastname'], $customerEntity->getLastname()); $this->assertSame($data[0]['street'], $customerEntity->getStreet()); $this->assertSame($data[0]['postcode'], $customerEntity->getPostcode()); $this->assertSame($data[0]['city'], $customerEntity->getCity()); $this->assertSame($data[0]['country'], $customerEntity->getCountry()); }
public function testDeleteExistingCustomer() { $customerTable = new CustomerTable($this->adapter); $customerEntity = $customerTable->fetchSingleById(42); $customerTable->deleteCustomer($customerEntity); $queryTable = $this->getConnection()->createQueryTable('loadCustomersOrderedByLastname', 'SELECT * FROM customers WHERE id = "42";'); $this->assertEquals(0, $queryTable->getRowCount()); }