cgl.narada.service.storage.db
Class DatabaseStatements

java.lang.Object
  cgl.narada.service.storage.db.DatabaseStatements

public class DatabaseStatements
extends Object

Title: DatabaseStatements

Description: Statements for Mysql

Copyright: Copyright (c) 2005

Method Summary

void	executeDeleteFromEntity13Stmt(String entityId)
void	executeDeleteFromEntityInventory13Stmt(String sequenceNumber)
void	executeDeleteFromEntityInventory25Stmt(String sequenceNumber, String entityId)
void	executeDeleteFromEntityTemplate15Stmt(String entityId, String templateId)
void	executeDeleteFromInventoryFull13Stmt(String sequenceNumber)
void	executeDeleteFromInventoryLight13(String sequenceNumber)
void	executeDeleteFromProfile15Stmt(String templateId, String profileId)
void	executeDeleteFromTemplate13Stmt(String templateId)
void	executeDeleteFromTimestampInfo13Stmt(String sequenceNumber)
void	executeInsertIntoEntityInventoryStmt(String sequenceNumber, String destAddr)
void	executeInsertIntoEntityStmt(String entityId)
void	executeInsertIntoEntityTemplateStmt(String templateId, String entityId)
void	executeInsertIntoInventoryFullStmt(String sequenceNumber, String previousSequenceNumber, String eventID, byte[] eventString, String templateId)
void	executeInsertIntoInventoryLightStmt(String sequenceNumber, String previousSequenceNumber, String templateId, String catenation, String status)
void	executeInsertIntoProfileStmt(String profileId, String profileType, byte[] subscription, String templateId, String destinationAddress)
void	executeInsertIntoTemplateStmt(String templateID, String templateType, byte[] templateInfo)
void	executeInsertIntoTimestampInfoStmt(String sequenceNumber, String timestamp, String templateId)
ResultSet	executeInventoryLightCompleteRowDESCStmt(String templateId)
ResultSet	executeInventoryLightCompleteRowStmt(String templateId)
ResultSet	executeSelectAllFromEntity9Stmt()
ResultSet	executeSelectAllFromEntityInventoryStmt(String sequenceNumber)
ResultSet	executeSelectCatenationFromEntityTemplateStmt(String templateId, String entityId)
ResultSet	executeSelectEntityIdFromEntityTemplateStmt(String templateId)
ResultSet	executeSelectEventFromInventoryFullStmt(String sequenceNumber)
ResultSet	executeSelectMAXSeqNumberFromEntityInventoryStmt()
ResultSet	executeSelectMAXSeqNumberFromInventoryFullStmt()
ResultSet	executeSelectMAXSeqNumberFromInventoryLight1Stmt()
ResultSet	executeSelectMAXSeqNumberFromInventoryLight2Stmt(String templateId)
ResultSet	executeSelectMAXSeqNumberTimestampFromTimestampInfoStmt(String templateId)
ResultSet	executeSelectMINSeqNumberTimestampFromTimestampInfoStmt(String templateId)
ResultSet	executeSelectProfileTypeSubscriptionFromProfileStmt(String templateId)
ResultSet	executeSelectSeqNumberFromEntityInventoryInventoryLightStmt(String seqNumber1, String seqNumber2, String entityId, String templateId)
ResultSet	executeSelectSeqNumberFromInventoryLight15Stmt(String templateId)
ResultSet	executeSelectSeqNumberFromInventoryLight29Stmt(String seqNumber1, String seqNumber2, String templateId)
ResultSet	executeSelectSeqNumberFromTimestampInfoStmt(String templateId, String timestamp1, String timestamp2)
ResultSet	executeSelectSeqNumberTimestampFromTimestampInfo15Stmt(String templateId)
ResultSet	executeSelectSeqNumberTimestampFromTimestampInfo29Stmt(String templateId, String timestamp1, String timestamp2)
ResultSet	executeSelectSeqNumberTimestampFromTimestampInfo39Stmt(String templateId, String sequenceNumber, String timestamp)
ResultSet	executeSelectSyncpointFromEntityTemplateStmt(String templateId, String entityId)
ResultSet	executeSelectTemplateBytesFromTemplateStmt()
ResultSet	executeSelectTimestampFromTimestampInfoStmt(String templateId, String sequenceNumber)
ResultSet	executeTimestampInfoCompleteRowDESCStmt(String templateId)
ResultSet	executeTimestampInfoCompleteRowStmt(String templateId)
void	executeUpdateEntityInventory16Stmt(String entityId1, String sequenceNumber, String entityId2)
void	executeUpdateEntityTemplate16Stmt(String syncpoint, String templateId, String entityId)
void	executeUpdateEntityTemplate26Stmt(String catenation, String templateId, String entityId)
void	executeUpdateInventoryLightStatusStmt(int status)
static DatabaseStatements	getInstance()
void	initialize(Connection connection, DataAccessObject storageDao)
void	initializeDeleteAndUpdateStatements()
void	initializeInsertIntoStatements()
void	initializeSelectStatements()
void	initializeUpdateStatements()
static void	main(String[] args)

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static DatabaseStatements getInstance()

