Package overit.geocallapp.wfm.cee.replicator.datasource

Class DACeeInterventions

java.lang.Object

overit.geocall.da.DABase

overit.geocallapp.replicator.basic.base.DataSource.DABaseReplicator

overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

overit.geocallapp.wfm.cee.replicator.datasource.DACeeInterventions

All Implemented Interfaces:

Serializable, DataAttributesHolder, EDMConfigurableBean, overit.geocall.marks.FieldExposer, overit.geocall.marks.NameExposer, DBFieldMapper, DBObjectMapper, Identified, Tool, overit.geocallapp.replicator.basic.base.DataSource.IDSDABase

public class DACeeInterventions
extends overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

DABase for extraction queries related to CEE interventions

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
static final int	SELECT_CEE_INTERVENTIONS

Fields inherited from class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

COMMAND_NONE, COMMAND_NOT_ALLOWED, LOG, RESET_TOMBSTONE_VALUE

Fields inherited from class overit.geocallapp.replicator.basic.base.DataSource.DABaseReplicator

_table

Fields inherited from class overit.geocall.da.DABase

DA_BASE_FILTER_PREFIX, DELETE_FILTER, DELETE_PK, INSATE, INSERT, REPLACE_DBVIEW, SAVE_DBVIEW, SELECT_FILTER, SELECT_NONE, SELECT_PK, UPDATE_FILTER, UPDATE_PK, UPSERT

Constructor Summary

Constructors

Constructor	Description
DACeeInterventions()

Method Summary

Modifier and Type	Method	Description
protected int	giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)	Implements new specific commands that are different from the standard ones.
protected DBView	giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)	Implements new specific queries that are different from the standard ones.

Methods inherited from class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

acknowledge, addCustomTombStone, addResetTombstone, addResetTombstone, addTombstones, appendCustomTombstone, buildTableTombstone, calcIdReplicationOperationsCenter, containsResetTombstone, getFilialeAuteLoginPda, getIdAuteUltimaModificaPda, getIdOperationsCenterCustom, getIdPdaFk, getIdServerFk, getListaFiliali, getSyncParams, getTombstoneFkTable, getTombstoneFromDBView, getUserOperationsCenter, getUserVisibilitySettings, giveBranchField, giveDBFieldMap, giveDBObjectMap, giveFactoryField, giveOrderCols, givePoolName, givePrimaryKeys, giveSequenceField, giveTableName, isBlankLastSync, isInitialSync, isUnidentifiedMobileUser, isUnidentifiedMobileUser, isUserSafety, loadUserVisibilitySettings, needsResetTombstone, postOperation, postProcessDataForPda, preOperation, setSqlSelectFkTable, setSqlSelectFkTable, setSqlUnionDifferential

Methods inherited from class overit.geocallapp.replicator.basic.base.DataSource.DABaseReplicator

preInsert, preUpdate, setReplicationParam, setReplicationTable

Methods inherited from class overit.geocall.da.DABase

command, command, command, getAutoIncrementVal, getDataAttributes, getDBFieldMap, getDBFields, getDBObjectMap, getFieldMap, getIdentity, getQueryId, getQueryId, getReadOnlyCols, getSequenceNextVal, getTeacher, giveIsDistinct, giveIsService, giveMinLevel, giveStar, hasNotBeenDecorated, haveDBFieldMap, haveDBObjectMap, markAsDecorated, postDelete, postInsert, postUpdate, preDelete, preQuery, query, query, query, query, query, release, removeReadOnlyCols, replace, replace, save, save, setDataAttributes, setDBFieldMap, setDBObjectMap, setIdentity, setReadOnlyCols, useConnection

Methods inherited from class java.lang.Object

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

Methods inherited from interface overit.geocall.edm.model.DataAttributesHolder

getEntities

Methods inherited from interface overit.geocall.edm.model.EDMConfigurableBean

getEntity, hasEntity

Field Details

SELECT_CEE_INTERVENTIONS

public static final int SELECT_CEE_INTERVENTIONS

See Also:

• Constant Field Values

Constructor Details

DACeeInterventions

public DACeeInterventions()

Method Details

giveQueries

protected DBView giveQueries(int i,
 PooledConnection conn,
 DBStatement stmt,
 HashGetter filter,
 int maxrows,
 int skiprows)
                      throws SQLException

Description copied from class: DABase

Implements new specific queries that are different from the standard ones.
For all the queries implemented with this method we must set, in the DBStatement, the SQL (setSql()), the parameters (available as filters and settable using set()) and any map (setDBObjectMap(), setDBFieldMap()) to use on the DBStatement.
The execution is done when we call one of the query() methods, so we can do here only the statement setup.
It is fundamental that the method return null if the query id is not recognized.

Overrides:

giveQueries in class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

Parameters:

i - The id of the query

conn - Connection from which we have extracted the DBStatement; it can be used to extract other DBStatement

stmt - DBStatement used to set the SQL code and the parameters

filter - Parameters to set in the DBStatement

maxrows - Maximum rows number extracted with the query

skiprows - Number of initial lines that you do not want to be returned. Even these lines, although skipped, are counted in the maxrows parameter.

Returns:

If the query id is valid we must return the DBStatement passed as parameter; if the is is not valid, or we don't want to add specific queries to the standard ones we must return null

Throws:

SQLException - If there is an error in the SQL SQLException is thrown

giveCommands

protected int giveCommands(int i,
 PooledConnection conn,
 DBStatement stmt,
 HashGetter oKeys,
 HashGetter oParams)
                    throws SQLException

Description copied from class: DABase

Implements new specific commands that are different from the standard ones.
For all the commands implemented with this method we must set, in the DBStatement, the SQL (setSql()), (setDBObjectMap(), setDBFieldMap()) to use on the DBStatement.
The execution is done when we call one of the command() methods, so we can do here only the statement setup.
It is fundamental that the method return null if the command id is not recognized.

Overrides:

giveCommands in class overit.geocallapp.wfm.replicator.datasource.DAReplicatorWfmBase

Parameters:

i - The id of the command

conn - Connection from which we have extracted the DBStatement; it can be used to extract other DBStatement

stmt - DBStatement used to set the SQL code and the parameters

oKeys - Values used as filters to set for the update commands

oParams - Values to set as parameters in the DBStatement

Returns:

If the command id is valid we must return the DBStatement passed as parameter; if the id is not valid, or we don't want to add specific commands to the standard ones we must return null

Throws:

SQLException - If there is an error in the SQL SQLException is thrown