search

phenopolis / phenopolis_genomics_browser

Python API and React frontend for the Phenopolis Genomics Browser
https://dev-live.phenopolis.org
MIT License
31 stars 2 forks source link

changing the reference in hom_variants and het_variants to individual… #220

Closed priesgo closed 3 years ago

priesgo commented 3 years ago

This improves the query to count variants on authorised individuals, but in order to do that it changes the reference from tables hom_variants and het_variants to individuals.internal_id, it used to be external_id.

Deploying this to dev and prod requires to run this two updates:

update hom_variants set individual = individuals.internal_id from individuals where individual = individuals.external_id;
update het_variants set individual = individuals.internal_id from individuals where individual = individuals.external_id;