Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

operator and date terms missing from local cv #6

Open
bellerbrock opened this issue Feb 17, 2020 · 0 comments
Open

operator and date terms missing from local cv #6

bellerbrock opened this issue Feb 17, 2020 · 0 comments

Comments

@bellerbrock
Copy link
Member

Loading phenotypes fails on StorePhenotypes.pm line 453 and 454 thanks to missing cvterms.

We should add them to the dockerfile db. In the meantime I used the following sql to add them manually:

BEGIN;
INSERT INTO dbxref (db_id,accession) VALUES (273,'operator');
INSERT INTO dbxref (db_id,accession) VALUES (273,'date');
INSERT INTO cvterm (cv_id,name,definition,dbxref_id)
 VALUES (39,'operator','',( SELECT dbxref_id FROM dbxref WHERE accession = 'operator' ));
 INSERT INTO cvterm (cv_id,name,definition,dbxref_id)
  VALUES (39,'date','',( SELECT dbxref_id FROM dbxref WHERE accession = 'date' )); 
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant