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.sql.Timestamp ts, java.lang.String stableId, java.lang.String stanzaId, java.lang.String refStableId, java.lang.String body, java.lang.String msg)
static void
addTagToMessage(java.lang.String ownerJid, java.lang.String stableId, 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, 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.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, short refType, java.lang.String tags, java.lang.String contains, java.lang.String stableId, java.sql.ResultSet[] data)
static void
getMessages(java.lang.String ownerJid, java.lang.String buddyJid, java.sql.Timestamp from, java.sql.Timestamp to, short refType, 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, short refType, 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.sql.Timestamp ts, java.lang.String stableId, java.lang.String stanzaId, java.lang.String refStableId, java.lang.String body, java.lang.String msg) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
addTagToMessage
public static void addTagToMessage(java.lang.String ownerJid, java.lang.String stableId, 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, 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.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, short refType, java.lang.String tags, java.lang.String contains, java.lang.String stableId, 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, short refType, 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, short refType, 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
-
-