September 2017 – Automation Fraternity Blog

Selenium: Handling Multiple Tabs in Chrome

September 3, 2017 admin

To handle multiple tabs you have to make a switch between drivers.

		    ArrayList<String> tabs = new ArrayList<String> (driver.getWindowHandles());
		    driver.switchTo().window(tabs.get(1));
		    try {
				Thread.sleep(5000);
			} catch (InterruptedException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		   System.out.println(driver.getTitle());
			o_search.o_add_to_cart_on_product_detail.click();
			
		   // driver.close();
		    driver.switchTo().window(tabs.get(0));

ArrayList<String> tabs = new ArrayList<String> (driver.getWindowHandles());

driver.switchTo().window(tabs.get(1));

try {

Thread.sleep(5000);

} catch (InterruptedException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

System.out.println(driver.getTitle());

o_search.o_add_to_cart_on_product_detail.click();

// driver.close();

driver.switchTo().window(tabs.get(0));

Continue Reading →

Selenium: Read Data from HTML WebTable and return HashMap

September 1, 2017 admin

public static void main(String[] args) {

		
			System.setProperty("webdriver.chrome.driver", "/Users/akashtyagi/Documents/SeleniumFW_SVN/dependencies/chromedriver");

			
			WebDriver driver = new ChromeDriver();
			driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS);
			
			driver.get("https://www.w3schools.com/html/html_tables.asp");
			WebElement o_tbl_object = driver.findElement(By.id("customers"));
			LinkedHashMap<Integer,LinkedHashMap<Integer,String>> o_result = f_get_table_content(o_tbl_object);
			System.out.println(o_result.toString());
			
			
		
	}


public static LinkedHashMap<Integer,LinkedHashMap<Integer,String>> f_get_table_content(WebElement o_tbl_object){
		try{


	
		LinkedHashMap<Integer,String> o_clm_data;// = new LinkedHashMap<Integer,String>();
		LinkedHashMap<Integer,LinkedHashMap<Integer,String>> tbl_map_result = new LinkedHashMap<Integer,LinkedHashMap<Integer,String>>();
		

		List<WebElement> list_rows = o_tbl_object.findElements(By.tagName("tr"));
		List<WebElement> list_clms;
		int i_row_count = list_rows.size();
		int i_clm_count;// = list_clms.size();
		for(int i=0;i<i_row_count;i++){
			list_clms = list_rows.get(i).findElements(By.tagName("td"));
			i_clm_count = list_clms.size();
			o_clm_data = new LinkedHashMap<Integer,String>();
			for(int j=0;j<i_clm_count;j++){

				o_clm_data.put(j,list_clms.get(j).getText());
			
			}//End Inner For
			
			tbl_map_result.put(i, o_clm_data);
		}//End Outer For
		
		
		if(  (tbl_map_result.get(0).size()>0) && (tbl_map_result.size()>0) ){
			System.out.println("info:HTML table fetched and returned in dual hashmap");
			
		}else{
			System.out.println("fail:Unable to fetch data from table. Row Count:" +  (tbl_map_result.size()) + " Clm Count: " + (tbl_map_result.get(0).size()) );
					
		}
		
		return tbl_map_result;
		}catch(Exception e){
			System.out.println("fail:Unable to fetch data from Html table." +   
					" Stack Trace: " +e.getMessage());
			return null;
		}
	}//End Function

public static void main(String[] args) {

System.setProperty("webdriver.chrome.driver", "/Users/akashtyagi/Documents/SeleniumFW_SVN/dependencies/chromedriver");

WebDriver driver = new ChromeDriver();

driver.manage().timeouts().implicitlyWait(20, TimeUnit.SECONDS);

driver.get("https://www.w3schools.com/html/html_tables.asp");

WebElement o_tbl_object = driver.findElement(By.id("customers"));

LinkedHashMap<Integer,LinkedHashMap<Integer,String>> o_result = f_get_table_content(o_tbl_object);

System.out.println(o_result.toString());

}

public static LinkedHashMap<Integer,LinkedHashMap<Integer,String>> f_get_table_content(WebElement o_tbl_object){

try{

LinkedHashMap<Integer,String> o_clm_data;// = new LinkedHashMap<Integer,String>();

LinkedHashMap<Integer,LinkedHashMap<Integer,String>> tbl_map_result = new LinkedHashMap<Integer,LinkedHashMap<Integer,String>>();

List<WebElement> list_rows = o_tbl_object.findElements(By.tagName("tr"));

List<WebElement> list_clms;

int i_row_count = list_rows.size();

int i_clm_count;// = list_clms.size();

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

list_clms = list_rows.get(i).findElements(By.tagName("td"));

i_clm_count = list_clms.size();

o_clm_data = new LinkedHashMap<Integer,String>();

for(int j=0;j<i_clm_count;j++){

o_clm_data.put(j,list_clms.get(j).getText());

}//End Inner For

tbl_map_result.put(i, o_clm_data);

}//End Outer For

if( (tbl_map_result.get(0).size()>0) && (tbl_map_result.size()>0) ){

System.out.println("info:HTML table fetched and returned in dual hashmap");

}else{

System.out.println("fail:Unable to fetch data from table. Row Count:" + (tbl_map_result.size()) + " Clm Count: " + (tbl_map_result.get(0).size()) );

}

return tbl_map_result;

}catch(Exception e){

System.out.println("fail:Unable to fetch data from Html table." +

" Stack Trace: " +e.getMessage());

return null;

}

}//End Function

