import pytest from unittest.mock import MagicMock @pytest.fixture def mock_sf(): sf = MagicMock() mock_cur = MagicMock() mock_cur.fetchall.return_value = [] mock_cur.fetchone.return_value = None mock_cur.description = [] sf.cursor.return_value = mock_cur return sf