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, String stableId, 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	tigMucGetMessage(String roomJid, String stableId, 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, String stableId, 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	tigMucMamUpdateMessage(String roomJid, String stableId, String body, String msg)
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 Details

StoredProcedures

public StoredProcedures()

Method Details

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,
 String stableId,
 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

tigMucGetMessage

public static void tigMucGetMessage(String roomJid,
 String stableId,
 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,
 String stableId,
 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

tigMucMamUpdateMessage

public static void tigMucMamUpdateMessage(String roomJid,
 String stableId,
 String body,
 String msg)
                                   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