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

Class HSqlDbCalendarHandler

java.lang.Object

com.openindex.openestate.tool.calendar.db.DbCalendarHandlerImpl

com.openindex.openestate.tool.calendar.db.hsql.HSqlDbCalendarHandler

All Implemented Interfaces:

DbCalendarHandler

public class HSqlDbCalendarHandler
extends DbCalendarHandlerImpl

HSqlDbCalendarHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_ENTRY_BEGIN
static String	FIELD_ENTRY_END
static String	FIELD_ENTRY_ICAL
static String	FIELD_ENTRY_ID
static String	FIELD_ENTRY_NOTES
static String	FIELD_ENTRY_STATUS
static String	FIELD_ENTRY_TITLE
static String	FIELD_ENTRY_TYPE
static String	FIELD_ENTRY_UID
static String	FIELD_GROUP_AUTH_METHOD
static String	FIELD_GROUP_AUTH_PASS
static String	FIELD_GROUP_AUTH_USER
static String	FIELD_GROUP_ID
static String	FIELD_GROUP_NAME
static String	FIELD_GROUP_NOTES
static String	FIELD_GROUP_TYPE
static String	FIELD_GROUP_URL
static String	PROC_REMOVE_ENTRIES
static String	PROC_REMOVE_GROUPS
static String	PROC_SAVE_ENTRIES
static String	PROC_SAVE_GROUPS
static String	TABLE_ENTRIES
static String	TABLE_GROUPS
static String	VIEW_ENTRIES
static String	VIEW_GROUPS

Constructor Summary

Constructors

Constructor	Description
HSqlDbCalendarHandler()

Method Summary

Modifier and Type	Method	Description
DbCalendarEntry[]	getEntries(Connection c, long[] ids)
DbCalendarEntry[]	getEntries(Connection c, long groupId, String[] uids)
DbCalendarEntry[]	getEntries(Connection c, String keyword, long[] groupIds, int limit)
DbCalendarEntry[]	getEntries(Connection c, net.fortuna.ical4j.model.property.Status[] status, DbCalendarEntry.Type[] types, long[] groupIds, Date begin, Date end)
long[]	getEntryIds(Connection c, long[] groupIds)
long[]	getGroupIds(Connection c)
DbCalendarGroup[]	getGroups(Connection c, long[] ids)
void	removeEntries(Connection c, long[] ids)
void	removeGroups(Connection c, long[] ids)
void	saveEntry(Connection c, DbCalendarEntry entry)
void	saveGroup(Connection c, DbCalendarGroup group)

Methods inherited from class com.openindex.openestate.tool.calendar.db.DbCalendarHandlerImpl

getEntries, getEntries, getEntries, getEntry, getEntry, getEntryIds, getGroup, getGroupEntries, getGroupEntries, getGroups, removeEntry, removeGroup

Methods inherited from class java.lang.Object

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

Field Detail

PROC_REMOVE_GROUPS

public static final String PROC_REMOVE_GROUPS

See Also:

Constant Field Values

PROC_REMOVE_ENTRIES

public static final String PROC_REMOVE_ENTRIES

See Also:

Constant Field Values

PROC_SAVE_GROUPS

public static final String PROC_SAVE_GROUPS

See Also:

Constant Field Values

PROC_SAVE_ENTRIES

public static final String PROC_SAVE_ENTRIES

See Also:

Constant Field Values

VIEW_GROUPS

public static final String VIEW_GROUPS

See Also:

Constant Field Values

VIEW_ENTRIES

public static final String VIEW_ENTRIES

See Also:

Constant Field Values

TABLE_GROUPS

public static final String TABLE_GROUPS

See Also:

Constant Field Values

FIELD_GROUP_ID

public static final String FIELD_GROUP_ID

See Also:

Constant Field Values

FIELD_GROUP_NAME

public static final String FIELD_GROUP_NAME

See Also:

Constant Field Values

FIELD_GROUP_NOTES

public static final String FIELD_GROUP_NOTES

See Also:

Constant Field Values

FIELD_GROUP_URL

public static final String FIELD_GROUP_URL

See Also:

Constant Field Values

FIELD_GROUP_TYPE

public static final String FIELD_GROUP_TYPE

See Also:

Constant Field Values

FIELD_GROUP_AUTH_METHOD

public static final String FIELD_GROUP_AUTH_METHOD

See Also:

Constant Field Values

FIELD_GROUP_AUTH_USER

