Package com.openindex.openestate.tool.mail.db.hsql

Class HSqlDbMailMessageHandler

java.lang.Object

com.openindex.openestate.tool.mail.db.DbMailMessageHandlerImpl

com.openindex.openestate.tool.mail.db.hsql.HSqlDbMailMessageHandler

All Implemented Interfaces:

DbMailMessageHandler

public class HSqlDbMailMessageHandler
extends DbMailMessageHandlerImpl

HSqlDbMailMessageHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_ADDRESS_PERSON
static String	FIELD_ADDRESS_TYPE
static String	FIELD_ADDRESS_VALUE
static String	FIELD_FOLDER_AUTO_RETRIEVAL
static String	FIELD_FOLDER_HOLDS_FOLDERS
static String	FIELD_FOLDER_HOLDS_MESSAGES
static String	FIELD_FOLDER_ID
static String	FIELD_FOLDER_NAME
static String	FIELD_FOLDER_PARENT_ID
static String	FIELD_FOLDER_SPECIAL_TYPE
static String	FIELD_HEADER_KEY
static String	FIELD_HEADER_VALUE
static String	FIELD_MESSAGE_FROM
static String	FIELD_MESSAGE_HAS_ATTACHMENTS
static String	FIELD_MESSAGE_HASH
static String	FIELD_MESSAGE_ID
static String	FIELD_MESSAGE_IN_REPLY_TO
static String	FIELD_MESSAGE_IS_ANSWERED
static String	FIELD_MESSAGE_IS_ARCHIVED
static String	FIELD_MESSAGE_IS_DOWNLOADED
static String	FIELD_MESSAGE_IS_DRAFT
static String	FIELD_MESSAGE_IS_FLAGGED
static String	FIELD_MESSAGE_IS_FORWARDED
static String	FIELD_MESSAGE_IS_RECEIVED
static String	FIELD_MESSAGE_IS_SEEN
static String	FIELD_MESSAGE_MDN_STATUS
static String	FIELD_MESSAGE_MIME_ID
static String	FIELD_MESSAGE_RECEIVED_AT
static String	FIELD_MESSAGE_SENT_AT
static String	FIELD_MESSAGE_SIZE
static String	FIELD_MESSAGE_SUBJECT
static String	FIELD_MESSAGE_TO
static String	FIELD_MESSAGE_UID
static String	FIELD_MESSAGE_UID_VALIDITY
static String	FIELD_PART_DESCRIPTION
static String	FIELD_PART_DISPOSITION
static String	FIELD_PART_FILE_CONTENT
static String	FIELD_PART_FILE_NAME
static String	FIELD_PART_FILE_SIZE
static String	FIELD_PART_ID
static String	FIELD_PART_PARENT_ID
static String	FIELD_PART_TEXT
static String	FIELD_PART_TYPE
static String	PROC_REMOVE_ADDRESSES
static String	PROC_REMOVE_FOLDERS
static String	PROC_REMOVE_HEADERS
static String	PROC_REMOVE_MESSAGES
static String	PROC_REMOVE_PARTS
static String	PROC_SAVE_ADDRESSES
static String	PROC_SAVE_FOLDERS
static String	PROC_SAVE_HEADERS
static String	PROC_SAVE_MESSAGES
static String	PROC_SAVE_PARTS
static String	PROC_SET_MESSAGES_ANSWERED
static String	PROC_SET_MESSAGES_ARCHIVED
static String	PROC_SET_MESSAGES_FORWARDED
static String	PROC_SET_MESSAGES_MDN
static String	PROC_SET_MESSAGES_SEEN
static String	TABLE_ADDRESSES
static String	TABLE_FOLDERS
static String	TABLE_HEADERS
static String	TABLE_MESSAGES
static String	TABLE_PARTS
static String	VIEW_ADDRESSES
static String	VIEW_FOLDERS
static String	VIEW_HEADERS
static String	VIEW_MESSAGES
static String	VIEW_PARTS
static String	VIEW_PARTS_CONTENT

Constructor Summary

Constructors

Constructor	Description
HSqlDbMailMessageHandler()

Method Summary

