Package tigase.archive.db.derby
Class StoredProcedures
java.lang.Object
tigase.archive.db.derby.StoredProcedures
- Author:
- andrzej
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionstatic void
addMessage
(String ownerJid, String buddyJid, Timestamp ts, String stableId, String stanzaId, String refStableId, String body, String msg) static void
addTagToMessage
(String ownerJid, String stableId, String tag) protected static StringBuilder
appendContainsQuery
(StringBuilder sb, String contains) protected static StringBuilder
appendTagsQuery
(StringBuilder sb, String tags) static void
deleteExpiredMessages
(String domain, Timestamp before) static Long
static void
getCollections
(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, Integer limit, Integer offset, ResultSet[] data) static void
getCollectionsCount
(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, ResultSet[] data) static Long
static void
getMessage
(String ownerJid, String stableId, ResultSet[] data) static void
getMessagePosition
(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, String stableId, ResultSet[] data) static void
getMessages
(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, Integer limit, Integer offset, ResultSet[] data) static void
getMessagesCount
(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, ResultSet[] data) static void
getTagsForUser
(String ownerJid, String tagStartsWith, Integer limit, Integer offset, ResultSet[] data) static void
getTagsForUserCount
(String ownerJid, String tagStartsWith, ResultSet[] data) static void
removeMessages
(String ownerJid, String buddyJid, Timestamp from, Timestamp to) protected static String
sha1OfLower
(String data)
-
Constructor Details
-
StoredProcedures
public StoredProcedures()
-
-
Method Details
-
addMessage
public static void addMessage(String ownerJid, String buddyJid, Timestamp ts, String stableId, String stanzaId, String refStableId, String body, String msg) throws SQLException - Throws:
SQLException
-
addTagToMessage
public static void addTagToMessage(String ownerJid, String stableId, String tag) throws SQLException - Throws:
SQLException
-
appendContainsQuery
-
appendTagsQuery
-
deleteExpiredMessages
- Throws:
SQLException
-
ensureJid
- Throws:
SQLException
-
getCollections
public static void getCollections(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, 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, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getJidId
- Throws:
SQLException
-
getMessagePosition
public static void getMessagePosition(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, String stableId, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getMessage
public static void getMessage(String ownerJid, String stableId, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getMessages
public static void getMessages(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, Integer limit, Integer offset, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getMessagesCount
public static void getMessagesCount(String ownerJid, String buddyJid, Timestamp from, Timestamp to, short refType, String tags, String contains, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getTagsForUser
public static void getTagsForUser(String ownerJid, String tagStartsWith, Integer limit, Integer offset, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getTagsForUserCount
public static void getTagsForUserCount(String ownerJid, String tagStartsWith, ResultSet[] data) throws SQLException - Throws:
SQLException
-
removeMessages
public static void removeMessages(String ownerJid, String buddyJid, Timestamp from, Timestamp to) throws SQLException - Throws:
SQLException
-
sha1OfLower
- Throws:
SQLException
-