Step documentation for DbTable
Delete templated table data
Deletes data from a table
Sentences
Type |
Language |
Sentence |
Given |
en |
^the ([a-zA-Z0-9_@$#-]+) table (.+) is empty$ |
Arguments
Parameter |
Datatype |
Description |
database config |
String |
The name of the database config |
table name |
String |
The name of the table to delete the data from |
Examples
Given the demo table CUST_SAT is empty
Retrieve data of templated table
Retrieves data from a table or view
Sentences
Type |
Language |
Sentence |
When |
en |
^I retrieve the contents of the ([a-zA-Z0-9_@$#-]+) (.+) (?:table |
Arguments
Parameter |
Datatype |
Description |
database config |
String |
The name of the database config |
table name |
String |
The name of the table to retrieve the data from |
Examples
When I retrieve the contents of the demo CUST_SAT table
Insert data into table
Loads data into a table
Sentences
Type |
Language |
Sentence |
When |
en |
^I insert the following data in ([a-zA-Z0-9_@$#-]+) table (.+):$ |
Arguments
Parameter |
Datatype |
Description |
database config |
String |
The name of the database config |
table name |
String |
The name of the table to insert the data into |
data to insert |
DataTable |
The data to load into the table. See TestDataTable. |
Examples
When I insert the following data in demo table CUST_SAT:
| Id | Description |
| 1 | 'FirstRow' |
| 2 | 'SecondRow' |
Add key table to composite object
Adds a key table to a composite object. 'Key' means inserts into this table will be made distinct
Sentences
Type |
Language |
Sentence |
Given |
en |
^I have a key table named (.+) in ([a-zA-Z0-9_@$#-]+) for object (.+)$ |
Arguments
Parameter |
Datatype |
Description |
table name |
String |
The name of the key table to add to the composite object |
database config |
String |
The name of the database config that applies to the key table |
composite object |
String |
The name of the composite object the key table is added to. This can be a new composite object or one that is configured in the CrossTest configuration. |
Examples
Given I have a key table named CUST_HUB in demo for object Customer
Add context table to composite object
Adds a context table to a composite object. 'Context' means inserts into this table will not be made distinct
Sentences
Type |
Language |
Sentence |
Given |
en |
^I have a context table named (.+) in ([a-zA-Z0-9_@$#-]+) for object (.+)$ |
Arguments
Parameter |
Datatype |
Description |
table name |
String |
The name of the context table to add to the composite object |
database config |
String |
The name of the database config that applies to the context table |
composite object |
String |
The name of the composite object the context table is added to. This can be a new composite object or one that is configured in the CrossTest configuration. |
Examples
Given I have a context table named CUST_SAT in demo for object Customer
Delete data from composite object
Deletes data from all tables belonging to a composite object
Sentences
Type |
Language |
Sentence |
Given |
en |
^the object (.+) is empty$ |
Arguments
Parameter |
Datatype |
Description |
composite object |
String |
The name of the composite object |
Examples
Given the object Customer is empty
Load data for composite object
Loads data into the tables that are configured for the composite object, either via step sentences or through the configuration.
Sentences
Type |
Language |
Sentence |
When |
en |
^I insert the following data for object (.+):$ |
Arguments
Parameter |
Datatype |
Description |
composite object |
String |
The name of the composite object to insert the data for. |
data to insert |
DataTable |
The data to load into the tables |
Examples
When I insert the following data for object Customer:
| Id | Description |
| 1 | 'FirstRow' |
| 2 | 'SecondRow' |
Insert data into table using template
Insert data into a table and overrule the template that is defined on the databaseconfig
Sentences
Type |
Language |
Sentence |
When |
en |
^I insert the following data using template ([a-zA-Z0-9_@$#-]+) in ([a-zA-Z0-9_@$#-]+) table (.+):$ |
Arguments
Parameter |
Datatype |
Description |
object template |
String |
The name of the object template to apply |
database config |
String |
The name of the database config |
table name |
String |
The name of the table to insert data into |
data to insert |
DataTable |
The data to load into the table. See TestDataTable. |
Examples
When I insert the following data using template newdemo in demo table CUST_SAT:
| Id | Description |
| 1 | 'FirstRow' |
| 2 | 'SecondRow' |