Data types


Since version 1.11, NBi offers the opportunity to validate the data-types of the attributes of a relational database. This feature will be extended in the next releases.

System-under-test

The system-under-test must be define with a parent element named data-type. Within this element, you must specify an element column with the same information that for a test of structure (see previous chapters).

Example:

<system-under-test>
  <data-type>
    <column
      caption="column"
      table="table"
      perspective="dwh"
      connectionString="ConnectionString"
    />
  </data-type>
</system-under-test>

Assertion

The unique valid assertion for a system-under-test data-type is the assertion is. This assertion expects a value equivalent to a data-type. The data-type could be vague or precise. To illustrate this, inside the element is you can define a value varchar or varchar(50). In case the result is a varchar(20), the first test will succeed but the last one will fail. This feature is also active for decimal or datetime types.

<assert>
  <is>
    varchar(50)
  </is>
</assert>