Automation testing concepts and challenges

Simple JDBC Program with CRUD operations

noreply@blogger.com (Baba Fakruddin) — Thu, 31 Jan 2019 18:03:00 +0000

package com.jdbc;

import com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException;

import java.sql.*;
import java.util.*;

public class Book {
static Connection con = null;
static Statement statement = null;

public static void main(String[] args) throws ClassNotFoundException, SQLException {
//Scanner scanner = new Scanner(System.in);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/advancedJava", "baba", "baba");

BookDAO bookDAO1 = new BookDAO(1, "LKG", "SchoolA", 20.30f);
BookDAO bookDAO2 = new BookDAO(2, "UKG", "SchoolZ", 50.30f);
BookDAO bookDAO3 = new BookDAO(3, "1stClass", "SchoolC", 30.85f);
BookDAO bookDAO4 = new BookDAO(4, "2ndClass", "SchoolA", 50.50f);
BookDAO bookDAO5 = new BookDAO(5, "3rdClass", "SchoolD", 80.90f);

List allBooks = Arrays.asList(bookDAO1, bookDAO2, bookDAO3, bookDAO4, bookDAO5);
List collectionOfBooks = new ArrayList<>();
collectionOfBooks.addAll(allBooks);

/*
* Insert 5 Rows into Book Table
* */
insertRecords(allBooks);

/*
* Read All Records
* */
readRecords();

/*
* Update Records
* */
updateRecords(bookDAO2);

/*
* Delete Records
* */
deleteRecords(bookDAO2);

con.close();
}

public static void readRecords() throws SQLException {
System.out.println("-------------------------------- Read Records Start -----------------------------------------------");
statement = con.createStatement();
ResultSet rs = statement.executeQuery("select * from Book");
while (rs.next()){
System.out.println(rs.getString("BookCode") + "\t" + rs.getString("BookName") + "\t" + rs.getString("BookAuthor") + "\t" + rs.getString("BookPrice"));
}
}

public static void insertRecords(List allBooks) throws SQLException {
System.out.println("-------------------------------- Insert Records Start -----------------------------------------------");
PreparedStatement preparedStatement;
preparedStatement = con.prepareStatement("insert into Book values (?, ?, ?, ?)");
Iterator eachBook = allBooks.iterator();
BookDAO currentBook = null;
while (eachBook.hasNext()) {
currentBook = (BookDAO) eachBook.next();
preparedStatement.setInt(1, currentBook.getBookCode());
preparedStatement.setString(2, currentBook.getBookName());
preparedStatement.setString(3, currentBook.getBookAuthor());
preparedStatement.setFloat(4, currentBook.getBookPrice());
try {
if (preparedStatement.executeUpdate() > 0) {
System.out.print("Book details inserted successfully : ");
System.out.println(currentBook.toString());
} else {
System.out.println("Book Details are not inserted, Please check the program");
}
} catch (MySQLIntegrityConstraintViolationException e) {
System.out.println(e.getMessage() + " -- So, skipping this record insertion");
}
}
}

public static void updateRecords(BookDAO bookDAO) throws SQLException {
System.out.println("-------------------------------- Update Records Start -----------------------------------------------");
PreparedStatement preparedStatement = con.prepareStatement("update Book set BookAuthor=? where BookCode = ?");
bookDAO.setBookAuthor("BabaProgram");
bookDAO.setBookCode(2);
preparedStatement.setString(1, bookDAO.getBookAuthor());
preparedStatement.setInt(2, bookDAO.getBookCode());
if (preparedStatement.executeUpdate()>0){
System.out.println("Book Details are updated successfully");
System.out.println(bookDAO.toString());
}else {
System.out.println("Book Details are not updated successfully");
}
}

public static void deleteRecords(BookDAO bookDAO) throws SQLException {
System.out.println("-------------------------------- Delete Records Start -----------------------------------------------");
PreparedStatement preparedStatement = con.prepareStatement("delete from Book where BookCode=?");
preparedStatement.setInt(1, bookDAO.getBookCode());
if(preparedStatement.executeUpdate()>0){
System.out.println("Delete of the below record is successful in DB");
System.out.println(bookDAO.toString());
//Print the rest of all records in console
statement = con.createStatement();
ResultSet rs = statement.executeQuery("select * from Book");
while (rs.next()){
System.out.println(rs.getString("BookCode") + "\t" + rs.getString("BookName") + "\t" + rs.getString("BookAuthor") + "\t" + rs.getString("BookPrice"));
}
}
}

}

class BookDAO{
private int BookCode;
private String BookName;
private String BookAuthor;
private float BookPrice;

public BookDAO(int bookCode, String bookName, String bookAuthor, float bookPrice) {
BookCode = bookCode;
BookName = bookName;
BookAuthor = bookAuthor;
BookPrice = bookPrice;
}

public int getBookCode() {
return BookCode;
}

public void setBookCode(int bookCode) {
BookCode = bookCode;
}

public String getBookName() {
return BookName;
}

public void setBookName(String bookName) {
BookName = bookName;
}

public String getBookAuthor() {
return BookAuthor;
}

public void setBookAuthor(String bookAuthor) {
BookAuthor = bookAuthor;
}

public float getBookPrice() {
return BookPrice;
}

public void setBookPrice(float bookPrice) {
BookPrice = bookPrice;
}

@Override
public String toString() {
return "BookDAO{" +
"BookCode=" + BookCode +
", BookName='" + BookName + '\'' +
", BookAuthor='" + BookAuthor + '\'' +
", BookPrice=" + BookPrice +
'}';
}
}

Get Prime Numbers with different approaches

noreply@blogger.com (bfakruddin.d@gmail.com) — Thu, 02 Aug 2018 17:47:00 +0000

Below Program show you different ways to get prime numbers.


import java.lang.reflect.Array;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.ListIterator;

public class PrimeNumbers {
    public static void main(String[] args) {
        PrimeNumbers pn = new PrimeNumbers();
        List getPrimesWithBasicLogic = pn.getAllPrimeNumbersTillByAllLesserValues(20, 300);
        Iterator it = getPrimesWithBasicLogic.iterator();
        while (it.hasNext()){
            System.out.println(it.next());
        }

        double sqrtOf = pn.sqrtOf(9);
        System.out.println((int)sqrtOf);

        List getPrimesWithSqrRoot = pn.getAllPrimeNumbersBySqrRoot(2, 111);
        Iterator it1 = getPrimesWithSqrRoot.iterator();
        while (it1.hasNext()){
            System.out.println(it1.next());
        }

        int[] op = pn.getAllPrimeNumbersBySieveOfEratostheness(15);
        for(int j=0; j<=op.length-1; j++){
            if(op[j]==0){
                continue;
            }
            System.out.println(op[j]);
        }
    }

    /**     * Function: getAllPrimeNumbersBySieveOfEratostheness     * Description: Get All Prime Numbers using Sieve Of Eratostheness algorithm     * inputs: max Value (prints all prime numbers till max)     * outputs: int[] array with all prime numbers places as 1's and non primes as 0's     * Time complexity: O(n loglogn)     * */    public int[] getAllPrimeNumbersBySieveOfEratostheness(int max){
        int[] primes = new int[max+1];
        int[] op = new int[primes.length-1];
        for(int i=1; i<=primes.length-1; i++){
            primes[i]=1;
        }
        primes[0]=0;
        primes[1]=0;
        for(int i=2; i<primes.length; i++){
            if(primes[i]==1){
                for(int j=2; i*j<=max; i++){
                    primes[i*j]=0;
                }
                op[i]=i;
            }
        }

        return op;
    }

