SQL Rules
Vexdata provides ability to write test cases in English which are converted to SQL.
Write the test case in English in the AI Prompt section and click on Generate SQL.
Ensure that all the tables required for this test case are selected in the source section. This is necessary to generate SQL from English.
Below are examples to guide you in creating effective test cases for both single-table and multi-table test scripts.
Sample Data
Users Table
Orders Table
English Inputs and Corresponding SQL
Validate that no users are underage
Rule: Ensure that all users are at least 18 years old in users table
SQL:
Result :
Validate that no users are beyond retirement age
Rule: Check that no user is older than 30 in Users table.
SQL:
Result: Fail
Failed Record Count = 1
Validate that all users have a positive credit limit
Rule: Confirm that every user has a credit limit greater than zero in users table.
SQL:
Result: Pass
Ensure total orders do not exceed credit limits
Rule: Validate that the sum of order amounts for each user in Orders table does not exceed their credit limit in Users table.
SQL:
Result: Pass
Check for active users with no orders.
Rule: Identify users in users table who have not placed any orders.
SQL:
These examples provide a clear demonstration of how English test case inputs can be translated into SQL queries to validate data across different scenarios in a database system.
Do not include a LIMIT clause in your SQL queries. The engine automatically applies a LIMIT operation to retrieve sample data. For failure counts, the full query is executed as a subquery to accurately calculate the number of failed records.
Last updated