From 72f158fa3d90b888440735b0883c271e951159bc Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Wed, 29 Jan 2025 12:56:24 -0600 Subject: Update field name. Use "xref_id" rather than "pxr.Id" since the former is a little clearer. --- uploader/phenotypes/models.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 " -- cgit v1.2.3