File: extra.sql

package info (click to toggle)
libchado-perl 1.22-4
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 24,024 kB
  • sloc: xml: 192,540; sql: 165,936; perl: 28,298; sh: 101; python: 73; makefile: 46
file content (12 lines) | stat: -rw-r--r-- 1,052 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
/* we need to have the ontologies loaded before we can do this.  "make prepdb" now needs to come after "make ontologies" */
insert into cvterm_relationship (subject_id,object_id,type_id) values (
  (select cvterm_id from cvterm where name = 'blood_cell' and cv_id = (select cv_id from cv where name = 'Cell Ontology')),
  (select cvterm_id from cvterm where name = 'blood' and cv_id = (select cv_id from cv where name = 'Mouse Adult Anatomy Ontology')),
  (select cvterm_id from cvterm where name = 'part_of' and cv_id = (select cv_id from cv where name = 'Relationship Ontology'))
);
insert into cvterm_relationship (subject_id,object_id,type_id) values (
  (select cvterm_id from cvterm where name = 'chondrocyte' and cv_id = (select cv_id from cv where name = 'Cell Ontology')),
  (select cvterm_id from cvterm where name = 'cartilage' and cv_id = (select cv_id from cv where name = 'Mouse Adult Anatomy Ontology')),
  (select cvterm_id from cvterm where name = 'part_of' and cv_id = (select cv_id from cv where name = 'Relationship Ontology'))
);