by Jerome Josephraj
Share
Using NoCodeBDD, you can easily assert values across multiple rows of a SQL result. For an example, let’s look at the following table, which is a result of a SQL query. If your requirement is to select all users with Age 32 and to assert the First Name and Last Name from both rows, then it can be easily done in NoCodeBDD by selecting Multiple Row option.
| FirstName | LastName | Age | EmployeeID | UserId | |
| Row 1 | Joe | Doe | 32 | EMP0001 | U0001 |
| Row 2 | Joe | Blog | 32 | EMP0002 | U0002 |
| Row 3 | Harry | Williams | 30 | EMP0003 | U0003 |
| Row 4 | John | Kerry | 37 | EMP0003 | U0004 |
“How to test DB results without writing any code” blog post shows how a SQL can be added and a Single Row can be asserted. To Assert multiple row, simply select Multiple Row option and enter the row number in which the expected value is, enter the column name, condition and its value that you want to assert. That’s it.
Once you have provided all required information, NoCodeBDD will do all the hard work for you and automate the code in the background. All you have to do is, press the Run menu and run the scenario you just added. You can also view the results in the audit page. This is shown in the GIF below
As you can see, asserting a single row or a multiple rows using NoCodeBDD is extremely easy and all it takes is minutes compared to hours using a scripted automation solution.
STAY IN THE LOOP
Subscribe to our free newsletter.
Rolling out BDD in a project requires careful planning and a well-structured process. As a tech consultant on a large project, I had to make several changes to their BDD process and automation suite implementation. Some changes were straightforward, while others proved more challenging. If you’re considering implementing BDD in […]
10 Tips for Writing Effective BDD Scenarios When rolling out BDD having a clear and concise scenario writing is a vital aspect of successful BDD adoption. This blog post will provide you with 10 tips to enhance your BDD scenario writing, making it easy to understand, maintainable, and efficient. 1. […]
It will be difficult to automate testing if you don’t consider it when creating your web application. It will be difficult, regardless of whether you are a code wizard or a no-code ninja. Here are some crucial ideas to have in mind as you develop your app to make testing a […]
Many websites now require two-factor authentication (2FA) as an extra security measure beyond a standard username and password. When a user enables 2FA for their account, they will receive a code (OTP) via their phone or email after successfully logging in with their username and password. This code must be […]
