Skip to content

Step documentation for DatabaseTable

Load data into table

Loads data into a table

Sentences

Type Language Sentence
Given en the table ([[a-zA-Z0-9_@$#]+].[[a-zA-Z0-9_@$#]+]) is loaded with the following data:
Given nl de tabel ([[a-zA-Z0-9_@$#]+].[[a-zA-Z0-9_@$#]+]) met de volgende data geladen wordt:

Arguments

Parameter Datatype Description
destinationTableName String The name of the table to write the data to
dataToWrite Table The data to write to the table, formatted as a table with the appropriate column names. See TestDataTable.

Examples

Given the table [dbo].[#testTable] is loaded with the following data:
    | Id | Description |
    | 1  | 'FirstRow'  |
    | 2  | 'SecondRow' |
Gegeven de tabel [dbo].[#testTable] met de volgende data geladen wordt:
    | id | description |
    | 1  | 'FirstRow'  |
    | 2  | 'SecondRow' |

Load data into templated table

Loads data into a table that conforms to a configured table template

Sentences

Type Language Sentence
Given en the ([a-zA-Z0-9_-]+) table ([a-zA-Z0-9_@$#]+) is loaded with the following data:
Given en the ([a-zA-Z0-9_-]+) table ([[a-zA-Z0-9_@$#]+].[[a-zA-Z0-9_@$#]+]) is loaded with the following data:
Given nl de ([a-zA-Z0-9_-]+) tabel ([a-zA-Z0-9_@$#]+) met de volgende data geladen wordt:
Given nl de ([a-zA-Z0-9_-]+) tabel ([[a-zA-Z0-9_@$#]+].[[a-zA-Z0-9_@$#]+]) met de volgende data geladen wordt:

Arguments

Parameter Datatype Description
objectTemplateName String The name of the object template, referring to an object template from the config
destinationTableName String The name of the table to write the data to
dataToWrite Table The data to write to the table, formatted as a table with the appropriate column names. See TestDataTable.

Examples

Given the staging table [dbo].[#testTable] is loaded with the following data:
    | Id | Description |
    | 1  | 'FirstRow'  |
    | 2  | 'SecondRow' |
Gegeven de staging tabel [dbo].[#testTable] met de volgende data geladen wordt:
    | Id | Description |
    | 1  | 'FirstRow'  |
    | 2  | 'SecondRow' |

Retrieves data from a table

Sentences

Type Language Sentence
When en I retrieve the contents of the [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] (?:table|view)
When nl ik de inhoud van de (?:tabel|view) [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] ophaal

Arguments

Parameter Datatype Description
tableOrViewSchema String The name of the table or view's schema
tableOrViewName String The name of the table or view to get the data from

Examples

When I retrieve the contents of the [dbo].[#testTable] table
Als ik de inhoud van de tabel [dbo].[#testTable] ophaal

Delete data from table

Deletes data from a table

Sentences

Type Language Sentence
Given en the table [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] is empty
Given nl dat de tabel [([a-zA-Z0-9_@$#]+)].[([a-zA-Z0-9_@$#]+)] leeg is

Arguments

Parameter Datatype Description
tableOrViewSchema String The name of the table schema
tableOrViewName String The name of the table to delete the data from

Examples

Given the table [dbo].[#testTable] is empty
Gegeven dat de tabel [dbo].[#testTable] leeg is