/** * @covers Zend\Db\Sql\Delete::getSqlString */ public function testGetSqlString() { $this->delete->from('foo') ->where('x = y'); $this->assertEquals('DELETE FROM "foo" WHERE x = y', $this->delete->getSqlString()); }
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; }