Package tigase.pubsub.repository.derby

Class StoredProcedures

java.lang.Object

tigase.pubsub.repository.derby.StoredProcedures

public class StoredProcedures
extends Object

Author:

andrzej

Constructor Summary

Constructors

Constructor	Description
StoredProcedures()

Method Summary

Modifier and Type	Method	Description
protected static Long	getIdOfJid(Connection conn, String jid)
protected static String	sha1OfLower(String data)
static void	tigPubSubCountNodes(String serviceJid, ResultSet[] data)
static void	tigPubSubCreateNode(String serviceJid, String nodeName, Integer nodeType, String nodeCreator, String nodeConf, Long collectionId, Timestamp ts, ResultSet[] data)
static void	tigPubSubDeleteAllNodes(String serviceJid, ResultSet[] data)
static void	tigPubSubDeleteItem(Long nodeId, String itemId, ResultSet[] data)
static void	tigPubSubDeleteNodeSubscription(Long nodeId, String jid, ResultSet[] data)
static Long	tigPubSubEnsureJid(String jid)
static Long	tigPubSubEnsureJid(Connection conn, String jid)
static Long	tigPubSubEnsureServiceJid(String serviceJid)
static void	tigPubSubFixItem(Long nodeId, String itemId, Timestamp creationDate, Timestamp updateDate)
static void	tigPubSubFixNode(Long nodeId, Timestamp creationDate)
static void	tigPubSubGetAllNodes(String serviceJid, ResultSet[] data)
static void	tigPubSubGetChildNodes(String serviceJid, String collection, ResultSet[] data)
static void	tigPubSubGetItem(Long nodeId, String itemId, ResultSet[] data)
static void	tigPubSubGetNodeAffiliations(Long nodeId, ResultSet[] data)
static void	tigPubSubGetNodeConfiguration(Long nodeId, ResultSet[] data)
static void	tigPubSubGetNodeId(String serviceJid, String nodeName, ResultSet[] data)
static void	tigPubSubGetNodeItemIds(Long nodeId, ResultSet[] data)
static void	tigPubSubGetNodeItemIdsSince(Long nodeId, Timestamp since, ResultSet[] data)
static void	tigPubSubGetNodeItemsMeta(Long nodeId, ResultSet[] data)
static void	tigPubSubGetNodeMeta(String serviceJid, String nodeName, ResultSet[] data)
static void	tigPubSubGetNodeSubscriptions(Long nodeId, ResultSet[] data)
static void	tigPubSubGetRootNodes(String serviceJid, ResultSet[] data)
static void	tigPubSubGetUserAffiliations(String serviceJid, String jid, ResultSet[] data)
static void	tigPubSubGetUserSubscriptions(String serviceJid, String jid, ResultSet[] data)
static void	tigPubSubMamQueryItemPosition(String nodesIds, Timestamp since, Timestamp to, String publisher, Integer order, Long nodeId, String itemId, ResultSet[] data)
static void	tigPubSubMamQueryItems(String nodesIds, Timestamp since, Timestamp to, String publisher, Integer order, Integer limit, Integer offset, ResultSet[] data)
static void	tigPubSubMamQueryItemsCount(String nodesIds, Timestamp since, Timestamp to, String publisher, Integer order, ResultSet[] data)
static void	tigPubSubRemoveNode(Long nodeId, ResultSet[] data)
static void	tigPubSubRemoveService(String serviceJid, ResultSet[] data)
static void	tigPubSubSetNodeAffiliation(Long nodeId, String jid, String affil, ResultSet[] data)
static void	tigPubSubSetNodeConfiguration(Long nodeId, String conf, Long collectionId, ResultSet[] data)
static void	tigPubSubSetNodeSubscription(Long nodeId, String jid, String subscr, String subscrId, ResultSet[] data)
static void	tigPubSubWriteItem(Long nodeId, String itemId, String publisher, String itemData, Timestamp ts, ResultSet[] data)

Methods inherited from class java.lang.Object

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

Constructor Detail

StoredProcedures

public StoredProcedures()

Method Detail

getIdOfJid

protected static Long getIdOfJid(Connection conn,
                                 String jid)
                          throws SQLException

Throws:

SQLException

sha1OfLower

protected static String sha1OfLower(String data)
                             throws SQLException

Throws:

SQLException

tigPubSubCreateNode

