diff options
| author | zsloan | 2023-09-21 18:59:51 +0000 |
|---|---|---|
| committer | zsloan | 2023-09-21 18:59:51 +0000 |
| commit | 0575c3c0660c8256b4def1b8ff4b4d1b0773ecef (patch) | |
| tree | b7812d018839637d12a890943fa1c2aea5144aef | |
| parent | 40189f056cd2d3db8d63b4704ecfacbea0c7f363 (diff) | |
| download | genenetwork3-0575c3c0660c8256b4def1b8ff4b4d1b0773ecef.tar.gz | |
Fix query in update_cross_reference
| -rw-r--r-- | gn3/db/phenotypes.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/gn3/db/phenotypes.py b/gn3/db/phenotypes.py index 6c6e61b..0339aba 100644 --- a/gn3/db/phenotypes.py +++ b/gn3/db/phenotypes.py @@ -188,8 +188,7 @@ def update_cross_reference(conn, dataset_id, trait_name, data:dict) -> int: cursor.execute( f"UPDATE PublishXRef SET {cols} WHERE " "Id=%(trait_name)s AND " - "InbredSetId=" - "(SELECT InbredSetId FROM PublishFreeze WHERE Id=%(dataset_id)s)", + "InbredSetId=%(dataset_id)s", { "dataset_id": dataset_id, "trait_name": trait_name, |