コード例 #1
0
    /**
     * @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());

    }
コード例 #2
0
 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;
 }