While working with Selenium automation testing, we use different 3rd party frameworks (TestNG, Junit, MBunit, Nunit) in combination with Java or .NET to report the result at the end of the test execution or we use our own dashboard/html kind of reports, While browsing different ways of reporting, got web links of ExtentReports, most of…
For initial understanding on database and SQL queries, refer MySQL Basics To automate database testing, we will use selenium with java language. JDBC (Java DataBase Connectivity) is an API (using Java language) to connect and play with database with SQL queries. In this post, let’s understand how we can connect with database using Java, and how…
Database testing: validate the front end data with the database. Let’s take an example of a e-commerce application, user booked a mobile phone by entering phone model, shipping / billing address, and submits, Data stored into database. Here we need to validate what the user enters data, should save exactly same to the database, then…
MySQL is considered to be most popular open source database, For more information regarding versions and features, please refer http://dev.mysql.com/ Topics Download and Install. Initial Setup Creating database tables Adding/updating/deleting data to tables Download and install To download MySQL database for windows, Navigate to this link http://dev.mysql.com/downloads/ click on MySQL Community Server (GPL) click on MSI…
Firefox profile is basically the personal settings of the firefox browser. Firefox profile contains information like your homepage, bookmarks, browser settings, history, saved passwords, download directory etc. Profile is basically a specific folder stored locally in your hard drive other than your firefox installation folder. We will see how we can set Firefox profile manually…
In this post, we will see how to handle / automate drop down webelement in Selenium and Java. Use cases would be – select an option from the drop down Fetch all the options. Fetch the selected option A dropdown element on browser looks like below – The HTML associated with select or dropdown is…
Every browser application has it’s own delay in loading the elements when we open a web application / navigate from one page to another / perform some action. Loading depends on different criteria like internet bandwidth, technology used in the application, server capacity, no of users accessing the browser app etc… While executing tests in…
InvocationCount OutPut: Thread ID: 1Thread ID: 1Thread ID: 1Thread ID: 1Thread ID: 1 Above method ran 5 times, a single thread will be assigned to run the method one by one.. ThreadPoolSize OutPut [ThreadUtil] Starting executor timeOut:0ms workers:5 threadPoolSize:3Thread ID: 11Thread ID: 12Thread ID: 13Thread ID: 12Thread ID: 11 Above method ran 5 times, but…
alwaysRun is a testNG attribute which makes a test method run always even if it’s dependent method is not run… let’s see the code implementation public class AlwaysRun { WebDriver driver; @Test public void test1() { driver = new FirefoxDriver(); driver.get(“http:qavalidation.com”); Assert.assertTrue(driver.getTitle().contains(“Testing”)); } @Test(dependsOnMethods = {“test1”}, alwaysRun=true) public void test2() { driver.findElement(By.linkText(“Selenium Tutorial!”)).click(); } }…