com.ibm.commerce.subscription.facade.server.services.dataaccess.db.jdbc

Class SubscriptionSQLComposer

  • All Implemented Interfaces:
    java.io.Serializable


    public class SubscriptionSQLComposer
    extends SQLComposer
    The SQL composer class to get the list of recurring orders based on the recurring flag and to get the list of subscriptions.
    See Also:
    Serialized Form
    • Field Summary

      Fields 
      Modifier and Type Field and Description
      static java.lang.String COPYRIGHT
      IBM copyright notice field.
    • Field Detail

      • COPYRIGHT

        public static final java.lang.String COPYRIGHT
        IBM copyright notice field.
        See Also:
        Constant Field Values
    • Constructor Detail

      • SubscriptionSQLComposer

        public SubscriptionSQLComposer()
    • Method Detail

      • composeSQLStatement

        public SQLComposer.SQLComposerInfo composeSQLStatement(java.lang.String sqlName,
                                                               java.lang.String entityTableName,
                                                               java.util.List resultSetInfo,
                                                               java.lang.String sqlstatement,
                                                               java.util.List params)
                                                        throws DataServiceSystemException
        Compose the SQL statement to get the list of recurring orders/subscriptions. Based on the SubscriptionTypeCode passed, the appropriate SQL is composed. If the SubscriptionTypeCode is 'RecurringOrder', then compose the SQL with subscription type Id set to 'NONE' and 'Recurring' flag set to 1. If the SubscriptionTypeCode is 'All', then compose the SQL with subscription type Id set to the values from the 'subscptype' table except the value 'NONE'.
        Specified by:
        composeSQLStatement in class SQLComposer
        Parameters:
        sqlName - The name of the SQL statement specified in the query template
        entityTableName - The entity table name specified in the query template
        resultSetInfo - The current resultSet information, which is a list of ResultSetData. If there is no result set information, this will an empty list and the value will never be null.
        sqlstatement - The optional SQL statement specified in the query template. This could be null if there is no SQL statement specified in the query template
        params - A list of optional parameters of type String specified in the query template. If no parameters are specified, this would be an empty list and will never be null.
        Returns:
        A structure representing the updated SQL statement, its resultSet information.
        Throws:
        DataServiceSystemException