Package tigase.archive.unified.db.derby

Class StoredProcedures

java.lang.Object

tigase.archive.db.derby.StoredProcedures

tigase.archive.unified.db.derby.StoredProcedures

public class StoredProcedures
extends tigase.archive.db.derby.StoredProcedures

Author:

andrzej

Constructor Summary

Constructors

Constructor	Description
StoredProcedures()

Method Summary

Modifier and Type	Method	Description
static void	addItem(String ownerJid, String buddyJid, String buddyRes, Timestamp ts, Integer direction, String type, String body, String msg, String hash, String itemType, Integer offline, String jingleSid, String jingleAction, String jingleReason, Integer jingleOffline, ResultSet[] data)
static void	for_GetMessages(String ownerJid, String msgIds, ResultSet[] data)
static void	for_GetMessagesCount(String ownerJid, ResultSet[] data)
static void	for_GetMessagesList(String ownerJid, ResultSet[] data)
static void	for_RemoveMessages(String ownerJid, String msgIds)
static void	for_UnmarkOfflineMessages(String ownerJid, String msgIds)
static void	getCollections(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, Integer byType, String itemType, Integer offline, Integer limit, Integer offset, ResultSet[] data)
static void	getCollectionsCount(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, Integer byType, String itemType, Integer offline, ResultSet[] data)
static void	getItemPosition(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, String hash, String itemType, Integer offline, ResultSet[] data)
static void	getItems(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, String itemType, Integer offline, Integer limit, Integer offset, ResultSet[] data)
static void	getItemsCount(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, String itemType, Integer offline, ResultSet[] data)
static void	queryRecent(String ownerJid, Timestamp start, Timestamp end, Integer chat, Integer groupchat, Integer call, Integer call_success, Integer call_missed, Integer call_canceled, Integer limit, Integer offset, ResultSet[] data)
static void	queryRecentCount(String ownerJid, Timestamp start, Timestamp end, Integer chat, Integer groupchat, Integer call, Integer call_success, Integer call_missed, Integer call_canceled, ResultSet[] data)

Methods inherited from class tigase.archive.db.derby.StoredProcedures

addMessage, addTagToMessage, appendContainsQuery, appendTagsQuery, deleteExpiredMessages, ensureJid, getCollections, getCollectionsCount, getJidId, getMessagePosition, getMessages, getMessagesCount, getTagsForUser, getTagsForUserCount, removeMessages, sha1OfLower

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

addItem

public static void addItem(String ownerJid,
                           String buddyJid,
                           String buddyRes,
                           Timestamp ts,
                           Integer direction,
                           String type,
                           String body,
                           String msg,
                           String hash,
                           String itemType,
                           Integer offline,
                           String jingleSid,
                           String jingleAction,
                           String jingleReason,
                           Integer jingleOffline,
                           ResultSet[] data)
                    throws SQLException

Throws:

SQLException

for_GetMessages

public static void for_GetMessages(String ownerJid,
                                   String msgIds,
                                   ResultSet[] data)
                            throws SQLException

Throws:

SQLException

for_GetMessagesCount

public static void for_GetMessagesCount(String ownerJid,
                                        ResultSet[] data)
                                 throws SQLException

Throws:

SQLException

for_GetMessagesList

public static void for_GetMessagesList(String ownerJid,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException

for_RemoveMessages

public static void for_RemoveMessages(String ownerJid,
                                      String msgIds)
                               throws SQLException

Throws:

SQLException

for_UnmarkOfflineMessages

public static void for_UnmarkOfflineMessages(String ownerJid,
                                             String msgIds)
                                      throws SQLException

Throws:

SQLException

getCollections

public static void getCollections(String ownerJid,
                                  String buddyJid,
                                  Timestamp from,
                                  Timestamp to,
                                  String tags,
                                  String contains,
                                  Integer byType,
                                  String itemType,
                                  Integer offline,
                                  Integer limit,
                                  Integer offset,
                                  ResultSet[] data)
                           throws SQLException

Throws:

SQLException

getCollectionsCount

public static void getCollectionsCount(String ownerJid,
                                       String buddyJid,
                                       Timestamp from,
                                       Timestamp to,
                                       String tags,
                                       String contains,
                                       Integer byType,
                                       String itemType,
                                       Integer offline,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException

getItemPosition

public static void getItemPosition(String ownerJid,
                                   String buddyJid,
                                   Timestamp from,
                                   Timestamp to,
                                   String tags,
                                   String contains,
                                   String hash,
                                   String itemType,
                                   Integer offline,
                                   ResultSet[] data)
                            throws SQLException

Throws:

SQLException

getItems

public static void getItems(String ownerJid,
                            String buddyJid,
                            Timestamp from,
                            Timestamp to,
                            String tags,
                            String contains,
                            String itemType,
                            Integer offline,
                            Integer limit,
                            Integer offset,
                            ResultSet[] data)
                     throws SQLException

Throws:

SQLException

getItemsCount

public static void getItemsCount(String ownerJid,
                                 String buddyJid,
                                 Timestamp from,
                                 Timestamp to,
                                 String tags,
                                 String contains,
                                 String itemType,
                                 Integer offline,
                                 ResultSet[] data)
                          throws SQLException

Throws:

SQLException

queryRecent

public static void queryRecent(String ownerJid,
                               Timestamp start,
                               Timestamp end,
                               Integer chat,
                               Integer groupchat,
                               Integer call,
                               Integer call_success,
                               Integer call_missed,
                               Integer call_canceled,
                               Integer limit,
                               Integer offset,
                               ResultSet[] data)
                        throws SQLException

Throws:

SQLException

queryRecentCount

public static void queryRecentCount(String ownerJid,
                                    Timestamp start,
                                    Timestamp end,
                                    Integer chat,
                                    Integer groupchat,
                                    Integer call,
                                    Integer call_success,
                                    Integer call_missed,
                                    Integer call_canceled,
                                    ResultSet[] data)
                             throws SQLException

Throws:

SQLException