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

Class SubscriptionSQLComposer

java.lang.Object

com.ibm.commerce.foundation.server.services.dataaccess.db.jdbc.SQLComposer

com.ibm.commerce.subscription.facade.server.services.dataaccess.db.jdbc.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

Nested Class Summary

Nested classes/interfaces inherited from class com.ibm.commerce.foundation.server.services.dataaccess.db.jdbc.SQLComposer

SQLComposer.SQLComposerInfo

Field Summary

Fields

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

Constructor Summary

Constructors

Constructor and Description
SubscriptionSQLComposer()

Method Summary

Modifier and Type	Method and Description
SQLComposer.SQLComposerInfo	composeSQLStatement(java.lang.String sqlName, java.lang.String entityTableName, java.util.List resultSetInfo, java.lang.String sqlstatement, java.util.List params) Compose the SQL statement to get the list of recurring orders/subscriptions.

Methods inherited from class com.ibm.commerce.foundation.server.services.dataaccess.db.jdbc.SQLComposer

getSelectionCriteria, setSelectionCriteria

Methods inherited from class java.lang.Object

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

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