function delete($id)
{
$req_mgr = new requirement_mgr($this->db);
// Delete Custom fields
$this->cfield_mgr->remove_all_design_values_from_node($id);
$result = $this->attachmentRepository->deleteAttachmentsFor($id, "req_specs");
// delete requirements (one type req spec children) with all related data
// coverage, attachments, custom fields, etc
$requirements_info = $this->get_requirements($id);
if (!is_null($requirements_info)) {
$items = null;
foreach ($requirements_info as $req) {
$items[] = $req["id"];
}
$req_mgr->delete($items);
}
// delete specification itself
$sql = "DELETE FROM {$this->object_table} WHERE id = {$id}";
$result = $this->db->exec_query($sql);
$sql = "DELETE FROM {$this->tables['nodes_hierarchy']} WHERE id = {$id}";
$result = $this->db->exec_query($sql);
if ($result) {
$result = 'ok';
} else {
$result = 'The DELETE SRS request fails.';
}
return $result;
}
