Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Auto-generating tests
Migration Platform
  • Overview
  • Product features
    • Release notes
    • Source and target platforms
    • Third-party applications
  • Getting started
    • Creating a new project
    • Ora2Pg installation
    • Tree view filtering
    • Compatible ODAC versions
    • Opening an existing project
    • Connecting to servers
      • Connecting to an Azure SQL Database
      • Connecting to an Oracle database
      • Connecting to a PostgreSQL database
      • Connecting to a Microsoft SQL Server database
    • Command timeout
  • Mapping
    • Object mapping
    • Error mapping rules
    • Data types mapping
  • Schema conversion
  • Schema comparison
  • Data comparison
  • Data migration
    • Migration task
      • Creating migration tasks
      • Templates
      • Migration options
      • Task actions
      • Task statuses
      • Errors or non-standard situations
    • Installing migration agent
      • Installing and uninstalling the data migration agent
      • Registering the migration agents
    • Project settings
  • Test organizer
    • Creating tests
    • Auto-generating tests
    • Groups and tests execution
    • Groups and tests states and execution statuses
    • Tests moving logic
    • Importing and exporting tests
    • Advanced comparison options
    • Creating reports
    • Error handling
  • Data store
  • Development project
  • System requirements
  • Hot keys
  • Known issues
  • Support

Auto-generating tests

  • Share
    • Share via Facebook
    • Share via Twitter
    • Share via Linkedin

Test Organizer module includes a mechanism for autogenerating tests for any object. It allows for automating the process of test creation and reducing time on manual test creation and setting parameter values.

To create a test automatically go to the context menu of the Source tree and select the Auto-generate tests option (Figure 1).

Note: By default, the name of an autogenerated test is <Source object name>$<Abbreviated template name>.


Figure 1. Autogenerating action

The DB Best Migration Platform has a set of templates that you can use to generate tests:

  • Call template — is used to auto-generate tests for the Procedure, Function, Package function, and Packaged procedure objects
  • Select template — is used to auto-generate tests for the Table and View objects.
  • Insert/Update/Delete templates — is used to auto-generate tests for the Table object only.

Note: You can’t use the empty template for autogenerating tests.

Group hierarchy of generated tests

The generated tests are combined into groups according to the following logic:

For the schema level:

  • AG_<Schema name>
    • AG_<Category name>
      • Groups and tests
    • AG_<Category name>
      • Groups and tests

For the category level:

  • AG_<Category name>_Tests
    • <Category name>_<Template name>
      • Tests of the category and template
    • <Category name>_<Template name>
      • Tests of the category and template

For a package:

  • Pckg_<Package name>_Tests
    • Pckg_Function_Tests
      • Tests
    • Pckg_Procedure_Tests
      • Tests

Tests auto-generation settings

Use the settings feature for tests auto-generation to generate tests in 3 different ways:

  • sort test groups by object type, test template, object name;
  • create tests with user-defined row limit or without the limit;
  • generate tests for database code objects using desired strategy and parameter inputs.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].

Did this page help you?

Provide Feedback
Next Overview

Did this page help you? Yes

Thanks for letting us know that we did a great job.

Did this page help you? No

Thanks for letting us know that there is a problem on this page.

Send Feedback

Feel free to share your ideas or occurred issues with us. The DB Best team will be happy to make our documentation better.

Please, specify your email address so that we can reach out to you to clarify your question. Also, we will use this email address to notify you about solving the issue.

* marks the mandatory fields

Dark theme Light theme

© 2002–2021 DB Best Technologies, LLC. All rights reserved.