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

Class HSqlDbAgencyExportsHandler

java.lang.Object

com.openindex.openestate.tool.agency.db.DbAgencyExportsHandlerImpl

com.openindex.openestate.tool.agency.db.hsql.HSqlDbAgencyExportsHandler

All Implemented Interfaces:

DbAgencyExportsHandler

public class HSqlDbAgencyExportsHandler
extends DbAgencyExportsHandlerImpl

HSqlDbAgencyExportHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_ENTRY_ACTION
static String	FIELD_ENTRY_EXPORTED
static String	FIELD_ENTRY_OBJECT_ID
static String	FIELD_ENTRY_OBJECT_NR
static String	FIELD_EXPORT_ENABLED
static String	FIELD_EXPORT_EXPOSE_ID
static String	FIELD_EXPORT_FORMAT
static String	FIELD_EXPORT_ID
static String	FIELD_EXPORT_LAST_EXECUTION
static String	FIELD_EXPORT_LIMIT
static String	FIELD_EXPORT_LOCK_TIME
static String	FIELD_EXPORT_NAME
static String	FIELD_EXPORT_NOTES
static String	FIELD_EXPORT_SEARCH_ID
static String	FIELD_EXPORT_TRANSFER
static String	FIELD_EXPORT_TRANSPORT
static String	FIELD_LOG_COUNT_DELETES
static String	FIELD_LOG_COUNT_ERRORS
static String	FIELD_LOG_COUNT_INSERTS
static String	FIELD_LOG_COUNT_NOTICES
static String	FIELD_LOG_COUNT_UPDATES
static String	FIELD_LOG_COUNT_WARNINGS
static String	FIELD_LOG_FORMAT
static String	FIELD_LOG_ID
static String	FIELD_LOG_LIMIT
static String	FIELD_LOG_TIME
static String	FIELD_LOG_TRANSFER
static String	FIELD_LOG_TRANSPORT
static String	FIELD_MESSAGE_CODE
static String	FIELD_MESSAGE_LEVEL
static String	FIELD_MESSAGE_TEXT
static String	FIELD_PUBLISHING_HASH
static String	FIELD_PUBLISHING_OBJECT_ID
static String	FIELD_PUBLISHING_OBJECT_KEY
static String	FIELD_PUBLISHING_OBJECT_NR
static String	FIELD_PUBLISHING_TIME
static String	FIELD_SETTING_KEY
static String	FIELD_SETTING_VALUE
static String	PROC_REMOVE_EXPORTS
static String	PROC_REMOVE_EXPORTS_LOGS
static String	PROC_REMOVE_EXPORTS_LOGS_ENTRIES
static String	PROC_REMOVE_EXPORTS_LOGS_MESSAGES
static String	PROC_REMOVE_EXPORTS_PUBLISHINGS
static String	PROC_REMOVE_EXPORTS_SETTINGS
static String	PROC_SAVE_EXPORTS
static String	PROC_SAVE_EXPORTS_LOGS
static String	PROC_SAVE_EXPORTS_LOGS_ENTRIES
static String	PROC_SAVE_EXPORTS_LOGS_MESSAGES
static String	PROC_SAVE_EXPORTS_PUBLISHINGS
static String	PROC_SAVE_EXPORTS_SETTINGS
static String	PROC_SET_EXPORTS_ENABLED
static String	TABLE_EXPORTS
static String	TABLE_EXPORTS_ENTRIES
static String	TABLE_EXPORTS_LOGS
static String	TABLE_EXPORTS_LOGS_ENTRIES
static String	TABLE_EXPORTS_LOGS_MESSAGES
static String	TABLE_EXPORTS_PUBLISHINGS
static String	TABLE_EXPORTS_SETTINGS
static String	VIEW_EXPORTS
static String	VIEW_EXPORTS_LOGS
static String	VIEW_EXPORTS_LOGS_ENTRIES
static String	VIEW_EXPORTS_LOGS_MESSAGES
static String	VIEW_EXPORTS_PUBLISHINGS
static String	VIEW_EXPORTS_SETTINGS

Constructor Summary

Constructors

Constructor	Description
HSqlDbAgencyExportsHandler()

Method Summary

Modifier and Type	Method	Description
long[]	getExportIds(Connection c)
long[]	getExportLogIds(Connection c, long exportId)
DbAgencyExportLog[]	getExportLogs(Connection c, long exportId)
DbAgencyExportLog[]	getExportLogs(Connection c, long[] ids)
DbAgencyExportLog[]	getExportLogsForObject(Connection c, long objectId)
DbAgencyExport[]	getExports(Connection c, long[] ids)
DbAgencyExport[]	getExports(Connection c, Boolean enabled)
DbAgencyExport[]	getExportsForObject(Connection c, long objectId, DbAgencyObject.ExportMode exportMode)
DbAgencyExportLog	getLatestExportLog(Connection c, long exportId)
void	loadExportLogEntries(Connection c, DbAgencyExportLog[] logs)
void	loadExportLogMessages(Connection c, DbAgencyExportLog[] logs)
void	loadExportPublishings(Connection c, DbAgencyExport[] exports)
void	loadExportSettings(Connection c, DbAgencyExport[] exports)
void	removeExportLogs(Connection c, long[] ids)
void	removeExportPublishings(Connection c, long exportId, long[] objectIds)
void	removeExports(Connection c, long[] ids)
void	saveExport(Connection c, DbAgencyExport export, boolean saveSettings, boolean savePublishings)
void	saveExportLog(Connection c, DbAgencyExportLog log)
void	setExportsEnabled(Connection c, long[] ids, boolean enabled)

Methods inherited from class com.openindex.openestate.tool.agency.db.DbAgencyExportsHandlerImpl

getExport, getExportLog, getExportLogIds, getExportLogs, getExports, loadExportLogEntries, loadExportLogMessages, loadExportPublishings, loadExportSettings, removeExport, removeExportLog, removeExportPublishing, setExportEnabled

Methods inherited from class java.lang.Object

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

Field Detail

PROC_REMOVE_EXPORTS

public static final String PROC_REMOVE_EXPORTS

See Also:

Constant Field Values

PROC_REMOVE_EXPORTS_LOGS

public static final String PROC_REMOVE_EXPORTS_LOGS

See Also:

Constant Field Values

PROC_REMOVE_EXPORTS_LOGS_ENTRIES

public static final String PROC_REMOVE_EXPORTS_LOGS_ENTRIES

See Also:

Constant Field Values

PROC_REMOVE_EXPORTS_LOGS_MESSAGES

public static final String PROC_REMOVE_EXPORTS_LOGS_MESSAGES

See Also:

Constant Field Values

PROC_REMOVE_EXPORTS_PUBLISHINGS

public static final String PROC_REMOVE_EXPORTS_PUBLISHINGS

See Also:

Constant Field Values

PROC_REMOVE_EXPORTS_SETTINGS

public static final String PROC_REMOVE_EXPORTS_SETTINGS

See Also:

Constant Field Values

PROC_SAVE_EXPORTS

public static final String PROC_SAVE_EXPORTS

See Also:

Constant Field Values

PROC_SAVE_EXPORTS_LOGS

public static final String PROC_SAVE_EXPORTS_LOGS

See Also:

Constant Field Values

PROC_SAVE_EXPORTS_LOGS_ENTRIES

public static final String PROC_SAVE_EXPORTS_LOGS_ENTRIES

See Also:

Constant Field Values

PROC_SAVE_EXPORTS_LOGS_MESSAGES

public static final String PROC_SAVE_EXPORTS_LOGS_MESSAGES

See Also:

Constant Field Values

PROC_SAVE_EXPORTS_PUBLISHINGS

public static final String PROC_SAVE_EXPORTS_PUBLISHINGS

See Also:

Constant Field Values

PROC_SAVE_EXPORTS_SETTINGS

public static final String PROC_SAVE_EXPORTS_SETTINGS

See Also:

Constant Field Values

PROC_SET_EXPORTS_ENABLED

public static final String PROC_SET_EXPORTS_ENABLED

See Also:

Constant Field Values

VIEW_EXPORTS

public static final String VIEW_EXPORTS

See Also:

Constant Field Values

VIEW_EXPORTS_LOGS

public static final String VIEW_EXPORTS_LOGS

See Also:

Constant Field Values

VIEW_EXPORTS_LOGS_ENTRIES

public static final String VIEW_EXPORTS_LOGS_ENTRIES

See Also:

Constant Field Values

VIEW_EXPORTS_LOGS_MESSAGES

public static final String VIEW_EXPORTS_LOGS_MESSAGES

See Also:

Constant Field Values

VIEW_EXPORTS_PUBLISHINGS

public static final String VIEW_EXPORTS_PUBLISHINGS

See Also:

Constant Field Values

VIEW_EXPORTS_SETTINGS

public static final String VIEW_EXPORTS_SETTINGS

See Also:

Constant Field Values

TABLE_EXPORTS

public static final String TABLE_EXPORTS

See Also:

Constant Field Values

FIELD_EXPORT_ID

public static final String FIELD_EXPORT_ID

See Also:

Constant Field Values

FIELD_EXPORT_NAME

public static final String FIELD_EXPORT_NAME

See Also:

Constant Field Values

FIELD_EXPORT_FORMAT

public static final String FIELD_EXPORT_FORMAT

See Also:

Constant Field Values

FIELD_EXPORT_TRANSPORT

public static final String FIELD_EXPORT_TRANSPORT

See Also:

Constant Field Values

FIELD_EXPORT_TRANSFER

public static final String FIELD_EXPORT_TRANSFER

See Also:

Constant Field Values

FIELD_EXPORT_ENABLED

public static final String FIELD_EXPORT_ENABLED

See Also:

Constant Field Values

FIELD_EXPORT_LIMIT

public static final String FIELD_EXPORT_LIMIT

See Also:

Constant Field Values

FIELD_EXPORT_NOTES

public static final String FIELD_EXPORT_NOTES

See Also:

Constant Field Values

FIELD_EXPORT_LAST_EXECUTION

public static final String FIELD_EXPORT_LAST_EXECUTION

See Also:

Constant Field Values

FIELD_EXPORT_LOCK_TIME

public static final String FIELD_EXPORT_LOCK_TIME

See Also:

Constant Field Values

FIELD_EXPORT_SEARCH_ID

public static final String FIELD_EXPORT_SEARCH_ID

See Also:

Constant Field Values

FIELD_EXPORT_EXPOSE_ID

public static final String FIELD_EXPORT_EXPOSE_ID

See Also:

Constant Field Values

TABLE_EXPORTS_LOGS

public static final String TABLE_EXPORTS_LOGS

See Also:

Constant Field Values

FIELD_LOG_ID

public static final String FIELD_LOG_ID

See Also:

Constant Field Values

FIELD_LOG_FORMAT

public static final String FIELD_LOG_FORMAT

See Also:

Constant Field Values

FIELD_LOG_TRANSPORT

public static final String FIELD_LOG_TRANSPORT

See Also:

Constant Field Values

FIELD_LOG_TRANSFER

public static final String FIELD_LOG_TRANSFER

See Also:

Constant Field Values

FIELD_LOG_LIMIT

public static final String FIELD_LOG_LIMIT

See Also:

Constant Field Values

FIELD_LOG_COUNT_INSERTS

public static final String FIELD_LOG_COUNT_INSERTS

See Also:

Constant Field Values

FIELD_LOG_COUNT_UPDATES

public static final String FIELD_LOG_COUNT_UPDATES

See Also:

Constant Field Values

FIELD_LOG_COUNT_DELETES

public static final String FIELD_LOG_COUNT_DELETES

See Also:

Constant Field Values

FIELD_LOG_COUNT_ERRORS

public static final String FIELD_LOG_COUNT_ERRORS

See Also:

Constant Field Values

FIELD_LOG_COUNT_WARNINGS

public static final String FIELD_LOG_COUNT_WARNINGS

See Also:

Constant Field Values

FIELD_LOG_COUNT_NOTICES