public static void tigPubSubCreateNode(String serviceJid,
                                       String nodeName,
                                       Integer nodeType,
                                       String nodeCreator,
                                       String nodeConf,
                                       Long collectionId,
                                       Timestamp ts,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException

tigPubSubDeleteAllNodes

public static void tigPubSubDeleteAllNodes(String serviceJid,
                                           ResultSet[] data)
                                    throws SQLException

Throws:

SQLException

tigPubSubDeleteItem

public static void tigPubSubDeleteItem(Long nodeId,
                                       String itemId,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException

tigPubSubDeleteNodeSubscription

public static void tigPubSubDeleteNodeSubscription(Long nodeId,
                                                   String jid,
                                                   ResultSet[] data)
                                            throws SQLException

Throws:

SQLException

tigPubSubEnsureJid

public static Long tigPubSubEnsureJid(String jid)
                               throws SQLException

Throws:

SQLException

tigPubSubEnsureJid

public static Long tigPubSubEnsureJid(Connection conn,
                                      String jid)
                               throws SQLException

Throws:

SQLException

tigPubSubEnsureServiceJid

public static Long tigPubSubEnsureServiceJid(String serviceJid)
                                      throws SQLException

Throws:

SQLException

tigPubSubFixItem

public static void tigPubSubFixItem(Long nodeId,
                                    String itemId,
                                    Timestamp creationDate,
                                    Timestamp updateDate)
                             throws SQLException

Throws:

SQLException

tigPubSubFixNode

public static void tigPubSubFixNode(Long nodeId,
                                    Timestamp creationDate)
                             throws SQLException

Throws:

SQLException

tigPubSubGetAllNodes

public static void tigPubSubGetAllNodes(String serviceJid,
                                        ResultSet[] data)
                                 throws SQLException

Throws:

SQLException

tigPubSubGetChildNodes

public static void tigPubSubGetChildNodes(String serviceJid,
                                          String collection,
                                          ResultSet[] data)
                                   throws SQLException

Throws:

SQLException

tigPubSubGetItem

public static void tigPubSubGetItem(Long nodeId,
                                    String itemId,
                                    ResultSet[] data)
                             throws SQLException

Throws:

SQLException

tigPubSubGetNodeAffiliations

public static void tigPubSubGetNodeAffiliations(Long nodeId,
                                                ResultSet[] data)
                                         throws SQLException

Throws:

SQLException

tigPubSubGetNodeConfiguration

public static void tigPubSubGetNodeConfiguration(Long nodeId,
                                                 ResultSet[] data)
                                          throws SQLException

Throws:

SQLException

tigPubSubGetNodeId

public static void tigPubSubGetNodeId(String serviceJid,
                                      String nodeName,
                                      ResultSet[] data)
                               throws SQLException

Throws:

SQLException

tigPubSubGetNodeItemIds

public static void tigPubSubGetNodeItemIds(Long nodeId,
                                           ResultSet[] data)
                                    throws SQLException

Throws:

SQLException

tigPubSubGetNodeItemIdsSince

public static void tigPubSubGetNodeItemIdsSince(Long nodeId,
                                                Timestamp since,
                                                ResultSet[] data)
                                         throws SQLException

Throws:

SQLException

tigPubSubGetNodeItemsMeta

public static void tigPubSubGetNodeItemsMeta(Long nodeId,
                                             ResultSet[] data)
                                      throws SQLException

Throws:

SQLException

tigPubSubGetNodeMeta

public static void tigPubSubGetNodeMeta(String serviceJid,
                                        String nodeName,
                                        ResultSet[] data)
                                 throws SQLException

Throws:

SQLException

tigPubSubGetNodeSubscriptions

public static void tigPubSubGetNodeSubscriptions(Long nodeId,
                                                 ResultSet[] data)
                                          throws SQLException

Throws:

SQLException

tigPubSubGetRootNodes

public static void tigPubSubGetRootNodes(String serviceJid,
                                         ResultSet[] data)
                                  throws SQLException

Throws:

SQLException

tigPubSubGetUserAffiliations

public static void tigPubSubGetUserAffiliations(String serviceJid,
                                                String jid,
                                                ResultSet[] data)
                                         throws SQLException

Throws:

SQLException

tigPubSubGetUserSubscriptions

public static void tigPubSubGetUserSubscriptions(String serviceJid,
                                                 String jid,
                                                 ResultSet[] data)
                                          throws SQLException

Throws:

SQLException

tigPubSubMamQueryItemPosition

public static void tigPubSubMamQueryItemPosition(String nodesIds,
                                                 Timestamp since,
                                                 Timestamp to,
                                                 String publisher,
                                                 Integer order,
                                                 Long nodeId,
                                                 String itemId,
                                                 ResultSet[] data)
                                          throws SQLException

Throws:

SQLException

tigPubSubMamQueryItems

public static void tigPubSubMamQueryItems(String nodesIds,
                                          Timestamp since,
                                          Timestamp to,
                                          String publisher,
                                          Integer order,
                                          Integer limit,
                                          Integer offset,
                                          ResultSet[] data)
                                   throws SQLException

Throws:

SQLException

tigPubSubMamQueryItemsCount

public static void tigPubSubMamQueryItemsCount(String nodesIds,
                                               Timestamp since,
                                               Timestamp to,
                                               String publisher,
                                               Integer order,
                                               ResultSet[] data)
                                        throws SQLException

Throws:

SQLException

tigPubSubRemoveNode

public static void tigPubSubRemoveNode(Long nodeId,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException

tigPubSubRemoveService

public static void tigPubSubRemoveService(String serviceJid,
                                          ResultSet[] data)
                                   throws SQLException

Throws:

SQLException

tigPubSubSetNodeAffiliation

public static void tigPubSubSetNodeAffiliation(Long nodeId,
                                               String jid,
                                               String affil,
                                               ResultSet[] data)
                                        throws SQLException

Throws:

SQLException

tigPubSubSetNodeConfiguration

public static void tigPubSubSetNodeConfiguration(Long nodeId,
                                                 String conf,
                                                 Long collectionId,
                                                 ResultSet[] data)
                                          throws SQLException

Throws:

SQLException

tigPubSubSetNodeSubscription

public static void tigPubSubSetNodeSubscription(Long nodeId,
                                                String jid,
                                                String subscr,
                                                String subscrId,
                                                ResultSet[] data)
                                         throws SQLException

Throws:

SQLException

tigPubSubWriteItem

public static void tigPubSubWriteItem(Long nodeId,
                                      String itemId,
                                      String publisher,
                                      String itemData,
                                      Timestamp ts,
                                      ResultSet[] data)
                               throws SQLException

Throws:

SQLException

tigPubSubCountNodes

public static void tigPubSubCountNodes(String serviceJid,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException