Wednesday, 8 October 2014

Handling dynamically generated ids in selenium webdriver

Step 1: Here I am trying to automate testing of a webpage that contains list of items. User input item is selected and is deleted. Here, I need to select BR2 and delete that item.

<div id="virtual_domains-content">
    <div class="columns">
        <div class="left-column">
            <h2>Virtual Domains</h2>
                <div class="search-row">
                    <div class="box scrolling list-editable">
                        <div id="virtual_domains-list" class="list-view">
                            <div id="virtual_domains-list-11" class="list-item-view">
                                <div class="content"> BR1</div>
                            </div>
                            <div id="virtual_domains-list-35" class="list-item-view">
                                <div class="content"> BR2</div>
                            </div>
                        </div>
                    </div>

Step 2:In the above code  contains class name.So,I am using  class name.

List<WebElement> list =driver.find_element_by_class_name("list-item-view");
for(WebElement option : list){
    System.out.println(option.getText());
    if(option.getText().equals("BR2")) {
        option.click();
        break;
    }

}

Wednesday, 24 September 2014

As a QA Analyst or software tester, how are you held accountable for the work you are doing?

We developed a checklist. 

1. Do you have Business Requirements documentation? 
2. Has there been a Business Requirements walk through? 
3. Have requirements been signed off? 
4. Is there a Functional Design Document? 
5. Has there been a Functional Design Review 
6. Do you have test plan? 
7. Have you had a test plan review? 
With peers? 
With developers? 
With Business Group? 
8. Has the code been reviewed? 
9. Have smoke tests been completed to accept code into test? (Entrance criteria) 
10. Is testing complete? 
11. Are there open defects? 
12. Do you meet the exit criteria? 
13. Have you had a results verification review? 
Who performed the review 
14. Was the timeline met? 
If no, specify reasons and state action plan 
15. Is the Deployment Plan ready? (MOP) 
16. Is the Deployment Validation Plan ready? 
17. Has the Deployment been completed? 
18. Was the Deployment successful? 
19. Have you archived project documentation?

Friday, 19 September 2014

High level Test process for a company with no formal processes.

My high level test process would include the following: 

1. Inquire - what should you test - ie access the requirements, product, design, etc. 
2. Intent - what will you test and how will you test it, plan your testing 
3. Implement - develop and execute your testing 
4. Inform - analyze, access, and inform others of your test results and recommendations 
5. Iterate - perform steps 1 - 4 as often as is appropriate and feasible given the SDLC 
6. Integrate - perform steps 1 - 5 within the context of the SDLC 
7. "Review - make sure you're doing the right things and doing them the right way by frequently (constantly?) 
8. Inspire - inspire others to embrace quality practices into their roles (as you do in yours) 
9. Integrity - ensure that you perform your tasks and role with professionalism and courtesy

Monday, 4 August 2014

Connecting to DataBase using Selenium WebDriver


Web Driver cannot directly connect to Database. You can only interact with your Browser using Web Driver. For this we use JDBC("Java Database Connectivity").The JDBC API is a Java API for accessing virtually any kind of tabular data.The value of the JDBC API is that an application can access virtually any data source and run on any platform with a Java Virtual Machine.In simplest terms, a JDBC technology-based driver ("JDBC driver") makes it possible to do Five things:

1.Load Jdbc driver
Class.forName("com.mysql.jdbc.Driver");

2.Establish a connection with a data source
Connection con =DriverManager.getConnection(dbUrl, userName, password);

3.create Statement Object
Statement stmt = con.createStatement();

4.Send queries and update statements to the data source
ResultSet rs = stmt.executeQuery(query);

5.Process the results
while(rs.next()){

String uName = rs.getString(1);
}

Example Program:

package com.dbconectin;
mport java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

public class dbConnection {

@Test
public void test() throws ClassNotFoundException, SQLException 
{
try{
//Connection Url
String dbUrl = "jdbc:mysql://localhost:3306/companydb_manf";
//Give Username
String userName ="root";
//Give Password
String password ="root";
//Give Db query
String query = "select * from sr_agritech_estimation_labor where user_id='manager';";

//Load mysql JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//Get connection to Db
Connection con =DriverManager.getConnection(dbUrl, userName, password);
//Create Statement Object
Statement stmt = con.createStatement();

//Send Sql query to Db

ResultSet rs = stmt.executeQuery(query);

//While loop to get all data
while(rs.next()){
String uName = rs.getString(1);
String uName1 = rs.getString(2);
String uName2 = rs.getString(3);
String uName3 = rs.getString(4);
String uName4 = rs.getString(5);
System.out.println(uName);
System.out.println(uName1);
System.out.println(uName2);
System.out.println(uName3);
System.out.println(uName4);
System.out.println("-----------------------");
}
//close db connection
con.close();
}catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}

}


}

