Selenium Reads & QA Tools Post

Good Reads

• Ten Steps of Selenium Automation Framework
• Selenium Automation Framework Example
• PRACTICE AUTOMATION ON DEMO LIVE SITE - ONLINESTORE.TOOLSQA.COM
• Selenium Interview Questions Part-1
• Selenium Interview Questions Part-2
• Updated the Getting Started With Selenium WebDriver free course
• Thoughts on a Selenium interactive exploratory test and debug tool
• Automation Frameworks With Example (Selenium)
• Design Patterns in Automation
• TestNG; accessing a Custom Annotation
• EvilTester - Testing Videos
• Selenium Training Session Videos
• Java Parallel Runs - BrowserStack - Good Tutorials
• Browser Stack Tutorials - Screenshots
• How to run parallel tests with Selenium WebDriver and TestNG
• Learn the Basics of Selenium at uTest University
• Selenium Automation Hybrid Framework
• LOGGING SELENIUM 2 EVENTS IN TWIST
• A few concepts and misconceptions about Selenium
• PageObject Pattern - Why, How and More
• PAGE OBJECT PATTERN
• Page Object Pattern | Selenium - Part I
• Page Object Pattern | Selenium - Part II
• Selenium Best Practices
• Through the eyes of sonar: Exception handling
• Java Selenium WebDriver example: how to create custom locators dynamically
• Http profiler using Selenium to track omniture calls
• Selenium WebDriver : Handling mouseover events
• How to capture popup windows using selenium.
• Simulating shopper abandonment in JMeter
• Selenium - WebDriver common errors
• Selenium extensive learning list
• Testing framework using Maven, TestNG and Webdriver
• How to select which TestNG suites to run in Maven Surefire plugin

PhantomJS

• Performance testing with PhantomJS

Tools / Useful Scripts

• Crawling all SQL Server tables and columns for a specific value

Fitnesse

• Parallel execution of Fitnesse tests

Sikuli

• HOW TO INTEGRATE SIKULI SCRIPT WITH SELENIUM WEBDRIVER
• Sikuli + webdriver examples with java programming

Mobile Automation

• Mobile Test Automation – a few questions to ask
• iOS Automation with Appium & Selenium
• Appium Test Automation tool for Native iOS Applications

Jmeter

• Advanced Load Testing with Apache JMeter
• Siege for Windows is a HTPP Load Testing and Benchmarking Utility
• ANALYTICS WITH JMETER
• LoadStorm v2.0 Now with Transaction Response Timing – What does this mean for you?
• Web Performance of Ecommerce Applications

Windows Testing

• White: Windows Desktop Applications Automation

More Tools

• Awaitility is a small Java-based DSL for synchronizing asynchronous operations
• DBFit

Happy Learning!!!

Coding Exercises

Two Interesting coding questions. Printing X using '*'. I remember C graphics programming to print in location. I tried it in link jdoodle

Update - Below code I got feedback on variables, return values. Found online code formatter link. C Program coding lines (link)..This post needs to be updated :)

The output looked like

This still need some tuning :) to arrive at X

Next is reversing a string in using recursion. Stackoverflow has a great example link

X i still need to re-look it later.

Happy Learning!!

Testing, Testing !! Learn both Coding & Testing

I have a strong opinion on automation and its benefits. Automation and Functional testing compliment each other. Majority of automation framework I have come across are for UI Automation, ETL, Web Services etc.

More than Automation I have observed below areas addressed very well with custom tools / custom coding efforts.

• Environment set-up / clean up tools
• DB meta data set-up scripts, Extensive SQL Queries for Analysing and validate data 
• Using Tools - SOAP UI / Custom test code for quick testing
• Debugging / checking DB states, APP server logs

These efforts will help to reduce test cycle time, good insight into application, certain level of white box testing will always boost your confidence on technical implementation. Automation evolves from these tools / scripts. Gradually these efforts will provide clarity toward building a good automation framework.

I don't recommend complete black box testing / white box testing. It has to be best of both the worlds. A good amount DEV-Test-DB understanding will always help to know the application better in terms of functionality / performance / certain extent white box testing.

