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
-
Method Summary
Modifier and TypeMethodDescriptionstatic 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
-
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
- Throws:
SQLException
-
for_GetMessagesList
- Throws:
SQLException
-
for_RemoveMessages
- Throws:
SQLException
-
for_UnmarkOfflineMessages
- 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
-