Description

• Declare a condition that should be true.
• Throw an error if the test breaks for an unexpected reason.
• End in failure if the assertion proves false.

Attributes

List of assert() Attributes

assert() for Database

Go to top

assert() for File

Go to top

assert() for Data Sets

Go to top

Individual assert() Attributes

assert() for Database Context

[Database Feature Module - Configuration properties not listed here.]

connection-id:

• Corresponds to id property in the @Database annotation.
• Any value other than one that corresponds to the id property in the @Database annotation is not allowed.

mode:

• Corresponds to one member in the list of modes, found in the @Database annotation.
• Any value other than one that corresponds to one of the modes listed in the @Database annotation is not allowed.

source-table:

• Database table with "actual" data for the assert operation.

target:

• Refers to a data file, found in folder data/, a sibling to the ETLUnit test class.

target-file:

• Not supported.

source-schema:

• The source table's schema name.

sql-script:

• Store the SQL script in a file with the extension ".sql" in its name, in folder sql/, a sibling to the ETLUnit test.

sql:

• In-line SQL script.

source-reference-file-type:

• Name of the FML file to be applied to the source table.  Does not include extension ".fml."

target-reference-file-type:

• Name of the FML file to be applied to the target data file.  Does not include extension ".fml."

reference-file-type:

• Synonym to source-reference-file-type.

column-list:

• A list of column names to include or exclude.

column-list-mode:

• Valid values:
  • include
    • Include for consideration the columns enumerated in column-list.
  • exclude
    • Exclude for consideration the columns enumerated in column-list.

assertion-mode:

• Valid values:
  • equals
    • Byte for byte, the source content matches the target content.
  • empty
    • The source is empty.
  • notEmpty
    • The source is not empty.

failure-id:

• In case of failure in the assert operation, use this failure id instead of the one that would normally be generated.

Go to top

assert() for File Context

[File Feature Module - Configuration properties not listed here.]

source-file:

• Required
• This is the "actual" data in the assert operation.  It may come from one of two places:
  
  • Output from the execute operation.
  • A file that has been registered with ETLUnit with the register operation.

sql:

• In-line SQL script.

sql-script:

• Store the SQL script in a file with the extension ".sql" in its name, in folder sql/, a sibling to the ETLUnit test.

target:

• Refers to a data file, found in folder data/, a sibling to the ETLUnit test class.

classifier:

• Value is a string.  Ad-hoc name of a classifier that will prevent, for instance, a registered file from producing an ERR_REGISTER_FILE_NAME_DUPLICATED error.

context:

• Used like classifier, it sets the assert in a different context than similar asserts.  May prevent a registered file from producing an ERR_REGISTER_FILE_NAME_DUPLICATED error.

producer:

failure-id:

• In case of failure in the assert operation, use this failure id instead of the one that would normally be generated.

assertion-mode:

• Valid values:
  • equals - - the default
    • Byte for byte, the source and target files compare favorably.
  • exists
    • The source file exists
  • notExists
    • The source file does not exist
  • empty
    • The source file is empty
  • notEmpty
    • The source file is not empty

reference-file-type:

• Synonym to source-reference-file-type.

base-source-reference-file-type:

• Reference file type for the source file in a three-tiered assertion (source-file, sql or sql-script, and target).
• source-file must have FML for this to work.
• Example:

source-reference-file-type:

• Name of the FML file to be applied to the source file.  Does not include extension ".fml."

target-reference-file-type:

• Name of the FML file to be applied to the target file.  Does not include extension ".fml."

column-list:

• A list of column names to include or exclude.

column-list-mode:

• Valid values:
  • include
    • Include for consideration the columns enumerated in column-list.
  • exclude
    • Exclude for consideration the columns enumerated in column-list.

Go to top

assert() for Data Sets Context

data-set-name:

• Required
• Matches the name of a text file in a folder 'dataset,' which is a sibling of the ETLUnit test class.
• The data set text file has file extention '.dataset.'

data-set-id:

• The data-set-id's value matches the value of the id property in the data set member's properties section.

failure-id:

• The failure to be generated by ETLUnit if the operation using the data set fails.
• A failure elsewhere in the test method will not invoke this failure ID.

ignore-data-set-properties:

• Causes the ETLUnit test to ignore properties included in the data set member's properties section.
• This does not include the id property in the data set member's properties section.

Go to top

Examples

Here is an example of the assert operation in the Database context that involves some configuration and FML.

Supporting Files

Configuration

Data

/*-- ID    COL3  --*/
/*-- INTEGER    VARCHAR  --*/
1    01012014
2    02022014
3    03032014
4    04042014
5    05052014
6    06062014
7    07072014
8    08082014
9    09092014
10    10102014
11    11112014
12    12122014

Sample Test Code

Go to top