    /**     * Function: getAllPrimeNumbersBySqrRoot     * Description: Get All Prime Numbers by using square root technique for min iterations (Trial Division)     * Inputs: min and max     * Output: List of prime numbers     * TimeComplexity: O(n√n)*/    public List getAllPrimeNumbersBySqrRoot(int min, int maxVal){
        if(min<=0 || maxVal==0){
            System.out.println("Enter min and max as Natural numbers ");
            return null;
        }
        List op = new ArrayList();
        for(int i=min; i<=maxVal; i++){     //O(n)            if(isThisPrimeNumberBySqroot(i)){
                op.add(i);
            }
        }
        return op;
    }

    public Boolean isThisPrimeNumberBySqroot(int input){
        if(input<=1){
            System.out.println("Enter Natural numbers greater than 1");
            return false;
        }
        int sqrtOf = (int) sqrtOf(input);
        for(int i=2; i<=sqrtOf; i++){       //O(√n)            if(input%i==0){
                return false;
            }
        }
        return true;
    }

    /**     * Function: getAllPrimeNumbersTillByAllLesserValues     * Description: returns all prime numbers from minval to maxval     * Inputs: min and max     * Output: List of prime numbers     * TimeComplexity: O(n^2)     * */    public List getAllPrimeNumbersTillByAllLesserValues(int min, int maxVal){
        if(min<=0 || maxVal==0){
            System.out.println("Enter min and max as Natural numbers ");
            return null;
        }
        double minVal = (double) min;
        double maxVal1 = (double) maxVal;
        List op = new ArrayList();
        for(int i=min; i<=maxVal; i++){
            if(isThisPrimeNumber(i)){
                op.add(i);
            }
        }
        return op;
    }

    public boolean isThisPrimeNumber(int input){
        if(input<=0 || input==1){
            System.out.println("Enter natural number >1");
            return false;
        }
        for(int i=2; i<input; i++){
            if(input%i==0){
                return false;
            }
        }
        return true;
    }

    /**     * Function: sqrtOf     * Description: Square root of an integer would be calculated     * inputs: input integer     * output: double (square root value of the given input)     * Timecomplexity: O(n) based on the e value     * Methodology: babylonians square root algorithm     * */    public double sqrtOf(int input){
        if(input ==0 || input<0){
            System.out.println("Please pass Positive value which is greater than 0");
            return 0;
        }
        double initVal = input/2;
        double e = 0.0000000001; //gives exact value - Do not keep just 0.000 values which may cause to infinite loop        do{
            initVal = (initVal+(input/initVal))/2.0;
        }while (initVal-(input/initVal)>e);
        return initVal;
    }
}

Find Squareroot in Java

noreply@blogger.com (Baba Fakruddin) — Thu, 03 May 2018 16:15:00 +0000

public double squareRootOf(double sqrtOf){

    double initVal = sqrtOf/2;
    double e = 0.0000000001; //gives exact value
    do{

        initVal = (initVal+(sqrtOf/initVal))/2.0;

    }while (initVal-(sqrtOf/initVal)>e);
    return initVal;
}

"A good threat is worth a thousand tests" - Boris Beizer

Find Integer Length

noreply@blogger.com (Baba Fakruddin) — Mon, 30 Apr 2018 17:54:00 +0000

Change Datatype as per your need. Simple but powerful

public int getIntLength(int input){
    int a = input;
    int count=0;

    if(a==0){
        count++;
    }

    while(a!=0){
        a = a/10;
        count++;
    }

    return count;
}

"A good threat is worth a thousand tests" - Boris Beizer

CI Jenkins JavaProject1

noreply@blogger.com (baba fakruddin) — Thu, 14 Sep 2017 03:52:00 +0000

"A good threat is worth a thousand tests" - Boris Beizer

Array Sort in Java (better performance)

noreply@blogger.com (bfakruddin.d@gmail.com) — Sat, 10 Jun 2017 17:45:00 +0000

package yourpackagename;

import java.lang.reflect.Array;
import java.util.Arrays;
import java.util.Timer;

public class ArrayPractices {

public static void main(String[] args){
//Array Declaration
int[] intArray={0, 100, 2, 22, 66, 501, 6, 8, 0};
long startTime= -1;
long endTime = -1;

// Java inbuilt Arrays.sort method from DualPivotQuicksort class method (Arrays.sort)
startTime=System.nanoTime();
Arrays.sort(intArray);

for(int i=0; i<=intArray.length-1;i++){
System.out.println(intArray[i]);
}
endTime= System.nanoTime();
System.out.println("Total execution time: " + (endTime - startTime) );

// User Defined method for sorting Array in ascending order
startTime=System.nanoTime();
int[] op = sorting(intArray, 0, intArray.length-1);
for(int i=0; i<=op.length-1; i++){
System.out.println(op[i]);
}

endTime= System.nanoTime();
System.out.println("Total execution time: " + (endTime - startTime) );
}

public static int[] sorting(int[] a, int start, int end){
int lowVal=-1;
int highVal=-1;
for(int i=start; i<=end; i++){
if(a.length-1>=i+1){
if(a[i]>a[i+1]){
lowVal = a[i+1];
highVal = a[i];
a[i]=lowVal;
a[i+1]=highVal;
i--;
}else if(a[i]<a[i+1]){
for(int k=end; k>=i+1; k--){
if(a.length-1>=k){
if(a[k]<a[i]){
highVal = a[i];
lowVal = a[k];
a[k]=highVal;
a[i]=lowVal;
}

}
}
}
}
}
return a;
}
}

Password Encoder Utility - Selenium

noreply@blogger.com (Baba Fakruddin) — Sat, 17 Dec 2016 07:44:00 +0000

Hi All,

We have password utility which generates based on your input string in QTP/UFT which is called as "Password encoder". As selenium is freeversion :) they're not providing you any direct utility, but you've option to encrypt and decrypt your password by using org.apache.commons.codec.binary.Base64 from Selenium-Java.

Step 1:

Create Maven Project/Java Project

You must have below dependency in maven project or add jar to your project manually

Step 2:

Create one package and create a class "PasswordEncoder" with Main method

Step 3:

Copy and paste below code to your class file

import org.apache.commons.codec.binary.Base64;

