/** * @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; }