Add pytest-xdist for parallel test execution

Without xdist it takes 2 minutes and 14 seconds and the second run with xdist on 10 core completing in 23.37 seconds

test/conftest.py

@@ -142,8 +142,12 @@ def data_config_filename() -> str:
 
 @pytest.fixture(scope="session")
 def db_uri():
-    """Provide the database uri configuration to run the migration on."""
-    return os.environ.get("DATABASE_URI_TEST", "postgresql://nwa:nwa@localhost/gso-test-db")
+    """Provide a unique database URI for each pytest-xdist worker, or a default URI if running without xdist."""
+    worker_id = os.getenv("PYTEST_XDIST_WORKER")
+    if worker_id:
+        return f"postgresql://nwa:nwa@localhost/gso-test-db_{worker_id}"
+
+    return "postgresql://nwa:nwa@localhost/gso-test-db"
 
 
 def run_migrations(db_uri: str) -> None:
@@ -176,7 +180,7 @@ def _database(db_uri):
     db.update(Database(db_uri))
     url = make_url(db_uri)
     db_to_create = url.database
-    url = url.set(database="postgres")
+    url = url.set(database=url.database)
 
     engine = create_engine(url)
     with engine.connect() as conn:
@@ -281,7 +285,7 @@ def partner_factory():
     return _create_partner
 
 
-@pytest.fixture(scope="session")
+@pytest.fixture()
 def geant_partner(partner_factory):
     return partner_factory(name="GEANT-TEST", email="goat-test@geant.org")