function tripal_cv_create_tripal_obo_temp
2.x tripal_cv.install | tripal_cv_create_tripal_obo_temp() |
Creates a temporary table to store obo details while loading an obo file
Related topics
1 call to tripal_cv_create_tripal_obo_temp()
- tripal_cv_install in tripal_cv/
tripal_cv.install - Implementation of hook_install().
File
- tripal_cv/
tripal_cv.install, line 87 - Contains functions executed only on install/uninstall of this module
Code
function tripal_cv_create_tripal_obo_temp() {
// the tripal_obo_temp table is used for temporary housing of records when loading OBO files
// we create it here using plain SQL because we want it to be in the chado schema but we
// do not want to use the Tripal Custom Table API because we don't want it to appear in the
// list of custom tables. It needs to be available for the Tripal Chado API so we create it
// here and then define it in the tripal_cv/api/tripal_cv.schema.api.inc
if (!chado_table_exists('tripal_obo_temp')) {
$sql = "
CREATE TABLE {tripal_obo_temp} (
id character varying(255) NOT NULL,
stanza text NOT NULL,
type character varying(50) NOT NULL,
CONSTRAINT tripal_obo_temp_uq0 UNIQUE (id)
);
";
chado_query($sql);
$sql = "CREATE INDEX tripal_obo_temp_idx0 ON {tripal_obo_temp} USING btree (id)";
chado_query($sql);
$sql = "CREATE INDEX tripal_obo_temp_idx1 ON {tripal_obo_temp} USING btree (type)";
chado_query($sql);
}
}