Modifier and Type	Method	Description
boolean	downloadPart(Connection c, long partId, OutputStream output)
DbMailMessage[]	getArchivedMessages(Connection c, long[] folderIds)
DbMailFolder[]	getFolderChildren(Connection c, long parentFolderId)
DbMailFolder	getFolderOnRoot(Connection c, long accountId)
DbMailFolder[]	getFolders(Connection c, long[] ids)
DbMailFolder[]	getFoldersForAutoRetrieval(Connection c, long[] accountIds)
DbMailMessage	getMessageFromFolder(Connection c, long folderId, long uid, long uidValidity)
DbMailMessage	getMessageFromFolder(Connection c, long folderId, String hash, String mimeId)
long[]	getMessageIdsFromFolder(Connection c, long folderId)
DbMailMessage[]	getMessages(Connection c, long[] ids)
DbMailMessage[]	getMessagesFromFolder(Connection c, long folderId)
DbMailPart[]	getPartChildren(Connection c, long parentPartId)
DbMailPart	getPartOnRoot(Connection c, long messageId)
DbMailPart[]	getParts(Connection c, long[] ids)
DbMailFolder[]	getSpecialFolders(Connection c, long accountId, DbMailFolder.SpecialType[] types)
Map<Long,Integer>	getUnseenMessagesCount(Connection c, long[] folderIds)
void	loadAddresses(Connection c, DbMailMessage[] messages)
void	loadPartHeaders(Connection c, DbMailPart[] parts)
void	removeFolders(Connection c, long[] ids)
void	removeMessages(Connection c, long[] ids)
void	removeParts(Connection c, long[] ids)
void	saveFolder(Connection c, DbMailFolder folder)
void	saveMessage(Connection c, DbMailMessage message)
void	savePart(Connection c, DbMailPart part, boolean recursive)
void	setMessagesAnswered(Connection c, long[] messageIds, boolean answered)
void	setMessagesArchived(Connection c, long[] messageIds, boolean archived)
void	setMessagesForwarded(Connection c, long[] messageIds, boolean forwarded)
void	setMessagesMdn(Connection c, long[] messageIds, DbMailMessage.MdnStatus mdnStatus)
void	setMessagesSeen(Connection c, long[] messageIds, boolean seen)

Methods inherited from class com.openindex.openestate.tool.mail.db.DbMailMessageHandlerImpl

getArchivedMessages, getFolder, getFolders, getFoldersForAutoRetrieval, getMessage, getPart, getSpecialFolder, getSpecialFolders, getUnseenMessagesCount, getUnseenMessagesCount, loadAddresses, loadFolderChildren, loadFolderParents, loadPartChildren, loadPartHeaders, loadPartHeaders, removeFolder, removeMessage, removePart, setMessageAnswered, setMessageArchived, setMessageForwarded, setMessageMdn, setMessageSeen

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PROC_REMOVE_ADDRESSES

public static final String PROC_REMOVE_ADDRESSES

See Also:

Constant Field Values

PROC_REMOVE_FOLDERS

public static final String PROC_REMOVE_FOLDERS

See Also:

Constant Field Values

PROC_REMOVE_HEADERS

public static final String PROC_REMOVE_HEADERS

See Also:

Constant Field Values

PROC_REMOVE_MESSAGES

public static final String PROC_REMOVE_MESSAGES

See Also:

Constant Field Values

PROC_REMOVE_PARTS

public static final String PROC_REMOVE_PARTS

See Also:

Constant Field Values

PROC_SAVE_ADDRESSES

public static final String PROC_SAVE_ADDRESSES

See Also:

Constant Field Values

PROC_SAVE_FOLDERS

public static final String PROC_SAVE_FOLDERS

See Also:

Constant Field Values

PROC_SAVE_HEADERS

public static final String PROC_SAVE_HEADERS

See Also:

Constant Field Values

PROC_SAVE_MESSAGES

public static final String PROC_SAVE_MESSAGES

See Also:

Constant Field Values

PROC_SAVE_PARTS

public static final String PROC_SAVE_PARTS

See Also:

Constant Field Values

PROC_SET_MESSAGES_ANSWERED

public static final String PROC_SET_MESSAGES_ANSWERED

