Description

fdcastel

opened on Nov 17, 2025

Issue body actions

@pcisar Could you give me an overview of your current process for building, testing, and releasing (publishing) a new version of this library?

I’d be happy to create GitHub Actions workflows to automate and speed up the release process.

Activity

1. fdcastel commented on Nov 17, 2025

   

   fdcastel

   on Nov 17, 2025

   MemberAuthor

   More actions

   I ran

   uv run pytest

   on a Windows system with Firebird 3.0.13 and encountered the errors below.

   =============================================== short test summary info ===============================================
   FAILED tests/test_connection.py::test_properties - assert not True
   FAILED tests/test_connection.py::test_transaction - assert not True
   FAILED tests/test_connection.py::test_db_info - assert [31798] == []
   FAILED tests/test_db_createdrop.py::test_create_drop_dsn - UnboundLocalError: cannot access local variable 'dsn' where it is not associated with a value
   FAILED tests/test_param_buffers.py::test_tpb_parsing - firebird.driver.types.DatabaseError: Internal error when using clumplet API: attempt to store data in dataless clum...
   FAILED tests/test_transaction.py::test_transaction_info - AssertionError: assert 'C:\\Users\\fdcastel.TOLKIEN\\AppData\\Local\\Temp\\pytest-of-fdcastel\\pytest-13\\db0\\test...
   ERROR tests/test_events.py::test_one_event - UnboundLocalError: cannot access local variable 'con' where it is not associated with a value
   ERROR tests/test_events.py::test_multiple_events - UnboundLocalError: cannot access local variable 'con' where it is not associated with a value
   ERROR tests/test_events.py::test_20_events - UnboundLocalError: cannot access local variable 'con' where it is not associated with a value
   ERROR tests/test_events.py::test_flush_events - UnboundLocalError: cannot access local variable 'con' where it is not associated with a value
   ERROR tests/test_info_providers.py::test_statement_info_provider - firebird.driver.types.DatabaseError: Dynamic SQL Error
   ERROR tests/test_server.py::test_backup - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_restore - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_local_backup - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_local_restore - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_nbackup - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_nrestore - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_set_default_cache_size - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_set_sweep_interval - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_shutdown_bring_online - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_set_space_reservation - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_set_write_mode - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_set_access_mode - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_set_sql_dialect - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_activate_shadow - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_no_linger - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_sweep - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ERROR tests/test_server.py::test_repair - Failed: Failed to create restore target DB C:\Users\fdcastel.TOLKIEN\AppData\Local\Temp\pytest-of-fdcastel\pytest-1...
   ================================ 6 failed, 85 passed, 17 skipped, 22 errors in 31.20s =================================
   

   I’ll dig into it later, but any pointers would help.
2. pcisar commented on Nov 17, 2025

   

   pcisar

   on Nov 17, 2025

   Contributor

   More actions

   I use Hatch. So install it, even via uv tool install hatch.
   Then from driver checkout directory run: hatch test

   Reacted by F.D.Castel
3. fdcastel commented on Nov 17, 2025

   

   fdcastel

   on Nov 17, 2025

   MemberAuthor

   More actions

   Thanks.

   I've installed hatch via uv tool install hatch.

   I ran the tests with hatch test: There are now 6 tests failing:

   ========= short test summary info =========
   FAILED tests/test_connection.py::test_properties - assert not True
   FAILED tests/test_connection.py::test_transaction - assert not True
   FAILED tests/test_connection.py::test_db_info - assert [31800] == []
   FAILED tests/test_param_buffers.py::test_tpb_parsing - firebird.driver.types.DatabaseError: Internal error when using clumplet API: attempt to store data in dataless clumplet
   FAILED tests/test_server.py::test_local_backup - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\fdcastel.TOLKIEN\\AppData\\Local\\Temp\\pytest-of-fdcastel\\pytest-31\\db0\\test_svc_db.fbk'
   ERROR tests/test_info_providers.py::test_statement_info_provider - firebird.driver.types.DatabaseError: Dynamic SQL Error
   ========= 5 failed, 108 passed, 16 skipped, 1 error in 53.05s ========= 
   

   Investigating.

   On what environment do you run the tests (OS, Firebird Version, etc)?
4. fdcastel commented on Nov 17, 2025

   

   fdcastel

   on Nov 17, 2025

   MemberAuthor

   More actions

   On same computer, with Firebird 5.0.3 installed:

   ========== short test summary info ==========
   FAILED tests/test_fb4.py::test_01_select_with_timezone_region - assert None is not None
   FAILED tests/test_fb4.py::test_02_select_with_timezone_offset - assert None is not None
   FAILED tests/test_fb4.py::test_03_insert_with_timezone_region - assert None is not None
   FAILED tests/test_fb4.py::test_04_insert_with_timezone_offset - assert None is not None
   FAILED tests/test_fb4.py::test_05_select_defloat - AssertionError: assert False
   FAILED tests/test_fb4.py::test_06_insert_defloat - AssertionError: assert False
   FAILED tests/test_fb4.py::test_07_select_int128 - firebird.driver.types.DatabaseError: Dynamic SQL Error
   FAILED tests/test_fb4.py::test_08_insert_int128 - ValueError: numeric overflow: value 1111111111222222222233333333334444
   FAILED tests/test_server.py::test_running - firebird.driver.types.DatabaseError: operating system directive fopen failed
   FAILED tests/test_server.py::test_wait - firebird.driver.types.DatabaseError: operating system directive fopen failed
   FAILED tests/test_server.py::test_log - firebird.driver.types.DatabaseError: operating system directive fopen failed
   FAILED tests/test_server.py::test_output_by_line - firebird.driver.types.DatabaseError: operating system directive fopen failed
   FAILED tests/test_server.py::test_output_to_eof - firebird.driver.types.DatabaseError: operating system directive fopen failed
   FAILED tests/test_server.py::test_local_backup - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\fdcastel.TOLKIEN\\AppData\\Local\\Temp\\pytest-of-fdcastel\\pytest-38\\db0\\test_svc_db.fbk'
   ========== 14 failed, 114 passed, 2 skipped in 32.75s ==========
   

   I'll try on Linux systems.

Issue actions