public class PasswordEncoder {

public static void main(String[] args) {

// TODO Auto-generated method stub

System.out.println();

System. out .println("* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *");

System.out.println("Encrypted password of given string is in next line");

System.out.println(EncyptPassword(args[0]));

System.out.println();

System. out .println("* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *");

}

public static String EncyptPassword(String strOrgPwd){

byte [] encoded =Base64.encodeBase64(strOrgPwd.getBytes());

return new String(encoded);

}

Step 4:

Export Maven project/Java project as (executable) Runnable jar file with name "passwordEncoder.jar"

Step 5:

Create a Folder in your local drive

Step 6:

Copy runnable jar file into the created folder

Step 7:

Create a bat file and copy paste below code

@echo off

cd\

setlocal

call:pwd pass

call:pwd pass2

cd /d %~dp0

IF "%pass%" == "%pass2%" ( echo.Passwords entered are matched, Hurray!!!

java —jar passwordEncoder.jar %pass% ) ELSE (

echo.Passwords entered does not matched... Try with correct password again!!!

pause

EXIT

)

pause

GOTO:EOF

:pwd var title color —— shows a password dialog box

:$created 20060101 :$changed 20080226 :$categories Input,Password

SETLOCAL

set "tit=%~2"

set "col=%~3"

set "pwd="

if not defined col set "col=EF"

if not defined tit set "tit=Password:"

set "f=%temp%\%~nx0.tmp~0.tmp"

start "%tit%" /wait cmd /c "mode con cols=50 lines=1&color %col%&set /p "in="&call echo.%%in%%>"%f%""

for /f "usebackq tokens=*" %%a in ("%f%") do set "pwd=%%a"

del /q "%f%"

ENDLOCAL&if "%~1" NEQ "" (SET %~1=%pwd%) ELSE ECHO.%txt%

EXIT /b

Step 8:

Create a short for the bat file and change icon as you like

Step 9:

Copy the shortcut file of bat and paste under all programs of you windows

Your Utility is ready... Go ahead and enjoy your own utility

Advantages:

1. You can enter string even during screen share. Text you're entering won't be displayed to all

2. Utility will ask for your password confirmation twice, which avoids typo error encryptions

"A good threat is worth a thousand tests" - Boris Beizer

Update TestSet Test status and upload file in ALM 11 OTA code using JACOBS (using Java)

noreply@blogger.com (bfakruddin.d@gmail.com) — Sat, 20 Aug 2016 17:05:00 +0000

Hi All,

Using VB, C#, VBScript to access COM is very straight forward and we can easily develop scripts/code based on Application API, you can get intellisense in IDEs, Excel Macros, etc., So, all methods are visible and documentation would be easily to find on each of them.

But, When we got situation to work on any COM using Java, it's not so easy as with VB/C#. we've multiple ways to deal with COM with Java, e.g. COM4j, JACOBS, etc., each jar has their own methods and way to access COM.

Mainly, now a days Web Automation is looking forward to Selenium - Java, But most of the projects would be running on ALM. Expectations from managements as to use Selenium, But integration with ALM for Test management.

I would like to show you guys how we can Access ALM - Testset(TestLab) Test and update test results, Attach any file in Test attachment with description.

Note: you can tweak this as per your need.

You must have Jacob dlls (32 and 64 bit) and place as shown below.

/**
* PreCondition to ALM Update code - Initialize Jacobs
* */
import com.jacob.com.LibraryLoader;

public class Core extends AppVariables{
   public void initializeJacobs(){
       String jacobDllVersionToUse;
       if (jvmBitVersion().contains("32")){
           jacobDllVersionToUse = "jacob-1.18-x86.dll";
       }
       else {
           jacobDllVersionToUse = "jacob-1.18-x64.dll";
       }
       File file = new File("Lib", jacobDllVersionToUse);
       System.setProperty(LibraryLoader.JACOB_DLL_PATH, file.getAbsolutePath());
   }
   public String jvmBitVersion(){
       return System.getProperty("sun.arch.data.model");
   }
}

/**
* Actual Class which has Code implementation
* */
import java.text.DateFormat;
import java.util.Calendar;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.ComFailException;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;
//import com.sun.jna.platform.win32.COM.TypeInfoUtil.Invoke;

import frameworkComponents.Core;

public class ALMTesting extends Core{

   /**
   * @param args
   */
   @SuppressWarnings("deprecation")
   public static void main(String[] args) {
       // TODO Auto-generated method stub
       Core cfw = new Core();
       cfw.initializeJacobs();

       uploadFileToTestSetTest("http://win-2008server:8080/qcbin/", "DEFAULT", "Testing", "Baba", "baba", "Root\\Testing", "TestingForJACOBS", "Sample-SeleniumTest", "C:\\Users\\Baba\\Desktop\\SQL_SA_pwd.txt");
   }

