Retrieves the list tables in the Chado schema. By default it only retursn the default Chado tables, but may also return custom tables added to the Chado schema as well.

@returns An associative array where the key and value pairs are the Chado table names.

Parameters

$include_custom: Optional. Set as TRUE to include any custom tables created in the Chado schema. Custom tables are added to Chado using the tripal_core_chado_create_table() function.

Related topics

File

tripal_core/api/tripal_core_chado.api.inc, line 3451

The Tripal Core API

Code

function tripal_core_get_chado_tables($include_custom = NULL) {


  // first get the chado version that is installed
  $v = tripal_core_get_chado_version();

  $tables = array();
  if ($v == '1.2') {
    $tables_v1_2 = tripal_core_chado_get_v1_2_tables();
    foreach ($tables_v1_2 as $table) {
      $tables[$table] = $table;
    }
  }
  if ($v == '1.11' or $v == '1.11 or older') {
    $tables_v1_11 = tripal_core_chado_get_v1_11_tables();
    foreach ($tables_v1_11 as $table) {
      $tables[$table] = $table;
    }
  }

  // now add in the custom tables too if requested
  if ($include_custom) {
    $sql = "SELECT table_name FROM {tripal_custom_tables}";
    $resource = db_query($sql);

    while ($r = db_fetch_object($resource)) {
      $tables[$r->table_name] = $r->table_name;
    }
  }

  asort($tables);
  return $tables;
}