Package org.jumpmind.symmetric.service
Interface ITriggerRouterService
- All Known Implementing Classes:
TriggerRouterService
public interface ITriggerRouterService
-
Method Summary
Modifier and TypeMethodDescriptionbuildSymmetricTableRouterId
(String triggerId, String sourceNodeGroupId, String targetNodeGroupId) buildTriggerRoutersForSymmetricTables
(String version, NodeGroupLink nodeGroupLink, String... tablesToExclude) Return a list of triggers used when extraction configuration data during the registration process.buildTriggersForSymmetricTables
(String version, String... tablesToExclude) void
void
createTriggersOnChannelForTables
(String channelId, String catalogName, String schemaName, List<String> tables, String lastUpdateBy) void
void
void
void
deleteRouter
(Router router) void
deleteTrigger
(Trigger trigger) void
deleteTriggerRouter
(String triggerId, String routerId) void
deleteTriggerRouter
(TriggerRouter triggerRouter) void
deleteTriggerRouters
(Collection<TriggerRouter> triggerRouters) void
deleteTriggers
(Collection<Trigger> triggers) boolean
doesTriggerExist
(String triggerId) boolean
doesTriggerExistForTable
(String tableName) void
void
dropTriggers
(boolean includeSymTriggers) void
dropTriggers
(Set<String> tables) void
dropTriggers
(TriggerHistory history) fillTriggerRoutersByHistId
(String sourceNodeGroupId, String targetNodeGroupId, String targetExternalId, List<TriggerHistory> triggerHistories) fillTriggerRoutersByHistIdAndSortHist
(String sourceNodeGroupId, String targetNodeGroupId, String targetExternalId, List<TriggerHistory> triggerHistories, boolean sortByFk) fillTriggerRoutersByHistIdAndSortHist
(String sourceNodeGroupId, String targetNodeGroupId, String targetExternalId, List<TriggerHistory> triggerHistories, List<TriggerRouter> triggerRouters, boolean sortByFk) findTriggerHistories
(String catalogName, String schemaName, String tableName) findTriggerHistory
(String catalogName, String schemaName, String tableName) findTriggerRouterById
(String triggerId, String routerId) findTriggerRouterById
(String triggerId, String routerId, boolean refreshCache) findTriggerRoutersByRouterId
(String routerId, boolean refreshCache) findTriggerRoutersByTriggerId
(String triggerId, boolean refreshCache) getActiveRouterByIdForCurrentNode
(String routerId, boolean refreshCache) Get router that is currently in use by a trigger router at the node that is hosting this call.getActiveTriggerHistories
(String tableName) getActiveTriggerHistories
(Trigger trigger) getAllTriggerRoutersForCurrentNode
(String sourceNodeGroupId) getAllTriggerRoutersForReloadForCurrentNode
(String sourceNodeGroupId, String targetNodeGroupId) getNewestTriggerHistoryForTrigger
(String triggerId, String catalogName, String schemaName, String tableName) getNewestTriggerHistoryForTrigger
(List<TriggerHistory> activeTriggerHistories, String triggerId, String catalogName, String schemaName, String tableName) getRouterById
(String routerId) getRouterById
(String routerId, boolean refreshCache) getRouters
(boolean replaceVariables) Get a list of routers for a specific node group link.getSortedTablesFor
(List<TriggerHistory> histories) getTablesFor
(List<TriggerHistory> histories) getTriggerById
(String triggerId) getTriggerById
(String triggerId, boolean refreshCache) getTriggerForCurrentNodeById
(String triggerId) getTriggerHistory
(int historyId) getTriggerName
(DataEventType dml, int maxTriggerNameLength, Trigger trigger, Table table, List<TriggerHistory> activeTriggerHistories, TriggerHistory oldhist, List<String> triggerNamesGeneratedThisSession) getTriggerRouterByTriggerHist
(String targetNodeGroupId, int triggerHistId, boolean refreshCache) getTriggerRouterForCurrentNode
(String triggerId, String routerId, boolean refreshCache) getTriggerRouterForTableForCurrentNode
(String catalog, String schema, String tableName, boolean refreshCache) getTriggerRouterForTableForCurrentNode
(NodeGroupLink link, String catalogName, String schemaName, String tableName, boolean refreshCache) getTriggerRouters
(boolean refreshCache) getTriggerRoutersByChannel
(String nodeGroupId) getTriggerRoutersByChannelFromDatabase
(String nodeGroupId) getTriggerRoutersByTriggerHist
(String targetNodeGroupId, boolean refreshCache) getTriggerRoutersForCurrentNode
(boolean refreshCache) Returns a map of trigger routers keyed by trigger id.getTriggerRoutersForSourceAndTargetNodes
(String sourceNodeGroupId, String targetNodeGroupId) getTriggerRoutersForTargetNode
(String targetNodeGroupId) Get a list of all the triggers that have been defined for the system.getTriggers
(boolean replaceTokens) getTriggersForCurrentNode
(boolean refreshCache) Returns a list of triggers that should be active for the current node.void
inactivateTriggerHistory
(TriggerHistory history) void
insert
(TriggerHistory newAuditRecord) void
insertTriggerRouters
(Collection<TriggerRouter> triggerRouters) void
insertTriggers
(Collection<Trigger> triggers) void
insertTriggersAndTriggerRouters
(Collection<Trigger> triggers, Collection<TriggerRouter> triggerRouters) boolean
isRouterBeingUsed
(String routerId) boolean
isTriggerBeingUsed
(String triggerId) boolean
void
renameRouter
(String oldId, Router router) void
renameTrigger
(String oldId, Trigger trigger) void
renameTriggerRouter
(String oldTriggerId, String oldRouterId, TriggerRouter TriggerRouter) void
saveRouter
(Router router) saveRouterAsCopy
(Router router) void
saveTrigger
(Trigger trigger) void
saveTriggerAsCopy
(String originalId, Trigger trigger) void
saveTriggerRouter
(TriggerRouter triggerRouter) void
saveTriggerRouter
(TriggerRouter triggerRouter, boolean updateTriggerRouterTableOnly) void
syncTrigger
(Trigger trigger, ITriggerCreationListener listener, boolean force) void
syncTrigger
(Trigger trigger, ITriggerCreationListener listener, boolean force, boolean verifyTrigger) boolean
boolean
syncTriggers
(boolean genAlways) boolean
syncTriggers
(StringBuilder sqlBuffer, boolean genAlways) boolean
syncTriggers
(String targetExternalId, boolean force) boolean
syncTriggers
(List<Table> tables, boolean genAlways) boolean
syncTriggers
(List<Trigger> triggers, ITriggerCreationListener listener, boolean force, boolean verifyInDatabase) boolean
syncTriggers
(Table table, boolean genAlways) void
updateTriggerRouters
(Collection<TriggerRouter> triggerRouters) void
updateTriggers
(Collection<Trigger> triggers)
-
Method Details
-
refreshFromDatabase
boolean refreshFromDatabase() -
getActiveTriggerHistoriesFromCache
List<TriggerHistory> getActiveTriggerHistoriesFromCache() -
getActiveTriggerHistories
List<TriggerHistory> getActiveTriggerHistories() -
getActiveTriggerHistories
-
getActiveTriggerHistories
-
getLastErrorTriggerHistories
Map<String,TriggerHistory> getLastErrorTriggerHistories() -
getTriggerRouters
-
getTriggerRoutersFromDatabase
List<TriggerRouter> getTriggerRoutersFromDatabase() -
buildTriggerRoutersForSymmetricTables
List<TriggerRouter> buildTriggerRoutersForSymmetricTables(String version, NodeGroupLink nodeGroupLink, String... tablesToExclude) Return a list of triggers used when extraction configuration data during the registration process.- Parameters:
sourceGroupId
- group id of the node being registered withtargetGroupId
- group id of the node that is registering
-
buildSymmetricTableRouterId
-
getTriggerForCurrentNodeById
-
getTriggerRouterForCurrentNode
TriggerRouter getTriggerRouterForCurrentNode(String triggerId, String routerId, boolean refreshCache) -
getTriggerRoutersForTargetNode
-
getTriggerRoutersForSourceAndTargetNodes
List<TriggerRouter> getTriggerRoutersForSourceAndTargetNodes(String sourceNodeGroupId, String targetNodeGroupId) -
getTriggersForCurrentNode
Returns a list of triggers that should be active for the current node.- Parameters:
refreshCache
- Indicates that the cache should be refreshed
-
getTriggerRoutersByChannel
-
getTriggerRoutersByChannelFromDatabase
-
getTriggerRoutersForCurrentNode
Returns a map of trigger routers keyed by trigger id.- Parameters:
refreshCache
- Indicates that the cache should be refreshed
-
getTriggerRoutersCacheByNodeGroupIdFromDatabase
Map<String,TriggerRouterRoutersCache> getTriggerRoutersCacheByNodeGroupIdFromDatabase() -
getTriggerRoutersByTriggerHist
Map<Integer,TriggerRouter> getTriggerRoutersByTriggerHist(String targetNodeGroupId, boolean refreshCache) -
getTriggerRoutersByTriggerHistFromDatabase
Map<String,Map<Integer, getTriggerRoutersByTriggerHistFromDatabase()TriggerRouter>> -
getTriggerRouterByTriggerHist
TriggerRouter getTriggerRouterByTriggerHist(String targetNodeGroupId, int triggerHistId, boolean refreshCache) -
getActiveRouterByIdForCurrentNode
Get router that is currently in use by a trigger router at the node that is hosting this call.- Parameters:
routerId
- The router_id to retrieverefreshCache
- Whether to force the router to be re-retrieved from the database
-
getRouterById
-
getRouterById
-
getRouters
-
getRouters
-
getRoutersByGroupLink
Get a list of routers for a specific node group link. -
isRouterBeingUsed
-
deleteRouter
-
deleteAllRouters
void deleteAllRouters() -
saveRouter
-
saveRouterAsCopy
-
renameRouter
-
getAllTriggerRoutersForCurrentNode
-
getTriggers
Get a list of all the triggers that have been defined for the system. -
getTriggers
-
saveTrigger
-
insertTriggers
-
updateTriggers
-
saveTriggerAsCopy
-
renameTrigger
-
deleteTrigger
-
deleteTriggers
-
deleteAllTriggers
void deleteAllTriggers() -
dropTriggers
void dropTriggers() -
dropTriggers
void dropTriggers(boolean includeSymTriggers) -
dropTriggers
-
createTriggersOnChannelForTables
-
isTriggerBeingUsed
-
doesTriggerExist
-
doesTriggerExistForTable
-
getAllTriggerRoutersForReloadForCurrentNode
List<TriggerRouter> getAllTriggerRoutersForReloadForCurrentNode(String sourceNodeGroupId, String targetNodeGroupId) -
getTriggerRouterForTableForCurrentNode
Set<TriggerRouter> getTriggerRouterForTableForCurrentNode(NodeGroupLink link, String catalogName, String schemaName, String tableName, boolean refreshCache) -
getTriggerRouterForTableForCurrentNode
Set<TriggerRouter> getTriggerRouterForTableForCurrentNode(String catalog, String schema, String tableName, boolean refreshCache) -
findTriggerRouterById
-
findTriggerRouterById
-
findTriggerRoutersByTriggerId
-
findTriggerRoutersByRouterId
-
inactivateTriggerHistory
-
getNewestTriggerHistoryForTrigger
TriggerHistory getNewestTriggerHistoryForTrigger(List<TriggerHistory> activeTriggerHistories, String triggerId, String catalogName, String schemaName, String tableName) -
getNewestTriggerHistoryForTrigger
TriggerHistory getNewestTriggerHistoryForTrigger(String triggerId, String catalogName, String schemaName, String tableName) -
getTriggerHistory
-
findTriggerHistories
-
findTriggerHistory
-
getTriggerById
-
getTriggerById
-
getTriggerName
String getTriggerName(DataEventType dml, int maxTriggerNameLength, Trigger trigger, Table table, List<TriggerHistory> activeTriggerHistories, TriggerHistory oldhist, List<String> triggerNamesGeneratedThisSession) -
insert
-
getHistoryRecords
Map<Long,TriggerHistory> getHistoryRecords() -
deleteTriggerRouter
-
deleteTriggerRouter
-
deleteTriggerRouters
-
deleteAllTriggerRouters
void deleteAllTriggerRouters() -
saveTriggerRouter
-
saveTriggerRouter
-
renameTriggerRouter
-
insertTriggerRouters
-
insertTriggersAndTriggerRouters
void insertTriggersAndTriggerRouters(Collection<Trigger> triggers, Collection<TriggerRouter> triggerRouters) -
updateTriggerRouters
-
syncTrigger
-
syncTrigger
void syncTrigger(Trigger trigger, ITriggerCreationListener listener, boolean force, boolean verifyTrigger) -
syncTriggers
boolean syncTriggers(List<Trigger> triggers, ITriggerCreationListener listener, boolean force, boolean verifyInDatabase) -
syncTriggers
-
syncTriggers
-
syncTriggers
-
dropTriggers
-
syncTriggers
boolean syncTriggers(boolean genAlways) -
syncTriggers
boolean syncTriggers() -
syncTriggers
-
getFailedTriggers
-
fillTriggerRoutersByHistIdAndSortHist
Map<Integer,List<TriggerRouter>> fillTriggerRoutersByHistIdAndSortHist(String sourceNodeGroupId, String targetNodeGroupId, String targetExternalId, List<TriggerHistory> triggerHistories, List<TriggerRouter> triggerRouters, boolean sortByFk) -
fillTriggerRoutersByHistIdAndSortHist
Map<Integer,List<TriggerRouter>> fillTriggerRoutersByHistIdAndSortHist(String sourceNodeGroupId, String targetNodeGroupId, String targetExternalId, List<TriggerHistory> triggerHistories, boolean sortByFk) -
fillTriggerRoutersByHistId
Map<Integer,List<TriggerRouter>> fillTriggerRoutersByHistId(String sourceNodeGroupId, String targetNodeGroupId, String targetExternalId, List<TriggerHistory> triggerHistories) -
findTriggerHistoryForGenericSync
TriggerHistory findTriggerHistoryForGenericSync() -
clearCache
void clearCache() -
findMatchingTriggers
-
getTablesFor
-
getSortedTablesFor
-
buildTriggersForSymmetricTables
-