Object Repository in Selenium

Unlike QTP/UFT, Selenium does not offer the default implementation for  object repository. In QTP things are really straightforward, just object spy the controls and add to object repository, and further with the blessings of intellisense feature in its IDE, utilize them easily in writing scripts.

But how we can achieve the same in selenium??..
It can be done by using Properties file feature of Java. Lets begin with some basic explanation.

What is Object Repository?

Object Repository is a centralized location where we can store objects information, it acts as interface between Test script and application in order to identify the objects during the execution.

We always recommend using external file for object repository rather than hard coding the objects and its properties directly into our code. Why this??? As it reduces the maintenance  effort and provides positive ROI, for example say any of the object properties change within our application under test, we can easily change it in external object repository file, rather than searching and doing updates  for that object individually in the code.

Principle:-
A basic object repository can be implemented as a collection of key-value pairs, with the key being a logical name identifying the object and the value containing unique objects properties used to identify the object on a screen. For this, we will use a .properties file in Java which is a basic collection of key-value pairs.

Creating Properties File in Eclipse:-

Step1:-
Right click on the Package in the solution Explorer of Eclipse-> New ->Other

Adding New File in Eclipse

Or 
Right click on the Package in the solution Explorer of Eclipse-> New ->File (In this case Step-2 below is not required)

New ->File in Eclipse

Step2:-
General ->File ->Click Next

New Wizard in Eclipse

Step3:-
Give name to the file with .properties extension (Say OR_Gmail_Login.properties) ->Click Finish

Naming Properties File in Eclipse

Note:- 
We generally create each properties file for every single page and capture all the UI elements present on the page and use it as per the needs.


Adding Key/value Pairs in Properties File:-

Before adding our objects into object repository, let’s outline a simple scenario that we will be automating in Selenium:-

1. Launch Gmail login page.
2. Fill the Username & Password fields and click on Submit button

After creating our empty properties file, now we need to add our elements, in the form of key and Value pairs.
For Example:-

Gmail.LoginPage.txtPassword -> Key
Passwd->Value

Note: - In Value property we have taken the Locator and its value, which will be used to identify our control. As password field, is getting uniquely identified by ID field so we have taken that value.

Properties File in Java

Code:-

package OR;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Properties;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;

public class PropertiesFile {
  public static void main(String[] args)  {
   //Creating the File Object
   File file = new File("D:\\Automation\\Selenium\\MyCode\\FirstSeleniumCode\\src\\OR\\OR_Gmail_Login.properties");
   //Creating properties object
   Properties prop = new Properties();
  //Creating InputStream object to read data
   FileInputStream objInput = null;
   try {
    objInput = new FileInputStream(file);
    //Reading properties key/values in file
    prop.load(objInput);
    //Closing the InputStream
    objInput.close();
    } catch (FileNotFoundException e) {
     System.out.println(e.getMessage());   
     
    } catch (IOException e) {
   System.out.println(e.getMessage());
  }
   //Creating the driver instance
   WebDriver driver = new FirefoxDriver();
   //Adding wait
   driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS);
   //Launching the GMAIL page
   driver.get(prop.getProperty("Gmail.URL"));
   //Entering the UserName
   WebElement element = driver.findElement(By.id(prop.getProperty("Gmail.LoginPage.txtUserName")));
   element.sendKeys("uftHelp@gmail.com");
   //Entering the Password
   element = driver.findElement(By.id(prop.getProperty("Gmail.LoginPage.txtPassword")));
   element.sendKeys("uftHelp");
   //Clicking the SignIn button
   element = driver.findElement(By.id(prop.getProperty("Gmail.LoginPage.btnSignIn")));
   element.click();
   System.out.println("Test Scenario Completed!!");
   //Destroying the driver object
   //driver.close();

  }
}

Resizing a web element using movebyoffs

Genarally when ever we want to change the size of an element we do with the help of mouse manually. Now we will see to resize / change the size of an element using webdriver actions class with moveByOffset which moves the mouse position from its current position by the given offset.

Below are the simple steps thats needs to be followed for the below example:-

Step 1: Open the URL
Step 2: Wait for the element that you want to resize. (Make sure if there are any frames then we need to shift to the frame and then perform operation).
Step 3: We will define a method using which we need to pass web element and the coordinates to the method.

