Name

adams.flow.transformer.TimeseriesDbReader

Synopsis

Outputs timeseries containers generated from an SQL SELECT statement.
The input is interpreted as the ID of the timeseries to load.
This ID can be used in the SQL statement using the {ID} placeholder.

Additional information

Flow input/output:
- input: java.lang.String, java.lang.Integer, java.lang.Long
- output: adams.data.timeseries.Timeseries

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	TimeseriesDbReader

  
  
• 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 timeseries data; use the {ID} placeholder in the statement to specify the ID of the timeseries to load.

  command-line	-sql <adams.db.SQLStatement>
  default	select timestamp,value from table where id = {ID} order by timestamp

  
  
• columnTimestamp
  

  The name of the column containing the timestamp for a data point (accepted types: integer, date, time, datetime, timestamp); if left empty, the first date-like column from the SQL statement is used.

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

  
  
• columnValue
  

  The name of the column containing the value for a data point (accepted types: numeric); if left empty, the first numeric column from the SQL statement is used.

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