Continue Reading →

Selenium: Fluent Wait in Selenium

admin

	public static void f_fluent_wait_for_webelement(WebDriver driver, WebElement element, int timoutSec, int pollingSec) {

	    FluentWait<WebDriver> fWait = new FluentWait<WebDriver>(driver).withTimeout(timoutSec, TimeUnit.SECONDS)
	        .pollingEvery(pollingSec, TimeUnit.SECONDS)
	        .ignoring(NoSuchElementException.class, TimeoutException.class).ignoring(StaleElementReferenceException.class);

	        try {
	            
	        	fWait.until(ExpectedConditions.visibilityOf(element));
	        	fWait.until(ExpectedConditions.elementToBeClickable(element));
	        	System.out.println("Element found - " + element.toString().substring(70));
	        } catch (Exception e) {

	        	System.out.println("Element Not found - " + element.toString().substring(70));

	          }

	       // return element;	

	    }

public static void f_fluent_wait_for_webelement(WebDriver driver, WebElement element, int timoutSec, int pollingSec) {

FluentWait<WebDriver> fWait = new FluentWait<WebDriver>(driver).withTimeout(timoutSec, TimeUnit.SECONDS)

.pollingEvery(pollingSec, TimeUnit.SECONDS)

.ignoring(NoSuchElementException.class, TimeoutException.class).ignoring(StaleElementReferenceException.class);

try {

fWait.until(ExpectedConditions.visibilityOf(element));

fWait.until(ExpectedConditions.elementToBeClickable(element));

System.out.println("Element found - " + element.toString().substring(70));

} catch (Exception e) {

System.out.println("Element Not found - " + element.toString().substring(70));

}

// return element;

}

Continue Reading →

Java_Code: JDBC Connection in java

