mercredi 16 septembre 2020

How to work with collections in data driven testing?

I want to use data driven testing. For this I keep data in excel file. For example, I have sheet Person with the following columns and rows:

Id| Name | Surname | Age
------------------------
2 | Mike | Black   | 25
3 | Bob  | Tuck    | 23

Now, every person has 0..N cars, and every car has model, number and color. How to add these data about cars? Should I create extra sheet with cars and add column Cars to Person and to list all cars of the person by id:

Id| Name | Surname | Age | Cars
--------------------------------
2 | Mike | Black   | 25  | 14, 20
3 | Bob  | Tuck    | 23  | 5

Or maybe there are better ways?

Aucun commentaire:

Enregistrer un commentaire