File

tripal_chado/includes/tripal_chado.mapping.inc, line 96

Code

function tripal_chado_add_cvterm_mapping($cvterm_id, $tablename, $chado_field) {
  // check if the record exists
  $record = db_select('chado_cvterm_mapping', 'tcm')
    ->fields('tcm', array('mapping_id'))
    ->condition('cvterm_id', $cvterm_id)
    ->execute()
    ->fetchField();
  // insert records into the chado_cvterm_mapping table.
  if (!$record) {
    db_insert('chado_cvterm_mapping')
      ->fields(
      array(
        'cvterm_id' => $cvterm_id,
        'chado_table' => $tablename,
        'chado_field' => $chado_field
      )
      )
      ->execute();
  }
  // if the record exists, update the term mapping
  else {
    db_update('chado_cvterm_mapping')
      ->fields(
      array(
        'chado_table' => $tablename,
        'chado_field' => $chado_field
      )
      )
      ->condition('cvterm_id', $cvterm_id)
      ->execute()
      ;
  }
}