Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Aqua Data Studio has made the tool "Manage Unit Tests" easy to use for SQLServer and PostgreSQL database platforms. Users can find the feature under the Tools main application menu or by selecting Tools > Manage Unit Test from the right-click menu in the database Schema browser.

Image RemovedImage Added

Unit Testing Schema.pngImage RemovedImage Added

Choose the Database or Server in the connection dialog. In the Manage Unit Tests UI, users can choose which database to work on, SQLServer, or PostgreSQL.

Info
This option is only enabled for SQLServer and PostgreSQL connections.

Unit Testing connection dialog.pngImage RemovedImage Added

The Manage Unit Tests workspace offers different options.

Unit Testing Toolbar Menu.pngImage RemovedImage Added

  • Create Unit Test Class - Brings up a window to type in a name for the Test Class. Once it-s created, it will automatically appear in the Unit Test tree.
  • Create Unit Test Case - Brings up a window to type in a name for the Test Case and to add a Description. Once created, the Edit Unit Test Function will open. In this section you can edit the name but not the description.
  • Run Test - To run the test for the selected Test Class or Test Case.
  • Rerun Test - In case users unselects a Test Class or Test Case, use the Rerun Test icon to try testing it again.
  • Stop - To stop a Test.
  • Refresh - To have a fresh look into the window and start selecting which Test Class and Test Case to Run again.
  • Reconnect - To reconnect to the Database.
  • Help - To be redirected to the Online Help page.

Unit Testing Create Class.pngImage RemovedImage Added

Unit Testing Create Case.pngImage RemovedImage Added

In the Framework section, choose if you want to use a pgTap or a pgUnit.

Unit Testing Framework Tab.pngImage RemovedImage Added

In the Database section, select between the Databases you have available for Unit Testing.

Unit Testing Database Tab.pngImage RemovedImage Added

In the search section, users can look for a specific name and Run a Test faster.

Unit Testing Search.pngImage RemovedImage Added

Once users have selected which Test Class and Test Case to Run, click on the Run Test icon.

The Results will appear at the bottom of the window. There is a section where users can select if they want to View as a Spreadsheet or to have the Results spreadsheet be sent to an email address. Remember that to use this feature you have to have the mail system enabled. You can configure it under File > Options > Email.

Image Added


Image Added


Unit Testing Results.pngImage RemovedImage Added