Returns a list of organisms that are currently synced with Drupal

Related topics

File

tripal_organism/api/tripal_organism.api.inc, line 50

Provides an application programming interface (API) to manage organisms

Code

function tripal_organism_get_synced() {

  // use this SQL for getting synced organisms
  $dsql = "SELECT * FROM {chado_organism}";
  $orgs = db_query($dsql);

  // use this SQL statement for getting the organisms
  $csql = "SELECT * FROM {Organism} " .
    "WHERE organism_id = %d";

  $org_list = array();

  // iterate through the organisms and build an array of those that are synced
  while ($org = db_fetch_object($orgs)) {
    $info = db_fetch_object(chado_query($csql, $org->organism_id));
    $org_list[] = $info;
  }
  return $org_list;
}