diff options
author | Frederick Muriuki Muriithi | 2025-01-29 12:56:24 -0600 |
---|---|---|
committer | Frederick Muriuki Muriithi | 2025-01-29 12:56:24 -0600 |
commit | 72f158fa3d90b888440735b0883c271e951159bc (patch) | |
tree | 85030a219ac875cac5d0f7806d544d69469cb760 | |
parent | be2c1cd490bf11b3d5582065d8e88ab44f891bd8 (diff) | |
download | gn-uploader-72f158fa3d90b888440735b0883c271e951159bc.tar.gz |
Update field name.
Use "xref_id" rather than "pxr.Id" since the former is a little
clearer.
-rw-r--r-- | uploader/phenotypes/models.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/uploader/phenotypes/models.py b/uploader/phenotypes/models.py index c9afc22..e1ec0c9 100644 --- a/uploader/phenotypes/models.py +++ b/uploader/phenotypes/models.py @@ -75,7 +75,7 @@ def dataset_phenotypes(conn: mdb.Connection, limit: Optional[int] = None) -> tuple[dict, ...]: """Fetch the actual phenotypes.""" _query = ( - "SELECT pheno.*, pxr.Id, ist.InbredSetCode FROM Phenotype AS pheno " + "SELECT pheno.*, pxr.Id AS xref_id, ist.InbredSetCode FROM Phenotype AS pheno " "INNER JOIN PublishXRef AS pxr ON pheno.Id=pxr.PhenotypeId " "INNER JOIN PublishFreeze AS pf ON pxr.InbredSetId=pf.InbredSetId " "INNER JOIN InbredSet AS ist ON pf.InbredSetId=ist.Id " |