function tripal_get_mviews

2.x tripal_core.mviews.api.inc tripal_get_mviews()
3.x tripal_chado.DEPRECATED.api.inc tripal_get_mviews()

Retrieves the list of materialized view IDs and their names

Return value

An array of objects with the following properties: mview_id, name

Related topics

File

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

Code

function tripal_get_mviews() {

  $results = db_select('tripal_mviews', 'tm')
    ->fields('tm', array('mview_id', 'name'))
    ->execute();

  $list = array();
  while ($mview = $results->fetchObject()) {
    $list[] = $mview;
  }
  return $list;
}