initialize

public void initialize(Connection connection,
                       DataAccessObject storageDao)

initializeUpdateStatements

public void initializeUpdateStatements()

initializeInsertIntoStatements

public void initializeInsertIntoStatements()

initializeDeleteAndUpdateStatements

public void initializeDeleteAndUpdateStatements()

initializeSelectStatements

public void initializeSelectStatements()

executeUpdateInventoryLightStatusStmt

public void executeUpdateInventoryLightStatusStmt(int status)
                                           throws ServiceException

Throws:

ServiceException

executeInsertIntoEntityStmt

public void executeInsertIntoEntityStmt(String entityId)
                                 throws ServiceException

Throws:

ServiceException

executeInsertIntoEntityInventoryStmt

public void executeInsertIntoEntityInventoryStmt(String sequenceNumber,
                                                 String destAddr)
                                          throws ServiceException

Throws:

ServiceException

executeInsertIntoEntityTemplateStmt

public void executeInsertIntoEntityTemplateStmt(String templateId,
                                                String entityId)
                                         throws ServiceException

Throws:

ServiceException

executeInsertIntoInventoryFullStmt

public void executeInsertIntoInventoryFullStmt(String sequenceNumber,
                                               String previousSequenceNumber,
                                               String eventID,
                                               byte[] eventString,
                                               String templateId)
                                        throws ServiceException

Throws:

ServiceException

executeInsertIntoInventoryLightStmt

public void executeInsertIntoInventoryLightStmt(String sequenceNumber,
                                                String previousSequenceNumber,
                                                String templateId,
                                                String catenation,
                                                String status)
                                         throws ServiceException

Throws:

ServiceException

executeInsertIntoProfileStmt

public void executeInsertIntoProfileStmt(String profileId,
                                         String profileType,
                                         byte[] subscription,
                                         String templateId,
                                         String destinationAddress)
                                  throws ServiceException

Throws:

ServiceException

executeInsertIntoTemplateStmt

public void executeInsertIntoTemplateStmt(String templateID,
                                          String templateType,
                                          byte[] templateInfo)
                                   throws ServiceException

Throws:

ServiceException

executeInsertIntoTimestampInfoStmt

public void executeInsertIntoTimestampInfoStmt(String sequenceNumber,
                                               String timestamp,
                                               String templateId)
                                        throws ServiceException

Throws:

ServiceException

executeDeleteFromEntity13Stmt

public void executeDeleteFromEntity13Stmt(String entityId)
                                   throws ServiceException

Throws:

ServiceException

executeDeleteFromEntityInventory13Stmt

public void executeDeleteFromEntityInventory13Stmt(String sequenceNumber)
                                            throws ServiceException

Throws:

ServiceException

executeDeleteFromEntityInventory25Stmt

public void executeDeleteFromEntityInventory25Stmt(String sequenceNumber,
                                                   String entityId)
                                            throws ServiceException

Throws:

ServiceException

executeDeleteFromEntityTemplate15Stmt

public void executeDeleteFromEntityTemplate15Stmt(String entityId,
                                                  String templateId)
                                           throws ServiceException

Throws:

ServiceException

executeDeleteFromInventoryFull13Stmt

public void executeDeleteFromInventoryFull13Stmt(String sequenceNumber)
                                          throws ServiceException

Throws:

ServiceException

executeDeleteFromInventoryLight13

public void executeDeleteFromInventoryLight13(String sequenceNumber)
                                       throws ServiceException

Throws:

ServiceException

executeDeleteFromProfile15Stmt

public void executeDeleteFromProfile15Stmt(String templateId,
                                           String profileId)
                                    throws ServiceException

Throws:

ServiceException

executeDeleteFromTemplate13Stmt

public void executeDeleteFromTemplate13Stmt(String templateId)
                                     throws ServiceException

Throws:

ServiceException

executeDeleteFromTimestampInfo13Stmt

public void executeDeleteFromTimestampInfo13Stmt(String sequenceNumber)
                                          throws ServiceException

Throws:

ServiceException

executeUpdateEntityTemplate16Stmt

public void executeUpdateEntityTemplate16Stmt(String syncpoint,
                                              String templateId,
                                              String entityId)
                                       throws ServiceException

Throws:

ServiceException

executeUpdateEntityTemplate26Stmt

public void executeUpdateEntityTemplate26Stmt(String catenation,
                                              String templateId,
                                              String entityId)
                                       throws ServiceException

Throws:

ServiceException

executeUpdateEntityInventory16Stmt

public void executeUpdateEntityInventory16Stmt(String entityId1,
                                               String sequenceNumber,
                                               String entityId2)
                                        throws ServiceException

Throws:

ServiceException

executeSelectTemplateBytesFromTemplateStmt

public ResultSet executeSelectTemplateBytesFromTemplateStmt()
                                                     throws ServiceException

Throws:

ServiceException

executeSelectAllFromEntity9Stmt

public ResultSet executeSelectAllFromEntity9Stmt()
                                          throws ServiceException

Throws:

ServiceException

executeSelectMAXSeqNumberFromInventoryFullStmt