I guess every one can understand.....;)

Tuesday, 1 July 2014

How To Create And Run JUnit Test Suit For WebDriver Test - Step By Step

If you are planning to perform regression testing of any application using webdriver then obviously there will be multiple test cases or test classes under your webdriver project. Example - There are 2 junit test cases under your project's package. Now if you wants to run both of them then how will you do it? Simple and 
easy solution is creating JUnit test suite. If your project has more than 2 test cases then you can create test suite for all those test cases to run all test cases from one place.
Step 1 - Create new project and package
Create new project in eclipse with name = junitproject and then add new package =
   com.practice.testsuite under your project. 
Step 2 - Create 1st Test Case
Now create JUnit test case under com.practice.testsuite package with class name =
   Junit1 as bellow.
package com.practice.testsuite;
import org.junit.Test;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
public class junittest1 { WebDriver driver = new FirefoxDriver();
public class Junit1 {
 WebDriver driver;
  @Test
  public void f() {
  driver = new FirefoxDriver(); 
  driver.get("https://www.facebook.com/");
  driver.manage().window().maximize();
  driver.quit();
  }
}
Step 3 - Create 2nd test case
Same way, Create 2nd test class with name = Junit2 under package = junitpack as bellow.
package com.practice.testsuite;
import org.junit.Test;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
public class junittest1 { WebDriver driver = new FirefoxDriver();
public class Junit2 {
 WebDriver driver;
   @Test
  public void f() {
    driver = new FirefoxDriver(); 
   driver.get("https://www.google.com/");
   driver.manage().window().maximize();
   driver.quit();
  }
  @Test
  public void f() {
  driver = new FirefoxDriver(); 
  driver.get("https://www.facebook.com/");
  driver.manage().window().maximize();
  driver.quit();
  }
}

Step 4 - Create test suite for both test cases
Now we have 2 test cases(Junit1.java and jJunit2.java) under package = com.practice.testsuite.
To create test suite, Right click on com.practice.testsuite package folder and Go to -> New -> Other -> Java -> Junit ->  Select 'JUnit Test Suite'
package com.practice.testsuite;
import org.junit.runner.RunWith;
import org.junit.runners.Suite;
import org.junit.runners.Suite.SuiteClasses

@RunWith(Suite.class)
@SuiteClasses({Junit1.class,Junit2.class})
public class JunitSuite {

}

Step 5- Running test suite
 When you run JunitSuite test suite, eclipse will run both test cases (Junit1 and Junit2) one by one. When execution completed, you will see  output lines in console.



Tuesday, 27 May 2014

WebDriver: check if an element exists or not?

IF you are a Selenium Web Driver  Automation tester than most probably you would have gone through this situation, In which you have faced one exception that speaks “Element not found”.

I Found Solution for this scenario........

Case 1:
 boolean elements ;
  elements = driver.findElements(By.name("masterPassword")).isEmpty();
  if(elements == true)
  {
     System.out.println("Element is not present");  
  }
  else
  {
           System.out.println("Element is present");  
          //Do whatever You want
  }

Here i am checking whether the element is present or not. Based on that I am writing if() {}and else{} blocks.

Wednesday, 5 March 2014

Error:Unable to bind to locking port 7054 within 45000 ms

org.openqa.selenium.WebDriverException: Unable to bind to locking port 7054 within 45000 ms 
Build info: version: '2.30.0', revision: 'dc1ef9c', time: '2013-02-19 00:15:27' 
System info: os.name: 'Windows 7', os.arch: 'x86', os.version: '6.1', java.version: '1.7.0' 
Driver info: driver.version: FirefoxDriver 
Command duration or timeout: 47.94 seconds 
Build info: version: '2.28.0', revision: '18309', time: '2012-12-11 15:53:30' 
System info: os.name: 'Windows 7', os.arch: 'x86', os.version: '6.1', java.version: '1.7.0' 
Driver info: org.openqa.selenium.remote.RemoteWebDriver

Solution1: This generally means you have another copy of Firefox running on that
system. 
Solution2 : Try Uninstalling FireFox completely and then Install Firefox .

Angular JS Protractor Installation process - Tutorial Part 1

                     Protractor, formally known as E2E testing framework, is an open source functional automation framework designed spe...