admin

	//Downaload and Add ref to JDBC 6.0. jar location=> 
	//  ../Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar
	public static  LinkedHashMap<Integer,LinkedHashMap<Integer,String>>  f_get_sql_result_map(String s_query){
		  String s_result;
		  String connectionUrl;
		  String DB_LOG_SERVER_NAME = "<Server name>";

		  Map<String,String> map_result = new HashMap<String,String>(); 
		  LinkedHashMap<Integer,String> o_clm_data;
		  LinkedHashMap<Integer,LinkedHashMap<Integer,String>> tbl_map_result = new LinkedHashMap<Integer,LinkedHashMap<Integer,String>>();

		  
		  String JDBC_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  


			  connectionUrl = "jdbc:sqlserver://" + DB_LOG_SERVER_NAME+";" +  
					   "user=<username>;password=<password>;";  
	

		  
		   Connection conn = null;
		   Statement stmt = null;
		   ResultSet rs =null;
		   try{
			  //STEP 2: Register JDBC driver
			  Class.forName(JDBC_DRIVER);
			  conn = DriverManager.getConnection(connectionUrl);
			  stmt = conn.createStatement();  
			  rs = stmt.executeQuery(s_query);
			  ResultSetMetaData rsmd = rs.getMetaData();
			  
			  int i_clm_count = rsmd.getColumnCount();

			int i_map_row_counter=0;
			while(rs.next()){					  
				o_clm_data = new LinkedHashMap<Integer,String>();
				for(int i=1;i<=i_clm_count;i++){
					o_clm_data.put(i-1,rs.getString(i));
				 }//For closed
				tbl_map_result.put(i_map_row_counter, o_clm_data);
				i_map_row_counter = i_map_row_counter + 1;
			}//While Closed
			      
			      //System.out.println("Inside f_get_sql_result_multiple_records: " + map_result_query.get("ROW_1"));
			      if(tbl_map_result.isEmpty()) {
			    	  System.out.println("warn: Recordset is Empty. i.e. no records have been returned by the query. Connection Url: " + connectionUrl + " and Query: " + s_query);
			      }else{
			    	  System.out.println("info: Recordset has been stored in HashMap and returned. Connection Url: " + connectionUrl + " and Query: " + s_query);			    	  
			      }
			      return tbl_map_result;
			      

			   }catch(SQLException se){
			      //Handle errors for JDBC
				   System.out.println("warn:SQl Exception: " + se.toString() + " Query used: " + s_query);
			      //se.printStackTrace();
			      return tbl_map_result;
			   }catch(Exception e){
			      //Handle errors for Class.forName
			      //e.printStackTrace();
				   System.out.println("warn:Other General Exception: " + e.getMessage() + " Query used: " + s_query);
			      return tbl_map_result;
			   }finally{
			      //finally block used to close resources
			      try{
			         if(stmt!=null)
			        	 rs.close();
			            conn.close();
			         	
			      }catch(SQLException se){
			    	  System.out.println("warn:Unable to close connection f_get_sql_result_multiple_records: " + se.getMessage());
			      }// do nothing
			      try{
			         if(conn!=null)
			        	 rs.close();
			            conn.close();
			      }catch(SQLException se){
			         //se.printStackTrace();
			    	  System.out.println("warn:Unable to close the Connection f_get_sql_result_multiple_records" + se.getMessage() + " Query used: " + s_query);
			      }//end finally try
			   }//end try

		
	}//End of Function

//Downaload and Add ref to JDBC 6.0. jar location=>

// ../Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar

public static LinkedHashMap<Integer,LinkedHashMap<Integer,String>> f_get_sql_result_map(String s_query){

String s_result;

String connectionUrl;

String DB_LOG_SERVER_NAME = "<Server name>";

Map<String,String> map_result = new HashMap<String,String>();

LinkedHashMap<Integer,String> o_clm_data;

LinkedHashMap<Integer,LinkedHashMap<Integer,String>> tbl_map_result = new LinkedHashMap<Integer,LinkedHashMap<Integer,String>>();

String JDBC_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

connectionUrl = "jdbc:sqlserver://" + DB_LOG_SERVER_NAME+";" +

"user=<username>;password=<password>;";

Connection conn = null;

Statement stmt = null;

ResultSet rs =null;

try{

//STEP 2: Register JDBC driver

Class.forName(JDBC_DRIVER);

conn = DriverManager.getConnection(connectionUrl);

stmt = conn.createStatement();

rs = stmt.executeQuery(s_query);

ResultSetMetaData rsmd = rs.getMetaData();

int i_clm_count = rsmd.getColumnCount();

int i_map_row_counter=0;

while(rs.next()){

o_clm_data = new LinkedHashMap<Integer,String>();

for(int i=1;i<=i_clm_count;i++){

o_clm_data.put(i-1,rs.getString(i));

}//For closed

tbl_map_result.put(i_map_row_counter, o_clm_data);

i_map_row_counter = i_map_row_counter + 1;

}//While Closed

//System.out.println("Inside f_get_sql_result_multiple_records: " + map_result_query.get("ROW_1"));

if(tbl_map_result.isEmpty()) {

System.out.println("warn: Recordset is Empty. i.e. no records have been returned by the query. Connection Url: " + connectionUrl + " and Query: " + s_query);

}else{

System.out.println("info: Recordset has been stored in HashMap and returned. Connection Url: " + connectionUrl + " and Query: " + s_query);

}

return tbl_map_result;

}catch(SQLException se){

//Handle errors for JDBC

System.out.println("warn:SQl Exception: " + se.toString() + " Query used: " + s_query);

//se.printStackTrace();

return tbl_map_result;

}catch(Exception e){

//Handle errors for Class.forName

//e.printStackTrace();

System.out.println("warn:Other General Exception: " + e.getMessage() + " Query used: " + s_query);

return tbl_map_result;

}finally{

//finally block used to close resources

try{

if(stmt!=null)

rs.close();

conn.close();

}catch(SQLException se){

System.out.println("warn:Unable to close connection f_get_sql_result_multiple_records: " + se.getMessage());

}// do nothing

try{

if(conn!=null)

rs.close();

conn.close();

}catch(SQLException se){

//se.printStackTrace();

System.out.println("warn:Unable to close the Connection f_get_sql_result_multiple_records" + se.getMessage() + " Query used: " + s_query);

}//end finally try

}//end try

}//End of Function

