Thursday, April 7, 2016

Java and Appium Installation



JAVA AND APPIUM INSTALLATION


Hi guyes, 
   i'm sharing the detail steps to install and configure JAVA and appium.

Step1:  go to https://developer.android.com/sdk/index.html


Step2 : Download Android studio and Run exe file

Step 3: Post installation copy SDK folder from the present location.
      C:/Users/user/AppData/Local/android/SDK

Note:  AppData folder in invisible mode, enable invisible folder option





Note: create Appium folder in c drive

Step 4: Copy sdk from the path ( C:/Users/user/AppData/Local/android/SDK) and placed in C:/Appium folder. 



Step 5:  Download JDK ( Java)  from the below given url

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html



 Step 6: Set System variables path both JAVA and Android.
  
Setup environment variable-> go to system main drive-> right click and select properties->Click on advanced system settings ->go to Advanced ->click on Environment variable->


Click on New button under Environment variable – Set JAVA Path 


Create variable called JAVA_HOME and paste the value as ‘JAVA PATH’ and click on ok button.



Set another below  path in System variable -> under path variable 
C:\Program Files\Java\jdk1.8.0_45\bin 


Step 7: Set Android path

Create variable called ANDROID_HOME and

 paste the value as ‘C:\Appium\sdk’ and click on ok button.




Also Add below paths in the Path variable under system variable as  shown image in the next

Add below paths in Path Varibales

C:\Appium\sdk\tools

C:\Appium\sdk\platform-tools




Step 8:  Install Eclipse IDEE

Download "Eclipse IDE for Java Developers“
http://www.eclipse.org/downloads/

Note: Make sure select Eclipse ID


Download Zip file and extract in C drive.



 Step 9: go to eclipse folder -> and click on eclipse.exe 
Step10: put the following path (any path)as workspace -> Click on OK button


 Step 11: Create Eclipse project
Right click on Eclipse -> Select New -> Other-> Select JAVA Project-> Click Next 



Enter Project Name as ‘TestJava’ and click Finish -> Select NO.



Install ADT pulgIn

 Step 12: Install ADT Plugin into eclipse following instructions from below ink.

   http://developer.android.com/sdk/installing/installing-adt.html

Follow the instructions.

Copy the URL shown in circle

Step 13: Eclipse Help-> Install New Software

 Step14: Select Developer tools -> click on Next 

Step 15: click on Next 

Step 16: Click on Finish



Restart Eclipse -> Upon restarting ->select below location and click OK, 


Step 17: Configure ADT Plugin:
Windows -> Perspective -> customize perspective


Make sure select Android SDK and AVD Manager in both locations shown below

Step18:
Create AVD Virtual devise.

Click on below icon in Eclipse.


Configure AVD  emulator



Step18:  Download .net framework 4.5 to support from the below URL

https://www.microsoft.com/en-us/download/details.aspx?id=30653


Download and Install the framework.

Step 19:     Appium Installation

   download the appium from the given url

 http://appium.io/downloads.html


Download the AppiumForWindows.zip file  



Click on Appium –installer-> extract in the Appium C:\Appium\Appium folder


Click on Appium-installer -> click on appium installer.exe

Step 20: Appium Java client JAR and Selenium Jar download from Maven

go to  http://mvnrepository.com/artifact/io.appium/java-client/2.1.0
and download Java-client jar file.

Step 21: Download selenium Java from the below path.

http://docs.seleniumhq.org/download/

Note: Always consider Latest Version



Step 22: Download Zip file and extract in C drive.


C:\selenium-2.47.0\


Step33:   Create Java project and configure the selenium and java client jar files.


Wednesday, April 6, 2016

SOAPUI Database connection



SOAP UI TOOL DATABASE CONNECTION



  Hi Guys,
        I'm providing the details below to connect the database through the SOAPUI tool.

        1.Right click on the test case -> Insert Step -> JDBC request

        2. Enter JDBC Request -->; Click OK



3.Create name for JDBC connection -> Enter JDBC connection -> 
Click OK                                                               


4. In Database configuration window

5. SelectMSSQL Driver from drop down -> Click OK


6. Enter user name,password,database name -> Check for test connection -> Click OK

Connection string-(jdbc:sqlserver://127.0.0.1:1433;databaseName=MYTEST;user=test; password=PASS_VALUE)

*MyTEST is the database name 
* user is the username
* password is the password for accessing database.
*  1433 is port name


7. Write sql query    ->   run the query  -> check the response










Sample Projects to Practise



  I'm providing sample projects details which would help in practicing the automation stuff

              INSURANCE PROJECT      - http://demo.borland.com/InsuranceWebExtJS/

Mobile Automation - Appium

Friday, April 1, 2016

Data Driven Testing in SOAP UI Pro


What is Data driven:

 Running the same piece code for multiple inputs.

We need to verify that our system is taking all set of combinations which it expected to support.
To pass multiple data to the application at runtime, we need to parameterize our test scripts.

This concept which we achieve by parameterization is called Data Driven Testing .



1 . Create Test data in excel sheet.
* below test data is for Testing the webservice for Celsius to Farheit conversion



2. Once Test Step is created ( pls refer the previous sessions)

  Right click on step -> Insert Step -> DataSource





3. Enter Source Name -> Click Ok button


4.  Click on add property button shown below


5. Enter property name as  Input shown below



6. Add similar property as Expresult

7.  Select data source as Excel and provide the testdata input path shown below.

Data source drop down -> Select Excel (Or data source Used) -> Browse Source path(Saved location) ->  Start at Cell’ = Enter B2 (Excel Cell name, where input data exists) -> Click on execute


8. On Click execute -> Enter number Of rows from source


9.  Adding datasource loop

Right click on the test case -> Insert Step -> Data Source Loop 


10. Double click DataSourceLoop-> Select DataSource Step
-> and select Target Step as shown below -> Click ok


upon clicking the OK button -> test case would look like below step


11.  Get the data from test input

Open the CelesiusToFarenheit Test step - Place the cursor at input (?) (?


12. Place cursor Input(?) in Request editor, Right Click -> Get Data ->TestSuite-> select TestCase (in which source is located).



13. Double Click on test Case ->  Click on Execute button    
To view execution details -> Click on Transaction Log