Skip to content

v2.0.0
Compare
Choose a tag to compare
@amochin amochin released this 01 Oct 10:29
· 7 commits to master since this release
v2.0.0
d4ba70a
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.

Database Library 2.0.0 is a new major release, bringing new keywords with inline assertions using Assertion Engine (#208) and retry mechanism (#209), logging query results in table format (#147), support for custom connection parameters (#220) and other improvements.

This version also contains renamed keyword parameters and deprecations of keywords and requires Python 3.8 or newer and Robot Framework 5.0.1 or newer.

New features and improvements

  • New keywords Check Row Count and Check Query Result with assertion engine and retry mechanism. #208 #209
  • Query results are now automatically printed in table format in RF log. This behaviour can be adjusted or disabled. See docs for details. #147
  • Handling of connection parameters in keyword Connect To Database was deeply refactored. There is only one mandatory parameter left - db_module, all other parameters are optional now. Plus any custom parameters are supported now - both provided as keyword arguments or in config file. See details in keyword docs. #220
  • Other logging in keywords was cleaned and improved.
  • Keyword parameters were renamed according to Python PEP8 - snake_case instead of formerly used camelCase. See more details below in the deprecations section.
  • Support for OUT params when calling a stored procedure in MSSQL, which doesn't return any result sets - implemented via new keyword argument additional_output_params. See extended docs of the Call Stored Procedure keyword. #219
  • The documentation of all keywords and the entire library was deeply cleaned, consolidated and improved.

Backwards incompatibilities and deprecations

  • This version requires Python 3.8 or newer and Robot Framework 5.0.1 or newer.
  • Keyword parameters were renamed according to Python PEP8 - snake_case instead of formerly used camelCase. Moreover, some parameter names were changed to shorter or more precise versions. The old parameter names are still supported, but deprecated - the library logs a warning in case of their usage. The deprecated old-named parameters will be removed in future versions. #188
  • Introducing new keywords Check Row Count and Check Query Result with inline assertions allows to deprecate some redundant keywords. They will be removed in future versions.
  • Support of custom parameters in the Connect To Database keyword allows to deprecate the Connect To Database Using Custom Params keyword - it's redundant now. The deprecated keyword will be removed in future versions.
  • During refactoring of connection parameters, some hardcoded fallback values were removed. These values can be still set, if required, with new support of any custom parameters in the Connect To Database keyword.
    • Stop using localhost as fallback value for DB host
    • Stop using {SQL Server} as fallback value for pyodbc driver
    • Stop using TCPIP as fallback valued for ibm_db protocol

Full Changelog: v1.4.4...v2.0.0

Assets 2
Loading