about summary refs log tree commit diff
path: root/gn3
diff options
context:
space:
mode:
Diffstat (limited to 'gn3')
-rw-r--r--gn3/api/general.py3
-rw-r--r--gn3/db/traits.py2
2 files changed, 4 insertions, 1 deletions
diff --git a/gn3/api/general.py b/gn3/api/general.py
index cebb2e3..86fb7b7 100644
--- a/gn3/api/general.py
+++ b/gn3/api/general.py
@@ -11,6 +11,9 @@ from gn3.commands import run_cmd
 
 general = Blueprint("general", __name__)
 
+@general.route("/version")
+def version():
+  return jsonify("1.0")
 
 @general.route("/metadata/upload/", methods=["POST"],
                strict_slashes=False)
diff --git a/gn3/db/traits.py b/gn3/db/traits.py
index 85cccfa..f66ead3 100644
--- a/gn3/db/traits.py
+++ b/gn3/db/traits.py
@@ -7,7 +7,7 @@ from gn3.db.datasets import retrieve_trait_dataset
 def get_trait_csv_sample_data(conn: Any,
                               trait_name: int, phenotype_id: int):
     """Fetch a trait and return it as a csv string"""
-    sql = ("SELECT  Strain.Id, PublishData.Id, Strain.Name, "
+    sql = ("SELECT DISTINCT Strain.Id, PublishData.Id, Strain.Name, "
            "PublishData.value, "
            "PublishSE.error, NStrain.count FROM "
            "(PublishData, Strain, PublishXRef, PublishFreeze) "