   @SuppressWarnings("deprecation")
   static void uploadFileToTestSetTest(String almURL, String domain, String project, String almUserName, String almEncryptedPassword, String testFolder, String testSetName, String testName, String uploadFilePath){
       ActiveXComponent almConnection=new ActiveXComponent("TDAPIOLE80.TDConnection");
       Dispatch.call(almConnection, "InitConnectionEx", almURL);
       Dispatch.call(almConnection, "login", almUserName,almEncryptedPassword);
       Dispatch.call(almConnection, "connect",domain,project);

       /**By me on Test set factory*/
       //        Dispatch testLab = Dispatch.get(almConnection, "TestSetFactory").toDispatch();
       //        Dispatch testSetFilter = Dispatch.get(testLab, "Filter").toDispatch();

//       String testFolder = testFolder;
//       String testSetName = testSetName;
//       String testName = testName;
//       String uploadFilePath = uploadFilePath;

       Dispatch testSetTreeManager = Dispatch.get(almConnection, "TestSetTreeManager").toDispatch();
       Dispatch tsFolder = Dispatch.call(testSetTreeManager, "NodeByPath", testFolder).toDispatch();
       //Dispatch subFolderNode = Dispatch.get(tsFolder, "NewList").toDispatch();
       Dispatch testSetNode = Dispatch.get(tsFolder, "TestSetFactory").toDispatch();
       Dispatch testSetList = Dispatch.call(testSetNode, "NewList", "").toDispatch();
       //        Dispatch tsList = Dispatch.call(tsFolder, "FindTestSets", testSetName).toDispatch();

       System.out.println("till here good");
       Variant count = Dispatch.get(testSetList, "Count");
       System.out.println(count);
       int toInt = count.toInt();
       //        String[] testNames = new String[toInt];
       boolean blnFlag = false;
       for (int testSetIndex = 1; testSetIndex <= toInt; testSetIndex++ ) {
           Dispatch testSetItem = Dispatch.call(testSetList, "Item", new Variant(testSetIndex)).toDispatch();
           Variant testSetActName = Dispatch.get(testSetItem, "Name");
           System.out.println(testSetActName);
           if (testSetActName.toString().equalsIgnoreCase(testSetName)){
               Dispatch testSetTestFactory = Dispatch.get(testSetItem, "TSTestFactory").toDispatch();
               Dispatch testList = Dispatch.call(testSetTestFactory, "NewList", "").toDispatch();
               Variant testsCount = Dispatch.get(testList, "Count");
               System.out.println(testsCount);
               int testsCountInt = testsCount.toInt();
               for(int testIndex=1; testIndex<=testsCountInt; testIndex++){
                   Dispatch testItem = Dispatch.call(testList, "Item", new Variant(testIndex)).toDispatch();
                   Variant testActName = Dispatch.get(testItem, "TestName");
                   System.out.println(testActName);
                   if(testActName.toString().equalsIgnoreCase(testName)){

                       try{
                           Dispatch nowTest = testItem;
                           Dispatch attachmentFactory = Dispatch.get(testItem, "Attachments").toDispatch();
                           //                          Dispatch attachList = Dispatch.call(attachmentFactory, "NewList", "").toDispatch();

//                           Dispatch.put(nowTest, "Status", "Passed");
//                           Dispatch.call(nowTest, "Post");

                           //System.DBNull.Value
                           Variant paramVal = new Variant();
                           paramVal.putNull();
                           Dispatch nowAttachment = Dispatch.call(attachmentFactory, "AddItem", paramVal).toDispatch();
                           Dispatch.put(nowAttachment, "Description", Calendar.getInstance().getTime());
                           Dispatch.put(nowAttachment, "Filename", uploadFilePath);
                           Dispatch.put(nowAttachment, "Type", 1);
                           Dispatch.call(nowAttachment, "Post");

                           /** Updating steps in this test*/
                           // Create run factory for this test
                           Dispatch runF = Dispatch.get(testItem, "RunFactory").toDispatch();
                           // Add a name to this runfactory test
                           Dispatch runA = Dispatch.call(runF, "AddItem", "Automated").toDispatch();
                           Dispatch runAA = Dispatch.call(runF, "NewList","").toDispatch();

                           Variant runCount = Dispatch.get(runAA, "Count");
                           System.out.println("Run Count : "+ runCount);
                           int runsCountInt = runCount.toInt();

                           for(int run=1; run<=runsCountInt; run++){
                               Dispatch runItem = Dispatch.call(runAA, "Item", new Variant(run)).toDispatch();
                               Variant runName = Dispatch.get(runItem, "Name");
                               System.out.println(runName);

                               // Create Stepfactory for this Run
                               Dispatch oStep = Dispatch.get(runItem, "StepFactory").toDispatch();
                               //Create a step
                               Dispatch.call(oStep, "AddItem", "Test case result");
                               Dispatch oStepDetails = Dispatch.call(oStep, "NewList", "").toDispatch();

                               Dispatch.put(runItem, "Status", "Passed");
                               Dispatch.call(runItem, "Post");
                               // Create Stepfactory for this Run
//                               Dispatch oStep = Dispatch.get(runA, "StepFactory").toDispatch();

//                               Dispatch oStepDetails = Dispatch.call(oStep, "NewList", "").toDispatch();

                               // Update all steps to pass
                               Variant stepsCount=Dispatch.get(oStepDetails, "Count");
                               System.out.println("No of Step is - "+stepsCount);
                               int stepsCountInt = stepsCount.toInt();
                               for(int stepIndex=1; stepIndex<=stepsCountInt; stepIndex++){
                                   Dispatch stepItem = Dispatch.call(oStepDetails,"Item",new Variant(stepIndex)).toDispatch();
                                   Variant stepActName = Dispatch.get(stepItem, "Name");
                                   System.out.println("Step Name is : "+stepActName);
                                   try{
                                       Dispatch.put(stepItem, "Status", "Passed");
                                       Dispatch.call(stepItem, "Post");
                                   }catch(ComFailException i){
                                       System.out.println("COM Fail Exception occured, Exited without updates in ALM Status or FileName upload or Description or Type");
                                       Dispatch.call(almConnection, "Disconnect");
                                       Dispatch.call(almConnection, "Logout");
                                       Dispatch.call(almConnection, "ReleaseConnection");
                                       System.exit(-1);
                                   }
                               }
                               break;
                           }


                           blnFlag=true;
                           break;
                       }catch(ComFailException i){
                           System.out.println("COM Fail Exception occured, Exited without updates in ALM Status or FileName upload or Description or Type");
                           Dispatch.call(almConnection, "Disconnect");
                           Dispatch.call(almConnection, "Logout");
                           Dispatch.call(almConnection, "ReleaseConnection");
                           System.exit(-1);
                       }
                   }
               }
               if(blnFlag) break;
           }
       }

       Dispatch.call(almConnection, "Disconnect");
       Dispatch.call(almConnection, "Logout");
       Dispatch.call(almConnection, "ReleaseConnection");
       System.out.println("updates are done");
   }
}

"A good threat is worth a thousand tests" - Boris Beizer

Selenium webdriver returning only one ie window even it has multiple windows - Solution

noreply@blogger.com (Baba Fakruddin) — Tue, 10 May 2016 16:26:00 +0000

Hey, it's so annoying if we have a correct script which is working in good condition but not behaving as expected in desired system.

Selenium webdriver have few limitations, some times code developed on Firefox might not work as expected in Internet Explorer. I got this situation to handle with multiple windows on IE 11. But the code what I've developed on FF is failing on IE.

Here, winhandles method returning correct no. Of Windows on FF. But, IE always returning only one.

Solution:
1. Change "Compatibility View Settings" check ON in IE browser
2. Invoke "User Account Settings" in control panel and change settings go "Never notify"

Mostly above two steps will solve your problem.

"A good threat is worth a thousand tests" - Boris Beizer

Selenium - Useful Excel Methods

noreply@blogger.com (Baba Fakruddin) — Sun, 01 May 2016 17:43:00 +0000

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.HashMap;

import java.util.Iterator;

import java.util.Map;

import java.util.Map.Entry;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.WorkbookFactory;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;
　

/**

* Class : DataTable

* Description: Methods to deal with an excel file similar to QTP Datatable methods

* Developed By: Baba Fakruddin D

* Developed on: 01/05/2016

* */

/** Below class extends PublicVariables Class which has few public variables definitions - If you guys face errors after copy and paste this class, Please create those public variables in your class*/

class DataTable{
    public static String File = null;
    public String xlDataFileName;
    public String xlSheetName;
    public static Map tcRowData = new HashMap();
    private String path;
    public FileInputStream inputStream = null;
    public FileOutputStream outputStream = null;
    public String hname, value;
    public int i, j;
    public File file;
    public XSSFWorkbook workBook;
    public XSSFSheet sheet;

