Package adams.flow.source

Class SQLIdSupplier

  • All Implemented Interfaces:
    AdditionalInformationHandler, ArrayProvider, CleanUpHandler, Destroyable, GlobalInfoSupporter, LenientModeSupporter, LoggingLevelHandler, LoggingSupporter, OptionHandler, QuickInfoSupporter, ShallowCopySupporter<Actor>, SizeOfHandler, Stoppable, StoppableWithFeedback, VariablesInspectionHandler, DatabaseConnectionUser, VariableChangeListener, Actor, ArrayProvider, ErrorHandler, OutputProducer, Serializable, Comparable
    public class SQLIdSupplier
extends AbstractDatabaseIdSupplier
    Executes an SQL statement for generating the IDs.
    Variables are automatically expanded.

    Input/output:
    - generates:
       java.lang.Integer


    -logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
    The logging level for outputting errors and debugging output.
    default: WARNING
    min-user-mode: Expert
 
    -name <java.lang.String> (property: name)
    The name of the actor.
    default: SQLIdSupplier
 
    -annotation <adams.core.base.BaseAnnotation> (property: annotations)
    The annotations to attach to this actor.
    default:
 
    -skip <boolean> (property: skip)
    If set to true, transformation is skipped and the input token is just forwarded
    as it is.
    default: false
 
    -stop-flow-on-error <boolean> (property: 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.
    default: false
    min-user-mode: Expert
 
    -silent <boolean> (property: silent)
    If enabled, then no errors are output in the console; Note: the enclosing
    actor handler must have this enabled as well.
    default: false
    min-user-mode: Expert
 
    -output-array <boolean> (property: outputArray)
    Whether to output the IDs as array or one by one.
    default: false
 
    -lenient <boolean> (property: lenient)
    If enabled, the source no longer reports an error when not finding any IDs.
    default: false
 
    -sql <adams.db.SQLStatement> (property: SQL)
    The SQL statement to run that generates the IDs; variables get expanded
    automatically.
    default: select auto_id from table
 
    -type <INTEGER|STRING> (property: type)
    The type of IDs to generate.
    default: INTEGER
    Author:
    fracpete (fracpete at waikato dot ac dot nz)
    See Also:
    Serialized Form

    • Constructor Detail

      • SQLIdSupplier

        public SQLIdSupplier()