Field Detail

• QUERY_EMSPOT_USAGETYPE_IN_WRITE_SCHEMA

  protected static final java.lang.String QUERY_EMSPOT_USAGETYPE_IN_WRITE_SCHEMA
  

  SQL to fetch the usage type for associated to a catentry and store within the write schema

  See Also:

  Constant Field Values

Constructor Detail

• MarketingSpotManagementResourceManagerImpl

  public MarketingSpotManagementResourceManagerImpl()
  

Method Detail

• getObjectNoun

  protected java.lang.Object getObjectNoun()
  

  Creates a skeleton noun with only the unique ID is populated.

  Specified by:

  getObjectNoun in class ContentManagementResourceManagerImpl

  Parameters:

  uniqueId - a unique Id for the noun.

  nounName - the name of the noun to retrieve.

  Returns:

  the object noun

• getComponentId

  protected java.lang.String getComponentId()
  

  Returns the component identifier associated for the marketing component com.ibm.commerce.marketing

  Specified by:

  getComponentId in class ContentManagementResourceManagerImpl

  Returns:

  component name for marketing components.

• getObjectNounPath

  protected java.lang.String getObjectNounPath()
  

  Returns the object path for marketing nouns

  Specified by:

  getObjectNounPath in class ContentManagementResourceManagerImpl

  Returns:

  the object path

• validateUniqueObjectCode

  protected void validateUniqueObjectCode(java.lang.String objectId,
                              java.lang.String objectCode)
                                   throws java.lang.Exception
  

  Validates if the specified object code is unique in the read schema. This method is called when undo the delete of a object or when undo the update of object code.

  Overrides:

  validateUniqueObjectCode in class ContentManagementResourceManagerImpl

  Parameters:

  objectId - the object id.

  objectCode - the object code.

  Throws:

  java.lang.Exception - Exception may be thrown when there are problems to retrieve from database.

• getStatementToFindUniqueIDFromObjectCode

  protected java.lang.String getStatementToFindUniqueIDFromObjectCode()
  

  This method will return the statement which returns the unique id according to the unique identifier (code) of an marketing spot and the current store id. It is used to check if identifier is unique.

  Overrides:

  getStatementToFindUniqueIDFromObjectCode in class ContentManagementResourceManagerImpl

  Returns:

  String the SQL for finding the unique id according to the unique identifier.

• performActionNew

  protected void performActionNew(java.util.List<com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable> cmRelatedTables,
                      com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable cmParentRelatedTable)
                           throws java.lang.Exception
  

  Execute action on new for marketing eSpots.

  Overrides:

  performActionNew in class ContentManagementResourceManagerImpl

  Parameters:

  cmRelatedTables - List of tables on which the operation will be performed

  cmParentRelatedTable - Parent table. Null if this table has no parent

  Throws:

  java.lang.Exception - If there was an error of if the undo action should not be performed

• performActionUpdate

  protected void performActionUpdate(java.util.List<com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable> cmRelatedTables,
                         com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable cmParentRelatedTable)
                              throws java.lang.Exception
  

  Execute action on update for marketing eSpots.

  Overrides:

  performActionUpdate in class ContentManagementResourceManagerImpl

  Parameters:

  cmRelatedTables - List of tables on which the operation will be performed

  cmParentRelatedTable - Parent table. Null if this table has no parent

  Throws:

  java.lang.Exception - If there was an error of if the action should not be performed

• getNonUIDisplayableActivitiesForEMSpot

  public static java.util.List<java.lang.Integer> getNonUIDisplayableActivitiesForEMSpot(com.ibm.commerce.base.objects.ServerJDBCHelperAccessBean jdbcHelper,
                                                                         java.lang.Long eSpotId,
                                                                         java.lang.Long storeId,
                                                                         java.lang.String writeSchemaName)
                                                                                  throws java.lang.Exception
  

  Helper undo method to find all non-UI displayable activities for the given eMarketing Spot.

  Parameters:

  jdbcHelper - JDBC Helper

  eSpotId - eMarketing Spot Id

  storeId - Store Id

  writeSchemaName - Write schema name

  Returns:

  The list of activities for the given eMarketing Spot

  Throws:

  java.lang.Exception - If there was an error of if the action should not be performed

