Selenium Functional Automation Testing - Course Summary

• Web Driver is the web automation tool of the moment. Web Driver skills are in demand. And when you understand the Web Driver usage patterns, that this course teaches, then you can increase your automation effectiveness.
• An easy way to learn an automated test tool is by learning from the experiences of someone who knows how to use it. And that is what we do on this course.
• In this course you will learn real world techniques associated with the Web Driver API based on experience of using Web Driver to automate production web sites.
• This course focuses on the information you need to get productive with Web Driver. We don’t spend any time on the Selenium IDE, because you won’t use that in a production environment. We don’t spend any time on padding covering the architecture of Web Driver because you can find that information on the Web, and you don’t need to know it, to get productive.
• Throughout the course we stress, and demonstrate, self learning strategies so that you don’t just learn the Web Driver API in depth, you also learn how to discover more on your own.

Syllabus:

Installations

• eclipse-
• JDK 1.7
• Firefox 35.1 , firebug and fire path
• Set up TestNG, ANT and Selenium 2.44 for eclipse

Part - 1:

• Introduction to Core java 
• Class, Methods, Inheritance, Interfaces,Exception Handling, File Handling
• i.e Core java topics  which are required for Automation Testing.
• Introduction to Automation Testing
• Types of Automation Tools
• What is Selenium
• Introduction to types of types of applications
• Introduction to Web Application, and Browsers
• Introduction IDE   

Part - 2:

• About Eclipse IDE (Integrated Development Environment)
• Introduction to flavors of Eclipse IDE [Kepler, Luna, Mars(2015 version)]
• Introduction to Web Driver
• Basics of HTML tags
• Web Driver basic API's
• About XPath functions
• Types of Locators
• Handling with Drop down / List Boxes / Web Lists using "Select" API
• Web Driver Wait statements
• Types of Wait Statements
• Handling with multiple windows 
• Frame Handling
• Working with Bulk Elements

Part - 3:

• Handling file download pop-up using web driver
• Handling file attachment window using -Auto IT tool[Third Party Tool]
• Handling with excel work book using - Apache POI[Third Party Tool]
• Introduction Unit Testing framework tool
• usage of unit testing framework tool in automation testing
• Introduction to TestNG [Test Next Generation ] &Annotations
• About "Batch execution in TestNG"
• About "Parallel Execution TestNG"
• Introduction to framework and it's components
• Introduction to Page Object Model
• About page design pattern

Part - 4:

• About Hybrid frame work with POM
• Design Hybrid framework with all components
• Handling certificate errors in IE,Chrome,Firefox
• Data Base Connection using selenium web driver
• Generate XSLT reports for Test Execution

 Along with

1. SVN [Version control tool ]
2. Jenkins
3. Ant – as a build tool and to generate XSLT Reports.
4. Basics of Grid-2         
5. Implement automation framework for a real time project with your hands of experience.   

Course Goals and Objectives

• By the end of this course you will have a working knowledge of the Web Driver API
• You will know how to create effective synchronization routines to minimize intermittency
• You will know how to investigate the functionality of Web Driver by looking in the Web Driver code
• You will know how to craft effective assertions using JUnit and TestNG
• You will understand how to run your tests on different browsers
• You will understand different locator strategies and know how to use both CSS selectors and XPath selectors
• You will know end to end handling of selenium automation framework designing

Online Course Outline Additions:

v  I use GoToMeeting for providing online training.

v  Shares my desktop using GoToMeeting during training sessions.

v  Sessions will be interactive mode and can ask many questions as possible for clarifications.

v  If you missed out of any of the session, can plan for other suitable timings.

v  Course Material should be E-Mailed to your Mail ID’s.

v  You can attend my training sessions as long as possible with free of cost.

v  Training session will be provided in practical oriented and purely Real-Time oriented.

v  As well as the lectures , we will provide

§  Sample Resumes according to their experience.

§  Interview questions – with answers

Duration: 45 hours

For Class Room training or On-line Training

Contact Details: 

E-mail: ftindia@outlook.com or sparimi1@outlook.com

Mobile: +91 829 709 0603 or +91 944 141 0209

Selenium Mobile Automation

https://code.google.com/p/selenium/wiki/AndroidDriver

http://manojhans.blogspot.in/2013/08/native-android-apps-automation-with.html

How to scroll web element?--not browser—

FirefoxProfile profile=new FirefoxProfile();

profile.setEnableNativeEvents(true);

WebDriver driver=new FirefoxDriver(profile);

driver.navigate("http://jqueryui.com/draggable/");

Thread.sleep(6000L);

WebElement element=driver.findElement(By.xpath("//div[@id='draggable']"));

Actions actn=new Actions(driver);

actn.dragAndDropBy(element, 50, 50).build().perform();

How to refresh a page without using context click?

1.Using sendKeys.Keys method

driver.get("https://accounts.google.com/SignUp");

driver.findElement(By.id("firstname-placeholder")).sendKeys(Keys.F5);

2.Using navigate.refresh() method

driver.get("http://ruchi-myseleniumblog.blogspot.in/2013/12/100-selenium-interview-questions.html");

driver.navigate().refresh();

3.Using navigate.to() method

driver.get("http://ruchi-myseleniumblog.blogspot.in/2014/01/selenium-hybrid-framework-using.html");

driver.navigate().to(driver.getCurrentUrl());

4.Using get() method

driver.get("http://ruchi-myseleniumblog.blogspot.in/2013/12/basic-core-java-interview-questions.html");

driver.get(driver.getCurrentUrl());

5.Using sendKeys() method

driver.get("https://accounts.google.com/SignUp");

