• Home
• org.alliancegenome
• agr_curation_api
• v0.34.2
• source code
• v0.15.0.3__agr_curation_api.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.v0.15.0.3__agr_curation_api.sql Maven / Gradle / Ivy

UPDATE diseaseannotation
	SET uniqueid = CONCAT(uniqueid, '|true')
	WHERE negated = True AND uniqueid LIKE 'FB%'; 
	
UPDATE diseaseannotation
	SET uniqueid = CONCAT(uniqueid, '|false')
	WHERE negated = False AND uniqueid LIKE 'FB%'; 
	
UPDATE diseaseannotation 
	SET uniqueid = CONCAT(uniqueid, '|', vocabularyterm.name)
	FROM vocabularyterm
	WHERE diseaseannotation.diseasegeneticmodifierrelation_id = vocabularyterm.id AND uniqueid LIKE 'FB%';
	
UPDATE diseaseannotation
	SET uniqueid = CONCAT(uniqueid, '|', diseasegeneticmodifier_curie)
	WHERE diseasegeneticmodifier_curie IS NOT NULL AND uniqueid LIKE 'FB%';