• getActivitiesForEMSpot

  public static java.util.List<java.lang.Integer> getActivitiesForEMSpot(com.ibm.commerce.base.objects.ServerJDBCHelperAccessBean jdbcHelper,
                                                         java.lang.Long eSpotId,
                                                         java.lang.Long storeId,
                                                         java.lang.String writeSchemaName)
                                                                  throws java.lang.Exception
  

  Helper undo method to find all activities for the given eMarketing Spot.

  Parameters:

  jdbcHelper - JDBC Helper

  eSpotId - eMarketing Spot Id

  storeId - Store Id

  writeSchemaName - Write schema name

  Returns:

  The list of activities for the given eMarketing Spot

  Throws:

  java.lang.Exception - If there was an error of if the action should not be performed

• getActiveActivitiesForEMSpot

  public static java.util.List<java.lang.Integer> getActiveActivitiesForEMSpot(com.ibm.commerce.base.objects.ServerJDBCHelperAccessBean jdbcHelper,
                                                               java.lang.Long eSpotId,
                                                               java.lang.Long storeId,
                                                               java.lang.String writeSchemaName)
                                                                        throws java.lang.Exception
  

  Helper undo method to find all active activities for the given eMarketing Spot.

  Parameters:

  jdbcHelper - JDBC Helper

  eSpotId - eMarketing Spot Id

  storeId - Store Id

  writeSchemaName - Write schema name

  Returns:

  The list of active activities for the given eMarketing Spot

  Throws:

  java.lang.Exception - If there was an error of if the action should not be performed

• executeAction

  protected void executeAction(com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable relatedTable,
                   java.lang.Long[] keyValues)
                        throws java.lang.Exception
  

  Execute the operation on each table. The Marketing Spot tables have sublocks. Override the executeAction method and iterate over each record to free the locks before calling the super to undo the records within tables that have sublocks.

  Overrides:

  executeAction in class ContentManagementResourceManagerImpl

  Parameters:

  relatedTable - Table on which the operation will be performed. Table key values must be set.

  keyValues - The values to use in the query associated to relatedTable.

  Throws:

  java.lang.Exception - If there was an error or if the operation should be canceled

• handleUndoForMarketingSpotDefaultContentCollateral

  protected boolean handleUndoForMarketingSpotDefaultContentCollateral(com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable relatedTable,
                                                           java.lang.Long[] keyValues)
                                                                throws java.lang.Exception
  

  Process the Marketing Spot Collateral default content records for the current undo operation.

  Parameters:

  relatedTable - DMEMSPOTCOLLDEF table on which the operation will be performed. Table key values must be set.

  keyValues - The values to use in the query associated to relatedTable.

  Returns:

  true if the method processed sublock records.

  Throws:

  java.lang.Exception - If there was an error or if the operation should be canceled

• handleUnlockForMarketingSpotDefaultContentCollateral

  protected void handleUnlockForMarketingSpotDefaultContentCollateral(java.lang.Long emSDCCId,
                                                          java.lang.Long emSpotId)
                                                               throws java.lang.Exception
  

  Unlock the Marketing Spot default content collateral record provided.

  Parameters:

  emSDCCId - The value of the identifier for the Marketing Spot default content collateral.

  emSpotId - The value of the identifier for the Marketing Spot.

  Throws:

  java.lang.Exception - If there was an error

• handleUndoForMarketingSpotDefaultContent

  protected boolean handleUndoForMarketingSpotDefaultContent(com.ibm.commerce.contentmanagement.config.ContentManagementRelatedTable relatedTable,
                                                 java.lang.Long[] keyValues)
                                                      throws java.lang.Exception
  

  Process the Marketing Spot default content records for the current undo operation.

  Parameters:

  relatedTable - DMEMSPOTDEF table on which the operation will be performed. Table key values must be set.

  keyValues - The values to use in the query associated to relatedTable.

  Returns:

  true if the method processed sublock records.

  Throws:

  java.lang.Exception - If there was an error or if the operation should be canceled

• handleUnlockForMarketingSpotDefaultContent

  protected void handleUnlockForMarketingSpotDefaultContent(java.lang.Long emSDCId,
                                                java.lang.Long emSpotId)
                                                     throws java.lang.Exception
  

  Unlock the Marketing Spot default content record provided.

  Parameters:

  emSDCId - The value of the identifier for the Marketing Spot default content collateral.

  emSpotId - The value of the identifier for the Marketing Spot.

  Throws:

  java.lang.Exception - If there was an error