public ResultSet executeSelectMAXSeqNumberFromInventoryFullStmt()
                                                         throws ServiceException

Throws:

ServiceException

executeSelectMAXSeqNumberFromInventoryLight1Stmt

public ResultSet executeSelectMAXSeqNumberFromInventoryLight1Stmt()
                                                           throws ServiceException

Throws:

ServiceException

executeSelectMAXSeqNumberFromEntityInventoryStmt

public ResultSet executeSelectMAXSeqNumberFromEntityInventoryStmt()
                                                           throws ServiceException

Throws:

ServiceException

executeSelectEntityIdFromEntityTemplateStmt

public ResultSet executeSelectEntityIdFromEntityTemplateStmt(String templateId)
                                                      throws ServiceException

Throws:

ServiceException

executeSelectEventFromInventoryFullStmt

public ResultSet executeSelectEventFromInventoryFullStmt(String sequenceNumber)
                                                  throws ServiceException

Throws:

ServiceException

executeSelectMAXSeqNumberFromInventoryLight2Stmt

public ResultSet executeSelectMAXSeqNumberFromInventoryLight2Stmt(String templateId)
                                                           throws ServiceException

Throws:

ServiceException

executeSelectProfileTypeSubscriptionFromProfileStmt

public ResultSet executeSelectProfileTypeSubscriptionFromProfileStmt(String templateId)
                                                              throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberTimestampFromTimestampInfo15Stmt

public ResultSet executeSelectSeqNumberTimestampFromTimestampInfo15Stmt(String templateId)
                                                                 throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberFromInventoryLight15Stmt

public ResultSet executeSelectSeqNumberFromInventoryLight15Stmt(String templateId)
                                                         throws ServiceException

Throws:

ServiceException

executeSelectMINSeqNumberTimestampFromTimestampInfoStmt

public ResultSet executeSelectMINSeqNumberTimestampFromTimestampInfoStmt(String templateId)
                                                                  throws ServiceException

Throws:

ServiceException

executeSelectMAXSeqNumberTimestampFromTimestampInfoStmt

public ResultSet executeSelectMAXSeqNumberTimestampFromTimestampInfoStmt(String templateId)
                                                                  throws ServiceException

Throws:

ServiceException

executeSelectSyncpointFromEntityTemplateStmt

public ResultSet executeSelectSyncpointFromEntityTemplateStmt(String templateId,
                                                              String entityId)
                                                       throws ServiceException

Throws:

ServiceException

executeSelectCatenationFromEntityTemplateStmt

public ResultSet executeSelectCatenationFromEntityTemplateStmt(String templateId,
                                                               String entityId)
                                                        throws ServiceException

Throws:

ServiceException

executeSelectAllFromEntityInventoryStmt

public ResultSet executeSelectAllFromEntityInventoryStmt(String sequenceNumber)
                                                  throws ServiceException

Throws:

ServiceException

executeSelectTimestampFromTimestampInfoStmt

public ResultSet executeSelectTimestampFromTimestampInfoStmt(String templateId,
                                                             String sequenceNumber)
                                                      throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberFromTimestampInfoStmt

public ResultSet executeSelectSeqNumberFromTimestampInfoStmt(String templateId,
                                                             String timestamp1,
                                                             String timestamp2)
                                                      throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberTimestampFromTimestampInfo29Stmt

public ResultSet executeSelectSeqNumberTimestampFromTimestampInfo29Stmt(String templateId,
                                                                        String timestamp1,
                                                                        String timestamp2)
                                                                 throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberTimestampFromTimestampInfo39Stmt

public ResultSet executeSelectSeqNumberTimestampFromTimestampInfo39Stmt(String templateId,
                                                                        String sequenceNumber,
                                                                        String timestamp)
                                                                 throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberFromInventoryLight29Stmt

public ResultSet executeSelectSeqNumberFromInventoryLight29Stmt(String seqNumber1,
                                                                String seqNumber2,
                                                                String templateId)
                                                         throws ServiceException

Throws:

ServiceException

executeSelectSeqNumberFromEntityInventoryInventoryLightStmt

public ResultSet executeSelectSeqNumberFromEntityInventoryInventoryLightStmt(String seqNumber1,
                                                                             String seqNumber2,
                                                                             String entityId,
                                                                             String templateId)
                                                                      throws ServiceException

Throws:

ServiceException

executeTimestampInfoCompleteRowStmt

public ResultSet executeTimestampInfoCompleteRowStmt(String templateId)
                                              throws ServiceException

Throws:

ServiceException

executeTimestampInfoCompleteRowDESCStmt

public ResultSet executeTimestampInfoCompleteRowDESCStmt(String templateId)
                                                  throws ServiceException

Throws:

ServiceException

executeInventoryLightCompleteRowStmt

public ResultSet executeInventoryLightCompleteRowStmt(String templateId)
                                               throws ServiceException

Throws:

ServiceException

executeInventoryLightCompleteRowDESCStmt

public ResultSet executeInventoryLightCompleteRowDESCStmt(String templateId)
                                                   throws ServiceException

Throws:

ServiceException

main

public static void main(String[] args)