"""Mirrors tests/species.rs. Needs a live MariaDB (SQL_URI); skips with a message rather than failing when none is reachable (e.g. inside the Guix build sandbox, which has no network/database access). """ 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 SpeciesTest(ServerTestCase): def test_species_returns_ok_with_species_list(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", "/species") response = conn.getresponse() body = response.read() finally: conn.close() self.assertEqual(response.status, 200) species = json.loads(body) self.assertTrue(species) for record in species: self.assertIn("name", record) self.assertIn("family", record) # mouse and rat are always present in the database. names = {record["name"] for record in species} self.assertIn("mouse", names) self.assertIn("rat", names) if __name__ == "__main__": unittest.main()