See Also:

Constant Field Values

PROC_SET_MESSAGES_ARCHIVED

public static final String PROC_SET_MESSAGES_ARCHIVED

See Also:

Constant Field Values

PROC_SET_MESSAGES_FORWARDED

public static final String PROC_SET_MESSAGES_FORWARDED

See Also:

Constant Field Values

PROC_SET_MESSAGES_MDN

public static final String PROC_SET_MESSAGES_MDN

See Also:

Constant Field Values

PROC_SET_MESSAGES_SEEN

public static final String PROC_SET_MESSAGES_SEEN

See Also:

Constant Field Values

VIEW_FOLDERS

public static final String VIEW_FOLDERS

See Also:

Constant Field Values

VIEW_MESSAGES

public static final String VIEW_MESSAGES

See Also:

Constant Field Values

VIEW_PARTS

public static final String VIEW_PARTS

See Also:

Constant Field Values

VIEW_PARTS_CONTENT

public static final String VIEW_PARTS_CONTENT

See Also:

Constant Field Values

VIEW_HEADERS

public static final String VIEW_HEADERS

See Also:

Constant Field Values

VIEW_ADDRESSES

public static final String VIEW_ADDRESSES

See Also:

Constant Field Values

TABLE_FOLDERS

public static final String TABLE_FOLDERS

See Also:

Constant Field Values

FIELD_FOLDER_ID

public static final String FIELD_FOLDER_ID

See Also:

Constant Field Values

FIELD_FOLDER_PARENT_ID

public static final String FIELD_FOLDER_PARENT_ID

See Also:

Constant Field Values

FIELD_FOLDER_NAME

public static final String FIELD_FOLDER_NAME

See Also:

Constant Field Values

FIELD_FOLDER_HOLDS_MESSAGES

public static final String FIELD_FOLDER_HOLDS_MESSAGES

See Also:

Constant Field Values

FIELD_FOLDER_HOLDS_FOLDERS

public static final String FIELD_FOLDER_HOLDS_FOLDERS

See Also:

Constant Field Values

FIELD_FOLDER_AUTO_RETRIEVAL

public static final String FIELD_FOLDER_AUTO_RETRIEVAL

See Also:

Constant Field Values

FIELD_FOLDER_SPECIAL_TYPE

public static final String FIELD_FOLDER_SPECIAL_TYPE

See Also:

Constant Field Values

TABLE_MESSAGES

public static final String TABLE_MESSAGES

See Also:

Constant Field Values

FIELD_MESSAGE_ID

public static final String FIELD_MESSAGE_ID

See Also:

Constant Field Values

FIELD_MESSAGE_SUBJECT

public static final String FIELD_MESSAGE_SUBJECT

See Also:

Constant Field Values

FIELD_MESSAGE_FROM

public static final String FIELD_MESSAGE_FROM

See Also:

Constant Field Values

FIELD_MESSAGE_TO

public static final String FIELD_MESSAGE_TO

See Also:

Constant Field Values

FIELD_MESSAGE_SIZE

public static final String FIELD_MESSAGE_SIZE

See Also:

Constant Field Values

FIELD_MESSAGE_UID

public static final String FIELD_MESSAGE_UID

See Also:

Constant Field Values

FIELD_MESSAGE_UID_VALIDITY

public static final String FIELD_MESSAGE_UID_VALIDITY

See Also:

Constant Field Values

FIELD_MESSAGE_MIME_ID

public static final String FIELD_MESSAGE_MIME_ID

See Also:

Constant Field Values

FIELD_MESSAGE_HASH

public static final String FIELD_MESSAGE_HASH

See Also:

Constant Field Values

FIELD_MESSAGE_IN_REPLY_TO

public static final String FIELD_MESSAGE_IN_REPLY_TO

See Also:

Constant Field Values

FIELD_MESSAGE_IS_ANSWERED

public static final String FIELD_MESSAGE_IS_ANSWERED

See Also:

Constant Field Values

FIELD_MESSAGE_IS_ARCHIVED

public static final String FIELD_MESSAGE_IS_ARCHIVED

See Also:

Constant Field Values

FIELD_MESSAGE_IS_DOWNLOADED

