Skip to content

v1.11-Beta

Pre-release
Pre-release
Compare
Choose a tag to compare
@Seddryck Seddryck released this 12 Sep 20:55

Release 1.11

This release 1.11 introduces a set of new features and a bunch of bug fixes. The good news of this release are that we've a new contributor who successfully fixed three bugs and that I've started to work on xml as a data source.

This release is downloadable from there.

Version: 1.11.0.11 aka v1.11-BETA

What's new ?

New features

  • Load result-sets from xml files More info
  • You can test the data-type of a column in a relational model More info
  • Support of SSIS 2008R2 and 2012 for ETL testing More info
  • Add routines (stored procedures, table-valued-functions and scalar functions) to the testable objects of a relational model. More info
  • Register database providers in the config file to improve support of non-Microsoft data sources More info
  • One-sided tolerance More info

Bug fixes

Framework

genbi

What's next ?

Promote this release from status Beta to Stable

Main ideas for release 1.12 (or next)

  • Continue to support xml as a data source. The final goal is to be able to query xml files from reports (SSRS).
  • Support assertions about the count of rows added (or updated or deleted) in a table after the execution of a SQL statement or a ETL.
  • Support for testing the parameters of routine

Other ideas probably not for 1.12 but for later

  • Create fakes or stubs of views, stored procedures or functions during the setup of a test and remove them during the cleanup. Work already started
  • Support to surround the test with a transaction and rollback the transaction when the test has been executed.
  • Execute tests with etls running on a remote server.
  • Add a setup command to process parts of a cube (SSAS).
  • Support some tests about result-sets, to express easily conditions such has "If this field is greater than X then this other field must be greater than Y".
  • Support transformation of the result-set in the assert (move columns, remove columns, add columns).

I'm (still) working on a Release 2.0. This work is delayed to the lack of GUI for NUnit 3.0. Anyway the goals are still:

  • Lot of internal refactoring meaning easier to integrate new features (mostly done)
  • Compatible with NUnit 3.0 meaning easier to setup a test suite !
  • Easier to port it to another test framework than NUnit (xUnit, Fixie, ...)
  • Easier to write helpers to compare result-sets
  • Easier to create a Visual Studio Add-in

Naturally this Release 2.0 has a big constraint linked to the availability of NUnit 3.0 (currently still not available) so no planned date for the moment.