public static final String FIELD_GROUP_AUTH_USER

See Also:

Constant Field Values

FIELD_GROUP_AUTH_PASS

public static final String FIELD_GROUP_AUTH_PASS

See Also:

Constant Field Values

TABLE_ENTRIES

public static final String TABLE_ENTRIES

See Also:

Constant Field Values

FIELD_ENTRY_ID

public static final String FIELD_ENTRY_ID

See Also:

Constant Field Values

FIELD_ENTRY_UID

public static final String FIELD_ENTRY_UID

See Also:

Constant Field Values

FIELD_ENTRY_TITLE

public static final String FIELD_ENTRY_TITLE

See Also:

Constant Field Values

FIELD_ENTRY_TYPE

public static final String FIELD_ENTRY_TYPE

See Also:

Constant Field Values

FIELD_ENTRY_STATUS

public static final String FIELD_ENTRY_STATUS

See Also:

Constant Field Values

FIELD_ENTRY_BEGIN

public static final String FIELD_ENTRY_BEGIN

See Also:

Constant Field Values

FIELD_ENTRY_END

public static final String FIELD_ENTRY_END

See Also:

Constant Field Values

FIELD_ENTRY_NOTES

public static final String FIELD_ENTRY_NOTES

See Also:

Constant Field Values

FIELD_ENTRY_ICAL

public static final String FIELD_ENTRY_ICAL

See Also:

Constant Field Values

Constructor Detail

HSqlDbCalendarHandler

public HSqlDbCalendarHandler()

Method Detail

getEntries

public DbCalendarEntry[] getEntries(Connection c,
                                    long[] ids)
                             throws SQLException

Specified by:

getEntries in interface DbCalendarHandler

Specified by:

getEntries in class DbCalendarHandlerImpl

Throws:

SQLException

getEntries

public DbCalendarEntry[] getEntries(Connection c,
                                    long groupId,
                                    String[] uids)
                             throws SQLException

Specified by:

getEntries in interface DbCalendarHandler

Specified by:

getEntries in class DbCalendarHandlerImpl

Throws:

SQLException

getEntries

public DbCalendarEntry[] getEntries(Connection c,
                                    net.fortuna.ical4j.model.property.Status[] status,
                                    DbCalendarEntry.Type[] types,
                                    long[] groupIds,
                                    Date begin,
                                    Date end)
                             throws SQLException

Specified by:

getEntries in interface DbCalendarHandler

Specified by:

getEntries in class DbCalendarHandlerImpl

Throws:

SQLException

getEntries

public DbCalendarEntry[] getEntries(Connection c,
                                    String keyword,
                                    long[] groupIds,
                                    int limit)
                             throws SQLException

Specified by:

getEntries in interface DbCalendarHandler

Specified by:

getEntries in class DbCalendarHandlerImpl

Throws:

SQLException

getEntryIds

public long[] getEntryIds(Connection c,
                          long[] groupIds)
                   throws SQLException

Specified by:

getEntryIds in interface DbCalendarHandler

Specified by:

getEntryIds in class DbCalendarHandlerImpl

Throws:

SQLException

getGroups

public DbCalendarGroup[] getGroups(Connection c,
                                   long[] ids)
                            throws SQLException

Specified by:

getGroups in interface DbCalendarHandler

Specified by:

getGroups in class DbCalendarHandlerImpl

Throws:

SQLException

getGroupIds

public long[] getGroupIds(Connection c)
                   throws SQLException

Specified by:

getGroupIds in interface DbCalendarHandler

Specified by:

getGroupIds in class DbCalendarHandlerImpl

Throws:

SQLException

removeEntries

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

Specified by:

removeEntries in interface DbCalendarHandler

Specified by:

removeEntries in class DbCalendarHandlerImpl

Throws:

SQLException

removeGroups

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

Specified by:

removeGroups in interface DbCalendarHandler

Specified by:

removeGroups in class DbCalendarHandlerImpl

Throws:

SQLException

saveEntry

public void saveEntry(Connection c,
                      DbCalendarEntry entry)
               throws SQLException

Specified by:

saveEntry in interface DbCalendarHandler

Specified by:

saveEntry in class DbCalendarHandlerImpl

Throws:

SQLException

saveGroup

public void saveGroup(Connection c,
                      DbCalendarGroup group)
               throws SQLException

Specified by:

saveGroup in interface DbCalendarHandler

Specified by:

saveGroup in class DbCalendarHandlerImpl

Throws:

SQLException