public static final String FIELD_MESSAGE_IS_DOWNLOADED

See Also:

Constant Field Values

FIELD_MESSAGE_IS_DRAFT

public static final String FIELD_MESSAGE_IS_DRAFT

See Also:

Constant Field Values

FIELD_MESSAGE_IS_FLAGGED

public static final String FIELD_MESSAGE_IS_FLAGGED

See Also:

Constant Field Values

FIELD_MESSAGE_IS_FORWARDED

public static final String FIELD_MESSAGE_IS_FORWARDED

See Also:

Constant Field Values

FIELD_MESSAGE_IS_SEEN

public static final String FIELD_MESSAGE_IS_SEEN

See Also:

Constant Field Values

FIELD_MESSAGE_IS_RECEIVED

public static final String FIELD_MESSAGE_IS_RECEIVED

See Also:

Constant Field Values

FIELD_MESSAGE_HAS_ATTACHMENTS

public static final String FIELD_MESSAGE_HAS_ATTACHMENTS

See Also:

Constant Field Values

FIELD_MESSAGE_MDN_STATUS

public static final String FIELD_MESSAGE_MDN_STATUS

See Also:

Constant Field Values

FIELD_MESSAGE_RECEIVED_AT

public static final String FIELD_MESSAGE_RECEIVED_AT

See Also:

Constant Field Values

FIELD_MESSAGE_SENT_AT

public static final String FIELD_MESSAGE_SENT_AT

See Also:

Constant Field Values

TABLE_PARTS

public static final String TABLE_PARTS

See Also:

Constant Field Values

FIELD_PART_ID

public static final String FIELD_PART_ID

See Also:

Constant Field Values

FIELD_PART_PARENT_ID

public static final String FIELD_PART_PARENT_ID

See Also:

Constant Field Values

FIELD_PART_TYPE

public static final String FIELD_PART_TYPE

See Also:

Constant Field Values

FIELD_PART_DESCRIPTION

public static final String FIELD_PART_DESCRIPTION

See Also:

Constant Field Values

FIELD_PART_DISPOSITION

public static final String FIELD_PART_DISPOSITION

See Also:

Constant Field Values

FIELD_PART_TEXT

public static final String FIELD_PART_TEXT

See Also:

Constant Field Values

FIELD_PART_FILE_NAME

public static final String FIELD_PART_FILE_NAME

See Also:

Constant Field Values

FIELD_PART_FILE_SIZE

public static final String FIELD_PART_FILE_SIZE

See Also:

Constant Field Values

FIELD_PART_FILE_CONTENT

public static final String FIELD_PART_FILE_CONTENT

See Also:

Constant Field Values

TABLE_HEADERS

public static final String TABLE_HEADERS

See Also:

Constant Field Values

FIELD_HEADER_KEY

public static final String FIELD_HEADER_KEY

See Also:

Constant Field Values

FIELD_HEADER_VALUE

public static final String FIELD_HEADER_VALUE

See Also:

Constant Field Values

TABLE_ADDRESSES

public static final String TABLE_ADDRESSES

See Also:

Constant Field Values

FIELD_ADDRESS_TYPE

public static final String FIELD_ADDRESS_TYPE

See Also:

Constant Field Values

FIELD_ADDRESS_VALUE

public static final String FIELD_ADDRESS_VALUE

See Also:

Constant Field Values

FIELD_ADDRESS_PERSON

public static final String FIELD_ADDRESS_PERSON

See Also:

Constant Field Values

Constructor Detail

HSqlDbMailMessageHandler

public HSqlDbMailMessageHandler()

Method Detail

downloadPart

public boolean downloadPart(Connection c,
                            long partId,
                            OutputStream output)
                     throws SQLException,
                            IOException

Specified by:

downloadPart in interface DbMailMessageHandler

Specified by:

downloadPart in class DbMailMessageHandlerImpl

Throws:

SQLException

IOException

getArchivedMessages

public DbMailMessage[] getArchivedMessages(Connection c,
                                           long[] folderIds)
                                    throws SQLException

Specified by:

getArchivedMessages in interface DbMailMessageHandler

Specified by:

