From: <cmu...@us...> - 2007-11-03 00:32:02
|
Revision: 1119 http://obo.svn.sourceforge.net/obo/?rev=1119&view=rev Author: cmungall Date: 2007-11-02 17:32:01 -0700 (Fri, 02 Nov 2007) Log Message: ----------- Modified Paths: -------------- obo-database/trunk/sql/api/obd-mutable-api.plpgsql obo-database/trunk/sql/obd-core-views.sql Modified: obo-database/trunk/sql/api/obd-mutable-api.plpgsql =================================================================== --- obo-database/trunk/sql/api/obd-mutable-api.plpgsql 2007-11-03 00:03:36 UTC (rev 1118) +++ obo-database/trunk/sql/api/obd-mutable-api.plpgsql 2007-11-03 00:32:01 UTC (rev 1119) @@ -316,7 +316,30 @@ END; $$ LANGUAGE 'plpgsql'; +CREATE OR REPLACE FUNCTION store_subset (VARCHAR,VARCHAR) + RETURNS INT AS +$$ +DECLARE + v_subset_id INTEGER; + BEGIN + SELECT INTO v_subset_id store_instance_node($1,$2,'subset','subsetdef'); + RETURN v_subset_id; + END; +$$ LANGUAGE 'plpgsql'; +CREATE OR REPLACE FUNCTION store_node_subset_link_i (INT,VARCHAR) + RETURNS INT AS +$$ +DECLARE + v_node_id ALIAS FOR $1; + v_link_id INTEGER; + BEGIN + SELECT INTO v_link_id store_link_si(v_node_id,'oboMetaModel:inSubset',$2,''); + RETURN v_link_id; + END; +$$ LANGUAGE 'plpgsql'; + + -- DELETION -- CREATE OR REPLACE FUNCTION delete_node (VARCHAR) RETURNS INT AS $$ Modified: obo-database/trunk/sql/obd-core-views.sql =================================================================== --- obo-database/trunk/sql/obd-core-views.sql 2007-11-03 00:03:36 UTC (rev 1118) +++ obo-database/trunk/sql/obd-core-views.sql 2007-11-03 00:32:01 UTC (rev 1119) @@ -557,7 +557,7 @@ node.uid AS node_uid, node.label AS node_label FROM node - INNER JOIN description_with_type AS descr ON (node.source_id=descr.node_id); + INNER JOIN description_with_type AS descr USING (node_id); CREATE OR REPLACE VIEW alias_with_type AS SELECT @@ -573,9 +573,30 @@ node.uid AS node_uid, node.label AS node_label FROM node - INNER JOIN alias_with_type AS a ON (node.source_id=a.node_id); + INNER JOIN alias_with_type AS a USING (node_id); +CREATE OR REPLACE VIEW tagval_with_type AS + SELECT + tagval.*, + type.uid AS type_uid, + type.label AS type_label + FROM + tagval + LEFT OUTER JOIN node AS type ON (tagval.type_id=type.node_id); +CREATE OR REPLACE VIEW tagval_d AS + SELECT a.*, + node.uid AS node_uid, + node.label AS node_label + FROM node + INNER JOIN tagval_with_type AS a USING (node_id); + +CREATE OR REPLACE VIEW node_subset_d AS + SELECT * + FROM node_link_node_with_pred + WHERE pred_uid='oboMetaModel:inSubset'; + + -- ************************************************************ -- OBO METAMODEL -- ************************************************************ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |