Name

adams.flow.transformer.ReportDbUpdater

Synopsis

Adds all the data to the report (or reporthandler's report) passing through that the SQL statement returns.
The {ID} placeholder can be used in the SQL statement to represent the current handler's ID.
The following types of SQL statements are supported:
- multiple rows of key-value pairs.
- single row, with the key being the column name.

Additional information

Flow input/output:
- input: adams.data.report.Report, adams.data.report.MutableReportHandler
- output: adams.data.report.Report, adams.data.report.MutableReportHandler

Options

• loggingLevel
  

  The logging level for outputting errors and debugging output.

  command-line	-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST>
  default	WARNING
  min-user-mode	Expert

  
  
• name
  

  The name of the actor.

  command-line	-name <java.lang.String>
  default	ReportDbUpdater

  
  
• annotations
  

  The annotations to attach to this actor.

  command-line	-annotation <adams.core.base.BaseAnnotation>
  default

  
  
• skip
  

  If set to true, transformation is skipped and the input token is just forwarded as it is.

  command-line	-skip <boolean>
  default	false

  
  
• stopFlowOnError
  

  If set to true, the flow execution at this level gets stopped in case this actor encounters an error; the error gets propagated; useful for critical actors.

  command-line	-stop-flow-on-error <boolean>
  default	false
  min-user-mode	Expert

  
  
• silent
  

  If enabled, then no errors are output in the console; Note: the enclosing actor handler must have this enabled as well.

  command-line	-silent <boolean>
  default	false
  min-user-mode	Expert

  
  
• SQL
  

  The SQL statement that selects the key-value pairs for the report; you can use the {ID} placeholder for the current handler's ID in your SQL statement (if it is an adams.data.id.IDHandler).

  command-line	-sql <adams.db.SQLStatement>
  default	select key,value from table where id = \\\"{ID}\\\"

  
  
• queryType
  

  The type of query that the SQL statement represents; multiple rows with key-value pairs (KEY_VALUE) or single row with the column name as key (COLUMN_AS_KEY).

  command-line	-query-type <KEY_VALUE|COLUMN_AS_KEY>
  default	KEY_VALUE

  
  
• columnKey
  

  The name of the column containing the key for the key-value pairs to be added to the report.

  command-line	-column-key <java.lang.String>
  default	key

  
  
• columnValue
  

  The name of the column containing the value for the key-value pairs to be added to the report.

  command-line	-column-value <java.lang.String>
  default	value

  
  
• lenient
  

  If enabled, error messages are suppressed in case empty resultsets are encountered.

  command-line	-lenient <boolean>
  default	false