public static final String FIELD_LOG_COUNT_NOTICES

See Also:

Constant Field Values

FIELD_LOG_TIME

public static final String FIELD_LOG_TIME

See Also:

Constant Field Values

TABLE_EXPORTS_ENTRIES

public static final String TABLE_EXPORTS_ENTRIES

See Also:

Constant Field Values

TABLE_EXPORTS_LOGS_ENTRIES

public static final String TABLE_EXPORTS_LOGS_ENTRIES

See Also:

Constant Field Values

TABLE_EXPORTS_LOGS_MESSAGES

public static final String TABLE_EXPORTS_LOGS_MESSAGES

See Also:

Constant Field Values

FIELD_ENTRY_OBJECT_ID

public static final String FIELD_ENTRY_OBJECT_ID

See Also:

Constant Field Values

FIELD_ENTRY_OBJECT_NR

public static final String FIELD_ENTRY_OBJECT_NR

See Also:

Constant Field Values

FIELD_ENTRY_ACTION

public static final String FIELD_ENTRY_ACTION

See Also:

Constant Field Values

FIELD_ENTRY_EXPORTED

public static final String FIELD_ENTRY_EXPORTED

See Also:

Constant Field Values

FIELD_MESSAGE_LEVEL

public static final String FIELD_MESSAGE_LEVEL

See Also:

Constant Field Values

FIELD_MESSAGE_CODE

public static final String FIELD_MESSAGE_CODE

See Also:

Constant Field Values

FIELD_MESSAGE_TEXT

public static final String FIELD_MESSAGE_TEXT

See Also:

Constant Field Values

TABLE_EXPORTS_PUBLISHINGS

public static final String TABLE_EXPORTS_PUBLISHINGS

See Also:

Constant Field Values

FIELD_PUBLISHING_OBJECT_ID

public static final String FIELD_PUBLISHING_OBJECT_ID

See Also:

Constant Field Values

FIELD_PUBLISHING_OBJECT_NR

public static final String FIELD_PUBLISHING_OBJECT_NR

See Also:

Constant Field Values

FIELD_PUBLISHING_OBJECT_KEY

public static final String FIELD_PUBLISHING_OBJECT_KEY

See Also:

Constant Field Values

FIELD_PUBLISHING_HASH

public static final String FIELD_PUBLISHING_HASH

See Also:

Constant Field Values

FIELD_PUBLISHING_TIME

public static final String FIELD_PUBLISHING_TIME

See Also:

Constant Field Values

TABLE_EXPORTS_SETTINGS

public static final String TABLE_EXPORTS_SETTINGS

See Also:

Constant Field Values

FIELD_SETTING_KEY

public static final String FIELD_SETTING_KEY

See Also:

Constant Field Values

FIELD_SETTING_VALUE

public static final String FIELD_SETTING_VALUE

See Also:

Constant Field Values

Constructor Detail

HSqlDbAgencyExportsHandler

public HSqlDbAgencyExportsHandler()

Method Detail

getExports

public DbAgencyExport[] getExports(Connection c,
                                   long[] ids)
                            throws SQLException

Specified by:

getExports in interface DbAgencyExportsHandler

Specified by:

getExports in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExports

public DbAgencyExport[] getExports(Connection c,
                                   Boolean enabled)
                            throws SQLException

Specified by:

getExports in interface DbAgencyExportsHandler

Specified by:

getExports in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExportsForObject

public DbAgencyExport[] getExportsForObject(Connection c,
                                            long objectId,
                                            DbAgencyObject.ExportMode exportMode)
                                     throws SQLException

Specified by:

getExportsForObject in interface DbAgencyExportsHandler

Specified by:

getExportsForObject in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExportIds

public long[] getExportIds(Connection c)
                    throws SQLException

Specified by:

getExportIds in interface DbAgencyExportsHandler

Specified by:

getExportIds in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExportLogs

public DbAgencyExportLog[] getExportLogs(Connection c,
                                         long exportId)
                                  throws SQLException

Specified by:

getExportLogs in interface DbAgencyExportsHandler

