Package tigase.db.derby
Class MsgRepositoryStoredProcedures
java.lang.Object
tigase.db.derby.MsgRepositoryStoredProcedures
Created by andrzej on 22.03.2017.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidaddMessage(String receiver, String sender, Integer type, Timestamp ts, String message, Timestamp expired, Long limit, ResultSet[] data) static voiddeleteMessage(Long msgId) static voiddeleteMessages(String receiver, ResultSet[] data) static voiddeleteMessagesByIds(String receiver, String msgId1, String msgId2, String msgId3, String msgId4, ResultSet[] data) static voidgetExpiredMessages(int limit, ResultSet[] data) static voidgetExpiredMessagesBefore(Timestamp before, ResultSet[] data) static voidgetMessages(String receiver, ResultSet[] data) static voidgetMessagesByIds(String receiver, String msgId1, String msgId2, String msgId3, String msgId4, ResultSet[] data) static voidgetMessagesCount(String receiver, ResultSet[] data) static voidlistMessages(String receiver, ResultSet[] data)
-
Constructor Details
-
MsgRepositoryStoredProcedures
public MsgRepositoryStoredProcedures()
-
-
Method Details
-
addMessage
public static void addMessage(String receiver, String sender, Integer type, Timestamp ts, String message, Timestamp expired, Long limit, ResultSet[] data) throws SQLException - Throws:
SQLException
-
deleteMessage
- Throws:
SQLException
-
deleteMessages
- Throws:
SQLException
-
deleteMessagesByIds
public static void deleteMessagesByIds(String receiver, String msgId1, String msgId2, String msgId3, String msgId4, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getExpiredMessages
- Throws:
SQLException
-
getExpiredMessagesBefore
- Throws:
SQLException
-
getMessages
- Throws:
SQLException
-
getMessagesByIds
public static void getMessagesByIds(String receiver, String msgId1, String msgId2, String msgId3, String msgId4, ResultSet[] data) throws SQLException - Throws:
SQLException
-
getMessagesCount
- Throws:
SQLException
-
listMessages
- Throws:
SQLException
-