Qorus Integration Engine®
4.0.3.p2_git
|
Qorus oubound mapper based on raw SQL select statement. More...
Public Member Methods | |
constructor (hash mapv, *hash opts) | |
constructs a mapper object More... | |
hash | optionKeys () |
returns a list of valid constructor options for this class (can be overridden in subclasses) More... | |
Static Public Member Methods | |
static Qore::SQL::AbstractDatasource | getDatasource (reference opts) |
called in the constructor to get the Table object | |
Public Attributes | |
const | OptionKeys |
valid mapper keys | |
Qorus oubound mapper based on raw SQL select statement.
Options used for SqlRawStatementOutboundMapper are:
datasource:
(required) the name of the Qorus datasource containing the target tableselect:
(required) the name of the leading table or view for the select hashbind:
(optional) an SqlUtil select hash for the table
. It can use QorusSqlStatementOutboundMapper Variable BindingExample of the mapper definition in the qmapper file:
When SqlRawStatementOutboundMapper is initialized it can get the bind
runtime option to make sh
parametrized at runtime.
Example of mapper initialization in the workflow step:
Then values provided in runtime options (ropts
), key "bind"
are passed to the mappers's select statement. Resulting in for example:
constructs a mapper object
mapv | a mapping hash |
opts | a option hash |
hash OMQ::QorusRawSqlStatementOutboundMapper::optionKeys | ( | ) |
returns a list of valid constructor options for this class (can be overridden in subclasses)