tigase.archive.db.derby

Class StoredProcedures

java.lang.Object

tigase.archive.db.derby.StoredProcedures

public class StoredProcedures
extends Object

Author:

andrzej

Constructor Summary

Constructors

Constructor and Description
StoredProcedures()

Method Summary

Modifier and Type	Method and Description
static void	addMessage(String ownerJid, String buddyJid, String buddyRes, Timestamp ts, short direction, String type, String body, String msg, String hash, ResultSet[] data)
static void	addTagToMessage(long msgId, 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	ensureJid(String jid)
static void	getCollections(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, short byType, Integer limit, Integer offset, ResultSet[] data)
static void	getCollectionsCount(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, short byType, ResultSet[] data)
static Long	getJidId(tigase.xmpp.BareJID bareJid, String jidSha1)
static void	getMessagePosition(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, String hash, ResultSet[] data)
static void	getMessages(String ownerJid, String buddyJid, Timestamp from, Timestamp to, String tags, String contains, Integer limit, Integer offset, ResultSet[] data)
static void	getMessagesCount(String ownerJid, String buddyJid, Timestamp from, Timestamp to, 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)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

StoredProcedures

public StoredProcedures()

Method Detail

getMessages

public static void getMessages(String ownerJid,
                               String buddyJid,
                               Timestamp from,
                               Timestamp to,
                               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,
                                    String tags,
                                    String contains,
                                    ResultSet[] data)
                             throws SQLException

Throws:

SQLException

getMessagePosition

public static void getMessagePosition(String ownerJid,
                                      String buddyJid,
                                      Timestamp from,
                                      Timestamp to,
                                      String tags,
                                      String contains,
                                      String hash,
                                      ResultSet[] data)
                               throws SQLException

Throws:

SQLException

getCollections

public static void getCollections(String ownerJid,
                                  String buddyJid,
                                  Timestamp from,
                                  Timestamp to,
                                  String tags,
                                  String contains,
                                  short byType,
                                  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,
                                       short byType,
                                       ResultSet[] data)
                                throws SQLException

Throws:

SQLException

getJidId

public static Long getJidId(tigase.xmpp.BareJID bareJid,
                            String jidSha1)
                     throws SQLException

Throws:

SQLException

ensureJid

public static Long ensureJid(String jid)
                      throws SQLException

Throws:

SQLException

addMessage

public static void addMessage(String ownerJid,
                              String buddyJid,
                              String buddyRes,
                              Timestamp ts,
                              short direction,
                              String type,
                              String body,
                              String msg,
                              String hash,
                              ResultSet[] data)
                       throws SQLException

Throws:

SQLException

addTagToMessage

public static void addTagToMessage(long msgId,
                                   String tag)
                            throws SQLException

Throws:

SQLException

removeMessages

public static void removeMessages(String ownerJid,
                                  String buddyJid,
                                  Timestamp from,
                                  Timestamp to)
                           throws SQLException

Throws:

SQLException

deleteExpiredMessages

public static void deleteExpiredMessages(String domain,
                                         Timestamp before)
                                  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

appendTagsQuery

protected static StringBuilder appendTagsQuery(StringBuilder sb,
                                               String tags)

appendContainsQuery

protected static StringBuilder appendContainsQuery(StringBuilder sb,
                                                   String contains)

sha1OfLower

protected static String sha1OfLower(String data)
                             throws SQLException

Throws:

SQLException