Database Testing with CodedUI

Lets discuss about the Database Testing with CodedUI (C#) with some sample code

Connection String plays a key role in connecting to the database
Which has a different format for different Databases like Oracle,SQL etc

//Below code will login and open the DB connection.

string connetionString = “Data Source=DBSeverName;Initial Catalog=DBName;User ID=UserName;Password=DBPassword”;
SqlConnection connection = new SqlConnection(connetionString);
connection.Open();

Once the DB connection is setup, we need to define a sql Command for executing and Sql Datareader for reading the results of the command
Once the results are read by the data reader, it is loaded into a DataTable

//Below code will help to execute the Select query.
String Selectquery = “Select FirstName from Emp where EmpID in (01)”;
SqlCommand command = new SqlCommand(Selectquery, connection);
SqlDataReader reader = command.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(reader);

Once the data is loaded into the datatable, all we need to do is verify with the expected output

//Below code will help to verify the data which above code fetch from the particular table.
String rowText;
rowText = DB.dataTable.Rows[0][DB.dataTable.Columns[0]].ToString();
if (rowText.Contains(“Mayank”))
{
      Console.WriteLine(“FirstName is macthing with expected result”);
}
else
{
      Console.WriteLine(“Verification is not passed”);
}

After the verification, Close the connection

//It will close the connection.

connection.Close();

Using a App.config file to have different Sections in CodedUI project

To make coded UI tests to work in different environments, or to have different configuration values for different test methods to override the source of data file, a config file can be setup rather than a data source. 

Things to be done to achieve this

1. You’ll need to add a reference to the System.Configuration assembly for the solution
2. Then add the custom elements to app.config file (which is added to test project) TestSiteConfigurationData section name in the app.config file
3. Create configuration data class for a custom section in App.Config TestSiteConfigurationData.cs
4. Create the Helper class file for reading the data from configuration data class TestSiteConfigurationHelper.cs
5. Call the helper class in the Codedui Project and read the values from config file under your custom section

You might face an issue with some wrong value entered for the type of section in the app.config file

 <configSections>

    <section name="TestSiteConfigurationData"

             type="Configuring_Sections.TestSiteConfigurationData,Configuring Sections"/>

  </configSections>

   

Configuring_Sections.TestSiteConfigurationData - <ProjectNamespace>.<ConfigurationDataClassName>

Configuring Sections - the solution dll name i.e your CodedUI project name

Find the sample project implementing the above attached

Download Sample project here

Happy coding :)

Limit TestMethod Timeout in CodedUI

Sometimes when we have Test Methods which run for long time, we tend to see the below kind of exceptions and TestMethod execution stops.

"Test 'TestMethod_Name' exceeded execution timeout period." 

By default Execution time for a test method is 60mins.

This test execution timeout can be changed as per our requirements.

It can be either changed in the Settings file or else

First way is to Set a limit time for execution which is as shown below

[TestMethod]

[Timeout(6000)]

public void TestMethodName()

{

}

Second is to set infinite time limit when we dont know how much time the execution is going to happen or if we are expecting the execution to run completely irrespective of the time

[TestMethod]

[Timeout(TestTimeout.Infinite)]

public void TestMethodName()

{

}

Execute CodedUI TestMethod() through command prompt

Input the path of the dll in the Developer Command Prompt for VS2012/13..

cd C:\Users\...\Documents\Visual Studio 2012\Projects\CodedUITestProject\CodedUITestProject\bin\Debug

Using VSTest.Console.exe like this:

VSTest.Console.exe CodedUITestProject.dll /Tests:TestMethod1,testMethod2 /UseVsixExtensions:true  /Logger:trx

Note There is no /resultsfile option in VSTest.Console.exe command line. You need to use /Logger.trx if you want to generate a trx file.

Note The /Tests command line option cannot be used with the /TestCaseFilter command line option.

Usage  of /TestCaseFilter
Examples of /TestCaseFilter usage with filter as Priority

/TestCaseFilter:"Priority=1"

Examples of /TestCaseFilter usage with filter as Test Category
/TestCaseFilter:"TestCategory=Nightly

Examples of /TestCaseFilter usage with multiple filters using "|"
/TestCaseFilter:"TestCategory=Nightly|FullyQualifiedName=Namespace.ClassName.MethodName"

Schedule Coded UI Test to Execute At a Specific Time

