Package tigase.muc.repository.derby

Class StoredProcedures

  • public class StoredProcedures
extends java.lang.Object
    Created by andrzej on 19.10.2016.

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static void migrateFromOldSchema()  
      protected static java.lang.String sha1OfLower​(java.lang.String data)  
      static void tigMucAddMessage​(java.lang.String roomJid, java.sql.Timestamp ts, java.lang.String senderJid, java.lang.String senderNick, java.lang.String body, java.lang.Boolean publicEvent, java.lang.String msg)  
      static void tigMucCreateRoom​(java.lang.String roomJid, java.lang.String creatorJid, java.sql.Timestamp creationDate, java.lang.String roomName, java.lang.String roomConfig, java.sql.ResultSet[] data)  
      static void tigMucDeleteMessages​(java.lang.String roomJid)  
      static void tigMucDestroyRoom​(java.lang.String roomJid)  
      static void tigMucGetAvatar​(java.lang.Long id, java.sql.ResultSet[] data)  
      static void tigMucGetMessages​(java.lang.String roomJid, java.lang.Integer maxMessages, java.sql.Timestamp since, java.sql.ResultSet[] data)  
      static void tigMucGetRoom​(java.lang.String roomJid, java.sql.ResultSet[] data)  
      static void tigMucGetRoomAffiliations​(java.lang.Long roomId, java.sql.ResultSet[] data)  
      static void tigMucGetRoomsJids​(java.sql.ResultSet[] data)  
      static void tigMucMamGetMessagePosition​(java.lang.String roomJid, java.sql.Timestamp since, java.sql.Timestamp to, java.lang.String nickname, java.sql.Timestamp id_ts, java.sql.ResultSet[] data)  
      static void tigMucMamGetMessages​(java.lang.String roomJid, java.sql.Timestamp since, java.sql.Timestamp to, java.lang.String nickname, java.lang.Integer limit, java.lang.Integer offset, java.sql.ResultSet[] data)  
      static void tigMucMamGetMessagesCount​(java.lang.String roomJid, java.sql.Timestamp since, java.sql.Timestamp to, java.lang.String nickname, java.sql.ResultSet[] data)  
      static void tigMucSetAvatar​(java.lang.Long roomId, java.sql.Clob avatar, java.lang.String avatarHash)  
      static void tigMucSetRoomAffiliation​(java.lang.Long roomId, java.lang.String jid, java.lang.String affiliation, java.lang.Boolean persistent, java.lang.String nickname)  
      static void tigMucSetRoomConfig​(java.lang.String roomJid, java.lang.String name, java.lang.String config)  
      static void tigMucSetRoomSubject​(java.lang.Long roomId, java.lang.String subject, java.lang.String creator, java.sql.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 java.sql.SQLException
        Throws:
        java.sql.SQLException

      • sha1OfLower

        protected static java.lang.String sha1OfLower​(java.lang.String data)
                                       throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucAddMessage

        public static void tigMucAddMessage​(java.lang.String roomJid,
                                    java.sql.Timestamp ts,
                                    java.lang.String senderJid,
                                    java.lang.String senderNick,
                                    java.lang.String body,
                                    java.lang.Boolean publicEvent,
                                    java.lang.String msg)
                             throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucCreateRoom

        public static void tigMucCreateRoom​(java.lang.String roomJid,
                                    java.lang.String creatorJid,
                                    java.sql.Timestamp creationDate,
                                    java.lang.String roomName,
                                    java.lang.String roomConfig,
                                    java.sql.ResultSet[] data)
                             throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucDeleteMessages

        public static void tigMucDeleteMessages​(java.lang.String roomJid)
                                 throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucDestroyRoom

        public static void tigMucDestroyRoom​(java.lang.String roomJid)
                              throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucGetAvatar

        public static void tigMucGetAvatar​(java.lang.Long id,
                                   java.sql.ResultSet[] data)
                            throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucGetMessages

        public static void tigMucGetMessages​(java.lang.String roomJid,
                                     java.lang.Integer maxMessages,
                                     java.sql.Timestamp since,
                                     java.sql.ResultSet[] data)
                              throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucGetRoom

        public static void tigMucGetRoom​(java.lang.String roomJid,
                                 java.sql.ResultSet[] data)
                          throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucGetRoomAffiliations

        public static void tigMucGetRoomAffiliations​(java.lang.Long roomId,
                                             java.sql.ResultSet[] data)
                                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucGetRoomsJids

        public static void tigMucGetRoomsJids​(java.sql.ResultSet[] data)
                               throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucMamGetMessagePosition

        public static void tigMucMamGetMessagePosition​(java.lang.String roomJid,
                                               java.sql.Timestamp since,
                                               java.sql.Timestamp to,
                                               java.lang.String nickname,
                                               java.sql.Timestamp id_ts,
                                               java.sql.ResultSet[] data)
                                        throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucMamGetMessages

        public static void tigMucMamGetMessages​(java.lang.String roomJid,
                                        java.sql.Timestamp since,
                                        java.sql.Timestamp to,
                                        java.lang.String nickname,
                                        java.lang.Integer limit,
                                        java.lang.Integer offset,
                                        java.sql.ResultSet[] data)
                                 throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucMamGetMessagesCount

        public static void tigMucMamGetMessagesCount​(java.lang.String roomJid,
                                             java.sql.Timestamp since,
                                             java.sql.Timestamp to,
                                             java.lang.String nickname,
                                             java.sql.ResultSet[] data)
                                      throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucSetAvatar

        public static void tigMucSetAvatar​(java.lang.Long roomId,
                                   java.sql.Clob avatar,
                                   java.lang.String avatarHash)
                            throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucSetRoomAffiliation

        public static void tigMucSetRoomAffiliation​(java.lang.Long roomId,
                                            java.lang.String jid,
                                            java.lang.String affiliation,
                                            java.lang.Boolean persistent,
                                            java.lang.String nickname)
                                     throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucSetRoomConfig

        public static void tigMucSetRoomConfig​(java.lang.String roomJid,
                                       java.lang.String name,
                                       java.lang.String config)
                                throws java.sql.SQLException
        Throws:
        java.sql.SQLException

      • tigMucSetRoomSubject

        public static void tigMucSetRoomSubject​(java.lang.Long roomId,
                                        java.lang.String subject,
                                        java.lang.String creator,
                                        java.sql.Timestamp changeDate)
                                 throws java.sql.SQLException
        Throws:
        java.sql.SQLException