message: used tmp_path_factory fixture for 'test_alex_multithread
diff: @@ -2,6 +2,12 @@ import duckdb
  from threading import Thread, current_thread
  import pandas as pd
  import os
  +import pytest
  +
  +@pytest.fixture(scope="session")
  +def tmp_database(tmp_path_factory):
  + database = tmp_path_factory.mktemp("databases", numbered=True) / "tmp.duckdb"
  + return str(database)
  def insert_from_cursor(duckdb_con):
  # Insert a row with the name of the thread
  @@ -61,12 +67,10 @@ class TestPythonMultithreading(object):
  assert duckdb_con.execute("""SELECT * FROM my_inserts order by thread_name""").fetchall() == [('my_thread_0',), ('my_thread_1',), ('my_thread_2',)]
  - def test_multiple_cursors_persisted(self, request):
  - dbname = f'{request.node.name}.duckdb'
  - duckdb_con = duckdb.connect(dbname)
  + def test_multiple_cursors_persisted(self, tmp_database):
  + duckdb_con = duckdb.connect(tmp_database)
  duckdb_con.execute("""CREATE OR REPLACE TABLE my_inserts (thread_name varchar)""")
  -
  thread_count = 3
  threads = []
  @@ -84,14 +88,11 @@ class TestPythonMultithreading(object):
  assert duckdb_con.execute("""SELECT * FROM my_inserts order by thread_name""").fetchall() == [('my_thread_0',), ('my_thread_1',), ('my_thread_2',)]
  duckdb_con.close()
  - os.remove(dbname)
  - def test_same_connection_persisted(self, request):
  - dbname = f'{request.node.name}.duckdb'
  - duckdb_con = duckdb.connect(dbname)
  + def test_same_connection_persisted(self, tmp_database):
  + duckdb_con = duckdb.connect(tmp_database)
  duckdb_con.execute("""CREATE OR REPLACE TABLE my_inserts (thread_name varchar)""")
  -
  thread_count = 3
  threads = []
  @@ -109,4 +110,3 @@ class TestPythonMultithreading(object):
  assert duckdb_con.execute("""SELECT * FROM my_inserts order by thread_name""").fetchall() == [('my_thread_0',), ('my_thread_1',), ('my_thread_2',)]
  duckdb_con.close()
  - os.remove(dbname)
  