Azure, RPA, AI, Selenium, Angular, API
Selenium IDE. How it is implemented?
Selenium IDE is an integrated development environment for Selenium tests.
It is a plugin or extension to Firefox browser. It’s very easy to add and implement. It is for basic level of application test users.
Commands used in Selenium is called selenese
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?
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.
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/
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
Performance testing best practices and activities.
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
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
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
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.
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.
What is Foreign keys in database
Foreign keys are used in database to reference unique columns in another table.
Foreign keys connected with the concept of referential integrity.
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