Edits a materialized view to the chado database to help speed data access. This function supports the older style where postgres column specifications are provided using the $mv_table, $mv_specs and $indexed variables. It also supports the newer preferred method where the materialized view is described using the Drupal Schema API array.

Parameters

$mview_id: The mview_id of the materialized view to edit.

$name: The name of the materialized view.

$modulename: The name of the module submitting the materialized view (e.g. 'tripal_library').

$mv_table: The name of the table to add to chado. This is the table that can be queried.

$mv_specs: The table definition.

$indexed: The columns that are to be indexed.

$query: The SQL query that loads the materialized view with data.

$special_index: currently not used.

$comment: A string containing a description of the materialized view.

$mv_schema: If using the newer Schema API array to define the materialized view then this variable should contain the array.

File

tripal_chado/api/tripal_chado.DEPRECATED.api.inc, line 160

These api functions are deprecated, if your site is currently using them please update your code with the newer tripal_chado functions.

Code

function tripal_edit_mview($mview_id, $name, $modulename, $mv_table, $mv_specs, 
$indexed, $query, $special_index, $comment = null, $mv_schema = null) {
  chado_edit_mview($mview_id, $name, $modulename, $mv_table, $mv_specs, 
  $indexed, $query, $special_index, $comment = null, $mv_schema = null);
}