/**
* @covers Zend\Db\Sql\Delete::prepareStatement
*/
public function testPrepareStatement()
{
$mockDriver = $this->getMock('Zend\\Db\\Adapter\\Driver\\DriverInterface');
$mockAdapter = $this->getMock('Zend\\Db\\Adapter\\Adapter', null, array($mockDriver));
$mockStatement = $this->getMock('Zend\\Db\\Adapter\\Driver\\StatementInterface');
$mockStatement->expects($this->at(2))->method('setSql')->with($this->equalTo('DELETE FROM "foo" WHERE x = y'));
$this->delete->from('foo')->where('x = y');
$this->delete->prepareStatement($mockAdapter, $mockStatement);
}
public function unlink($contactId, $addressId)
{
$adapter = $this->getDbAdapter();
$statement = $adapter->createStatement();
$where = new Where();
$where->equalTo('contact_id', $contactId)->equalTo('address_id', $addressId);
$delete = new Delete();
$delete->from('contact_addresses')->where($where);
$delete->prepareStatement($adapter, $statement);
$result = $statement->execute();
return $result;
}
