NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
It should be possible to filter a result-set based on the content of another result-set. At the moment only equi-join conditions should be supported but could be extended in the future.
All rows of the initial result-set having no corresponding row in the second result-set are filtering out.
<result-set>
<query>
select 'a' as f0, 'FOO' as f1, null as f2 union all select 'B', 'bar', 'quark'
</query>
<alteration>
<exist>
<result-set>
<query>
select 'FOO' as Ref, 'Boo' as f0 union all select 'quark', 'Boo'
</query>
</result-set>
<condition>
<mapping candidate="f1" reference="Ref" />
</condition>
</exist>
</alteration>
</result-set>
It should be possible to filter a
result-set
based on the content of anotherresult-set
. At the moment only equi-join conditions should be supported but could be extended in the future.All rows of the initial result-set having no corresponding row in the second result-set are filtering out.