≡ModelConfig - DbSqlReadCall

Map results of a sql select to the targetPath.

Github

Super Class

≡DbSqlCall

Interface

≡ListParamsBeanInterface,ConfigReadCommand

Simple Call

The following example will add the result to "xyz" as a list of maps.

{ "(DbSqlReadCall)xyz":{ "sqlKey":"h2:mem:basic:AnObject", "hostConfigKey":"h2:mem:basic" }, "_serializationType":"STANDARD" }

Since default configuration defines "rowHead" with 0, which will be filled with metadata of the resultset, the value entries will be mapped as a list of map entries using the first row as a key.

Fields

Configuration

{ "author": "Werner Diwischek", "configModelKey": "ModelConfigObject", "description": "Map results of a sql select to the targetPath.", "expose": "WEB", "fields": { "condition": { "configModelKey": "FieldConfigObject", "description": "A condition for calls. ", "expose": "WEB", "fieldKey": "condition", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "condition", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 1000, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "duration": { "configModelKey": "FieldConfigObject", "description": "The duration of a call.", "expose": "WEB", "fieldKey": "duration", "modelKeys": "Long", "module": "elastic-objects", "moduleScope": "main", "naturalId": "duration", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": -1, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "hostConfigKey": { "configModelKey": "FieldConfigObject", "description": "A key for host objects.", "expose": "NONE", "fieldKey": "hostConfigKey", "modelKeys": "String", "module": "eo-calls", "moduleScope": "main", "naturalId": "hostConfigKey", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 80, "min": -1, "notNull": false, "override": false, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "keepCall": { "configModelKey": "FieldConfigObject", "description": "Will use an existing result file beforehand as template. ", "expose": "WEB", "fieldKey": "keepCall", "modelKeys": "KeepCalls", "module": "elastic-objects", "moduleScope": "main", "naturalId": "keepCall", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": -1, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "listParams": { "configModelKey": "FieldConfigObject", "description": "Parameters of type @ListParamsBean for list type read call operations like @CsvSimpleReadCall.", "expose": "NONE", "fieldKey": "listParams", "modelKeys": "ListParamsBean", "module": "eo-calls", "moduleScope": "main", "naturalId": "listParams", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 80, "min": -1, "notNull": false, "override": false, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "logLevel": { "configModelKey": "FieldConfigObject", "description": "logLevel", "expose": "WEB", "fieldKey": "logLevel", "modelKeys": "LogLevel", "module": "elastic-objects", "moduleScope": "main", "naturalId": "logLevel", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": -1, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "models": { "configModelKey": "FieldConfigObject", "description": "A string representation for a list of model keys.", "expose": "WEB", "fieldKey": "models", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "models", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 512, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "overwrite": { "configModelKey": "FieldConfigObject", "description": "A overwrite field flag for @Call.", "expose": "WEB", "fieldKey": "overwrite", "modelKeys": "Boolean", "module": "elastic-objects", "moduleScope": "main", "naturalId": "overwrite", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": -1, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "postpend": { "configModelKey": "FieldConfigObject", "description": "postpend String when executed by ExecutorCallImpl", "expose": "NONE", "fieldKey": "postpend", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "postpend", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 256, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "prepend": { "configModelKey": "FieldConfigObject", "description": "prepend String when executed by ExecutorCallImpl", "expose": "NONE", "fieldKey": "prepend", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "prepend", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 256, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "sourcePath": { "configModelKey": "FieldConfigObject", "description": "A sourcePath where EO offers it's input value when the execution starts.", "expose": "WEB", "fieldKey": "sourcePath", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "sourcePath", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 80, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "sqlKey": { "configModelKey": "FieldConfigObject", "description": "The key to select a configuration from DbSqlConfig within DbSqlCall.", "expose": "NONE", "fieldKey": "sqlKey", "modelKeys": "String", "module": "eo-db", "moduleScope": "main", "naturalId": "sqlKey", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 128, "min": -1, "notNull": false, "override": false, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "startCondition": { "configModelKey": "FieldConfigObject", "description": "A condition for calls. ", "expose": "WEB", "fieldKey": "startCondition", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "startCondition", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 1000, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } }, "targetPath": { "configModelKey": "FieldConfigObject", "description": "A targetPath where the result of the execution will be mapped. If value is \"_asString\" no mapping occured but a seralized version is returned as value to embed it in the resulting file. Path parameters could be set dynamically with =>[path]. in any combination.", "expose": "WEB", "fieldKey": "targetPath", "modelKeys": "String", "module": "elastic-objects", "moduleScope": "main", "naturalId": "targetPath", "properties": { "default": false, "final": false, "generated": false, "jsonIgnore": false, "max": 80, "min": -1, "notNull": false, "override": true, "property": false, "staticName": false, "super": true, "transient": false, "unique": false } } }, "interfaces": "ListParamsBeanInterface,ConfigReadCommand", "modelKey": "DbSqlReadCall", "module": "eo-db", "moduleScope": "main", "naturalId": "DbSqlReadCall", "packagePath": "org.fluentcodes.projects.elasticobjects.calls.db", "properties": { "abstract": false, "create": true, "dbAnnotated": false, "final": false }, "superKey": "DbSqlCall" }

This Page Elements

Page-Template:	ConfigsPage.html
Header:	Header.html
Footer:	Footer.html
Postversion of this page: { "asTemplate":true, "configFilter": ".*", "configType": "ModelConfig", "configSelected": "DbSqlReadCall", "selectedItem": "ModelConfigDbSqlReadCall", "(TemplateResourceCall)call": { "fileConfigKey":"ConfigsPage.html" } }