In the previous chapter of Transform Table into Dictionary we provided Vertical Data using Tables. That is useful when we have a long list of Data for e.g. Personal Information includes First Name, Last Name, Address and Job etc.
But this has some limitations like what if we want to execute the same step more than one time, it is not easy to manage that with Dictionary Key-Value pair. To obtain the functionality, it is required to use Horizontal Data rather than Vertical Data and that can be done by “Transform Table into DataTable“.
Transform Table into DataTable
We will be using the same example of LogIn Feature and modify it according to our usage. Before moving on to this chapter, please have a look at the base chapter of Data Driven Testing and see how the simple functionality works for LogIn Scenario.
1) Create a New Step
The first step is to create a new Step which will take Data in Table format. It is again an easy job to specify data for the step in Horizontal format. Just provide the Header and their values.
|
1 2 3 |
When User enter credentials | Username | Password | | testuser_1 | Test@123 | |
2) Create a New Step Definition
The second step is to create a new Steps Definition for newly created step, which can be done if bring the cursor on the created step and press F12. The Specflow will display the pop up with the Skeleton body of the step, which can be copied and used accordingly.
|
1 2 3 4 5 |
[When(@"User enter credentials")] public void WhenUserEnterCredentials(Table table) { } |
3) Transform table into DataTable
To convert Table into DataTable, it is required to use System. Data package (using System.Data).
Create a new folder in the solution and name it as Utils. Then create a new C# class with the name TableExtensions in the same folder and create a new static method called ToDataTable(), which will accept Table data.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
public static DataTable ToDataTable(Table table) { var dataTable = new DataTable(); foreach (var header in table.Header) { dataTable.Columns.Add(header, typeof(string)); } foreach (var row in table.Rows) { var newRow = dataTable.NewRow(); foreach (var header in table.Header) { newRow.SetField(header, row[header]); } dataTable.Rows.Add(newRow); } return dataTable; } |
4) Complete Step Definition Method
Now make use of ToDataTable function and convert the Table data into DataTable.
|
1 2 3 4 5 6 7 8 9 10 11 |
[When(@"User enter credentials")] public void WhenUserEnterCredentials(Table table) { var dataTable = TableExtensions.ToDataTable(table); foreach (DataRow row in dataTable.Rows) { driver.FindElement(By.Id("log")).SendKeys(row.ItemArray[0].ToString()); driver.FindElement(By.Id("pwd")).SendKeys(row.ItemArray[1].ToString()); driver.FindElement(By.Id("login")).Click(); } } |
With this, one can use the multiple Data sets for the same step.
The complete code will look like this:
LogIn_Feature File
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
Feature: LogIn_Feature In order to access my account As a user of the website I want to log into the website @mytag Scenario: Successful Login with Valid Credentials Given User is at the Home Page And Navigate to LogIn Page When User enter credentials | Username | Password | | testuser_1 | Test@123 | | testuser_2 | Test@154 | And Click on the LogIn button Then Successful LogIN message should display Scenario: Successful LogOut When User LogOut from the Application Then Successful LogOut message should display |
LogIn_Steps File
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
using OpenQA.Selenium; using OpenQA.Selenium.Firefox; using TechTalk.SpecFlow; using TechTalk.SpecFlow.Assist; using SpecFlowDemo.Utils; using System.Data; namespace SpecFlowDemo.Steps { [Binding] public class LogIn_Steps { public IWebDriver driver; [Given(@"User is at the Home Page")] public void GivenUserIsAtTheHomePage() { driver = new FirefoxDriver(); driver.Url = "https://www.store.demoqa.com"; } [Given(@"Navigate to LogIn Page")] public void GivenNavigateToLogInPage() { driver.FindElement(By.XPath(".//*[@id='account']/a")).Click(); } [When(@"User enter credentials")] public void WhenUserEnterCredentials(Table table) { var dataTable = TableExtensions.ToDataTable(table); foreach (DataRow row in dataTable.Rows) { driver.FindElement(By.Id("log")).SendKeys(row.ItemArray[0].ToString()); driver.FindElement(By.Id("pwd")).SendKeys(row.ItemArray[1].ToString()); driver.FindElement(By.Id("login")).Click(); driver.FindElement(By.Id("log")).Clear(); driver.FindElement(By.Id("pwd")).Clear(); } } [When(@"Click on the LogIn button")] public void WhenClickOnTheLogInButton() { driver.FindElement(By.Id("login")).Click(); } [When(@"User LogOut from the Application")] public void WhenUserLogOutFromTheApplication() { ScenarioContext.Current.Pending(); } [Then(@"Successful LogIN message should display")] public void ThenSuccessfulLogINMessageShouldDisplay() { //This Checks that if the LogOut button is displayed true.Equals(driver.FindElement(By.XPath(".//*[@id='account_logout']/a")).Displayed); } [Then(@"Successful LogOut message should display")] public void ThenSuccessfulLogOutMessageShouldDisplay() { ScenarioContext.Current.Pending(); } } } |
TableExtension Class File
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
using System.Data; using TechTalk.SpecFlow; namespace SpecFlowDemo.Utils { public class TableExtensions { public static DataTable ToDataTable(Table table) { var dataTable = new DataTable(); foreach (var header in table.Header) { dataTable.Columns.Add(header, typeof(string)); } foreach (var row in table.Rows) { var newRow = dataTable.NewRow(); foreach (var header in table.Header) { newRow.SetField(header, row[header]); } dataTable.Rows.Add(newRow); } return dataTable; } } } |
Project Solution Explorer
