[MOBY-guts] biomoby commit
Mark Wilkinson
mwilkinson at pub.open-bio.org
Fri May 9 15:47:37 UTC 2003
mwilkinson
Fri May 9 11:47:37 EDT 2003
Update of /home/repository/moby/moby-live/Database
In directory pub.open-bio.org:/tmp/cvs-serv8948
Modified Files:
mobycentral.mysql mobynamespace.mysql mobyobject.mysql
mobyrelationship.mysql mobyservice.mysql
Log Message:
bootstrapping values in the database dumps
moby-live/Database mobycentral.mysql,1.1,1.2 mobynamespace.mysql,1.3,1.4 mobyobject.mysql,1.4,1.5 mobyrelationship.mysql,1.1,1.2 mobyservice.mysql,1.3,1.4
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobycentral.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /home/repository/moby/moby-live/Database/mobycentral.mysql 2003/05/09 15:43:55 1.1
+++ /home/repository/moby/moby-live/Database/mobycentral.mysql 2003/05/09 15:47:37 1.2
@@ -20,12 +20,6 @@
# Dumping data for table 'authority'
#
-INSERT INTO authority VALUES (NULL,'your.URI.here','your_name at contact.address.com',1);
-INSERT INTO authority VALUES (NULL,'openinformatics.com','jason at openinformatics.com',2);
-INSERT INTO authority VALUES (NULL,'mged.org','jason at openinformatics.com',3);
-INSERT INTO authority VALUES (NULL,'ibm.com','jason at openinformatics.com',4);
-INSERT INTO authority VALUES (NULL,'foo.com','jason at openinformatics.com',5);
-INSERT INTO authority VALUES (NULL,'senger.org','senger at ebi.ac.uk',6);
#
# Table structure for table 'collection_input'
@@ -42,7 +36,6 @@
# Dumping data for table 'collection_input'
#
-INSERT INTO collection_input VALUES (2,'nice collection',31);
#
# Table structure for table 'collection_output'
@@ -59,7 +52,6 @@
# Dumping data for table 'collection_output'
#
-INSERT INTO collection_output VALUES (1,'nice output collection',31);
#
# Table structure for table 'secondary_input'
@@ -81,8 +73,6 @@
# Dumping data for table 'secondary_input'
#
-INSERT INTO secondary_input VALUES (13,NULL,NULL,NULL,'Kim,Blanka,Jitka,Martin,Blanka','STRING','un-named',31);
-INSERT INTO secondary_input VALUES (12,'123',23,234,'50,40,30','','favourite secondary article',31);
#
# Table structure for table 'service_instance'
@@ -106,12 +96,6 @@
# Dumping data for table 'service_instance'
#
-INSERT INTO service_instance VALUES ('moby','retrieveExperimentByName','URN:LSID:biomoby.org:ServiceType:13',2,'http://18.157.12.73/genex/G2G/retrieveExperimentByName','jason at openinformatics.com','1','Given an Experiment name, retrieve the MAGE object ',1);
-INSERT INTO service_instance VALUES ('moby','retrieveProtocolByName','URN:LSID:biomoby.org:ServiceType:14',2,'http://18.157.12.73/genex/G2G/retrieveProtocolByName','jason at openinformatics.com','1','Given a Protocol name, retrieve the MAGE object ',2);
-INSERT INTO service_instance VALUES ('moby','retrieveProtocolByName','URN:LSID:biomoby.org:ServiceType:14',3,'http://18.157.12.73/genex/G2G/retrieveProtocolByName','jason at openinformatics.com','1','Given a Protocol name, retrieve the MAGE object ',12);
-INSERT INTO service_instance VALUES ('moby','retrieveExperimentByName','URN:LSID:biomoby.org:ServiceType:13',4,'http://18.157.12.73/genex/G2G/retrieveExperimentByName','jason at openinformatics.com','0','Given an Experiment name, retrieve the MAGE object',13);
-INSERT INTO service_instance VALUES ('moby','retrievePBAByName','URN:LSID:biomoby.org:ServiceType:15',2,'http://18.157.12.73/genex/G2G/retrievePBAByName','jason at openinformatics.com','0','Given a PhysicalBioAssay name, retrieve the MAGE object',14);
-INSERT INTO service_instance VALUES ('moby','TestingService','URN:LSID:biomoby.org:ServiceType:18',6,'http://www.the-sengers.net','senger at ebi.ac.uk','1','ignore this',31);
#
# Table structure for table 'simple_input'
@@ -131,16 +115,6 @@
# Dumping data for table 'simple_input'
#
-INSERT INTO simple_input VALUES (1,'URN:LSID:biomoby.org:ObjectClass:3','URN:LSID:biomoby.org:NamespaceType:1','name',1,NULL);
-INSERT INTO simple_input VALUES (2,'URN:LSID:biomoby.org:ObjectClass:3','URN:LSID:biomoby.org:NamespaceType:1','name',2,NULL);
-INSERT INTO simple_input VALUES (3,'URN:LSID:biomoby.org:ObjectClass:3','URN:LSID:biomoby.org:NamespaceType:1','name',12,NULL);
-INSERT INTO simple_input VALUES (4,'URN:LSID:biomoby.org:ObjectClass:3','URN:LSID:biomoby.org:NamespaceType:1','name',13,NULL);
-INSERT INTO simple_input VALUES (5,'URN:LSID:biomoby.org:ObjectClass:3','URN:LSID:biomoby.org:NamespaceType:2','name',14,NULL);
-INSERT INTO simple_input VALUES (38,'URN:LSID:biomoby.org:ObjectClass:14','URN:LSID:biomoby.org:NamespaceType:5','simple 1 in collection',NULL,2);
-INSERT INTO simple_input VALUES (37,'URN:LSID:biomoby.org:ObjectClass:25','URN:LSID:biomoby.org:NamespaceType:6','simple 2 in collection',NULL,2);
-INSERT INTO simple_input VALUES (36,'URN:LSID:biomoby.org:ObjectClass:13','URN:LSID:biomoby.org:NamespaceType:5','simple 3 in collection',NULL,2);
-INSERT INTO simple_input VALUES (34,'URN:LSID:biomoby.org:ObjectClass:11',NULL,'dummy',31,NULL);
-INSERT INTO simple_input VALUES (35,'URN:LSID:biomoby.org:ObjectClass:11','URN:LSID:biomoby.org:NamespaceType:5,URN:LSID:biomoby.org:NamespaceType:6','first simple input',31,NULL);
#
# Table structure for table 'simple_output'
@@ -160,10 +134,3 @@
# Dumping data for table 'simple_output'
#
-INSERT INTO simple_output VALUES (1,'URN:LSID:biomoby.org:ObjectClass:7','URN:LSID:biomoby.org:NamespaceType:1',NULL,2,NULL);
-INSERT INTO simple_output VALUES (2,'URN:LSID:biomoby.org:ObjectClass:7','URN:LSID:biomoby.org:NamespaceType:1',NULL,12,NULL);
-INSERT INTO simple_output VALUES (3,'URN:LSID:biomoby.org:ObjectClass:6','URN:LSID:biomoby.org:NamespaceType:1','output',13,NULL);
-INSERT INTO simple_output VALUES (4,'URN:LSID:biomoby.org:ObjectClass:10','URN:LSID:biomoby.org:NamespaceType:2','output',14,NULL);
-INSERT INTO simple_output VALUES (5,'URN:LSID:biomoby.org:ObjectClass:14','URN:LSID:biomoby.org:NamespaceType:5','simple output in an output collection',NULL,1);
-INSERT INTO simple_output VALUES (6,'URN:LSID:biomoby.org:ObjectClass:11','URN:LSID:biomoby.org:NamespaceType:5,URN:LSID:biomoby.org:NamespaceType:6','first simple output',31,NULL);
-
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobynamespace.mysql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- /home/repository/moby/moby-live/Database/mobynamespace.mysql 2003/05/09 15:43:55 1.3
+++ /home/repository/moby/moby-live/Database/mobynamespace.mysql 2003/05/09 15:47:37 1.4
@@ -22,11 +22,6 @@
# Dumping data for table 'namespace'
#
-INSERT INTO namespace VALUES (1,'openinformatics.com/Genex/Experiment','Experiment Accession numbers from the Genex DB at openinformatics','openinformatics.com','jason at openinformatics.com');
-INSERT INTO namespace VALUES (2,'openinformatics.com/Genex/PhysicalBioAssay','PhysicalBioAssay Accession numbers from the Genex DB at openinformatics','openinformatics.com','jason at openinformatics.com');
-INSERT INTO namespace VALUES (3,'openinformatics.com/Genex/Protocol','Protocol Accession numbers from the Genex DB at openinformatics','openinformatics.com','jason at openinformatics.com');
-INSERT INTO namespace VALUES (5,'TestingNamespace','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO namespace VALUES (6,'TestingNamespace2','ignore this','senger.org','senger at ebi.ac.uk');
#
# Table structure for table 'namespace_term2term'
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyobject.mysql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- /home/repository/moby/moby-live/Database/mobyobject.mysql 2003/05/09 15:43:55 1.4
+++ /home/repository/moby/moby-live/Database/mobyobject.mysql 2003/05/09 15:47:37 1.5
@@ -27,13 +27,6 @@
INSERT INTO object VALUES (3,'String','a string','openinformatics.com','jason at openinformatics.com');
INSERT INTO object VALUES (4,'Float','a floating point number','openinformatics.com','jason at openinformatics.com');
INSERT INTO object VALUES (5,'DateTime','a date or time in ISO-8601 format','openinformatics.com','jason at openinformatics.com');
-INSERT INTO object VALUES (6,'MAGE/Experiment','a MAGE Experiment object','openinformatics.com','jason at openinformatics.com');
-INSERT INTO object VALUES (7,'MAGE/Protocol','a MAGE Protocol object','openinformatics.com','jason at openinformatics.com');
-INSERT INTO object VALUES (11,'TestingDataType','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO object VALUES (10,'MAGE/PhysicalBioAssay','a MAGE PhysicalBioAssay object','openinformatics.com','jason at openinformatics.com');
-INSERT INTO object VALUES (13,'TestingDataType3','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO object VALUES (14,'TestingDataType4','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO object VALUES (25,'TestingDataType2','ignore this','senger.org','senger at ebi.ac.uk');
#
# Table structure for table 'object_term2term'
@@ -53,19 +46,8 @@
# Dumping data for table 'object_term2term'
#
-INSERT INTO object_term2term VALUES (1,'URN:LSID:biomoby.org:ObjectRelation:ISA',49,47,NULL,'');
-INSERT INTO object_term2term VALUES (2,'URN:LSID:biomoby.org:ObjectRelation:ISA',50,49,NULL,'');
INSERT INTO object_term2term VALUES (3,'URN:LSID:biomoby.org:ObjectRelation:ISA',2,1,NULL,'');
INSERT INTO object_term2term VALUES (4,'URN:LSID:biomoby.org:ObjectRelation:ISA',3,1,NULL,'');
INSERT INTO object_term2term VALUES (5,'URN:LSID:biomoby.org:ObjectRelation:ISA',4,1,NULL,'');
INSERT INTO object_term2term VALUES (6,'URN:LSID:biomoby.org:ObjectRelation:ISA',5,3,NULL,'');
-INSERT INTO object_term2term VALUES (7,'URN:LSID:biomoby.org:ObjectRelation:ISA',6,3,NULL,'');
-INSERT INTO object_term2term VALUES (8,'URN:LSID:biomoby.org:ObjectRelation:ISA',7,3,NULL,'');
-INSERT INTO object_term2term VALUES (9,'URN:LSID:biomoby.org:ObjectRelation:ISA',10,3,NULL,'');
-INSERT INTO object_term2term VALUES (21,'URN:LSID:biomoby.org:ObjectRelation:ISA',25,11,NULL,'');
-INSERT INTO object_term2term VALUES (22,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,2,'money','');
-INSERT INTO object_term2term VALUES (23,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,14,'money','');
-INSERT INTO object_term2term VALUES (24,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,3,'money','');
-INSERT INTO object_term2term VALUES (25,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,13,'money','');
-INSERT INTO object_term2term VALUES (26,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,4,'money','');
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyrelationship.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /home/repository/moby/moby-live/Database/mobyrelationship.mysql 2003/05/09 15:43:55 1.1
+++ /home/repository/moby/moby-live/Database/mobyrelationship.mysql 2003/05/09 15:47:37 1.2
@@ -26,7 +26,6 @@
INSERT INTO relationship VALUES (10,'URN:LSID:biomoby.org:ObjectRelation:HASA','Describes a container relationship where the predicate object is contained within the subject object in one copy only','www.biomoby.org','markw at illuminae.com','object');
INSERT INTO relationship VALUES (9,'URN:LSID:biomoby.org:ObjectRelation:HAS','Describes a container relationship where the predicate object is contained within the subject object in one or more copies','www.biomoby.org','markw at illuminae.com','object');
INSERT INTO relationship VALUES (11,'URN:LSID:biomoby.org:ObjectRelation:ISA','Describes an inheritence relationship where all attributes of the parent must be in the child','www.biomoby.org','markw at illuminae.com','object');
-INSERT INTO relationship VALUES (12,'URN:LSID:biomoby.org:ServiceRelation:ISA','Describes an inheritence relationship where the predicate service performs a more specific operation compared to the subject service','www.biomoby.org','markw at illuminae.com','service');
#
# Table structure for table 'relationship_term2term'
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyservice.mysql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- /home/repository/moby/moby-live/Database/mobyservice.mysql 2003/05/09 15:43:55 1.3
+++ /home/repository/moby/moby-live/Database/mobyservice.mysql 2003/05/09 15:47:37 1.4
@@ -23,19 +23,11 @@
#
INSERT INTO service VALUES (1,'Service','The base type','auth','email');
-INSERT INTO service VALUES (12,'Retrieval/MAGE','Return a MAGE object in MAGE-ML','auth','email');
INSERT INTO service VALUES (9,'Retrieval','The base retrieval type','auth','email');
INSERT INTO service VALUES (5,'Resolution','resolve data','auth','email');
INSERT INTO service VALUES (6,'Parsing','parse data','auth','email');
INSERT INTO service VALUES (7,'Registration','register data','auth','email');
INSERT INTO service VALUES (8,'Analysis','analyze data','auth','email');
-INSERT INTO service VALUES (13,'Retrieval/MAGE/Experiment','MAGE Experiment object','auth','email');
-INSERT INTO service VALUES (14,'Retrieval/MAGE/Protocol','MAGE Protocol object','auth','email');
-INSERT INTO service VALUES (15,'Retrieval/MAGE/PhysicalBioAssay','MAGE PhysicalBioAssay object','auth','email');
-INSERT INTO service VALUES (17,'TestingServiceType','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO service VALUES (18,'TestingServiceType2','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO service VALUES (19,'TestingServiceType3','ignore this','senger.org','senger at ebi.ac.uk');
-INSERT INTO service VALUES (21,'TestingServiceType4','ignore this','senger.org','senger at ebi.ac.uk');
#
# Table structure for table 'service_term2term'
@@ -53,17 +45,4 @@
# Dumping data for table 'service_term2term'
#
-INSERT INTO service_term2term VALUES (1,'URN:LSID:biomoby.org:ServiceRelation:ISA',3,2);
-INSERT INTO service_term2term VALUES (11,'URN:LSID:biomoby.org:ServiceRelation:ISA',12,9);
-INSERT INTO service_term2term VALUES (8,'URN:LSID:biomoby.org:ServiceRelation:ISA',9,1);
-INSERT INTO service_term2term VALUES (4,'URN:LSID:biomoby.org:ServiceRelation:ISA',5,1);
-INSERT INTO service_term2term VALUES (5,'URN:LSID:biomoby.org:ServiceRelation:ISA',6,1);
-INSERT INTO service_term2term VALUES (6,'URN:LSID:biomoby.org:ServiceRelation:ISA',7,1);
-INSERT INTO service_term2term VALUES (7,'URN:LSID:biomoby.org:ServiceRelation:ISA',8,1);
-INSERT INTO service_term2term VALUES (12,'URN:LSID:biomoby.org:ServiceRelation:ISA',13,12);
-INSERT INTO service_term2term VALUES (13,'URN:LSID:biomoby.org:ServiceRelation:ISA',14,12);
-INSERT INTO service_term2term VALUES (14,'URN:LSID:biomoby.org:ServiceRelation:ISA',15,12);
-INSERT INTO service_term2term VALUES (15,'URN:LSID:biomoby.org:ServiceRelation:ISA',18,17);
-INSERT INTO service_term2term VALUES (19,'URN:LSID:biomoby.org:ServiceRelation:ISA',21,19);
-INSERT INTO service_term2term VALUES (18,'URN:LSID:biomoby.org:ServiceRelation:ISA',21,18);
More information about the MOBY-guts
mailing list