Category: Automation Framework

Posted on

What is an Application server

What is an Application server

 An Application server controls the business logic. Separating business logic from web server and adding to application server will give more reusability for this logic across different applications. This is more flexible design.

A web transaction using app server will be like this as below,

Browser (click operation to display some results on a grid> ==> Request goes to web server (Apache HTTP server) ==> Application server (Tomcat server) ==> Database

Or

Browser (click operation to display some results on a grid> ==> Request goes to web server (Apache HTTP server) ==> Application server (Tomcat server) ==> Web service ==> Third party Database

Note: Web server related topic – please click on  What is Web server?

Posted on

How to Enable/Disable Developer mode in Android phones

How to Enable/Disable Developer mode in Android phones

1.Go to Android device’s “Settings”,
2.Then go to “General” settings- please verify some phones may vary with flow, I am referring LG G2 phone’s navigation flow.
3.Scroll down to see “About Phone”
4.In About phone, single tap on “Software info” you would see “Build number”
5.Then, tap on 7 times on “Build number”to enable Developer mode or options.

Note: if the phone is already in Developer mode, then you can directly navigate to
Settings ==> About Phone ==> Developer options ==> enable/disable check box of USB Debugging.

Posted on

Performance test analysis.

Performance test analysis.

What is Performance test analysis?

Performance test analysis can be done real time script execution or post execution

 Real time script execution analysis

1)      Performance Engineer needs a coordination  with other teams like Database team, app server team, etc  to monitor real time performance on Database server, Application server

2)      Database and app server team can let Performance Engineer know the performance results on these servers like resource utilization, fail over server works / load balancing works fine etc.

Post script execution analysis

1)      Verification on Vuser metrics, Vuser errors,

2)      Verification Transactions graphs for TPS, response time, hits per second etc.

For additional details please click on click link https://shalimatech.com/load-testing-vs-performance-testing-vs-stress-testing/

Posted on

vlookup function in excel for column value matching

vlookup function in excel for column value matching

Row# 2 and column A showed the match results for Column B Row# 1 as you can see value 1 is matched against Column C records.

Row# 4 and column A showed no match results for Column B Row# 4 as you can see value 5A is not matched against Column C records.

so the code sample you need to use for the record range of 11 rows, as below

=IF(ISNA(VLOOKUP(B2, $C$2:$C$11, 2, FALSE )), “MISSING”, “MATCHED!”)

=IF(ISNA(VLOOKUP(B3, $C$2:$C$11, 2, FALSE )), “MISSING”, “MATCHED!”)

etc

VLOOKUP

 

 

Posted on

Performance testing best practices and activities.

Performance testing best practices and activities.

  1. As first step, Performance Engineer needs to learn the requirements, performance expectations & system architecture.

Note: To learn the performance requirements & expectations, SME (Subject matter expert ) or production user can help. This information will help to define performance goals and SLAs

  1. Then develop best matching performance test scenarios, approach, define goals (SLAs) & sign off test plan.

Note 1: To identify the right performance test scenarios, SME can give some feedback on about the current performance issues in production / live application that he/she is facing.

Note 2:  You can refer another blog of mine on different types of performance scenarios – click link load testing vs performance testing vs stress testing

  1. Now Performance Engineer can developer V– USER scripts and execute the scripts in Controller to generate performance analysis results

Note 1: Apart from delivering performance analysis results, Performance Engineer  can coordinate with other team to monitor real time performance on Database server, Application server and also make sure load balancing is working fine while stress testing.

Some of the e.g. when performance testing is needed

  1. for Database upgrade,
  2. Application upgrade,
  3. Or if user complains that application performance is bad – like page response is not meeting his/her expectations.
Posted on

Robot framework and Selenium2Library

Robot framework and Selenium2Library

Selenium2Library is library created for web testing. Robot framework utilizes this framework

Robot framework is mainly used for acceptance testing and it supports different browsers like IE, Chrome, Firefox etc.

Robot framework can be hosted in Github and script execution can be managed using Jenkins. I will be writing a detailed step by step documentation on Robot framework web testing  implementation.

Posted on

Jenkins vs GitHub

Jenkins vs GitHub

Jenkins allow continuous integration which helps developers or Automation testers to integrate code into a shared repository. It acts an open source automation server for test automation projects. Jenkins offers lots of plugins to integrate various tools.

GitHub is a web-based hosting service supporting distributed version control of codes. for e.g. if someone already registered a domain for a website in GoDaddy or similar domain services site but looking for a free hosting service, Github can be used to store code. Go daddy and Github should be linked to make this happen.

Posted on

What is Structured Query Language(SQL)

What is Structured Query Language(SQL)

SQL is Structured Query Language. e.g.MySQL and Microsoft SQL Server both are relational database management systems)
Data Definition L (DDL) – Create, Alter, Drop
Data Manipulation Language (DML)- Select , Insert, Update, Delete
Data Control Language(DCL) – Grant, Revoke