function chado_get_mview_table_names

2.x tripal_core.mviews.api.inc chado_get_mview_table_names()
3.x tripal_chado.mviews.api.inc chado_get_mview_table_names()

Retrieves the list of materialized views in this site.

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

Related topics

Tripal Custom Tables API
Provides an API to manage custom tables in Chado.
1 call to chado_get_mview_table_names()
tripal_views_integrate_all_chado_tables in tripal_views/includes/tripal_views_integration.inc
Integrate all chado tables in the schema api. This integration only occurs once and sets all Chado tables to a priority of 10

File

tripal_core/api/tripal_core.mviews.api.inc, line 312
Provides an application programming interface (API) to manage materialized views in Chado.

Code

function chado_get_mview_table_names() {

  $sql = "SELECT name FROM {tripal_mviews}";
  $resource = db_query($sql);

  $tables = array();
  foreach ($resource as $r) {
    $tables[$r->name] = $r->name;
  }

  asort($tables);
  return $tables;
}