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, Timestamp ts, String stableId, String stanzaId, String refStableId, String body, String msg, Integer itemType, Integer offline)
static void	addItemJingle(String ownerJid, String stableId, String sid, String action, String reason, Integer offline, Integer direction)
static void	addItemOffline(String ownerJid, String stableId, String buddyRes)
static void	fm_AddItem(String ownerJid, String stableId, String urlHash, String url, String mediaType, String name, String description, Long size)
static void	fm_QueryItems(String domain, String ownerJid, String buddyJid, Timestamp after, Timestamp before, String contains, String mediaTypeContains, Long smallerThan, Long biggerThan, Integer limit, Integer offset, ResultSet[] results)
static void	fm_QueryItemsCount(String domain, String ownerJid, String buddyJid, Timestamp after, Timestamp before, String contains, String mediaTypeContains, Long smallerThan, Long biggerThan, String beforeStableId, ResultSet[] results)
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, Integer 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, Integer itemType, Integer offline, ResultSet[] data)
static void	getItemPosition(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, String stableId, Integer itemType, Integer offline, ResultSet[] data)
static void	getItems(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, Integer itemType, Integer offline, Integer limit, Integer offset, ResultSet[] data)
static void	getItemsCount(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, Integer 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, getMessage, getMessagePosition, getMessages, getMessagesCount, getTagsForUser, getTagsForUserCount, removeMessages, sha1OfLower

Methods inherited from class Object

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

Constructor Details

StoredProcedures

public StoredProcedures()

Method Details

addItem

public static void addItem(String ownerJid,
 String buddyJid,
 Timestamp ts,
 String stableId,
 String stanzaId,
 String refStableId,
 String body,
 String msg,
 Integer itemType,
 Integer offline)
                    throws SQLException

Throws:

SQLException

addItemJingle

public static void addItemJingle(String ownerJid,
 String stableId,
 String sid,
 String action,
 String reason,
 Integer offline,
 Integer direction)
                          throws SQLException

Throws:

SQLException

addItemOffline

public static void addItemOffline(String ownerJid,
 String stableId,
 String buddyRes)
                           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,
 Integer 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,
 Integer itemType,
 Integer offline,
 ResultSet[] data)
                                throws SQLException

Throws:

SQLException

getItemPosition

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

Throws:

SQLException

getItems

public static void getItems(String ownerJid,
 String buddyJid,
 Timestamp from,
 Timestamp to,
 short refType,
 String tags,
 String contains,
 Integer 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,
 short refType,
 String tags,
 String contains,
 Integer 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

fm_AddItem

public static void fm_AddItem(String ownerJid,
 String stableId,
 String urlHash,
 String url,
 String mediaType,
 String name,
 String description,
 Long size)
                       throws SQLException

Throws:

SQLException

fm_QueryItems

public static void fm_QueryItems(String domain,
 String ownerJid,
 String buddyJid,
 Timestamp after,
 Timestamp before,
 String contains,
 String mediaTypeContains,
 Long smallerThan,
 Long biggerThan,
 Integer limit,
 Integer offset,
 ResultSet[] results)
                          throws SQLException

Throws:

SQLException

fm_QueryItemsCount

public static void fm_QueryItemsCount(String domain,
 String ownerJid,
 String buddyJid,
 Timestamp after,
 Timestamp before,
 String contains,
 String mediaTypeContains,
 Long smallerThan,
 Long biggerThan,
 String beforeStableId,
 ResultSet[] results)
                               throws SQLException

Throws:

SQLException