Unit test files

When you generate unit tests for a DataBlade® module, BladeSmith generates the files listed in the following table in the src\tests directory.
Table 1. Unit test files
File name Description
Setup.sql Optionally initializes the database. You can add SQL statements to create and populate the tables necessary for your debugging tests.

If you specify this file as your initialization file in the Properties dialog box, IfxQuery automatically runs this file after it creates a database.

Routine.sql Tests the user-defined routine. You can add SQL statements or modify the sample data for the routine. Use this file if you are debugging udr.c.

IfxQuery runs this file if you click Debug DataBlade Module with this file in the active window.

Opaque.sql Tests the support routines for each opaque data type. You can add SQL statements or modify the sample data for each support routine. Use this file if you are debugging Opaque.c or OpaqueServer.cpp.

IfxQuery runs this file if you click Debug DataBlade Module with this file in the active window.

Cleanup.sql Optionally deletes and drops tables and data in your test database.

IfxQuery runs this file if you click Debug DataBlade Module with this file in the active window.