public class ExperimentCheckExpiryCmdImpl extends ControllerCommandImpl implements ExperimentCheckExpiryCmd
Modifier and Type | Field and Description |
---|---|
static java.lang.String | COPYRIGHT
IBM copyright notice field.
|
protected static java.lang.String | SQL_COUNT_REGISTERED_USER_BY_EXPERIMENT
The SQL query which counts all of the registered users with the given experiment from the EXPRESULT table.
|
protected static java.lang.String | SQL_COUNT_UNIQUE_SESSION_BY_EXPERIMENT_AND_USER
The SQL query which counts all of the unique sessions with the given experiment and user from the EXPRESULT table.
|
protected static java.lang.String | SQL_FIND_ACTIVE_EXPERIMENTS
The SQL query used to find all experiments from the EXPERIMENT table which are active but currently marked as expired.
|
protected static java.lang.String | SQL_FIND_EXPERIMENTS_BY_STATUS
The SQL query which returns all experiments with the given status from the EXPERIMENT table.
|
protected static java.lang.String | SQL_FIND_EXPIRED_EXPERIMENTS
The SQL query used to find all experiments from the EXPERIMENT table which have been expired but currently marked as active.
|
protected static java.lang.String | SQL_UPDATE_ACTIVE_EXPERIMENTS_TO_EXPIRE
The SQL query used to find all experiments from the EXPERIMENT table which have been expired but currently marked as active.
|
protected static java.lang.String | SQL_UPDATE_EXPIRED_EXPERIMENTS_TO_ACTIVE
The SQL query used to find all experiments from the EXPERIMENT table which are active but currently marked as expired.
|
protected static java.lang.String | SQL_UPDATE_STATUS_BY_EXPERIMENT_IDS
The SQL query which updates the given experiments with the given status to the EXPERIMENT table.
|
Constructor and Description |
---|
ExperimentCheckExpiryCmdImpl() |
Modifier and Type | Method and Description |
---|---|
void | performExecute()
The performExecute method is called by the scheduler to check if any experiments are expired or not, based on their end date and expiry count.
|
public static final java.lang.String COPYRIGHT
protected static java.lang.String SQL_FIND_EXPIRED_EXPERIMENTS
protected static java.lang.String SQL_FIND_ACTIVE_EXPERIMENTS
protected static java.lang.String SQL_UPDATE_ACTIVE_EXPERIMENTS_TO_EXPIRE
protected static java.lang.String SQL_UPDATE_EXPIRED_EXPERIMENTS_TO_ACTIVE
protected static java.lang.String SQL_FIND_EXPERIMENTS_BY_STATUS
protected static java.lang.String SQL_UPDATE_STATUS_BY_EXPERIMENT_IDS
protected static java.lang.String SQL_COUNT_REGISTERED_USER_BY_EXPERIMENT
protected static java.lang.String SQL_COUNT_UNIQUE_SESSION_BY_EXPERIMENT_AND_USER
public void performExecute() throws ECException