By having a rotational setup. QA can code certain modules for certain releases, Dev can take up some automation / minimum testing to understand the application / domain better. Every function need to compliment each other. Cross functional skills and working experience is always a plus.

More Reads

• Has automated UI regression testing helped you in finding critical defects in system?
• Manual tester wanting to get into automation
• Stop Writing Automation
• Testing Trends…or not?

Happy Reading!!!

Learning SQLMap

SQLMap - Automatic SQL injection and database takeover tool. The tool is easy to use and execute tests. This post SQLMAP TUTORIAL FOR WINDOW 7 provided test sites to run tests using SQLMap

Steps are 

1. Python already installed (On my Win7 had python already installed)

2. Execute the tests against the test site provided (DB tables, results will be listed)

3. Listing DB's

4. Listing Tables

Many thanks for darkassassinscybercrew for sharing the test sites.

More Read - GUI for SQLMAP is available in link
Automated Security Testing of web applications using OWASP Zed Attack Proxy

Database protection Techniques : a different prespective
Introduction To SQLmap And Firewall Bypassing
Website Hacking - SQL Injections - Sqlmap Introduction

Happy Learning!!!

java de-compiler

Yet another short post from today's learning from Ambuj. Java Decompiler

1. Download Java Decompiler from link
2. Extract and run the exe
3. Drag and Drop the class file to see the source code

Actually, This article (Is Amazon hacking our apps? Or doing us all a security favour?) prompted to try out java decompiler. Working with Ambuj made it easier to learn in few steps.

More Reads - JProfiler (Similar to SQL profiler capture events running in your JVM)
JProfiler - Good Demo

Happy Learning!!

QA Free tools - Bug Tracking / Password Management

Redmine - Bug / Issues Tracking

This post is about using redmine for bugs / issues tracking. I was introduced to this tool by my colleague Ambuj. It was pretty easy working with the tool. This tool was pretty useful in terms of logging bugs / issues / reports / bug updates / notifications.

Verdict - Try it, Very Useful.

Password management tool - Password Dragon. This will be a good option for DBAs / SysAdmins to store password safely.

More Free Tools
Top 15 Free Tools Which Make Tester’s Life Easier
Jagger is a free application suite for continuous performance testing

More Reads

• Installing Redmine on windows
• Comparison of web-based bug tracking tools
• What functionality does JIRA provide which is not available in Bugzilla?
• Top 10 Open Source Bug Tracking System
• Spoonium Online Selenium Grid

Happy Learning!!!

Security Testing - Learning Resources

Next reading list for Security Testing

• Pentesterlab bootcamp tutorials
• Game Over: Damn Vulnerable Web Application
• SQL Injection - Mozilla Security Learning Center
• Virtual Security Lab Setup - OWASP Broken Web Apps, Webgoat, & ZAP
• SQL Injection
• Databases—Vulnerabilities, Costs of Data Breaches and Countermeasures

Apps to perform live security Tests

• Damn Vulnerable Web Application
• OWASP Broken Web Applications Project
• Pentesterlab exercises
• OWASP Broken Web Applications VM Video Walkthru

More Reads

• Deep End Research
• .NET Penetration Testing Cheat Sheet
• Bruteforce vs Denial of Service
• Stackexchange Security is good start for security related questions
• Video: Building Custom Android Malware for Penetration Testing
• Intercepting SSL traffic using WebScarab

Happy Learning!!!

Test Automation Framework Series

[Previous Post - Test Automation Framework Using Selenium - Part IV]

This is in continuation with Test Automation Framework Series. After 3 years I found step-by-step framework examples. As you see this reflects my stack overflow answer (Build first, Iterate and Improve). Rest of cleartrip test series / code improvements are covered in ClearTrip Tests (Very Good Walk through)

Project 1 - Selenium examples
Project 2 - ClearTrip Test. Downloaded and compiled the project. This list of 13 tests are great examples

I had also posted cleartrip automation assignment  earlier. (My incremental learning series :))

Another interesting post in similar lines - Evolution of Software Engineer. In the similar fashion Automation Framework Exercise evolves based on continuous feedback

