Name

adams.flow.source.TimeseriesDbReader

Synopsis

Outputs timeseries containers generated from an SQL SELECT statement.
A new container is started, whenever the value of the ID column changes (hence you need to ensure that the data is ordered on this column).

Additional information

Flow input/output:
- 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.

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

  
  
• columnID
  

  The name of the column containing the ID that distinguishes the timeseries (accepted types: numeric, string); if left empty, the first string column from the SQL statement is used.

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

  
  
• 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