getArchivedMessages in class DbMailMessageHandlerImpl

Throws:

SQLException

getFolders

public DbMailFolder[] getFolders(Connection c,
                                 long[] ids)
                          throws SQLException

Specified by:

getFolders in interface DbMailMessageHandler

Specified by:

getFolders in class DbMailMessageHandlerImpl

Throws:

SQLException

getFoldersForAutoRetrieval

public DbMailFolder[] getFoldersForAutoRetrieval(Connection c,
                                                 long[] accountIds)
                                          throws SQLException

Specified by:

getFoldersForAutoRetrieval in interface DbMailMessageHandler

Specified by:

getFoldersForAutoRetrieval in class DbMailMessageHandlerImpl

Throws:

SQLException

getFolderChildren

public DbMailFolder[] getFolderChildren(Connection c,
                                        long parentFolderId)
                                 throws SQLException

Specified by:

getFolderChildren in interface DbMailMessageHandler

Specified by:

getFolderChildren in class DbMailMessageHandlerImpl

Throws:

SQLException

getFolderOnRoot

public DbMailFolder getFolderOnRoot(Connection c,
                                    long accountId)
                             throws SQLException

Specified by:

getFolderOnRoot in interface DbMailMessageHandler

Specified by:

getFolderOnRoot in class DbMailMessageHandlerImpl

Throws:

SQLException

getMessageFromFolder

public DbMailMessage getMessageFromFolder(Connection c,
                                          long folderId,
                                          String hash,
                                          String mimeId)
                                   throws SQLException

Specified by:

getMessageFromFolder in interface DbMailMessageHandler

Specified by:

getMessageFromFolder in class DbMailMessageHandlerImpl

Throws:

SQLException

getMessageFromFolder

public DbMailMessage getMessageFromFolder(Connection c,
                                          long folderId,
                                          long uid,
                                          long uidValidity)
                                   throws SQLException

Specified by:

getMessageFromFolder in interface DbMailMessageHandler

Specified by:

getMessageFromFolder in class DbMailMessageHandlerImpl

Throws:

SQLException

getMessages

public DbMailMessage[] getMessages(Connection c,
                                   long[] ids)
                            throws SQLException

Specified by:

getMessages in interface DbMailMessageHandler

Specified by:

getMessages in class DbMailMessageHandlerImpl

Throws:

SQLException

getMessageIdsFromFolder

public long[] getMessageIdsFromFolder(Connection c,
                                      long folderId)
                               throws SQLException

Specified by:

getMessageIdsFromFolder in interface DbMailMessageHandler

Specified by:

getMessageIdsFromFolder in class DbMailMessageHandlerImpl

Throws:

SQLException

getMessagesFromFolder

public DbMailMessage[] getMessagesFromFolder(Connection c,
                                             long folderId)
                                      throws SQLException

Specified by:

getMessagesFromFolder in interface DbMailMessageHandler

Specified by:

getMessagesFromFolder in class DbMailMessageHandlerImpl

Throws:

SQLException

getParts

public DbMailPart[] getParts(Connection c,
                             long[] ids)
                      throws SQLException

Specified by:

getParts in interface DbMailMessageHandler

Specified by:

getParts in class DbMailMessageHandlerImpl

Throws:

SQLException

getPartChildren

public DbMailPart[] getPartChildren(Connection c,
                                    long parentPartId)
                             throws SQLException

Specified by:

getPartChildren in interface DbMailMessageHandler

Specified by:

getPartChildren in class DbMailMessageHandlerImpl

Throws:

SQLException

getPartOnRoot

public DbMailPart getPartOnRoot(Connection c,
                                long messageId)
                         throws SQLException

Specified by:

getPartOnRoot in interface DbMailMessageHandler

Specified by:

getPartOnRoot in class DbMailMessageHandlerImpl

Throws:

SQLException

getSpecialFolders

public DbMailFolder[] getSpecialFolders(Connection c,
                                        long accountId,
                                        DbMailFolder.SpecialType[] types)
                                 throws SQLException

Specified by:

getSpecialFolders in interface DbMailMessageHandler

Specified by:

getSpecialFolders in class DbMailMessageHandlerImpl

