aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBonfaceKilz2022-02-22 12:36:26 +0300
committerBonfaceKilz2022-03-12 15:33:09 +0300
commit83bfe825ece64807a96280fda9cb4ef3e8ac0587 (patch)
tree77d9783f1f7552b31019f26707033413fd33bae2
parent6bc7d5448970311c01aebae76c2189cf1a6aea59 (diff)
downloadgenenetwork3-83bfe825ece64807a96280fda9cb4ef3e8ac0587.tar.gz
db: Fix error in SQL query
* gn3/db/traits.py (get_trait_csv_sample_data): Update SQL to fix runtime errors.
-rw-r--r--gn3/db/traits.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/gn3/db/traits.py b/gn3/db/traits.py
index f686097..04b2a70 100644
--- a/gn3/db/traits.py
+++ b/gn3/db/traits.py
@@ -84,7 +84,7 @@ def get_trait_csv_sample_data(conn: Any,
"""Fetch a trait and return it as a csv string"""
__query = ("SELECT concat(st.Name, ',', ifnull(pd.value, 'x'), ',', "
"ifnull(ps.error, 'x'), ',', ifnull(ns.count, 'x')) as 'Data' "
- "ifnull(ca.Name, 'x') as 'CaseAttr', "
+ ",ifnull(ca.Name, 'x') as 'CaseAttr', "
"ifnull(cxref.value, 'x') as 'Value' "
"FROM PublishFreeze pf "
"JOIN PublishXRef px ON px.InbredSetId = pf.InbredSetId "
@@ -97,7 +97,7 @@ def get_trait_csv_sample_data(conn: Any,
"LEFT JOIN CaseAttributeXRefNew cxref ON "
"(cxref.InbredSetId = px.InbredSetId AND "
"cxref.StrainId = st.Id) "
- "LEFT JOIN CaseAttribute ca ON ca.Id = cxref.CaseAttributeId"
+ "LEFT JOIN CaseAttribute ca ON ca.Id = cxref.CaseAttributeId "
"WHERE px.Id = %s AND px.PhenotypeId = %s ORDER BY st.Name")
case_attr_columns = set()
csv_data = {}