db.migration.v0.36.0.3__fbcv_ontology_load.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of agr_curation_api Show documentation

This software is for using the curation api as a library

There is a newer version: v0.35.0

UPDATE ontologyterm SET ontologytermtype = 'FBCVTerm' WHERE ontologytermtype = 'DPOTerm';

DELETE FROM bulkloadfileexception WHERE bulkloadfilehistory_id IN (
	SELECT id FROM bulkloadfilehistory WHERE bulkloadfile_id IN (
		SELECT id FROM bulkloadfile WHERE bulkload_id = (
			SELECT id FROM bulkload WHERE ontologytype = 'DPO'
		)
	)
);

DELETE FROM bulkloadfilehistory WHERE bulkloadfile_id IN (
	SELECT id FROM bulkloadfile WHERE bulkload_id = (
		SELECT id FROM bulkload WHERE ontologytype = 'DPO'
	)
);

DELETE FROM bulkloadfile WHERE bulkload_id = (
	SELECT id FROM bulkload WHERE ontologytype = 'DPO'
);

UPDATE bulkurlload SET bulkloadurl = 'http://purl.obolibrary.org/obo/fbcv.owl' WHERE id = (
	SELECT id FROM bulkload WHERE ontologytype = 'DPO'
);

UPDATE bulkload SET name = 'FBcv Ontology Load', ontologytype = 'FBCV', bulkloadstatus = 'STOPPED' WHERE ontologytype = 'DPO';