When you have the data that is useful for creating the test assets is stored in a
database, you can import the data from the database and create a database Query in IBM® DevOps Test Hub (Test Hub).
You must have completed the following tasks:
When you want to create any database query, you must have an Edit branch. You can
create the Edit branch during the creation of the database query. All your dataset
resides in the Edit branch until you publish or discard the changes.
After you create the database query, you can either publish your changes to a remote
Git repository or you can discard the changes made to the database query. The Edit
branch automatically disappears from the
Branch list as well
as from the remote Git repository and sets the global branch to the previously
selected branch in the following conditions:
-
Log in to Test Hub.
The Projects page of the initial team space is
displayed.
-
Click to open the project that contains the test assets.
The Overview page of the project is
displayed.
-
Click .
The Data page and the Data navigator panel are
displayed.
-
Select the branch in the project repository from the
Branch list.
The assets and resources in the selected branch are displayed in the
Data navigator panel.
-
Create a folder, if you want to use a new folder to contain the
resource by performing the following steps:
-
Select the project or a logical folder in the Data navigator panel,
right-click, and then click Folder.
Alternatively, select the project or a logical folder in the
Data navigator panel, click the Open action
menu icon
, and then click
Folder.
The Create new folder dialog is
displayed.
-
Enter a name for the folder.
For example, enter MyFolder as the name
of the folder.
-
Click Create.
The folder is created under the project and displayed in the
Data navigator panel.
-
Perform any of the following actions:
- Click the Open action menu icon
in the Data navigator panel, and then click
Database Query.
- Click Add files in the right panel, and then
click Database Query.
The Edit branch dialog is displayed.
-
Select your action to either select an existing Edit branch or create
an Edit branch:
- Perform the following steps to select an existing Edit
branch:
- Select Use an existing edit
branch.
- Select an Edit branch from the Select
branch list if Edit branches already
exist in the selected branch of the repository.
Note: A warning message is
displayed if the Edit branch, which you selected,
is behind the source branch. To update the
selected edit branch and maintain synchronization
with the source branch, you can select the
Update branch option when
switching checkbox.
- Click Ok.
- Perform the following steps to create the Edit branch:
- Select Create new edit
branch.
- Enter a name for the Edit branch in the
Branch Name field.
- Click Save.
-
Perform the following steps in the Create database query
dialog:
-
Enter a name for the database query in the Name
field.
For example, the name of the database query can be
my_db_query.
-
Select a folder.
-
Click Save.
A message is displayed that confirms database query is created.
The database query is displayed in the Data page. The
database query is listed under the logical folder
Datasets under the physical folder
MyFolder that you created. The name of the database
query is suffixed with the .dtd.yaml file extension.
For example, the file name of the database query can be
my_db_query.dtd.yaml.
-
Perform the following steps in the Data page to select the
table and query the data from the database:
-
Select the database from the Connection
list.
-
Select the table in the selected database from the
Table list.
The data from the selected table is displayed.
-
Select the required column of the table from which you want to import
the data.
-
Click View to switch between the
Visual and Code view.
Note: Note: The default view is
Visual view. In the
Code view you can type the query to get
data from the database.
-
Click the Preview icon
to
view the queried data from the database in tabular format in the bottom
window.
-
Click Save icon
to save
the queried data from the database.
You have created a database query in your project.
Publish the database query to the Git repository so that other members of the project
can use the database query. See Publishing changes in an Edit branch.
You can create a dataset using the database query. See Creating a dataset by using a database query
You can create a Data definition using the database query. See Creating a Data definition by importing fields from a database query.