Compute the means while doing the cross-refences.HEADmain

1 files changed, 6 insertions, 0 deletions

diff --git a/scripts/load_phenotypes_to_db.py b/scripts/load_phenotypes_to_db.py
index 08ee558..9c636b9 100644
--- a/scripts/load_phenotypes_to_db.py
+++ b/scripts/load_phenotypes_to_db.py
@@ -226,6 +226,12 @@ def cross_reference_phenotypes_publications_and_data(
              "%(publication_id)s, %(data_id)s, 'Upload of new data.'"
              ")"),
             _params)
+        cursor.executemany(
+            "UPDATE PublishXRef SET mean="
+            "(SELECT AVG(value) FROM PublishData WHERE PublishData.Id=PublishXRef.DataId) "
+            "WHERE PublishXRef.Id=%(xref_id)s AND "
+            "InbredSetId=%(population_id)s",
+            _params)
         return _params
     return tuple()