The best way I have found to accomplish this is to create a .bat file which executes the test using the mstest command line tool, and setting this .bat to execute at a specific time using task scheduler. I currently do this daily on a project I am working on.
Here are the steps oulined to execute a .bat driven Coded UI test at a specified time.

Step1:
Create a .bat similar to the following:

set mstestPath="C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE"
 %mstestpath%\mstest /testcontainer:AutomatedUITest.dll  /resultsfile:TestOutput.trx

Test your script by double-clicking the .bat and assure that the test is properly executing.

Step2:

Assuming you name this .bat “TestRunner.bat”, you would then open Task Scheduler (pre-installed on Windows, type “Task” into the search bar to locate). You will see Task Scheduler (local) in the upper left of the window. Right-click, then select create Task. Give the task a name and choose appropriate security settings. Click the Triggers tab, and assign when you wish the test to auto-execute. In this screen you can set the appropriate time to run. Now click the Actions tab, click new and assign your script “TestRunner.bat” to execute and any parameters you may wish to feed to your script. Now choose settings and allow the test to run on demand. Ensure your test is executing properly by clicking the Task Scheduler Library underneath Task Scheduler (local), locate your task, right-click and choose run. If everything executes as expected, you can rest assured that your scheduled task will properly execute at the time(s) you have designated.

Invoking a TestMethod from TestCleanUp in CodedUI

While running a Test method, suppose the application went down suddenly or a time out issue came up because of which ContolNotFound exception occurred and got existed from the test method.
In this scenario in order to invoke the test method from the TestCleanup again this is how we do

[TestCleanup]

 public override void MyTestCleanup()

 {
      // Here i am writing for an generic flow checking my test failed.
      // you can check if any time out window availability or application down messages in browser

      if (TestContext.CurrentTestOutcome == UnitTestOutcome.Failed)

      {      

            var type = Type.GetType(TestContext.FullyQualifiedTestClassName);      

            if (type != null)

           {

                var instance = Activator.CreateInstance(type);

                var method = type.GetMethod(TestContext.TestName);

                try

               {

                    method.Invoke(instance, null);

               }

               catch

              {

            

              }

         }

     }
 }

selenium Webdriver script with SpecFlow and Visual Studio

SpecFlow is the .Net version of Cucumber. This is a Behavior development framework for .Net. Here we will show how we can implement our Selenium Webdriver script using SpecFlow framework.

Test Case : Verify the search Functionality of Google Search page

• Open the browser and navigate to “www.google.com”.
• Enter the word “SpecFlow” as Search Text.
• Click on Search button.
• Verify the search result.

Step One : Installing IDE integration package for SpecFlow 

• Open Visual Studio and go to Tools>>Extension and Updates…

 

• Extensions and Update window is displayed. Enter the word “SpecFlow” at search text box and press enter from keyboard. “SpecFlow for Visual Studio 2013” package is displayed as Search Result.
• If you see Disable and Uninstall button then it means it is already installed with your IDE like the following.

• If you see Download button then Click on this button.

• It starts downloading.

• After finishing download,click on Install button.

• After finishing installation, click on Restart Now button.

• Visual Studio will be restarted and if you go to Tools>>Extension and Updates… and search with “SpecFlow” then you see “SpecFlow for Visual Studio 2013” is installed.
• In the same way search the extensions “NUnit Test Adapter” and Download it. It is used for NUnit Framework.

• Click on Install button.

• Click on Restart Now button to restart Visual Studio.

Step Two : Crating a new project with Unit Test Framework

• Click on File menu and go File>>New>>Project

• New project window is displayed.
• Select Visual C#
• Select Test
• Select Unit Test Project

• Enter project name as “GoogleSearchTest”
• Select Location. In my case “D:\Development\”.
• Select Solution name. In my case Solution name is same as Project name.
• Check Create Directory for solution
• Click on OK button.

• “GoogleSearchTest” project is created.

Step Three : Add SpecFlow  reference from nuget.org

• Go to Solution Explorer and Right click on Reference and click on Manage NuGet Packages…

• Manage NuGet Packages window is displayed.
• Enter the text SpecFlow at search text box and press enter from Keyboard.
• SpecFlow package is displayed at Search list.
• Click on Install button.

• Installation Started.

• After finishing installation, a green color icon is displayed and shown that SpecFlow is installed.

• In the same way, we need to add SepcFlow.NUnit package.

