Knapsack Pro

NBi vs unittest comparison of testing frameworks
What are the differences between NBi and unittest?

NBi

http://www.nbi.io/

unittest

https://docs.Python.org/3/library/unittest.html
Programming language

.NET

Python

Category

Integration Testing, Unit Testing, Acceptance Testing

Unit Testing

General info

NBi is an open-source framework for testing Business Intelligence solutions or validating data quality.

NBi helps you to create tests targeting your databases, cubes, etls and reports. Tests are written in xml using an intuitive syntax therefore thereis no need of any development language. Nbi tests target databases, cubes, etls and reports

unittest is a unit testing framework for Python

The unittest test framework is Python’s xUnit style framework. It is a standard module that is bundled with Python and supports the automation and aggregation of tests and common setup and shutdown code for them.
xUnit
Set of frameworks originating from SUnit (Smalltalk's testing framework). They share similar structure and functionality.

No

Yes

unittest is a xUnit style frameworkfor Python, it was previously called PyUnit.
Client-side
Allows testing code execution on the client, such as a web browser

No

Yes

Front-end functionality and behaviour can be tested by unittest.
Server-side
Allows testing the bahovior of a server-side code

Yes

Nbi tests Business intelligence software which retrieve, analyze, transform and report data therefore it targets databases, cubes, etls and reports and you can natively connect to any database supporting OleDb or ODBC connection

Yes

Since the webserver funtionalities have their own features and each feature has its own functions, we can write tests with unittest to test each function
Fixtures
Allows defining a fixed, specific states of data (fixtures) that are test-local. This ensures specific environment for a single test

No

Yes

By use of the 'setUp()' function which is called to prepare the test fixture
Group fixtures
Allows defining a fixed, specific states of data for a group of tests (group-fixtures). This ensures specific environment for a given group of tests.

No

Yes

unittest allows you to group your initialization code into a setUp function and clean up code in a tearDown function
Generators
Supports data generators for tests. Data generators generate input data for test. The test is then run for each input data produced in this way.

N/A

Yes

unittest contains generator methods in the module 'unittest.TestCase'
Licence
Licence type governing the use and redistribution of the software

Apache License 2.0

MIT License

Mocks
Mocks are objects that simulate the behavior of real objects. Using mocks allows testing some part of the code in isolation (with other parts mocked when needed)

Yes

You can create your own mock objects

Yes

Mocks are available from the library unittest.mock which allows you to replace parts of your system under test with mock objects
Grouping
Allows organizing tests in groups

Yes

Yes, Nbi comes with a solution to automate, as much as possible, the creation of the test-suites through its user interface, named GenBI

Yes

One can build suites either manually or use test discovery to build the suite automatically by scanning a directory
Other
Other useful information about the testing framework