tripal/tripal_genetic/api/tripal_genetic.api.inc

<?php
/**
 * @file
 * @todo Add file header description
 */

/**
 *
 */
function tripal_genetic_get_genotypes_by_feature_id($feature_id) {

  /**
  $sql = 'SELECT nd_experiment_id FROM nd_experiment_genotype WHERE genotype_id IN (SELECT genotype_id FROM feature_genotype WHERE feature_id=%d)';
  $resource = db_query($sql, $feature_id);

  $values['nd_experiment_id'] = array();
  while ($r = db_fetch_object($resource)) {
    $values['nd_experiment_id'][] = $r->nd_experiment_id;
  }

  $object = tripal_core_generate_chado_var('nd_experiment',$values);
  $object = tripal_core_expand_chado_vars($object, 'table', 'nd_experiment_genotype');
  $object = tripal_core_expand_chado_vars($object, 'table', 'feature_genotype');
  $object = tripal_core_expand_chado_vars($object, 'table', 'nd_experiment_stock');
  */

  $sql = 'SELECT genotype_id FROM {genotype} WHERE genotype_id IN (SELECT genotype_id FROM {feature_genotype} WHERE feature_id=%d)';
  $resource = db_query($sql, $feature_id);

  $values['genotype_id'] = array();
  while ($r = db_fetch_object($resource)) {
    $values['genotype_id'][] = $r->genotype_id;
  }

  if (!empty($values['genotype_id'])) {
    $object = tripal_core_generate_chado_var('genotype', $values);
  }
  else {
    $object = array();
  }
  return $object;
}