============================= test session starts ==============================
platform linux -- Python 3.12.3, pytest-9.0.2, pluggy-1.6.0 -- /usr/bin/python3
cachedir: .pytest_cache
rootdir: /home/jay/projects/InsuRo/.worktrees/task-2274-dev2/server
configfile: pyproject.toml
plugins: anyio-4.12.1, asyncio-1.3.0, cov-7.0.0, respx-0.22.0, Faker-40.8.0
asyncio: mode=Mode.STRICT, debug=False, asyncio_default_fixture_loop_scope=None, asyncio_default_test_loop_scope=function
collecting ... collected 30 items

server/tests/test_sb_helpers.py::TestSbRows::test_sb_rows_with_valid_list_data PASSED [  3%]
server/tests/test_sb_helpers.py::TestSbRows::test_sb_rows_with_empty_list PASSED [  6%]
server/tests/test_sb_helpers.py::TestSbRows::test_sb_rows_with_none_data PASSED [ 10%]
server/tests/test_sb_helpers.py::TestSbRows::test_sb_rows_without_data_attribute PASSED [ 13%]
server/tests/test_sb_helpers.py::TestSbRows::test_sb_rows_with_single_item_list PASSED [ 16%]
server/tests/test_sb_helpers.py::TestSbRows::test_sb_rows_with_complex_nested_data PASSED [ 20%]
server/tests/test_sb_helpers.py::TestSbFirst::test_sb_first_with_multiple_rows PASSED [ 23%]
server/tests/test_sb_helpers.py::TestSbFirst::test_sb_first_with_single_row PASSED [ 26%]
server/tests/test_sb_helpers.py::TestSbFirst::test_sb_first_with_empty_list PASSED [ 30%]
server/tests/test_sb_helpers.py::TestSbFirst::test_sb_first_with_none_data PASSED [ 33%]
server/tests/test_sb_helpers.py::TestSbFirst::test_sb_first_without_data_attribute PASSED [ 36%]
server/tests/test_sb_helpers.py::TestSbFirst::test_sb_first_with_complex_dict PASSED [ 40%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_with_valid_dict_data PASSED [ 43%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_with_none_data PASSED [ 46%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_without_data_attribute PASSED [ 50%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_with_empty_dict PASSED [ 53%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_with_complex_nested_dict PASSED [ 56%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_with_boolean_values PASSED [ 60%]
server/tests/test_sb_helpers.py::TestSbSingle::test_sb_single_with_numeric_values PASSED [ 63%]
server/tests/test_sb_helpers.py::TestEdgeCases::test_sb_rows_returns_list_type PASSED [ 66%]
server/tests/test_sb_helpers.py::TestEdgeCases::test_sb_first_returns_dict_or_none PASSED [ 70%]
server/tests/test_sb_helpers.py::TestEdgeCases::test_sb_single_returns_dict_or_none PASSED [ 73%]
server/tests/test_sb_helpers.py::TestEdgeCases::test_sb_rows_with_special_characters PASSED [ 76%]
server/tests/test_sb_helpers.py::TestEdgeCases::test_sb_first_with_special_characters PASSED [ 80%]
server/tests/test_sb_helpers.py::TestEdgeCases::test_sb_single_with_special_characters PASSED [ 83%]
server/tests/test_sb_helpers.py::TestIntegrationScenarios::test_scenario_list_query_then_first PASSED [ 86%]
server/tests/test_sb_helpers.py::TestIntegrationScenarios::test_scenario_single_query PASSED [ 90%]
server/tests/test_sb_helpers.py::TestIntegrationScenarios::test_scenario_list_query_iteration PASSED [ 93%]
server/tests/test_sb_helpers.py::TestIntegrationScenarios::test_scenario_empty_result_handling PASSED [ 96%]
server/tests/test_sb_helpers.py::TestIntegrationScenarios::test_scenario_safe_type_casting PASSED [100%]

============================== 30 passed in 0.07s ==============================