function chado_project_delete

2.x tripal_project.chado_node.inc chado_project_delete($node)
3.x tripal_project.chado_node.inc chado_project_delete($node)
1.x tripal_project.module chado_project_delete($node)

Implementation of hook_delete().

Parameters

$node: The node which is to be deleted, only chado project and chado_project need to be dealt with since the drupal node is deleted automagically

Related topics

File

tripal_project/tripal_project.module, line 335
This file contains the basic functions needed for this drupal module. The drupal tripal_project module maps directly to the chado general module.

Code

function chado_project_delete($node) {

  $project_id = chado_get_id_for_node('project', $node);

  // if we don't have a project id for this node then this isn't a node of
  // type chado_project or the entry in the chado_project table was lost.
  if (!$project_id) {
    return;
  }

  // Remove data from {chado_project}, {node} and {node_revisions} tables of
  // drupal database
  $sql_del = "DELETE FROM {chado_project} " .
    "WHERE nid = %d " .
    "AND vid = %d";
  db_query($sql_del, $node->nid, $node->vid);
  $sql_del = "DELETE FROM {node_revisions} " .
    "WHERE nid = %d " .
    "AND vid = %d";
  db_query($sql_del, $node->nid, $node->vid);
  $sql_del = "DELETE FROM {node} " .
    "WHERE nid = %d " .
    "AND vid = %d";
  db_query($sql_del, $node->nid, $node->vid);


  // Remove data from project and projectprop tables of chado database as well
  chado_query("DELETE FROM {projectprop} WHERE project_id = %d", $project_id);
  chado_query("DELETE FROM {project} WHERE project_id = %d", $project_id);
}