USoft Rule Language examples: Simple constraints

The following examples show the USoft Rule Language syntax and equivalent SQL for simple constraints.

Simple Conditional Constraint

USoft Rule Language

SQL Equivalent

FOR drivers
DO NOT ALLOW THAT age < 23

SELECT   ''
FROM     driver
WHERE    age < 23

Simple Corrective Constraint

USoft Rule Language

SQL Equivalent

FOR drivers
MAKE SURE THAT   status = 'Accredited'
WHERE            age > 23
OR               license_date > sysdate  -  (3 * 365)

UPDATE   driver
SET      status = 'Accredited'
WHERE    age > 23
OR       license_date > sysdate - (3 * 365)