Getting started with SQLRules Services

SQLRules is a REST API and the associated services and applications to evaluate the coverage of SQL database queries. Coverage criteria are implemented in a set of rules, that when evaluated with respect to a given database determine the coverage of the database with respect to the query. Two criteria are implemented:

SQLFpc - Full Predicate Coverage rules for SQL: Based on Modified Condition Decision Coverage (MCDC) for SQL. Each rule is an SQL statement that is covered if the execution against the database returns at least one row.
See article Full predicate coverage for testing SQL database queries. Software Testing, Verification and Reliability, 20 (3) 237-288, September 2010.
SQLMutation - Mutants for SQL: It is a mutation system for database queries. Each rule is a mutant of the original SQL query. The mutant is dead (i.e. the rule is covered) if the execution against the database returns the same rows than the original query.
See article Mutating Database Queries, Information and Software Technology, 49(4) 398-417, 2007.

Check the below links to the API, documentation and applications:

REST API specification: To visualize the OpenApi specification and interact with the API resources (swagger-ui).
Test Data Rules components in GitHub (TdRules): To generate the rules and the database schema from an application (available on Java and .NET). NOTE: The name TdRules is progressively replacing SQLRules to enable generation of rules for other data stores than relational.
Complementary applications:
- SQLRules web client: To rapidly generate the rules from a web browser (see the documentation).
- SQLRules standalone desktop application: Java application to generate and evaluate the rules for multiple queries against your local database.
- XDBSchema standalone desktop application: Java application to generate the database schema required by SQLRules from your local database.
Release Notes
Terms of Use

Deprecated versions: