From c33cfc004e3b7f3e1dc52d3e89c785a175edd0d6 Mon Sep 17 00:00:00 2001 From: John Nduli Date: Mon, 26 Aug 2024 20:40:49 +0300 Subject: feat: add api calls to get categories and last comment --- gn3/api/metadata_api/wiki.py | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'gn3/api') diff --git a/gn3/api/metadata_api/wiki.py b/gn3/api/metadata_api/wiki.py index 1e566cd..32872f3 100644 --- a/gn3/api/metadata_api/wiki.py +++ b/gn3/api/metadata_api/wiki.py @@ -85,3 +85,28 @@ def get_wiki_entries(symbol: str): payload.headers["Content-Type"] = "application/ld+json" return payload, status_code return jsonify(data), status_code + + +@wiki_blueprint.route("/", methods=["GET"]) +def get_wiki(comment_id: int): + with db_utils.database_connection(current_app.config["SQL_URI"]) as conn: + return jsonify(wiki.get_latest_comment(conn, comment_id)) + return jsonify(error="Error editting wiki entry, most likely due to DB error!"), 500 + + +@wiki_blueprint.route("/categories", methods=["GET"]) +def get_categories(): + with db_utils.database_connection(current_app.config["SQL_URI"]) as conn: + cursor = conn.cursor() + categories_dict = wiki.get_categories(cursor) + return jsonify(categories_dict) + return jsonify(error="Error editting wiki entry, most likely due to DB error!"), 500 + + +@wiki_blueprint.route("/species", methods=["GET"]) +def get_species(): + with db_utils.database_connection(current_app.config["SQL_URI"]) as conn: + cursor = conn.cursor() + species_dict = wiki.get_species(cursor) + return jsonify(species_dict) + return jsonify(error="Error editting wiki entry, most likely due to DB error!"), 500 -- cgit v1.2.3