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
All Methods Static Methods Concrete Methods Modifier and Type Method Description static void
addItem(java.lang.String ownerJid, java.lang.String buddyJid, java.lang.String buddyRes, java.sql.Timestamp ts, java.lang.Integer direction, java.lang.String type, java.lang.String body, java.lang.String msg, java.lang.String hash, java.lang.String itemType, java.lang.Integer offline, java.lang.String jingleSid, java.lang.String jingleAction, java.lang.String jingleReason, java.lang.Integer jingleOffline, java.sql.ResultSet[] data)
static void
for_GetMessages(java.lang.String ownerJid, java.lang.String msgIds, java.sql.ResultSet[] data)
static void
for_GetMessagesCount(java.lang.String ownerJid, java.sql.ResultSet[] data)
static void
for_GetMessagesList(java.lang.String ownerJid, java.sql.ResultSet[] data)
static void
for_RemoveMessages(java.lang.String ownerJid, java.lang.String msgIds)
static void
for_UnmarkOfflineMessages(java.lang.String ownerJid, java.lang.String msgIds)
static void
getCollections(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.Integer byType, java.lang.String itemType, java.lang.Integer offline, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data)
static void
getCollectionsCount(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.Integer byType, java.lang.String itemType, java.lang.Integer offline, java.sql.ResultSet[] data)
static void
getItemPosition(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.String hash, java.lang.String itemType, java.lang.Integer offline, java.sql.ResultSet[] data)
static void
getItems(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.String itemType, java.lang.Integer offline, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data)
static void
getItemsCount(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.String itemType, java.lang.Integer offline, java.sql.ResultSet[] data)
static void
queryRecent(java.lang.String ownerJid, java.sql.Timestamp start, java.sql.Timestamp end, java.lang.Integer chat, java.lang.Integer groupchat, java.lang.Integer call, java.lang.Integer call_success, java.lang.Integer call_missed, java.lang.Integer call_canceled, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data)
static void
queryRecentCount(java.lang.String ownerJid, java.sql.Timestamp start, java.sql.Timestamp end, java.lang.Integer chat, java.lang.Integer groupchat, java.lang.Integer call, java.lang.Integer call_success, java.lang.Integer call_missed, java.lang.Integer call_canceled, java.sql.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
-
-
-
-
Method Detail
-
addItem
public static void addItem(java.lang.String ownerJid, java.lang.String buddyJid, java.lang.String buddyRes, java.sql.Timestamp ts, java.lang.Integer direction, java.lang.String type, java.lang.String body, java.lang.String msg, java.lang.String hash, java.lang.String itemType, java.lang.Integer offline, java.lang.String jingleSid, java.lang.String jingleAction, java.lang.String jingleReason, java.lang.Integer jingleOffline, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
for_GetMessages
public static void for_GetMessages(java.lang.String ownerJid, java.lang.String msgIds, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
for_GetMessagesCount
public static void for_GetMessagesCount(java.lang.String ownerJid, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
for_GetMessagesList
public static void for_GetMessagesList(java.lang.String ownerJid, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
for_RemoveMessages
public static void for_RemoveMessages(java.lang.String ownerJid, java.lang.String msgIds) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
for_UnmarkOfflineMessages
public static void for_UnmarkOfflineMessages(java.lang.String ownerJid, java.lang.String msgIds) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getCollections
public static void getCollections(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.Integer byType, java.lang.String itemType, java.lang.Integer offline, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getCollectionsCount
public static void getCollectionsCount(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.Integer byType, java.lang.String itemType, java.lang.Integer offline, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getItemPosition
public static void getItemPosition(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.String hash, java.lang.String itemType, java.lang.Integer offline, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getItems
public static void getItems(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.String itemType, java.lang.Integer offline, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getItemsCount
public static void getItemsCount(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, java.lang.String tags, java.lang.String contains, java.lang.String itemType, java.lang.Integer offline, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
queryRecent
public static void queryRecent(java.lang.String ownerJid, java.sql.Timestamp start, java.sql.Timestamp end, java.lang.Integer chat, java.lang.Integer groupchat, java.lang.Integer call, java.lang.Integer call_success, java.lang.Integer call_missed, java.lang.Integer call_canceled, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
queryRecentCount
public static void queryRecentCount(java.lang.String ownerJid, java.sql.Timestamp start, java.sql.Timestamp end, java.lang.Integer chat, java.lang.Integer groupchat, java.lang.Integer call, java.lang.Integer call_success, java.lang.Integer call_missed, java.lang.Integer call_canceled, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-