DBCheck SQL Generator
Incolla qui il tuo file YAML di configurazione o trascinalo nell'area di testo.
version
Input YAML
validation_rules: - id: rule#1 # optional, id of rule severity: E # optional I, W, E source: # mandatory table: table1 # mandatory table pk: table1pk # optional primary key of table field: table1field # optional field to check joinfield: fable1join # optional field for join, joinField || field || pk || null fk: # optional table join table: table2 # mandatory if fk: is define, table for join pk: table2pk # optional primary key for right table joinfield: table2join # optional field for join, if not present pk is used field: table2file # optional field to show in result = field || joinfield || pk || null where: table1.fieldX is not null # optional additional where condition check: # optional, if not present is check.value = is null sql: # optional sql for where value: is null # optional used to build ${( fk.field || fk.joinField || fk.pk || surce.field || source.pk )} ${check.value} on_success: # optional error if generated where is true message: record ${source.field} error # optional error message. valid ${struct.field} for name and (${struct.field}) for its content on_fail: # optional error if generated where is false. cannot be present with on_fail message: # optional error message. valid ${struct.field} for name and (${struct.field}) for its content fix: # optional build fix. Place here your SQL code with (${source.pk}) to identify correct record or use update: # optional sql for update. put here value for source.field delete: # optional if present build delete statement for (${source.pk})
Genera SQL
Output SQL
Scarica SQL