DbRoutineParameter

DbRoutine is an object describing a DbRoutine parameter.

Properties

Name	Type	Description	Notes
name	String	Logical parameter name	unquoted
qName	String	Qualified name	quoted name, computed by DbLang
mode	String	Parameter mode: IN, OUT or INOUT	IN by default
type	String	Parameter type description
default	String	DEFAULT expression	quoted to be interpolated in CREATE FUNCTION as is

Domain-specific language

The class implements a tiny DSL to build DbRoutineParameter objects from formatted strings.

parameter ::= mode? name type ("=" default)
mode      ::= ("IN" | "OUT" | "INOUT")

Example:

parameters: [
  'id INT',
  'delta DECIMAL (10,2) = 0',
  'OUT accrued DECIMAL (10,2)',
  {
    name: 'xtra',
    mode: 'INOUT',
    type: 'TEXT',
    default: "''",
  },
]