MultipleSqlCron

Group

Time-driven Custom Classes

Class Name

com.ebd.hub.datawizard.util.MultipleSqlCron

Function

This class allows to cascade multiple DefaultSqlCrons.

Configuration File

sample_multiple_sql_cron.properties

Description

This class allows cascading multiple DefaultSqlCrons. The results of the individual DefaultSqlCrons are merged in the same order the DefaultSqlCrons are called. This order is defined in the configuration file, which contains the paths to the configuration files of the individual DefaultSqlCrons.

Example

sample_multiple_sql_cron.properties
#
#Sample config file for MultipleSQLCron
#
#Calls DefaultSQLCron several times with different config files and merges the results.
#Index starts at 0 and step size is 1.
#Single DefaultSQLCron does not write a dump to disk, even if defined in the individual config file.
#
#Do not call other DefaultSQLCron when first call does not return any data (default)
continue_on_empty_result = false
#Calls DefaultSQLCron twice with the following config files:
config.0=./conf/sample_sql_cron1.properties
config.1=./conf/sample_sql_cron2.properties
#Dump result as a CSV file
save_as_csv=./dump_all.csv