diff options
Diffstat (limited to 'gn3')
-rw-r--r-- | gn3/api/general.py | 3 | ||||
-rw-r--r-- | gn3/db/traits.py | 2 |
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) " |