Package overit.geocallapp.wfm.workorders.bl.operation.operationRequirement.migration.task

Class BTRepopulateOperationRequirement

java.lang.Object

overit.geocall.bl.BusinessTask<Void>

overit.geocallapp.wfm.workorders.bl.operation.operationRequirement.migration.task.BTRepopulateOperationRequirement

All Implemented Interfaces:

Serializable, Interruptable, Tool

public class BTRepopulateOperationRequirement
extends BusinessTask<Void>
implements Interruptable

Task to repopulate the table RWOOPERATIONREQUIREMENT from the values contained in AWOOPERATION denormalized fields (AWOOMANDATORYIDENTNUMSET, AWOOPREFERREDIDENTNUMSET, AWOOMANDATORYTEAM).

This task is used for migration from the old denormalized structure to the new normalized RWOOPERATIONREQUIREMENT table.

Since:

22.0

See Also:

• Serialized Form

GCApi:

task

Field Summary

Fields

Modifier and Type	Field	Description
protected int	deletedRows
protected int	insertedRows
protected boolean	interrupt
protected static final LogChannel	LOG
protected TimeSlot	timeSlot

Constructor Summary

Constructors

Constructor	Description
BTRepopulateOperationRequirement()

Method Summary

Modifier and Type	Method	Description
protected void	body(Void i, PoolKit pk)	Implements this method to write the specific task logic to handle the input parameter.
void	pleaseInterrupt()
protected void	populateTable(DBView dbvOperations, PoolKit pk)	Populates the RWOOPERATIONREQUIREMENT table from the extracted operations.

Methods inherited from class overit.geocall.bl.BusinessTask

start, start, startAlone, startInBackground

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

LOG

protected static final LogChannel LOG

interrupt

protected boolean interrupt

timeSlot

protected TimeSlot timeSlot

deletedRows

protected int deletedRows

insertedRows

protected int insertedRows

Constructor Details

BTRepopulateOperationRequirement

public BTRepopulateOperationRequirement()

Method Details

body

protected void body(Void i,
 PoolKit pk)
             throws DAException,
DAValidateException

Description copied from class: BusinessTask

Implements this method to write the specific task logic to handle the input parameter.

Specified by:

body in class BusinessTask<Void>

Parameters:

i - the object upon which the task will works on

pk - the poolkit containing the reference to the database connection that can be used

Throws:

DAException - in case of database error

DAValidateException - in case of database validation error

populateTable

protected void populateTable(DBView dbvOperations,
 PoolKit pk)
                      throws DAValidateException,
DAException,
SQLException

Populates the RWOOPERATIONREQUIREMENT table from the extracted operations.

For each operation with denormalized requirement data, deletes existing records and inserts new ones based on the denormalized field values.

Parameters:

dbvOperations - the DBView containing operations with denormalized requirement data

pk - the PoolKit for database operations

Throws:

DAValidateException - if validation fails

DAException - if a database error occurs

SQLException - if a SQL error occurs

pleaseInterrupt

public void pleaseInterrupt()

Specified by:

pleaseInterrupt in interface Interruptable