Skip to content

v0.5.0b1

Choose a tag to compare

View all tags
@s3dev s3dev released this 11 Sep 09:38
· 3 commits to master since this release
v0.5.0b1
dd49842

Changes

MS SQL Server support:

  • A database interface has been added for MS SQL Server support, via
    pyodbc.

MSSQL table backup:

  • Functionality has been added to the MSSQL interface for backing up any
    given table in the database to the backup database. Note this is
    not a filesystem backup.
  • A 'database_exists' function has been added to the interface primarily
    to facilitate the backup, but also for general use.

MSSQL table checksum:

  • A function has been added to the MSSQL interface enabling the user to
    calculate a table checksum (easily).
  • Aside, this function will also be used by the MSSQL table backup logic
    to verify if a table was successfully backed up.

Other changes:

  • Updated the 'execute_query' method to include a 'commit' argument,
    which defaults to True for backwards compatibility.

Fixes:

  • Consistently applied the name 'mssql' for all MS SQL Server related
    object items in the interface; rather than variations such as
    'sqlserver'.
  • Addressed an issue when an MSSQL USP does not have any parameters to return.
  • Introduced exit codes to the backup routine for MSSQL.
  • Addressed an issue in reporting SQLAlchemy errors.

Testing:

  • The tests for the MSSQL interface have been updated for 100% code
    coverage. All MSSQL interface tests complete successfully.
  • Testing for MySQL and SQLite completed successfully (on a different
    environment) with 98% code coverage. The remaining 2% relates to the
    MSSQL and non-supported database engine routing in the
    database.DBInterface.new method.

Released: 2025-09-11

Assets 3
Loading