FAQ — For SDET And QA

Here is the first series of very general problems we face while we are developing a software framework…

The purpose of these posts is to help just by sharing…

The content will develop over time and I hope we can keep it short as much as possible while adding new findings each time.

Ready? Here we go…

Passing multiple parameters at once in cucumber

It’s also possible to pass multiple options at once. This is how it can be done

mvn verify -Dcucumber.options=” — tags @SomeThing” -Dcucumber.options=” — tags @SomeThing” -Dcucumber.options=” — tags @SomeThing”

OR

mvn verify -Dcucumber.options=” — tags @SomeThing,@Something,@Something” The comma represents a logical or, and specifying multiple — tags arguments.

How to solve PIKIX Error?

A nightmare once you see the below error, just run the below command on the terminal to see the results OR you can go with the CERT solution…

sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider .certpath.SunCertPathBuilderException:

mvn clean install -Dmaven.wagon.http.ssl.insecure=true -Dmaven.wagon.http.ssl.allowall=true -Dmaven.wagon.http.ssl.ignore.validity.dates=true

OR.

mvn install -Dmaven.wagon.http.ssl.insecure=true -Dmaven.wagon.http.ssl.allowall=true -Dmaven.wagon.http.ssl.ignore.validity.dates=true

JUnit Assertions

How to use JUnit assertions in an efficient way?

import org.junit.Assert;
Assert.<methods come in>
import static org.junit.Assert.*;
assert<methods come in>

How to create a folder on the cmd command line.

1. Open a terminal and navigate to the folder which contains your Visual Studio projects.
2. Run the following command: touch .gitignore. You do not see it, but a hidden .gitignore file was just created.
3. Run the following command: vim .gitignore. This opens the empty file with a text editor inside the terminal.
4. Paste the contents into the opened vim text editor. If you scroll at the bottom of the text editor you now see the — INSERT — a text which means that the content is ready to be saved.
5. To save the file press ESC, type :wq and finally press ENTER. What you just saved is a complete .gitignore file with a blacklist

How to make the files visible after creating?

The hidden files and folders will remain in view until you press Cmd + Shift + . (dot) a second time.

SSL Handshake Error on API

Use the below single line of the code at top of the Rest API code.

RestAssured.useRelaxedHTTPSValidation();

The response is pulled like: response.getBody().asString(); But the the following line may not work: response.body().path(“request”);

Redirection on API

given().redirects().follow(false/true).etc

How to find the count on SQL

You can put the below sample on your SQL Developer to run for the count:

SELECT count(*) as totalCount (-open a parentheses — your original query -close the parentheses)

SQL Connection

It’s look like, the Oracle JDBC driver can not work with multiple service names. Use this:

entryabcd = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = abcd.dk.xyz.com)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = abcd) ) ) abcd.world, abcd.dk.xyz.com = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = abcd.dk.xyz.com)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = abcd) ) )