How to create test data to insert into a database (how to create a page row)
I have a test case for which I want to create some test data. I want this test data to be available no matter which environment I am in (Dev, QA, etc). So to do this I want to add 3 to 4 rows of data to the database that the Data Page will be referencing.
Ex. Suppose I have an database table (which is replacated by the class) Names, which have fields, "ID", "First", "Last"
I want to add the following data:
1, "Frank", "Franklin"
2, "George", "Gershwin"
3, "Harry", "Henderson"
To do this, I started to create a Data Transform. In the Pages & Classes, I've added:
Rows | Code-Pega-List
Rows.Row | Names
What do I do on the Definitions tab? I've tried to do an Update Page or Append and Map to, but I don't seem to be doing something correctly.
I have a test case for which I want to create some test data. I want this test data to be available no matter which environment I am in (Dev, QA, etc). So to do this I want to add 3 to 4 rows of data to the database that the Data Page will be referencing.
Ex. Suppose I have an database table (which is replacated by the class) Names, which have fields, "ID", "First", "Last"
I want to add the following data:
1, "Frank", "Franklin"
2, "George", "Gershwin"
3, "Harry", "Henderson"
To do this, I started to create a Data Transform. In the Pages & Classes, I've added:
Rows | Code-Pega-List
Rows.Row | Names
What do I do on the Definitions tab? I've tried to do an Update Page or Append and Map to, but I don't seem to be doing something correctly.
| Row | Action | Target | Relation | Source |
| 1 | Update Page | Rows | ||
| 1.1 | Set | ID | 3838 | |
| 1.2 | Set | First | "Frank" | |
| 1.3 | Set | Last | "Franklin" | |
| 2 | Update Page | Rows | ||
| 2.1 | Set | ID | 3839 | |
| 2.2 | Set | First | "George" | |
| 2.3 | Set | Last | "Gershwin" |
Updated: 12 Apr 2018 6:02 EDT
Appriss, Inc
US
You'll notice my IDs are not proper. That's not the point though. Just assume I meant 3838, 3839, 3840 OR 1, 2, 3 in the appropriate spots.
Also, in the Definition tab, the Target cell for the Sets would be Rows.Row.ID, Rows.Row.First, and Rows.Row.Last.
British Telecom
IN
Hi Jeff,
Have You tried creating Datatype, which will automatically create data pages.
You can create test data in the Record tab and use it
Updated: 20 Apr 2018 16:45 EDT
Appriss, Inc
US
What I ended up doing is create a Decision Table where the Results is "Evaluate all rows". The decision table contains all the desired data and each column header is .Rows(<APPEND>).FirstProperty, .Rows(<LAST>).SubsequentProperty. Where .Rows is an added property to the data page I'm modeling and it is a List Page of that data page. I then used a Data Transform to get the data from the decision table. It all worked out.