Selecting a date from Datepicker using Selenium WebDriver

Calendars look pretty and of course they are fancy too.So now a days most of the websites are using advancedjQuery Datepickers instead of displaying individual dropdowns for month,day,year. :P

If we look at the Datepicker, it is just a like a table with set of rows and columns.To select a date ,we just have to navigate to the cell where our desired date is present.

Step 1:  Here I am taking Sample Website "http://www.cleartrip.com/"
step 2:  Here we can able to select date whatever we want( This is pure dynamic)
step 3:  Here I am Implementing all my logic in 'genericDatePicker()' Method. This method i am   passing date(date format should be dd/mm/yyyy).
step 4: Here First I am Clicking Calendar field and then i am getting Month/Year.
Step 5: I have written Enum method(I am assigning Number to every Month)
Step 6: After that I am calculating total months.
Step 7: Finally I am Clicking the Date From DatePicker..

Here is a sample code on how to pick a 26/10/2016..

view plainprint?

1. package com.utility;
   
   
   import java.util.List;
   
   
   import org.junit.After;
   import org.junit.Before;
   import org.junit.Test;
   import org.openqa.selenium.By;
   import org.openqa.selenium.WebDriver;
   import org.openqa.selenium.WebElement;
   import org.openqa.selenium.firefox.FirefoxDriver; 
2. public class RedBus {
     WebDriver driver;

   @Before
   public void setUp() throws Exception {
   

   driver = new FirefoxDriver();

   driver.get("http://www.cleartrip.com/");

   driver.manage().window().maximize();

   }

   
   

   @Test
   public  void datePicker(){
   

   genericDatePicker("26/09/2016");  //date format should be dd/mm/yy

   }

   
   

   public  void genericDatePicker(String inputDate){
   

   /* CLicking the Date Feild*/

   WebElement ele =driver.findElement(By.id("DepartDate"));  

   ele.click();

   /*Here we are getting Month and Year */
   String month = driver.findElement(By.xpath("//div[@class='monthBlock first']/div[1]//span[1]")).getText();
   String year = driver.findElement(By.xpath("//div[@class='monthBlock first']/div[1]//span[2]")).getText();
   System.out.println("Application month : "+month + " Year :"+year);
   int monthNum = getMonthNum(month);
   System.out.println("Enum Num : "+monthNum);
   String[] parts = inputDate.split("/");   // Here I am Spliting Our Input String Value
   //Here I am Implementing the Logic
   int noOfHits = ((Integer.parseInt(parts[2])-Integer.parseInt(year))*12)+(Integer.parseInt(parts[1])-monthNum);
   System.out.println("No OF Hits "+noOfHits);

   for(int i=0; i< noOfHits;i++){
   

   driver.findElement(By.className("nextMonth ")).click();

   }

   /* selecting the month div*/
   List<WebElement> cals=driver.findElements(By.xpath("//div[@class='monthBlock first']//tr"));
   System.out.println(cals.size());
   /*iterating the "tr" list*/
   for( WebElement daterow : cals){
   /*getting the all "td" s*/
   List<WebElement> datenums = daterow.findElements(By.xpath("//td"));
   /*iterating the "td" list*/
   for(WebElement date : datenums ){
   /* Checking The our input Date(if it match go inside and click*/
   

   if(date.getText().equalsIgnoreCase(parts[0])){

   date.click();

   break;

   }

   }

   }

   }

   
   

   // This method will return Month Number
   public  int getMonthNum(String month){
   for (Month mName : Month.values()) {
   

   if(mName.name().equalsIgnoreCase(month))

   return mName.value;

   }

   return -1;

   }

   
   

   // Here I am Creating Enum Method(I am assigning Number to every Month)
   public enum Month {
   

   January(1), February(2), March(3), April(4), May(5), June(6) , July(7), August(8), September(9), October(10), November(11),December(12);

   private int value;

   
   private Month(int value) {
   

   this.value = value;

   }

   
   

   }

   
   

     @After
   public void tearDown() throws Exception {
   

   driver.quit();

   }

   
   
   
   
   }
3. 
   

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;
    }

}

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?

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

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.....;)