Retrieves the default vocabulary for a given table and field.

Each table in Chado that has a 'type_id' (or foreign key constraint to the cvterm table) will have a default vocabulary assigned. This indicates to Tripal that terms in that vocabulary are used to set the type_id for that table. An example where this is used is the tripal_get_cvterm_select_options() function which generates a list of options for a select box used in a Drupal form. The select box will list the terms from the default vocabulary in the drop down.

This function uses the Chado table and field name (e.g. 'type_id') to retreive the vocabulary assgined.

Parameters

$table: The name of the table that contains a field with a foreign key relationship to the cvterm table

$field: The table field name that has the foreign key relationship to the cvterm table for which the default vocabulary will be set

Return value

The cv object of the default vocabulary or an empty array if not available.

Related topics

File

legacy/tripal_cv/api/tripal_cv.api.inc, line 45

Provides legacy application programming interface (API) to manage controlled vocabularies in the Chado database.

Code

function tripal_get_default_cv($table, $field) {
  $sql = "
    SELECT cv_id
    FROM {tripal_cv_defaults}
    WHERE table_name = :table and field_name = :field
  ";
  $cv_id = db_query($sql, array(':table' => $table, ':field' => $field))->fetchField();

  return tripal_get_cv(array('cv_id' => $cv_id));
}