"""Mirrors tests/group_by_name.rs. Needs a live MariaDB (SQL_URI); skips with a message rather than failing when none is reachable, same as test_species_by_name.py. """ import http.client import json import socket import unittest from server_test_case import HOST, PORT, ServerTestCase def database_reachable(): try: with socket.create_connection(("127.0.0.1", 3306), timeout=0.5): return True except OSError: return False class GroupByNameTest(ServerTestCase): def test_group_by_name_bxd_returns_group_row(self): if not database_reachable(): self.skipTest("no database on 127.0.0.1:3306") conn = http.client.HTTPConnection(HOST, int(PORT), timeout=10) try: conn.request("GET", "/groups/BXD") response = conn.getresponse() body = response.read() finally: conn.close() self.assertEqual(response.status, 200) group = json.loads(body) self.assertEqual(group["name"], "BXD") self.assertEqual(group["display_name"], "BXD") self.assertEqual(group["genetic_type"], "riset") def test_group_by_name_numeric_id_returns_same_group_row(self): """BXD's InbredSet.Id is 1, same as its InbredSetId; replicates gn-guile's gn.data.population:population-info, which looks a group up by numeric Id rather than by name.""" if not database_reachable(): self.skipTest("no database on 127.0.0.1:3306") conn = http.client.HTTPConnection(HOST, int(PORT), timeout=10) try: conn.request("GET", "/groups/1") response = conn.getresponse() body = response.read() finally: conn.close() self.assertEqual(response.status, 200) group = json.loads(body) self.assertEqual(group["name"], "BXD") self.assertEqual(group["id"], 1) def test_group_by_name_unknown_group_returns_404(self): if not database_reachable(): self.skipTest("no database on 127.0.0.1:3306") conn = http.client.HTTPConnection(HOST, int(PORT), timeout=10) try: conn.request("GET", "/groups/not-a-real-group") response = conn.getresponse() body = response.read() finally: conn.close() self.assertEqual(response.status, 404) request_id = response.getheader("x-request-id") error = json.loads(body) self.assertEqual(error["status"], 404) self.assertEqual(error["code"], "group_not_found") self.assertEqual(error["operation_id"], "group_by_name") self.assertEqual(error["spec_url"], "/openapi.json") self.assertEqual(error["next"], "/groups") self.assertEqual(error["request_id"], request_id) if __name__ == "__main__": unittest.main()