-
Notifications
You must be signed in to change notification settings - Fork 12
NMB_OF_RESULTS
Jakub Raczek edited this page Nov 17, 2016
·
11 revisions
<cmpSqlResultsTest>
<compare mode="NMB_OF_RESULTS">
<sql datasourceName="PostgreSQL">
<![CDATA[
SELECT addressid, addressline1, addressline2, city, stateprovinceid, postalcode, modifieddate
FROM public.personaddress
LIMIT 1
]]>
</sql>
<assert type="EQ">1</assert>
<assert type="NE">0</assert>
<assert type="LT">2</assert>
<assert type="LE">1</assert>
<assert type="GE">1</assert>
<assert type="GT">0</assert>
</compare>
</cmpSqlResultsTest>
- datasourceName - name of connection to database engine defined in cmpSqlResults-config.xml file Supported assertions:
- EQ (equal),
- NE (not equak),
- LT (less than),
- LE (less or equal),
- GE (greater or equal),
- GT (greater than) You can combine multiple assertions at the same time. If you do not specify any assertion, the test will pass
- Home
- Getting started
- Command line parameters
- Deploying licensed jdbc drivers
- Comparators
- Fetch
- KEY
- Minus
- NMB_OF_RESULTS
- FILE
- OLAP
- Building multilevel tests structure
- TeamCity support
- Test definitions
- Filtering tests for execution
- Test report
- Compiling, replacing tokens in connection definition
- Replacing tokens in SQL queries
- Execute Stored Procedure before test