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, String domain, Integer autocreateService, ResultSet[] data)
static void	tigPubSubCreateService(String serviceJid, String domain, Integer isPublic, 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, String domain, Integer autocreateService)
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, Integer order, ResultSet[] data)
static void	tigPubSubGetNodeItemIdsSince(Long nodeId, Integer order, 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	tigPubSubGetServices(String domain, Integer isPublic, ResultSet[] data)
static void	tigPubSubGetUserAffiliations(String serviceJid, String jid, ResultSet[] data)
static void	tigPubSubGetUserSubscriptions(String serviceJid, String jid, ResultSet[] data)
static void	tigPubSubMamAddItem(Long nodeId, String uuid, Timestamp ts, String itemData, String itemId, ResultSet[] data)
static void	tigPubSubMamQueryItem(Long nodeId, String stableId, ResultSet[] data)
static void	tigPubSubMamQueryItemPosition(Long nodeId, Timestamp since, Timestamp to, String uuid, ResultSet[] data)
static void	tigPubSubMamQueryItems(Long nodeId, Timestamp since, Timestamp to, Integer limit, Integer offset, ResultSet[] data)
static void	tigPubSubMamQueryItemsCount(Long nodeId, Timestamp since, Timestamp to, ResultSet[] data)
static void	tigPubSubMamUpdateItem(Long nodeId, String uuid, String itemData, ResultSet[] data)
static void	tigPubSubQueryItemPosition(String nodesIds, Timestamp since, Timestamp to, Integer order, Long nodeId, String itemId, ResultSet[] data)
static void	tigPubSubQueryItems(String nodesIds, Timestamp since, Timestamp to, Integer order, Integer limit, Integer offset, ResultSet[] data)
static void	tigPubSubQueryItemsCount(String nodesIds, Timestamp since, Timestamp to, 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, String uuid, ResultSet[] data)

Methods inherited from class java.lang.Object

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

Constructor Details

StoredProcedures

public StoredProcedures()

Method Details

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,
 String domain,
 Integer autocreateService,
 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,
 String domain,
 Integer autocreateService)
                                      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,
 Integer order,
 ResultSet[] data)
                                    throws SQLException

Throws:

SQLException

tigPubSubGetNodeItemIdsSince

public static void tigPubSubGetNodeItemIdsSince(Long nodeId,
 Integer order,
 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

tigPubSubMamAddItem

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

Throws:

SQLException

tigPubSubMamUpdateItem

public static void tigPubSubMamUpdateItem(Long nodeId,
 String uuid,
 String itemData,
 ResultSet[] data)
                                   throws SQLException

Throws:

SQLException

tigPubSubMamQueryItemPosition

public static void tigPubSubMamQueryItemPosition(Long nodeId,
 Timestamp since,
 Timestamp to,
 String uuid,
 ResultSet[] data)
                                          throws SQLException

Throws:

SQLException

tigPubSubMamQueryItem

public static void tigPubSubMamQueryItem(Long nodeId,
 String stableId,
 ResultSet[] data)
                                  throws SQLException

Throws:

SQLException

tigPubSubMamQueryItems

public static void tigPubSubMamQueryItems(Long nodeId,
 Timestamp since,
 Timestamp to,
 Integer limit,
 Integer offset,
 ResultSet[] data)
                                   throws SQLException

Throws:

SQLException

tigPubSubMamQueryItemsCount

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

Throws:

SQLException

tigPubSubQueryItemPosition

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

Throws:

SQLException

tigPubSubQueryItems

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

Throws:

SQLException

tigPubSubQueryItemsCount

public static void tigPubSubQueryItemsCount(String nodesIds,
 Timestamp since,
 Timestamp to,
 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,
 String uuid,
 ResultSet[] data)
                               throws SQLException

Throws:

SQLException

tigPubSubCountNodes

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

Throws:

SQLException

tigPubSubGetServices

public static void tigPubSubGetServices(String domain,
 Integer isPublic,
 ResultSet[] data)
                                 throws SQLException

Throws:

SQLException

tigPubSubCreateService

public static void tigPubSubCreateService(String serviceJid,
 String domain,
 Integer isPublic,
 ResultSet[] data)
                                   throws SQLException

Throws:

SQLException