diff options
| -rw-r--r-- | scripts/load_phenotypes_to_db.py | 6 |
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() |