    public DataTable(String path) throws IOException{
        this.path = path;
        this.file = new File(path);
        try{
            inputStream = new FileInputStream(path);
            workBook = new XSSFWorkbook(inputStream);
            sheet = workBook.getSheetAt(0);
            inputStream.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public DataTable(String path, String sheetName){
        this.path = path;
        this.file = new File(path);
        try{
            inputStream = new FileInputStream(path);
            workBook = new XSSFWorkbook(inputStream);
            sheet = workBook.getSheet(sheetName);
            inputStream.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    /*public DataTable(File file, XSSFWorkbook workBook){
        this.file = file;
        this.workBook = workBook;
        System.out.println("For Creating object");
    }*/

    public DataTable(File file, XSSFWorkbook workBook, XSSFSheet sheet){
        this.file = file;
        this.workBook = workBook;
        this.sheet = sheet;
    }

    public int getRowCount(String sheetName){
        int index = workBook.getSheetIndex(sheetName);
        if(index==-1){
            return -1;
        }else{
            sheet = workBook.getSheetAt(index);
            int number = sheet.getLastRowNum()+1;
            return number;
        }
    }

    /**
    * Function: setFile
    * Description: Set the excel file based on input filePath
    * @author Baba
    * @category Generic
    * @param filePath
    * @return void
    * Tested: 22/05/2016 - working as expected
    * */
    public void setFile(String filePath) throws FileNotFoundException{
        inputStream = null;
        workBook = null;
        file = null;
        try {
            file = new File(filePath);
            inputStream = new FileInputStream(file);
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            System.out.println ("File not found in the specified path.");
            e.printStackTrace();
        }
        try {
            workBook = new XSSFWorkbook(inputStream);
            inputStream.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    /**
    * Function: createWorkBook
    * Description: Creates an excel work book in filepath with "Sheet1" sheet as sent as parameter
    * @author Baba
    * @param filePath
    * @return XSSFWorkbook
    * @category Generic
    * Tested: 22/05/2016 - working as expected
    * */
    public XSSFWorkbook createWorkBook(String filePath) throws IOException{
        inputStream = null;
        workBook = null;
        sheet = null;
        file = null;
        file = new File(filePath);
        if(file.exists()){
            inputStream = new FileInputStream(file);
        }else{
            workBook = new XSSFWorkbook();
            outputStream = new FileOutputStream(file);
            workBook.write(outputStream);
            outputStream.flush();
            outputStream.close();
            inputStream = new FileInputStream(file);
        }

        workBook = new XSSFWorkbook(inputStream);
        sheet = workBook.createSheet();
//        DataTableMethods.createSheet("Sheet1");
//        sheet = workBook.createSheet("Sheet1");

        inputStream.close();
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();

        if(file.exists()){
            return workBook;
        }else{
            return null;
        }
    }

    /**
    * Function: createWorkBook
    * Description: Creates an excel workbook and in filepath and sheetName as sent as parameter
    * @author Baba
    * @param filePath, sheetName
    * @return XSSFWorkbook
    * @category Generic
    * Tested: 22/05/2016 - working as expected
    * */
    public XSSFWorkbook createWorkBook(String filePath, String sheetName) throws IOException{
        inputStream = null;
        workBook = null;
        sheet = null;
        file = new File(filePath);
        if(file.exists()){
            inputStream = new FileInputStream(file);
        }else{
            workBook = new XSSFWorkbook();
            outputStream = new FileOutputStream(file);
            workBook.write(outputStream);
            outputStream.flush();
            outputStream.close();
            inputStream = new FileInputStream(file);
        }

        workBook = new XSSFWorkbook(inputStream);

        DataTable dts = new DataTable(file, workBook, sheet);
        dts.createSheet(sheetName);

//        DataTableMethods.createSheet(sheetName);
//        sheet = workBook.createSheet("Sheet1");

        inputStream.close();
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();

        if(file.exists()){
            return workBook;
        }else{
            return null;
        }
    }

    /**
    * Function: createSheet
    * Description: Creates excel sheet in workbook which set as global, use setfile to set one excel file
    * @author Baba
    * @param sheetName
    * @return Sheet
    * @category Generic
    * Tested: 22/05/2016 - working as expected
    * */
    public Sheet createSheet(String sheetName) throws IOException{
        int shtCnt = workBook.getNumberOfSheets();
        Boolean blnFlag;
        if(shtCnt>0){
            for (int i=0; i                blnFlag = true;
                for (int j=0;j                    if (workBook.getSheetName(j).equalsIgnoreCase(sheetName)){
                        blnFlag = false;
                        break;
                    }
                }
                if (blnFlag){
                    sheet = workBook.createSheet(sheetName);
                    break;
                }else{
                    break;
                }
            }
        }else if(shtCnt==0){
            sheet = workBook.createSheet(sheetName);
        }

        sheet = workBook.getSheet(sheetName);

        Row row = sheet.createRow(0);
        row.createCell(0);

        try {
            if (inputStream!=null){
                inputStream.close();
            }
            outputStream = new FileOutputStream(file);
            workBook.write(outputStream);
            outputStream.flush();
            outputStream.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return sheet;
    }

    /**
    * Function: saveAs
    * Description: Save an excel workBook as excel file in the path sent as parameter
    * @author Baba
    * @param sheetName
    * @return Sheet
    * @throws IOException
    * @category Generic
    * Tested: 22/05/2016 - working as expected
    * */
    public void saveAs(String filePath) throws IOException{
        outputStream = new FileOutputStream(new File(filePath));
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
    }

    public void closeWorkBook(){
        try {
            outputStream.flush();
            outputStream.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public Sheet setSheet(String sheetName){
        sheet = workBook.getSheet(sheetName);
        return sheet;
    }

    public String getSheetName(){
        return sheet.getSheetName();
    }

    public void setFileAndSheet(String filePath, String sheetName) throws IOException{
        /*inputStream = null;
        workBook = null;
        sheet = null;
        DataTable dts = new DataTable(filePath);
        dts.setFile(filePath);
        dts.setSheet(sheetName);*/
        try{
            inputStream = new FileInputStream(filePath);
            workBook = new XSSFWorkbook(inputStream);
            sheet = workBook.getSheet(sheetName);
            File file = new File(filePath);
            DataTable dts = new DataTable(file, workBook, sheet);
            inputStream.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public String value(int row, int column){
        row = row-1;
        column = column-1;
        Cell cellValue = sheet.getRow(row).getCell(column);
        if(cellValue!=null){
            return cellValue.toString();
        }else{
            System.out.println("No Value contains in Row/Column : "+ row +"/"+column);
            return null;
        }
    }

    public int getRowNumber(String cellValue, int column){
        int i=0;
        Iterator rowIterator = sheet.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
//            System.out.println(row.toString());

            Cell cell = row.getCell(column-1);
            if (cell!=null){
                if(cell.toString().equalsIgnoreCase(cellValue)){
                    return i+1;
                }
            }

            i = i+1;
        }
        return -1;
    }

    public Row getRow(String cellValue, int column){
        Iterator rowIterator = sheet.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
            Cell cell = row.getCell(column-1);
            if(cell!=null){
                if(cell.toString().equalsIgnoreCase(cellValue)){
                    return row;
                }
            }
        }
        return null;
    }

    public Row getRow(int row){
        int lastRowNo = sheet.getLastRowNum();
        if (row<=lastRowNo){
            return sheet.getRow(row-1);
        }else{
            return null;
        }
    }

    public Row getRow(String rowCellText){
        DataTable dts = new DataTable(file, workBook, sheet);
        int rowNum = dts.getRowNumber(rowCellText);
        return dts.getRow(rowNum);
    }

    public int getRowNumber(String tCID){
        int i=0;
        Iterator rowIterator = sheet.iterator();
        while(rowIterator.hasNext()){
            Row row = rowIterator.next();
            Cell cell = row.getCell(0);
            if(cell.toString().equalsIgnoreCase(tCID)){
                return i+1;
            }
            i = i+1;
        }
        return -1;
    }

    public int getColumnNumber(String cellValue, int rowNumber){
        int i=0;
        rowNumber = rowNumber-1;
        Iterator colIterator = sheet.getRow(rowNumber).cellIterator();
        while(colIterator.hasNext()){
            Cell cell = colIterator.next();
            if (cell.getStringCellValue().toString().equalsIgnoreCase(cellValue)){
                return i+1;
            }
            i = i+1;
        }
        return -1;
    }

    public Cell getColumn(String cellValue, int rowNumber){
        int i=0;
        rowNumber = rowNumber-1;
        Iterator colIterator = sheet.getRow(rowNumber).cellIterator();
        while(colIterator.hasNext()){
            Cell cell = colIterator.next();
            if (cell.getStringCellValue().toString().equalsIgnoreCase(cellValue)){
                return cell;
            }
            i = i+1;
        }
        return null;
    }

    public int getRowCount(){
        return sheet.getLastRowNum()+1;
    }

    public int getColumnCount(int row, String sheetName){
        DataTable dts = new DataTable(file, workBook, sheet);
        XSSFSheet sheet = (XSSFSheet) dts.setSheet(sheetName);
        return sheet.getRow(row-1).getLastCellNum();
    }

    public int getColumnCount(String sheetName){
        DataTable dts = new DataTable(file, workBook, sheet);
        XSSFSheet sheet = (XSSFSheet) dts.setSheet(sheetName);
        return sheet.getRow(0).getLastCellNum();
    }

    public int getColumnCount(int row){
//        DataTable dts = new DataTable(file, workBook, sheet);
        return sheet.getRow(row-1).getLastCellNum();
    }

    public int getColumnCount(){
//        DataTable dts = new DataTable(file, workBook, sheet);
        return sheet.getRow(0).getLastCellNum();
    }

    public int getSheetCount(){
        return workBook.getNumberOfSheets();
    }

    public int getSheetNumber(String sheetName){
        int i, shtCnt;
        shtCnt = getSheetCount();
        for (i=1; i<=shtCnt; i++){
            if(workBook.getSheetAt(i-1).getSheetName().toString().equalsIgnoreCase(sheetName)){
                return i;
            }
        }
        return -1;
    }

    public int getColumnNumber(String columnName){
        int i = 0;
        Row row = sheet.getRow(0);
        Iterator colIterator = row.cellIterator();
        while (colIterator.hasNext()){
            Cell cell = colIterator.next();
            if(cell.getStringCellValue().toString().equalsIgnoreCase(columnName)){
                return i+1;
            }
            i = i+1;
        }
        return -1;
    }

    public Row addNewRow(int rowNo) throws IOException{
        boolean op = false;
        Row row = sheet.createRow(rowNo-1);
        Cell cell = row.createCell(0);
        cell.setCellValue("New Row");
        if (row!=null){
            op = true;
        };

        /*if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();*/
        if (op){
            return row;
        }else{
            return null;
        }

    }

    public XSSFCell addNewColumn() throws IOException{
        boolean op=false;
        DataTable dts = new DataTable(file, workBook, sheet);
        int cc = dts.getColumnCount();
        XSSFCell cell = null;
        if (cc!=-1){
            cell = sheet.getRow(0).createCell(cc);
        }
        if(cell!=null){
            op = true;
        }
        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();

        if(op){
            return cell;
        }else{
            return null;
        }
    }

    public XSSFCell addNewColumn(int row) throws IOException{
        boolean op = false;
        DataTable dts = new DataTable(file, workBook, sheet);
        int cc = dts.getColumnCount();
        XSSFCell cell = null;
        if(cc==-1){
            cell = sheet.getRow(row).createCell(cc+1);
        }else{
            cell = sheet.getRow(row).createCell(cc);
        }
        if(cell!=null){
            op = true;
        }
        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
        if(op){
            return cell;
        }else{
            return null;
        }
    }

    public void setCellData(int row, int column, String cellValue) throws IOException{
//        inputStream = new FileInputStream(file)
        row = row-1;
        column = column-1;
        DataTable dts = new DataTable(file, workBook, sheet);
        Row actRow = sheet.getRow(row);
        if(actRow == null){
            System.out.println("Added New Row in the Sheet and Set Cell Value");
            actRow = dts.addNewRow(row+1);
        }

        Cell actCell = actRow.getCell(column);
//        if(actCell==null){
//            actCell = DataTableMethods.addNewColumn(row);
//        }
//
        if(actCell==null){
            try{
                actCell = actRow.createCell(column);
            }catch(Exception e){
                e.printStackTrace();
                System.out.println(column + "column doesn't exist. exiting method");
                return;
            }
        }

        actCell.setCellType(actCell.CELL_TYPE_STRING);
        actCell.setCellValue(cellValue);

        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
    }


    public boolean setCellData(int row, String column, String cellValue) throws IOException{
        row = row-1;
        DataTable dts = new DataTable(file, workBook, sheet);
        int colNum = dts.getColumnNumber(column);
        if (colNum!=-1){
            colNum = colNum-1;
        }else{
            System.out.println("Column : "+ column + " doesn't exist");
            return false;
        }


        Row actRow = sheet.getRow(row);
        if(actRow==null){
            System.out.println("Added New Row in the Sheet and Set Cell Value");
            actRow = dts.addNewRow(row);
        }

        Cell actCell = actRow.getCell(colNum);
//        if(actCell==null){
//            actCell = actRow.createCell(colNum);
//        }

        if(actCell==null){
            try{
                actCell=actRow.createCell(colNum);
            }catch(Exception e){
                e.printStackTrace();
                System.out.println(column + " column doesn't exist");
                return false;
            }
        }

        actCell.setCellType(Cell.CELL_TYPE_STRING);
        actCell.setCellValue(cellValue);

        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
        return true;
    }

    public void setCellData(String rowCellText, int column, int trgtColumn, String cellValue) throws IOException{
        DataTable dts = new DataTable(file, workBook, sheet);
        Row actRow = dts.getRow(rowCellText, column);

        if(actRow==null){
            System.out.println("No such Cell value exists : "+rowCellText + " in column : "+ column);
            return;
        }

        Cell actCell = actRow.getCell(column-1);
        if(actCell==null){
            System.out.println("No such Cell value exists : "+rowCellText + " in column : "+ column);
            return;
//            actCell = actRow.createCell(trgtColumn-1);
        }

        Cell trgtCell = actRow.getCell(trgtColumn-1);
        if(trgtCell==null){
            try{
                trgtCell = actRow.createCell(trgtColumn-1);
            }catch(Exception e){
                e.printStackTrace();
                System.out.println("column doesn't exist");
                return;
            }

//            trgtCell.setCellType(Cell.CELL_TYPE_STRING);
            trgtCell.setCellValue(cellValue);

        }else{
            trgtCell.setCellValue(cellValue);
        }

        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
//        return true;
    }

    public void setRowData(int row, Map rowData) throws IOException{
        DataTable dts = new DataTable(file, workBook, sheet);
        Row actRow = dts.getRow(row);
        Cell cell = null;
        Iterator entries = rowData.entrySet().iterator();
        while(entries.hasNext()){
            Entry thisEntry = (Entry)entries.next();
            Object key = thisEntry.getKey();
            Object value = thisEntry.getValue();
            int colNum = dts.getColumnNumber(key.toString());
            if(colNum!=-1){
                cell = actRow.getCell(colNum);
                if(cell==null){
                    cell = actRow.createCell(colNum);
                    cell.setCellValue(value.toString());
                }else{
                    cell.setCellValue(value.toString());
                }
//                actRow.getCell(colNum).setCellValue(value.toString());
//                actRow.getCell(colNum).setCellValue("Hello");
            }else{
                System.out.println("No such column exists in table");
            }
        }
        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
    }

    public void setRowData(String rowCellText, Map rowData) throws IOException{
        DataTable dts = new DataTable(file, workBook, sheet);
//        inputStream = new FileInputStream(file);
//        int rowNo = DataTableMethods.getRowNumber(rowCellText);
        Row actRow = dts.getRow(rowCellText);

        Cell cell = null;
        /*cell = actRow.getCell(0);

        cell = actRow.getCell(4);
        if(cell==null){
            cell = actRow.createCell(4);
            cell.setCellValue("India");
        }
        cell = actRow.getCell(5);*/

        Iterator> entries = rowData.entrySet().iterator();
        while(entries.hasNext()){
            Entry thisEntry = (Entry) entries.next();
            Object key = thisEntry.getKey();
            Object value = thisEntry.getValue();
            int colNum = dts.getColumnNumber(key.toString());
            if(colNum!=-1){
                dts.setCellData(rowCellText, 1, colNum, value.toString());
                cell = actRow.getCell(colNum);
                /*if(cell==null){
                    cell = actRow.createCell(colNum);
                    cell.setCellValue(value.toString());
                }else{
                    cell.setCellValue(value.toString());
                }*/
//                actRow.getCell(colNum).setCellValue(value.toString());
                cell=null;
            }else{
                System.out.println("No Column exists with name : "+ key.toString());
            }
        }
        if (inputStream!=null){
            inputStream.close();
        }
        outputStream = new FileOutputStream(file);
        workBook.write(outputStream);
        outputStream.flush();
        outputStream.close();
    }
}

A good threat is worth a thousand tests" - Boris Beizer

Solution for Microsoft Script debugger window invoke at end of Test execution

noreply@blogger.com (Baba Fakruddin) — Sun, 01 May 2016 17:34:00 +0000

UFT/QTP invokes Microsoft script debugger window and pass/holds at the lines in Test_Terminate method if we use Class constructor and destructor.

Execution from UFT/QTP - Test get stuck at lines in Test termination method in class.
Execution from ALM - Test get pass for a while (~3 mins) and disappears for next test execution kick off.

This is really annoying and impacts test performance too.

Solution: Use "On Error Resume Next" as first line in "Test_Terminate" method. It will never bother you by invoking Microsoft script debugger window.

"A good threat is worth a thousand tests" - Boris Beizer

Date format - conversions in vbscript

noreply@blogger.com (bfakruddin.d@gmail.com) — Sun, 31 Jan 2016 18:22:00 +0000

We have always challenges with date format conversions in QTP/UFT because vbscript supports minimal date functions. of course, we cause use dotnetfactory and few advanced concepts on date related formats/methods/conversions.

Here, a simple function which can be understandable to everyone who have basic idea of vbscript.

you can add your required condition in below function and utilize.

'/* Function Name: formatDate
'/* Function Description: function to convert input date format to user desired format and return with expected delimeter
'/* Function Inputs: inputDateAsSysFormat (send an input date with same system format), outputDateFormat (output, you required with format), delimeter (date, month, year which should separate with)
'/* Function Returns: expected outputDateFormat
Function formatDate(inputDateAsSysFormat, outputDateformat, delimeter)
    Dim actDate

    Select Case outputDateFormat
        Case "MDYYYY", "mdyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            yr = Year(actDate)
            dayy = Day(actDate)
            formatDate = mon&delimeter&dayy&delimeter&yr
        Case "DMYYYY", "dmyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            yr = Year(actDate)
            dayy = Day(actDate)
            formatDate = dayy&delimeter&mon&delimeter&yr
        Case "MDYY", "mdyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            yr = Year(actDate)
            dayy = Day(actDate)
            formatDate = mon&delimeter&dayy&delimeter&right(yr, 2)
        Case "DMYY", "dmyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            yr = Year(actDate)
            dayy = Day(actDate)
            formatDate = dayy&delimeter&mon&delimeter&right(yr, 2)
        Case "MMDDYY", "mmddyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            If len(mon)=1 Then
                mon = "0"&mon
            End If
            yr = Year(actDate)
            dayy = Day(actDate)
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = mon&delimeter&dayy&delimeter&right(yr, 2)
        Case "MMDDYYYY",  "mmddyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            If len(mon)=1 Then
                mon = "0"&mon
            End If
            yr = Year(actDate)
            dayy = Day(actDate)
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = mon&delimeter&dayy&delimeter&yr
        Case "MMMDDYYYY", "mmmddyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = mon&delimeter&dayy&delimeter&yr
        Case "MMMDYYYY", "mmmdyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=2 Then
                dayy = right(dayy, 1)
            End If
            formatDate = mon&delimeter&dayy&delimeter&yr
        Case "MMMDDYY", "mmmddyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            formatDate = mon&delimeter&dayy&delimeter&right(yr, 2)
        Case "MMMDYY", "mmmdyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=2 Then
                dayy = right(dayy, 1)
            End If
            formatDate = mon&delimeter&dayy&delimeter&right(yr, 2)
        Case "DDMMYYYY", "ddmmyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            If len(mon)=1 Then
                mon = "0"&mon
            End If
            yr = Year(actDate)
            dayy = Day(actDate)
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = dayy&delimeter&mon&delimeter&yr
        Case "DDMMYY",  "ddmmyy"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            If len(mon)=1 Then
                mon = "0"&mon
            End If
            yr = Year(actDate)
            dayy = Day(actDate)
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = dayy&delimeter&mon&delimeter&right(yr, 2)
        Case "DDMMMYY", "ddmmmyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = dayy&delimeter&mon&delimeter&right(yr,2)
        Case "DMMMYY", "dmmmyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=2 Then
                dayy = right(dayy, 1)
            End If
            formatDate = dayy&delimeter&mon&delimeter&right(yr, 2)
        Case "DDMMMYYYY", "ddmmmyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = dayy&delimeter&mon&delimeter&yr
        Case "DMMMYYYY", "dmmmyyyy"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=2 Then
                dayy = right(dayy, 1)
            End If
            formatDate = dayy&delimeter&mon&delimeter&yr
        Case "YYMMDD", "yymmdd"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            If len(mon)=1 Then
                mon = "0"&mon
            End If
            yr = Year(actDate)
            dayy = Day(actDate)
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = right(yr, 2)&delimeter&mon&delimeter&dayy
        Case "YYYYMMDD", "yyyymmdd"
            actDate = FormatDateTime(inputDateAsSysFormat,2)
            mon = Month(actDate)
            If len(mon)=1 Then
                mon = "0"&mon
            End If
            yr = Year(actDate)
            dayy = Day(actDate)
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = yr&delimeter&mon&delimeter&dayy
        Case "YYMMMDD", "yymmmdd"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = right(yr, 2)&delimeter&mon&delimeter&dayy
        Case "YYMMMD", "yymmmd"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=2 Then
                dayy = right(dayy, 1)
            End If
            formatDate = right(yr, 2)&delimeter&mon&delimeter&dayy
        Case "YYYYMMMDD", "yyyymmmdd"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=1 Then
                dayy = "0"&dayy
            End If
            formatDate = yr&delimeter&mon&delimeter&day
        Case "YYYYMMMD", "yyyymmmd"
            actDate = FormatDateTime(inputDateAsSysFormat,1)
            mon = left(Trim(Split(actDate, ",")(1)), 3)
            yr = Trim(split(actDate, ",")(2))
            dayy = Trim(Split(Trim(Split(actDate, ",")(1)), " ")(1))
            If len(dayy)=2 Then
                dayy = right(dayy, 1)
            End If
            formatDate = yr&delimeter&mon&delimeter&day
        Case else
            Print "output Format expected is not set in this function"
            formatDate = Null
    End Select
End Function

Share your comments if you've any. Thank you - Baba

"A good threat is worth a thousand tests" - Boris Beizer

UFT Automation - possible ways of connection with Oracle DB

noreply@blogger.com (bfakruddin.d@gmail.com) — Tue, 26 Jan 2016 17:24:00 +0000

Oracle DB will be connected client to server by below providers.

1. Microsoft OLE DB Provider for ODBC Drivers

2. Oracle Provider for OLE DB

3. Microsoft OLE DB Provider for Oracle

Process to make connection by above providers

1. Microsoft OLE DB Provider for ODBC Drivers

a. Invoke ODBC drivers (32 bit or 64 bit)

b. Add DSN with server details (DS Name, Description, TNS Service Name, User ID, <Test Connection with Password>)

c. Invoke Data link properties application

d. Select the provider “Microsoft OLE DB Provider for ODBC Drivers”, Click Next

e. Select DSN Name, UserName, Password and Test Connection (Connection must be successful as its success during DSN creation)

f. Once Test connection is successful, Connection string will be available in “Data link properties”. We can use same connection string for

Automation

Connection String looks like: “Provider=MSDASCIL1;Persist Security Info=,gr ID=;Data Source=;...”

2. Oracle Providerfor OLE DB

a. No need of creating DSN

b. Invoke Data Link properties application

c. Select the provider “Oracle Providerfor OLE DB”, Click on Next

d. Provide Data Source(tns name), User Name, Password and click on Test connection

e. Connection must be successful and connection string would be generated

Connection String looks like: “Provider=0raOLEDB.Oracle.1;Persist ççqr Info= jseUser ID=;Data Source=;...”

3. Microsoft OLE DB Provider for Oracle

a. No need of creating DSN

b. Invoke Data Link properties application

c. Selectthe provider “Microsoft OLE DB Providerfor Oracle”, Click on Next

d. Provide Server Name(tns name), User Name, Password. Click on Test connection

e. Connection must be successful and connection string would be generated

Connection String looks like: “Provider=MSDAORA.1;User ID=;Data Source=;Persist security Info=False;...”

"A good threat is worth a thousand tests" - Boris Beizer

Unlock the Locked ALM resource

noreply@blogger.com (bfakruddin.d@gmail.com) — Fri, 15 Jan 2016 18:36:00 +0000

How to unlock ALM resource locked by other user.

Usually, we face this situation when multiple people simultaneous work with different resources from ALM or forget to close the accessed resources in Automation tool or association of resources in tool are in utilization. Any of above can hinder your work, below script can unblock you to proceed ahead.

Dim QCUserName, QCCon, con, recset
QCUserName = "" 'ALM user which locked the user
Set QCCon = QCUtil.QCConnection
Set Con = QCCon.Command
Con.CommandText = "DELETE FROM LOCKS WHERE LK_USER = "&QCUserName&""
Set recset = Con.execute
Set QCCon = Nothing
Sec con = Nothing
set recset = Nothing
"A good threat is worth a thousand tests" - Boris Beizer

Automation Script to Restart Windows Virtual Machines (VMs) with PowerShell

noreply@blogger.com (bfakruddin.d@gmail.com) — Sat, 31 Oct 2015 13:07:00 +0000

Note: we must have current user in administrator

Follow below procedure to add user to admin group in VM
Computer --> Manage --> Local Users and Groups --> (User($username variable user in below ps script) must be added here, if not add)
VMs.txt – notepad contains all VMs (computer names) to be restarted in each line
Ps file contains below code

''*----------------------------------------- Power shell script as below ----------------------------------
$username = 'admin user of computer'
$password = 'admin user password'
$secstr = New-Object -TypeName System.Security.SecureString
$password.ToCharArray() | ForEach-Object {$secstr.AppendChar($_)}
$cred = new-object -typename System.Management.Automation.PSCredential -argumentlist $username, $secstr
restart-computer (get-content "Note pad which contain(.txt) suggested to maintain in Shared location") -credential $cred -force
''*---------------------------------------------------------------------------------------------------------------------

Above file will be executed by below vbs file

''*---------------------------------------- VB script File as below ------------------------------------------
Dim var
var = msgbox("Are you sure you want to restart all EXECUTION VMs",4,"Restart Vms by Powershell")
If var = 6 Then
   Dim objShell
   Set objShell = WScript.CreateObject("WScript.Shell")
   objShell.Run "powershell -file ""power shell script path (.ps1) suggested to maintain in shared location"""
   Set objshell = nothing
Else
   Msgbox "Selected NO to Restart all execution VMs", 64, "Input By User"
End If
''*-------------------------------------------------------------------------------------------------------------------------

"A good threat is worth a thousand tests" - Boris Beizer

Recording modes in UFT

noreply@blogger.com (baba fakruddin) — Sun, 07 Jun 2015 15:26:00 +0000

Recording modes in UFT

"A good threat is worth a thousand tests" - Boris Beizer

Recovery Scenarios in UFT

noreply@blogger.com (baba fakruddin) — Tue, 02 Jun 2015 17:15:00 +0000

Recovery Scenario File in UFT

"A good threat is worth a thousand tests" - Boris Beizer

Environment Variables in UFT

noreply@blogger.com (baba fakruddin) — Tue, 02 Jun 2015 16:48:00 +0000

Environment Variables in UFT

"A good threat is worth a thousand tests" - Boris Beizer

Parameterization in UFT

noreply@blogger.com (baba fakruddin) — Sun, 31 May 2015 05:48:00 +0000

How to parameterize a test and different ways to parameterize in UFT in this video

"A good threat is worth a thousand tests" - Boris Beizer

Actions in UFT / QTP

noreply@blogger.com (baba fakruddin) — Sat, 23 May 2015 16:32:00 +0000

Working with Actions in UFT

"A good threat is worth a thousand tests" - Boris Beizer

Database Checkpoint

noreply@blogger.com (baba fakruddin) — Thu, 21 May 2015 17:26:00 +0000

How to work with Database checkpoint in UFT / QTP

"A good threat is worth a thousand tests" - Boris Beizer

How to work with File Content Checkpoint in UFT / QTP

noreply@blogger.com (baba fakruddin) — Mon, 18 May 2015 16:37:00 +0000

How to work with File Content Checkpoint in UFT / QTP

"A good threat is worth a thousand tests" - Boris Beizer

How to work with Standard Checkpoints in UFT / QTP

noreply@blogger.com (Baba Fakruddin) — Mon, 18 May 2015 16:35:00 +0000

How to work with Standard Checkpoints in UFT / QTP

"A good threat is worth a thousand tests" - Boris Beizer

How to work with Text checkpoint in UFT / QTP

noreply@blogger.com (Baba Fakruddin) — Mon, 18 May 2015 16:33:00 +0000

How to work with Text checkpoint in UFT / QTP

"A good threat is worth a thousand tests" - Boris Beizer

UFT Test and Action iterations

noreply@blogger.com (Baba Fakruddin) — Mon, 11 May 2015 18:14:00 +0000

Test and Action iterations in UFT based on the rows in Global and Action sheets.

"A good threat is worth a thousand tests" - Boris Beizer