[MOBY-guts] biomoby commit

[Mark Wilkinson]

Tue Jan 28 09:16:26 EST 2003
Update of /home/repository/moby/moby-live/Example_Code
In directory dev:/tmp/cvs-serv19621

Modified Files:
	get_service_signatures.sql 
Log Message:
get_service_signatures.sql
moby-live/Example_Code get_service_signatures.sql,1.1,1.2
===================================================================
RCS file: /home/repository/moby/moby-live/Example_Code/get_service_signatures.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /tmp/T0fIaywM	2003-01-28 09:16:26.500007789 -0500
+++ /tmp/T1gIaywM	2003-01-28 09:16:26.510010325 -0500
@@ -1,7 +1,9 @@
-select t1.term as INPUT, t2.term as NS, t3.term as OUTPUT, S.service_name from 
-Service as S, OntologyEntry as t1, OntologyEntry as t2, OntologyEntry as t3, 
-ServiceParameter as SP1, ServiceParameter as SP2, ServiceParameter as SP3 
-where SP1.type='in' and SP2.type='ns' and SP3.type='out' and SP1.service_id = 
-S.id and SP2.service_id = S.id and SP3.service_id = S.id and 
+select t1.term as INPUT, t2.term as NS, t4.term as TRANSFORM, t3.term as 
+OUTPUT, S.service_name from Service as S, OntologyEntry as t1, OntologyEntry 
+as t2, OntologyEntry as t3, OntologyEntry as t4, ServiceParameter as SP1, 
+ServiceParameter as SP2, ServiceParameter as SP3 where S.service_type_id = 
+t4.id and SP1.type='in' and SP2.type='ns' and SP3.type='out' and 
+SP1.service_id = S.id and SP2.service_id = S.id and SP3.service_id = S.id and 
 SP1.ontologyentry_id = t1.id and SP2.ontologyentry_id = t2.id and  
-SP3.ontologyentry_id = t3.id;
+SP3.ontologyentry_id = t3.id;  
+