public function testInsertNewCustomer()
 {
     $customerEntity = new CustomerEntity();
     $customerEntity->setId(99);
     $customerEntity->setFirstname('Horst');
     $customerEntity->setLastname('Hrubesch');
     $customerEntity->setStreet('Am Köpfen 124');
     $customerEntity->setPostcode('21451');
     $customerEntity->setCity('Hamburg');
     $customerEntity->setCountry('de');
     $customerTable = new CustomerTable($this->adapter);
     $customerTable->insertCustomer($customerEntity);
     $queryTable = $this->getConnection()->createQueryTable('loadCustomersOrderedByLastname', 'SELECT * FROM customers WHERE id = "99";');
     $expectedRow = $queryTable->getRow(0);
     $hydrator = new CustomerHydrator();
     $customerRow = $hydrator->extract($customerEntity);
     $this->assertEquals($expectedRow, $customerRow);
 }