Specified by:

getExportLogs in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExportLogs

public DbAgencyExportLog[] getExportLogs(Connection c,
                                         long[] ids)
                                  throws SQLException

Specified by:

getExportLogs in interface DbAgencyExportsHandler

Specified by:

getExportLogs in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExportLogsForObject

public DbAgencyExportLog[] getExportLogsForObject(Connection c,
                                                  long objectId)
                                           throws SQLException

Specified by:

getExportLogsForObject in interface DbAgencyExportsHandler

Specified by:

getExportLogsForObject in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getExportLogIds

public long[] getExportLogIds(Connection c,
                              long exportId)
                       throws SQLException

Specified by:

getExportLogIds in interface DbAgencyExportsHandler

Specified by:

getExportLogIds in class DbAgencyExportsHandlerImpl

Throws:

SQLException

getLatestExportLog

public DbAgencyExportLog getLatestExportLog(Connection c,
                                            long exportId)
                                     throws SQLException

Specified by:

getLatestExportLog in interface DbAgencyExportsHandler

Specified by:

getLatestExportLog in class DbAgencyExportsHandlerImpl

Throws:

SQLException

loadExportLogEntries

public void loadExportLogEntries(Connection c,
                                 DbAgencyExportLog[] logs)
                          throws SQLException

Specified by:

loadExportLogEntries in interface DbAgencyExportsHandler

Specified by:

loadExportLogEntries in class DbAgencyExportsHandlerImpl

Throws:

SQLException

loadExportLogMessages

public void loadExportLogMessages(Connection c,
                                  DbAgencyExportLog[] logs)
                           throws SQLException

Specified by:

loadExportLogMessages in interface DbAgencyExportsHandler

Specified by:

loadExportLogMessages in class DbAgencyExportsHandlerImpl

Throws:

SQLException

loadExportPublishings

public void loadExportPublishings(Connection c,
                                  DbAgencyExport[] exports)
                           throws SQLException

Specified by:

loadExportPublishings in interface DbAgencyExportsHandler

Specified by:

loadExportPublishings in class DbAgencyExportsHandlerImpl

Throws:

SQLException

loadExportSettings

public void loadExportSettings(Connection c,
                               DbAgencyExport[] exports)
                        throws SQLException

Specified by:

loadExportSettings in interface DbAgencyExportsHandler

Specified by:

loadExportSettings in class DbAgencyExportsHandlerImpl

Throws:

SQLException

removeExports

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

Specified by:

removeExports in interface DbAgencyExportsHandler

Specified by:

removeExports in class DbAgencyExportsHandlerImpl

Throws:

SQLException

removeExportLogs

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

Specified by:

removeExportLogs in interface DbAgencyExportsHandler

Specified by:

removeExportLogs in class DbAgencyExportsHandlerImpl

Throws:

SQLException

removeExportPublishings

public void removeExportPublishings(Connection c,
                                    long exportId,
                                    long[] objectIds)
                             throws SQLException

Specified by:

removeExportPublishings in interface DbAgencyExportsHandler

Specified by:

removeExportPublishings in class DbAgencyExportsHandlerImpl

Throws:

SQLException

saveExport

public void saveExport(Connection c,
                       DbAgencyExport export,
                       boolean saveSettings,
                       boolean savePublishings)
                throws SQLException

Specified by:

saveExport in interface DbAgencyExportsHandler

Specified by:

saveExport in class DbAgencyExportsHandlerImpl

Throws:

SQLException

saveExportLog

public void saveExportLog(Connection c,
                          DbAgencyExportLog log)
                   throws SQLException

Specified by:

saveExportLog in interface DbAgencyExportsHandler

Specified by:

saveExportLog in class DbAgencyExportsHandlerImpl

Throws:

SQLException

setExportsEnabled

public void setExportsEnabled(Connection c,
                              long[] ids,
                              boolean enabled)
                       throws SQLException

Specified by:

setExportsEnabled in interface DbAgencyExportsHandler

Specified by:

setExportsEnabled in class DbAgencyExportsHandlerImpl

Throws:

SQLException