Continue Reading →

Java_Code: Generate Random Numeric String with Min and Max digit

admin

		  public static String f_generate_random_numeric_string(long i_min, long i_max){
			  Random rand = new Random();
			  long random = (int )(Math.random() * i_max + i_min);
			  String result = Long.toString(random);
			  System.out.println("info", "Random numeric string generated. Min and Max mentioned as: " +
					  i_min + " max : " + i_max + " result: " + result);
			  return result;
			  
		  }

public static String f_generate_random_numeric_string(long i_min, long i_max){

Random rand = new Random();

long random = (int )(Math.random() * i_max + i_min);

String result = Long.toString(random);

System.out.println("info", "Random numeric string generated. Min and Max mentioned as: " +

i_min + " max : " + i_max + " result: " + result);

return result;

}

Continue Reading →

Java_Code: Generate Time Based Unique Integer

admin

	  public static String f_generate_time_based_unique_integer(){
		  String result;
		  String y,mon,d,h,min,s,mil;
		  
		  Calendar now = Calendar.getInstance();
		  int year = now.get(Calendar.YEAR);
		  int month = now.get(Calendar.MONTH) + 1; // Note: zero based!
		  int day = now.get(Calendar.DAY_OF_MONTH);
		  int hour = now.get(Calendar.HOUR_OF_DAY);
		  int minute = now.get(Calendar.MINUTE);
		  int second = now.get(Calendar.SECOND);
		  int millis = now.get(Calendar.MILLISECOND);
		  
		  y = Integer.toString(year);
		  mon = Integer.toString(month);
		  d = Integer.toString(day);
		  h = Integer.toString(hour);
		  min = Integer.toString(minute);
		  s = Integer.toString(second);
		  mil = Integer.toString(millis);
		  
		  
		  result = y+mon+d+h+min+s;
		  System.out.println("info", "Unique Time based String Generated: " +  result);
			  
		  return result;
		  
	  }

public static String f_generate_time_based_unique_integer(){

String result;

String y,mon,d,h,min,s,mil;

Calendar now = Calendar.getInstance();

int year = now.get(Calendar.YEAR);

int month = now.get(Calendar.MONTH) + 1; // Note: zero based!

int day = now.get(Calendar.DAY_OF_MONTH);

int hour = now.get(Calendar.HOUR_OF_DAY);

int minute = now.get(Calendar.MINUTE);

int second = now.get(Calendar.SECOND);

int millis = now.get(Calendar.MILLISECOND);

y = Integer.toString(year);

mon = Integer.toString(month);

d = Integer.toString(day);

h = Integer.toString(hour);

min = Integer.toString(minute);

s = Integer.toString(second);

mil = Integer.toString(millis);

result = y+mon+d+h+min+s;

System.out.println("info", "Unique Time based String Generated: " + result);

return result;

}

Continue Reading →