# TOB Generator

### ![](https://1143774439-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1ooXfQ2qWGFRh6lihybt%2Fuploads%2Fgit-blob-b1ff09efdc12bf5f66706c589ab22a99da1cb7dd%2FIcon_TOB_program.gif?alt=media)

### Abstract

Plug-in to generate test data objects containing 1:1 compare sql scripts from database schemas by OMrun and generate tob objects to compare the content of all existing tables within a source and a target database. This plug-in is often used in combination with TscGenerator and RtlGenerator.

***

### Input

Execution parameters to invoke a generation:

**Field `@param1`** (**Infrastructure info**) \[mandatory]

* Description: TestScripts BusinessSystem and Component, separated by semicolon
* Syntax: \<full path> (without ending backslash);\<business system name>;\<componant name>
* Example: D:\omrun\_demo\DCC-Event\TestScripts;Comparison;DataCompare

**Field `@param2`** (**Schema and table names**) \[mandatory]

* Description: Collected schema.table (source) and schema.table (destination) prepared by RtlGenerator, separated by semicolon
* Syntax: \<schema name>.\table name> (source database);\<schema name>.\table name> (target database)
* Example: demo\_source.categories;demo\_target.categories

**Field `@param3`** (**Table selection query without schema name**) \[mandatory]

* Description: Generated query prepared by RtlGenerator
* Syntax: \<Query> (without schema name)
* Example: \<SELECT category\_id AS category\_id, category\_name AS category\_name, description AS description, picture AS picture FROM categories>

**Field `@param4`** (**Primary keys from database**) \[mandatory]

* Description: Collected primary keys prepared by RtlGenerator, separated by semicolon
* Syntax: \<Id1>;\<Id2> etc.
* Example: \<category\_id>;\<other\_id>

***

### Output

Generated 1:1 data compare test objects contained within a predefined test component, based on the generated parameter list of a schema table query from source and target databases.