Package tigase.db.derby
Class MsgRepositoryStoredProcedures
java.lang.Object
tigase.db.derby.MsgRepositoryStoredProcedures
Created by andrzej on 22.03.2017.
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionstatic void
addMessage
(String receiver, String sender, Integer type, Timestamp ts, String message, Timestamp expired, Long limit, ResultSet[] data) static void
deleteMessage
(Long msgId) static void
deleteMessages
(String receiver, ResultSet[] data) static void
deleteMessagesByIds
(String receiver, String msgId1, String msgId2, String msgId3, String msgId4, ResultSet[] data) static void
getExpiredMessages
(int limit, ResultSet[] data) static void
getExpiredMessagesBefore
(Timestamp before, ResultSet[] data) static void
getMessages
(String receiver, ResultSet[] data) static void
getMessagesByIds
(String receiver, String msgId1, String msgId2, String msgId3, String msgId4, ResultSet[] data) static void
getMessagesCount
(String receiver, ResultSet[] data) static void
listMessages
(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
-