driver.findElement(By.id("firstname-placeholder")).sendKeys("\uE035");

Database Connection using Java and Selenium

Database Connection using Java and Selenium

// import sql package
import java.sql.*;

//http://docsrv.sco.com/JDK_guide/jdbc/getstart/callablestatement.doc.html
public class Database_connection {


public static void main(String[] args) throws SQLException {

 Connection conn = null;
 String url = "jdbc:mysql://localhost:3306/";
 String dbName = "test";
 String driver = "com.mysql.jdbc.Driver";
 String userName = "root";
 String password = "root";

 try{
 Class.forName(driver).newInstance();// create object of Driver
 conn = DriverManager.getConnection(url+dbName,userName,password);
 // connection will be established

 // *******************Statement******************
 Statement stmt = conn.createStatement();
 ResultSet rs = stmt.executeQuery("select * from users");

//  rs.next(); // 1st row
//  System.out.println(rs.getString(2));
//  rs.next(); // 2nd row
//  System.out.println(rs.getString(1));
 while(rs.next()){
System.out.println(rs.getString(1) + "-- "+rs.getString(2)+" -- "+rs.getString(3));
 }

 System.out.println("*********************************");
 // *****************PREPARED STATEMENT**************
 PreparedStatement pstmt = conn.prepareStatement("select * from users where name = ? and sex=?");
 pstmt.setString(1, "B");
 pstmt.setString(2, "F");
 ResultSet rs1 = pstmt.executeQuery();

 while(rs1.next()){
System.out.println(rs1.getString(1) + "-- "+rs1.getString(2)+" -- "+rs1.getString(3));
 }


//***************Callable Statement************************
 //CallableStatement cstmt = conn.prepareCall("{call getTestData(?,?,?,?)}");
   //cstmt.registerOutParameter(1, java.sql.Types.DECIMAL, 3);
   //cstmt.setString(2, "xxxxx");
 
 
   //cstmt.executeUpdate();
  // double d =cstmt.getDouble(1);

//     //********************Add row Insert************************
   pstmt = conn.prepareStatement("insert into users values (?,?,?)");
   pstmt.setString(1, "Tom");
   pstmt.setString(2, "London");
   pstmt.setString(3, "M");
 
   int i=pstmt.executeUpdate();
   if(i==1){
    System.out.println("inserted the record");
   }
 

 }catch(Exception e){
  e.printStackTrace();
 }finally{
 conn.close();
 }
}

}

java program to count number of unique words separated by comma (,) or newline and their occurrence from text file.

java program to count number of unique words separated by comma (,) or newline and their occurrence from text file.

package programs;

import java.util.*;
import java.io.*;

public class uniquewrdsoccurence {

private String[] spliter;
private int[] count;
public void countWord(String Text) {

String temp1 = Text.replaceAll("[\\n]", " ");
String temp = temp1.replaceAll(",", " ");
spliter = temp.replaceAll("[.?!:;/]", "").split(" ");
count = new int[spliter.length];
for (int i = 0; i < spliter.length; i++) {
temp = spliter[i];
for (int k = 0; k < spliter.length; k++) {
if (temp.equalsIgnoreCase(spliter[k])) {
count[k]++;
}
}
}

printResult();
}

private void printResult() {

HashMap map = new HashMap();
int counter = 0;

for (int i = 0; i < spliter.length; i++) {
map.put(spliter[i].toLowerCase(), count[i]);
}

Iterator it = map.keySet().iterator();

System.out.println("Words             Count");
System.out.println("#######################");
while (it.hasNext()) {
counter++;

String temp = (String) it.next();

// prints the word 
System.out.print(temp);

// prints the spaces
for (int i = 0; i < (20 - temp.length()); i++) {
System.out.print(" ");
}

// print the value -total count
System.out.println(map.get(temp.toString()));

}
System.out.println("#######################");
System.out.println("Number of unique words in file:" + counter);
}

// main method 
public static void main(String[] arg) {
String pattern = "";
String str = null;

try {
FileInputStream filestream = new FileInputStream(
System.getProperty("user.dir") + "\\words.txt");
DataInputStream datastream = new DataInputStream(filestream);
BufferedReader Br = new BufferedReader(new InputStreamReader(datastream));
while ((str = Br.readLine()) != null) {
pattern = pattern.concat(str);
pattern = pattern.concat(" ");
}
datastream.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
uniquewrdsoccurence wco = new uniquewrdsoccurence();
wco.countWord(pattern);
}

}

How to find broken images in a page using Selenium

How to find broken images in a page using Selenium

package programs;

import java.util.List;
import org.apache.http.HttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.DefaultHttpClient;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;

public class findbrokenimages {
static int invalidimg;
static WebDriver driver ;
public static void main(String[] args) {
try {
driver = new FirefoxDriver();
driver.get("http://ruchi-myseleniumblog.blogspot.in");
invalidimg = 0;
List allImages  = driver.findElements(By.tagName("img"));
System.out.println("Total  images are " + allImages.size());
for (int i = 0; i < allImages.size(); i++) {
WebElement img = (WebElement) allImages.get(i);
if (img != null) {
verifyimgActive(img);
}
}

System.out.println("Total invalid images are " + invalidimg);
driver.quit();
} catch (Exception e) {
e.printStackTrace();
System.out.println(e.getMessage());
}
}



public static void verifyimgActive(WebElement img) {
try {
HttpResponse response = new DefaultHttpClient().execute(new HttpGet(img.getAttribute("src")));
   if (response.getStatusLine().getStatusCode() != 200)
invalidimg++;
}
catch (Exception e) {
e.printStackTrace();
}
}
}