Very Interesting slide from presentation in link. Similar to my learning path :)

Github Test Automation projects
Test Automation Framework (TAF)
Git Code

Selenium Test Framework
Selenium Test Framework

Happy Learning!!!

Free Tool - Managing System, Environment Variables using Rapid Environment Editor

While managing servers / different environments we keep upgrading environmental variables, custom paths. Rapid Environment Editor tool is very useful for managing this job. It highlights invalid paths to quickly fix them.

While setting up eclipse, this environment issues pop up, this editor was useful to fix issues.

Happy Learning!!!

Interview Question - Maximum Palindrome Substring in given String

Some candidates write logic, working code, impressive ideas. This question 'Maximum Palindrome Substring in given String' I got a good answer during one of interview discussions.

I tried the same in codepad link. This is C++ code. The solution code is

int main()

{

    char inputname[50] = "aaabbaa";

    char match[50];

    char temp[50];

    char revtemp[50];

    int length = 0;

    int currentpalindromelength = 0;

    int maxpalindromelength = 0;

    int palstart=0, palend=0;

    int i,j;

    for(i = 0;inputname[i] !='\0'; i++)

    {

        length++;

    }

    printf("length is %d\n", length);

    for(int ipos = 0; ipos  < length; ipos++)

    {

        for(j = ipos+1; j < length; j++)

        {

            int startpos=0;

            for(int k = ipos; k < j; k++)

            {

                temp[startpos++] = inputname[k];

            }

            temp[startpos] = '\0';

            printf("string to compare %s \n", temp);

            startpos=0;

            for(int z = j-1; z >=0; z--)

            {

                revtemp[startpos++] = inputname[z];

            }

            revtemp[startpos] = '\0';

            printf("reverse string to compare %s\n", revtemp);

            int result = strcmp(temp, revtemp);

            if (result == 0)

            {

                    printf("Both strings are equal \n");

                    currentpalindromelength = 0;

                    for(int iCur = 0;temp[iCur] !='\0'; iCur++)

                    {

                        currentpalindromelength ++;

                    }

                    if(currentpalindromelength > maxpalindromelength)

                    {

                        maxpalindromelength = currentpalindromelength;

                        palstart = ipos;

                        palend =j;

                    }

            }

            else

            {

                  printf("\nBoth strings are not equal \n");

           }

        }

    }

    printf("max palindrome length is %d",maxpalindromelength);

    printf("start pos is %d\n",palstart);

    printf("end pos is %d\n",palend);

    for(int k = palstart; k < palend; k++)

    {

         printf("%c",inputname[k]);

    }

    printf("\n");

    return 0;

}

This worked for multiple cases. codepad is very good!.

Happy Coding!!!

Frequently Used Scripts & Notes

TSQL Reusable scripts - bookmarking the same

Tip #1. What is the command to truncate a SQL Server log file?

Tip #2. Settings to Capture Deadlock Trace in SQL Server Logs
DBCC TRACEON (1204, -1)
DBCC TRACEON (1222, -1)

Tip #3. Checking SQL Server Version

select SERVERPROPERTY('productversion'),SERVERPROPERTY('productlevel'),SERVERPROPERTY('edition')

Tip #4. Creating a custom firefox template

Step 1. Windows -> Run specify below command
firefox.exe -ProfileManager -no-remote

Step 2. Create custom profile

Step 3. Command to run selenium using template
Example:  java -jar selenium-server.jar -firefoxProfileTemplate “<Selenium Profile Directory>”

Usage:  java -jar selenium-server.jar -firefoxProfileTemplate C:\Users\Administrator\AppData\Roaming\Mozilla\Firefox\Profiles\sd88nd1n.FRProfile

Step 4. With Logs captured below is modified steps

Usage: java -jar C:\\SeleniumServer\\selenium-server-standalone-2.25.0.jar -port 5555 > C:\\ReportLogs\\\SeleniumServerStatus.txt 2>&1 -firefoxProfileTemplate "C:\\Users\\Administrator\\AppData\Roaming\\Mozilla\\Firefox\\Profiles\\ku6gbc8j.FRProfile"

References Link1


Happy Learning!!!