DbTable¶

This page describes the DbTable steps.

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 (.+) is loaded with the following data:
Given	nl	de ([a-zA-Z0-9_@$#-]+) tabel (.+) met de volgende data geladen wordt:

Arguments¶

The details of every argument of the step are listed below.

Parameter	Datatype	Description
table template	string	The name of the object template, referring to an object template from the config
table name	string	The name of the table to write the data to
data to insert	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' |

Load data into table¶

Loads data into a table

Sentences¶

Type	Language	Sentence
Given	en	the table (.+) is loaded with the following data:
Given	nl	de tabel (.+) met de volgende data geladen wordt:

Arguments¶

The details of every argument of the step are listed below.

Parameter	Datatype	Description
table name	string	The name of the table to write the data to
data to insert	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' |

Retrieve data from table¶

Retrieves data from a table

Sentences¶

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

Arguments¶

The details of every argument of the step are listed below.

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

Examples¶

 When I retrieve the contents of the [dbo].[#testTable] table

 When I retrieve the contents of the dbo.#testTable table

 Als ik de inhoud van de tabel dbo.#testTable ophaal

 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_@$#\s]+)].[([a-zA-Z0-9_@$#\s]+)] is empty
Given	nl	dat de tabel [([a-zA-Z0-9_@$#\s]+)].[([a-zA-Z0-9_@$#\s]+)] leeg is
Given	en	the table ([a-zA-Z0-9_@$#\s]+).([a-zA-Z0-9_@$#\s]+) is empty
Given	nl	dat de tabel ([a-zA-Z0-9_@$#\s]+).([a-zA-Z0-9_@$#\s]+) leeg is

Arguments¶

The details of every argument of the step are listed below.

Parameter	Datatype	Description
schema name	string	The name of the table schema
table name	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

 Given the table [dbo].[#testTable] is empty

 Gegeven dat de tabel [dbo].[#testTable] leeg is