Package tigase.muc.repository.derby

Class StoredProcedures

java.lang.Object

tigase.muc.repository.derby.StoredProcedures

public class StoredProcedures
extends Object

Created by andrzej on 19.10.2016.

Constructor Summary

Constructors

Constructor	Description
StoredProcedures()

Method Summary

Modifier and Type	Method	Description
static void	migrateFromOldSchema()
protected static String	sha1OfLower(String data)
static void	tigMucAddMessage(String roomJid, Timestamp ts, String senderJid, String senderNick, String body, Boolean publicEvent, String msg)
static void	tigMucCreateRoom(String roomJid, String creatorJid, Timestamp creationDate, String roomName, String roomConfig, ResultSet[] data)
static void	tigMucDeleteMessages(String roomJid)
static void	tigMucDestroyRoom(String roomJid)
static void	tigMucGetAvatar(Long id, ResultSet[] data)
static void	tigMucGetMessages(String roomJid, Integer maxMessages, Timestamp since, ResultSet[] data)
static void	tigMucGetRoom(String roomJid, ResultSet[] data)
static void	tigMucGetRoomAffiliations(Long roomId, ResultSet[] data)
static void	tigMucGetRoomsJids(ResultSet[] data)
static void	tigMucMamGetMessagePosition(String roomJid, Timestamp since, Timestamp to, String nickname, Timestamp id_ts, ResultSet[] data)
static void	tigMucMamGetMessages(String roomJid, Timestamp since, Timestamp to, String nickname, Integer limit, Integer offset, ResultSet[] data)
static void	tigMucMamGetMessagesCount(String roomJid, Timestamp since, Timestamp to, String nickname, ResultSet[] data)
static void	tigMucSetAvatar(Long roomId, Clob avatar, String avatarHash)
static void	tigMucSetRoomAffiliation(Long roomId, String jid, String affiliation, Boolean persistent, String nickname)
static void	tigMucSetRoomConfig(String roomJid, String name, String config)
static void	tigMucSetRoomSubject(Long roomId, String subject, String creator, Timestamp changeDate)

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

migrateFromOldSchema

public static void migrateFromOldSchema()
                                 throws SQLException

Throws:

SQLException

sha1OfLower

protected static String sha1OfLower(String data)
                             throws SQLException

Throws:

SQLException

tigMucAddMessage

public static void tigMucAddMessage(String roomJid,
                                    Timestamp ts,
                                    String senderJid,
                                    String senderNick,
                                    String body,
                                    Boolean publicEvent,
                                    String msg)
                             throws SQLException

Throws:

SQLException

tigMucCreateRoom

public static void tigMucCreateRoom(String roomJid,
                                    String creatorJid,
                                    Timestamp creationDate,
                                    String roomName,
                                    String roomConfig,
                                    ResultSet[] data)
                             throws SQLException

Throws:

SQLException

tigMucDeleteMessages

public static void tigMucDeleteMessages(String roomJid)
                                 throws SQLException

Throws:

SQLException

tigMucDestroyRoom

public static void tigMucDestroyRoom(String roomJid)
                              throws SQLException

Throws:

SQLException

tigMucGetAvatar

public static void tigMucGetAvatar(Long id,
                                   ResultSet[] data)
                            throws SQLException

Throws:

SQLException

tigMucGetMessages

public static void tigMucGetMessages(String roomJid,
                                     Integer maxMessages,
                                     Timestamp since,
                                     ResultSet[] data)
                              throws SQLException

Throws:

SQLException

tigMucGetRoom

public static void tigMucGetRoom(String roomJid,
                                 ResultSet[] data)
                          throws SQLException

Throws:

SQLException

tigMucGetRoomAffiliations

public static void tigMucGetRoomAffiliations(Long roomId,
                                             ResultSet[] data)
                                      throws SQLException

Throws:

SQLException

tigMucGetRoomsJids

public static void tigMucGetRoomsJids(ResultSet[] data)
                               throws SQLException

Throws:

SQLException

tigMucMamGetMessagePosition

public static void tigMucMamGetMessagePosition(String roomJid,
                                               Timestamp since,
                                               Timestamp to,
                                               String nickname,
                                               Timestamp id_ts,
                                               ResultSet[] data)
                                        throws SQLException

Throws:

SQLException

tigMucMamGetMessages

public static void tigMucMamGetMessages(String roomJid,
                                        Timestamp since,
                                        Timestamp to,
                                        String nickname,
                                        Integer limit,
                                        Integer offset,
                                        ResultSet[] data)
                                 throws SQLException

Throws:

SQLException

tigMucMamGetMessagesCount

public static void tigMucMamGetMessagesCount(String roomJid,
                                             Timestamp since,
                                             Timestamp to,
                                             String nickname,
                                             ResultSet[] data)
                                      throws SQLException

Throws:

SQLException

tigMucSetAvatar

public static void tigMucSetAvatar(Long roomId,
                                   Clob avatar,
                                   String avatarHash)
                            throws SQLException

Throws:

SQLException

tigMucSetRoomAffiliation

public static void tigMucSetRoomAffiliation(Long roomId,
                                            String jid,
                                            String affiliation,
                                            Boolean persistent,
                                            String nickname)
                                     throws SQLException

Throws:

SQLException

tigMucSetRoomConfig

public static void tigMucSetRoomConfig(String roomJid,
                                       String name,
                                       String config)
                                throws SQLException

Throws:

SQLException

tigMucSetRoomSubject

public static void tigMucSetRoomSubject(Long roomId,
                                        String subject,
                                        String creator,
                                        Timestamp changeDate)
                                 throws SQLException

Throws:

SQLException