final public function delete($extraWhereClause = '')
    {
        if (self::RSMODE_CONNECTED_EDIT !== $this->mode) {
            throw new \LogicException('Recordset: The recordset is not on edit mode [current: ' . $this->mode . ']');
        }
        // check the entity is not empty
        if ('' === $this->entity) {
            throw new \LogicException('Recordset: The recordset does not have a valid unique entity');
        }
        $sql = $this->sqlDelete($extraWhereClause);
        $altered = $this->dbal->execute($sql);
        if (0 === $altered) {
            $this->logger->warning(print_r([
                'message' => "Recordset: The statement '$sql' return zero affected rows"
                    . ' but it should delete at least one record',
                'entity' => $this->entity,
                'extraWhereClause' => $extraWhereClause,
                'original' => $this->originalValues,
            ], true));
        }
        return $altered;
    }
final public function delete($extraWhereClause = '')
    {
        if (self::RSMODE_CONNECTED_EDIT !== $this->mode) {
            throw new \LogicException('Recordset: The recordset is not on edit mode [current: ' . $this->mode . ']');
        }
        // check the entity is not empty
        if ('' === $this->entity) {
            throw new \LogicException('Recordset: The recordset does not have a valid unique entity');
        }
        $sql = $this->sqlDelete($extraWhereClause);
        $altered = $this->dbal->execute($sql);
        if (0 === $altered) {
            $this->logger->warning(print_r([
                'message' => "Recordset: The statement '$sql' return zero affected rows"
                    . ' but it should delete at least one record',
                'entity' => $this->entity,
                'extraWhereClause' => $extraWhereClause,
                'original' => $this->originalValues,
            ], true));
        }
        return $altered;
    }
final public function delete ( $ extraWhereClause = '' ) { if ( self :: RSMODE_CONNECTED_EDIT !== $ this -> mode ) { throw new \ LogicException ( 'Recordset: The recordset is not on edit mode [current: ' . $ this -> mode . ']' ) ; } // check the entity is not empty if ( '' === $ this -> entity ) { throw new \ LogicException ( 'Recordset: The recordset does not have a valid unique entity' ) ; } $ sql = $ this -> sqlDelete ( $ extraWhereClause ) ; $ altered = $ this -> dbal -> execute ( $ sql ) ; if ( 0 === $ altered ) { $ this -> logger -> warning ( print_r ( [ 'message' => "Recordset: The statement '$sql' return zero affected rows" . ' but it should delete at least one record' , 'entity' => $ this -> entity , 'extraWhereClause' => $ extraWhereClause , 'original' => $ this -> originalValues , ] , true ) ) ; } return $ altered ; }
Build and execute the SQL DELETE sentence
Return how many rows where altered
@param string $extraWhereClause
@return int|false
Build and execute the SQL DELETE sentence Return how many rows where altered