Allowable JSON keys for SQL interaction objects
SQL interaction objects are java objects that allow CRUD operations on the database.
Key Name | Finders | Updaters | Deleters | Inserters | Questions | Counters |
---|---|---|---|---|---|---|
name | mandatory | mandatory | mandatory | mandatory | mandatory | mandatory |
unique | optional (must be a boolean value of true or false, defaults to false) | invalid | invalid | invalid | invalid | invalid |
selectClause will create a select clause bean | optional | optional | optional | optional | mandatory must return a single result of type boolean | optional must return a single result of type integer |
selectFields only if required by the select clause | optional | optional | optional | optional | invalid | invalid |
whereClause | optional | optional | optional | optional | optional | optional |
whereFields only if required by the where clause | optional | optional | optional | optional | optional | optional |
insertClause | invalid | invalid | invalid | optional | invalid | invalid |
valuesClause | invalid | invalid | invalid | optional only if there is no select clause | invalid | invalid |
valueFields | invalid | invalid | invalid | optional only if there is no select clause and there is a values clause | invalid | invalid |
setClause | invalid | mandatory | invalid | invalid | invalid | invalid |
setFields | invalid | optional only if required by the set clause | invalid | invalid | invalid | invalid |
orderBy | optional | invalid | invalid | invalid | invalid | invalid |