Throws:

SQLException

getUnseenMessagesCount

public Map<Long,Integer> getUnseenMessagesCount(Connection c,
                                                      long[] folderIds)
                                               throws SQLException

Specified by:

getUnseenMessagesCount in interface DbMailMessageHandler

Specified by:

getUnseenMessagesCount in class DbMailMessageHandlerImpl

Throws:

SQLException

loadAddresses

public void loadAddresses(Connection c,
                          DbMailMessage[] messages)
                   throws SQLException

Specified by:

loadAddresses in interface DbMailMessageHandler

Specified by:

loadAddresses in class DbMailMessageHandlerImpl

Throws:

SQLException

loadPartHeaders

public void loadPartHeaders(Connection c,
                            DbMailPart[] parts)
                     throws SQLException

Specified by:

loadPartHeaders in interface DbMailMessageHandler

Specified by:

loadPartHeaders in class DbMailMessageHandlerImpl

Throws:

SQLException

removeFolders

public void removeFolders(Connection c,
                          long[] ids)
                   throws SQLException

Specified by:

removeFolders in interface DbMailMessageHandler

Specified by:

removeFolders in class DbMailMessageHandlerImpl

Throws:

SQLException

removeMessages

public void removeMessages(Connection c,
                           long[] ids)
                    throws SQLException

Specified by:

removeMessages in interface DbMailMessageHandler

Specified by:

removeMessages in class DbMailMessageHandlerImpl

Throws:

SQLException

removeParts

public void removeParts(Connection c,
                        long[] ids)
                 throws SQLException

Specified by:

removeParts in interface DbMailMessageHandler

Specified by:

removeParts in class DbMailMessageHandlerImpl

Throws:

SQLException

saveFolder

public void saveFolder(Connection c,
                       DbMailFolder folder)
                throws SQLException

Specified by:

saveFolder in interface DbMailMessageHandler

Specified by:

saveFolder in class DbMailMessageHandlerImpl

Throws:

SQLException

saveMessage

public void saveMessage(Connection c,
                        DbMailMessage message)
                 throws SQLException

Specified by:

saveMessage in interface DbMailMessageHandler

Specified by:

saveMessage in class DbMailMessageHandlerImpl

Throws:

SQLException

savePart

public void savePart(Connection c,
                     DbMailPart part,
                     boolean recursive)
              throws SQLException,
                     IOException

Specified by:

savePart in interface DbMailMessageHandler

Specified by:

savePart in class DbMailMessageHandlerImpl

Throws:

SQLException

IOException

setMessagesAnswered

public void setMessagesAnswered(Connection c,
                                long[] messageIds,
                                boolean answered)
                         throws SQLException

Specified by:

setMessagesAnswered in interface DbMailMessageHandler

Specified by:

setMessagesAnswered in class DbMailMessageHandlerImpl

Throws:

SQLException

setMessagesArchived

public void setMessagesArchived(Connection c,
                                long[] messageIds,
                                boolean archived)
                         throws SQLException

Specified by:

setMessagesArchived in interface DbMailMessageHandler

Specified by:

setMessagesArchived in class DbMailMessageHandlerImpl

Throws:

SQLException

setMessagesForwarded

public void setMessagesForwarded(Connection c,
                                 long[] messageIds,
                                 boolean forwarded)
                          throws SQLException

Specified by:

setMessagesForwarded in interface DbMailMessageHandler

Specified by:

setMessagesForwarded in class DbMailMessageHandlerImpl

Throws:

SQLException

setMessagesMdn

public void setMessagesMdn(Connection c,
                           long[] messageIds,
                           DbMailMessage.MdnStatus mdnStatus)
                    throws SQLException

Specified by:

setMessagesMdn in interface DbMailMessageHandler

Specified by:

setMessagesMdn in class DbMailMessageHandlerImpl

Throws:

SQLException

setMessagesSeen

public void setMessagesSeen(Connection c,
                            long[] messageIds,
                            boolean seen)
                     throws SQLException

Specified by:

setMessagesSeen in interface DbMailMessageHandler

Specified by:

setMessagesSeen in class DbMailMessageHandlerImpl

Throws:

SQLException