Package tigase.archive.db.derby
Class StoredProcedures
- java.lang.Object
-
- tigase.archive.db.derby.StoredProcedures
-
public class StoredProcedures extends java.lang.Object
- Author:
- andrzej
-
-
Constructor Summary
Constructors Constructor Description StoredProcedures()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static void
addMessage(java.lang.String ownerJid, java.lang.String buddyJid, java.lang.String buddyRes, java.sql.Timestamp ts, short direction, java.lang.String type, java.lang.String body, java.lang.String msg, java.lang.String hash, java.sql.ResultSet[] data)
static void
addTagToMessage(long msgId, java.lang.String tag)
protected static java.lang.StringBuilder
appendContainsQuery(java.lang.StringBuilder sb, java.lang.String contains)
protected static java.lang.StringBuilder
appendTagsQuery(java.lang.StringBuilder sb, java.lang.String tags)
static void
deleteExpiredMessages(java.lang.String domain, java.sql.Timestamp before)
static java.lang.Long
ensureJid(java.lang.String jid)
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, short byType, 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, short byType, java.sql.ResultSet[] data)
static java.lang.Long
getJidId(tigase.xmpp.jid.BareJID bareJid, java.lang.String jidSha1)
static void
getMessagePosition(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.sql.ResultSet[] data)
static void
getMessages(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 limit, java.lang.Integer offset, java.sql.ResultSet[] data)
static void
getMessagesCount(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.sql.ResultSet[] data)
static void
getTagsForUser(java.lang.String ownerJid, java.lang.String tagStartsWith, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data)
static void
getTagsForUserCount(java.lang.String ownerJid, java.lang.String tagStartsWith, java.sql.ResultSet[] data)
static void
removeMessages(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to)
protected static java.lang.String
sha1OfLower(java.lang.String data)
-
-
-
Method Detail
-
addMessage
public static void addMessage(java.lang.String ownerJid, java.lang.String buddyJid, java.lang.String buddyRes, java.sql.Timestamp ts, short direction, java.lang.String type, java.lang.String body, java.lang.String msg, java.lang.String hash, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
addTagToMessage
public static void addTagToMessage(long msgId, java.lang.String tag) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
appendContainsQuery
protected static java.lang.StringBuilder appendContainsQuery(java.lang.StringBuilder sb, java.lang.String contains)
-
appendTagsQuery
protected static java.lang.StringBuilder appendTagsQuery(java.lang.StringBuilder sb, java.lang.String tags)
-
deleteExpiredMessages
public static void deleteExpiredMessages(java.lang.String domain, java.sql.Timestamp before) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
ensureJid
public static java.lang.Long ensureJid(java.lang.String jid) 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, short byType, 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, short byType, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getJidId
public static java.lang.Long getJidId(tigase.xmpp.jid.BareJID bareJid, java.lang.String jidSha1) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getMessagePosition
public static void getMessagePosition(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.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getMessages
public static void getMessages(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 limit, java.lang.Integer offset, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getMessagesCount
public static void getMessagesCount(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.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getTagsForUser
public static void getTagsForUser(java.lang.String ownerJid, java.lang.String tagStartsWith, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getTagsForUserCount
public static void getTagsForUserCount(java.lang.String ownerJid, java.lang.String tagStartsWith, java.sql.ResultSet[] data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
removeMessages
public static void removeMessages(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
sha1OfLower
protected static java.lang.String sha1OfLower(java.lang.String data) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-