Getting started with SQLRules

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 kind of coverage rules are generated:

• 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

• SQLRules API (V3) overview: How to generate the rules (SQLFpc or SQLMutation) from your own application.
• SQLRules API specification: To visualize the OpenApi specification and interact with the API resources (swagger-ui).
• 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:

• SQLFpc REST API V2
• SQLMutation REST API V2
• SQLRules V1 standalone application