• Clicking on Install button will install this package.

Step Four : Add Selenium Webdriver reference from nuget.org

• Enter the text Selenium WebDriver at search text box and press enter from Keyboard

Selenium WebDriver package is displayed at Search list.

Click on Install button.

Latest WebDriver will be installed and added as Reference.

Select Selenium WebDriver Support Classes package and click on Install button.

• After finishing installation and click on Close button to close the Package Manager window.
• Now verify that all the References are showing properly at the solution explorer.

Step Five : Create a Feature file and write test case steps using gherkin syntax

• Right click on the Project and go to Project>>Add>>New Item.

• Add New Item window displayed.
• Select Visual C# Items.
• Select SpecFlow Feature File.
• Enter file name as “GoogleSearchFeature.feature”. Note that Feature file name must have the extension “.feature”.
• Click on Add button.

• New Feature file is added with the project.

• Double click on the File name “GoogleSearchFeature.feature” and File is opened at the Editor with default text.

• Write the Feature name as “GoogleSearch”. Remove all the default text from Feature section.

Feature: GoogleSearch

• Write the case title as the scenario.

Scenario: Verify the search Functionality of Google Search page

• Write the test case steps using Gherkin syntax (Given…GoogleSearchWhen…Then).

Given : It describes the precondition to execute test steps.
When : It describes the steps to perform the test.
Then : It describes the expected result. 

In our case, Given clause will be,

Given I navigate to the page "www.google.com"
And I see the page is loaded

Note that we an “And” operator to write multiple clauses. 

When clause will be,

When I enter Search Keyword in the Search Text box
| Keyword  |
| SpecFlow |
And I click on Search Button

Note that here we write data table for search keyword where we use “Keyword” as the table column name and “SpecFlow” is the data. 

Then clause will be,

Then Search items shows the items related to SpecFlow

Now the Feature file looks like, 

Step Six : Write code for every step

• Here we write code for every Feature file steps.
• In Order to write code we need Add a step definition class.
• Right click on the Project and go to Project>>Add>>New Item. 

• Add New Item window is displayed.
• Select Visual C# Items.
• Select SpecFlow Step Definition
• Enter file name as “GoogleSearchFeatureSteps.cs”.
• Click on Add button.

• New class file is added with the project named “GoogleSearchFeatureSteps.cs”.

• Go to GoogleSearchFeature.feature file.
• Right click on Feature name and click on Generate Step Definitions

• Generate Step Definition Skeleton window is displayed.
• Click on Copy Methods to clipboard button and window is closed.

• Go to GoogleSearchFeatureSteps.cs class. Remove all the sample codes from the class and it looks like the following.

• Right click on the editor and paste the code on GoogleSearchFeatureSteps class.GoogleSearchFeatureSteps.cs class looks like the following. 

• Now we need to write automated scripts for every steps
• We need to add the following name space at GoogleSearchFeatureSteps.cs class.
• Go to GoogleSearchFeature.feature file.
• Right click on the First line of Given clause and click Go to Step Definition.

• Note that  GoogleSearchFeatureSteps.cs file is opened and mouse cursor is blinked on the Given method. Also note that method name is the combination of all word of Given clause.

• Write the code for GivenINavigateToThePage() method.

Note that we do not need to write any comment here as Methods name describes the steps. This is the contribution BDD.

• Write code for GivenISeeThePageIsLoaded() method.

Here we just verify that appropriate page is loaded.

• Write code for WhenIEnterSearchKeywordInTheSearchTextBox() method.

Note that we use list of data in our feature file that SpecFlow converts to table. We can use it as normal Row/Column concept.

• Write code for WhenIClickOnSearchButton() method.

• Write code for ThenSearchItemsShowsTheItemsRelatedToSpecFlow() method.

• GoogleSearchFeatureSteps.cs class looks like the following,

Step Seven : Run the test

• Delete default class UnitTest1.cs as it is not needed.

• Build the solution by going to Build>>Build Solution.
• Go to Test>>Windows>>Test Explorer
• Note that the scenario name is the test name VerifyTheSearchFunctionalityOfGoogleSearchPage
• Right click on the test name and click on Run Selected test.
  

• Test will run using NUnit and Passed.

• Click on Output link.
• We see the output step by step as it is written in our Feature file.

This is the power of SpecFlow using BDD.

Lot more new things are coming…