Publish from GitHub Actions?

[fdcastel]

@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.

[fdcastel]

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.

[pcisar]

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

[fdcastel]

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)?

[fdcastel]

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.