From 2edc685bb7c56d5f9f28da09378f300bfe81021d Mon Sep 17 00:00:00 2001 From: Pjotr Date: Thu, 8 Oct 2026 13:37:57 +0000 Subject: * src/db.rs, src/routes: add mapping_method, tissue, /mapping-methods, /accessions. Answers four more questions of aisearch's full_benchmark.csv from tables the API did not expose. * src/db.rs (Group, GroupDetail), src/routes/groups.rs: groups gain `mapping_method`, the name of the MappingMethod row their mapping_method_id points to (qtlreaper, Rqtl, ...), or null. * src/db.rs (Dataset): datasets gain `tissue`, the Tissue their ProbeFreeze points to (e.g. "Brain mRNA"). * src/routes/mapping_methods.rs: GET /mapping-methods lists the MappingMethod table, including tools no group uses (PLINK, FastMap). * src/routes/accessions.rs: GET /accessions/{accession} resolves a GeneNetwork accession number (GN602, gn602 or 602) via InfoFiles to the dataset's name, title, category (publish/probeset) and group. * docs/genenetwork_datatypes.md: MappingMethodId is a key into the MappingMethod table (the authoritative reading); GN2's code-based reading is noted as superseded. * tests/benchmark.rs, test/data/benchmark_search.json: add the 60 new full-benchmark rows that pass (full rows 0..114; search rows run against recorded production gn3, the rest need the database), and full rows 33 (mapping tools), 34 (Rqtl for outbred sets), 35 (GN602) and 44 (only GTEx v8 has TPM datasets). The untested rows are listed in the file's header comment with the reason for each. * tests, test/python: tests for the new fields and endpoints; both endpoints added to the OpenAPI and next-link crawl tests. * README.md, RELEASE_NOTES.md: document the new fields and endpoints. Co-Authored-By: Claude Sonnet 5.5 --- test/python/test_mapping_methods.py | 46 +++++++++++++++++++++++++++++++++++++ 1 file changed, 46 insertions(+) create mode 100644 test/python/test_mapping_methods.py (limited to 'test/python/test_mapping_methods.py') diff --git a/test/python/test_mapping_methods.py b/test/python/test_mapping_methods.py new file mode 100644 index 0000000..b5f7cdb --- /dev/null +++ b/test/python/test_mapping_methods.py @@ -0,0 +1,46 @@ +"""Mirrors tests/mapping_methods.rs. Needs a live MariaDB (SQL_URI) and a +valid token (every endpoint needs one now -- see docs/gn-auth.md); +skips with a message rather than failing when either is missing, same +as test_groups.py. +""" + +import http.client +import json +import unittest + +from auth_helpers import TOKEN_ENV, auth_token +from server_test_case import HOST, PORT, ServerTestCase, database_reachable, envelope_data + + +class MappingMethodsTest(ServerTestCase): + EXTRA_ENV = TOKEN_ENV + + def get(self, path): + token = auth_token() + if not token: + self.skipTest("no token (see docs/gn-auth.md)") + conn = http.client.HTTPConnection(HOST, int(PORT), timeout=30) + try: + conn.request("GET", path, headers={"Authorization": f"Bearer {token}"}) + response = conn.getresponse() + return response, response.read() + finally: + conn.close() + + def test_mapping_methods_lists_the_tools(self): + if not database_reachable(): + self.skipTest("no database on 127.0.0.1:3306") + + response, body = self.get("/mapping-methods") + self.assertEqual(response.status, 200) + methods = envelope_data(body) + # The MappingMethod table lists tools no group uses (PLINK, FastMap). + self.assertEqual( + [m["name"] for m in methods], + ["qtlreaper", "Rqtl", "HappyR", "PLINK", "FastMap"], + ) + self.assertEqual(methods[0]["id"], 1) + + +if __name__ == "__main__": + unittest.main() -- cgit 1.4.1