com.openindex.openestate.impl.db.hsql

Class HSqlDbSearchesHandler

java.lang.Object

com.openindex.openestate.impl.db.DbHandlerImpl

com.openindex.openestate.impl.db.DbSearchesHandlerImpl

com.openindex.openestate.impl.db.hsql.HSqlDbSearchesHandler

All Implemented Interfaces:

DbHandler, DbSearchesHandler

public class HSqlDbSearchesHandler
extends DbSearchesHandlerImpl

HSqlDbSearchesHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field and Description
static String	FIELD_ATTRIB_EQUALS
static String	FIELD_ATTRIB_EQUALS_CASE
static String	FIELD_ATTRIB_EQUALS_LIKE
static String	FIELD_ATTRIB_MATCHES
static String	FIELD_ATTRIB_NAME
static String	FIELD_ATTRIB_NUMERIC_MAX
static String	FIELD_ATTRIB_NUMERIC_MIN
static String	FIELD_ATTRIB_NUMERIC_UNIT
static String	FIELD_ATTRIB_ORDER
static String	FIELD_ATTRIB_TIME_BEGIN
static String	FIELD_ATTRIB_TIME_END
static String	FIELD_PARAM_KEY
static String	FIELD_PARAM_VALUE
static String	FIELD_SEARCH_ENABLED
static String	FIELD_SEARCH_ID
static String	FIELD_SEARCH_NAME
static String	FIELD_SEARCH_NOTES
static String	FIELD_VALUE_EQUALS
static String	FIELD_VALUE_EQUALS_CASE
static String	FIELD_VALUE_EQUALS_LIKE
static String	FIELD_VALUE_ORDER
static String	FIELD_VALUE_TYPE
static String	PROC_REMOVE_SEARCHES
static String	PROC_REMOVE_SEARCHES_ATTRIBS
static String	PROC_REMOVE_SEARCHES_PARAMS
static String	PROC_REMOVE_SEARCHES_VALUES
static String	PROC_SAVE_SEARCHES
static String	PROC_SAVE_SEARCHES_ATTRIBS
static String	PROC_SAVE_SEARCHES_PARAMS
static String	PROC_SAVE_SEARCHES_VALUES
static String	PROC_SET_SEARCHES_ENABLED
static String	VIEW_SEARCHES
static String	VIEW_SEARCHES_ATTRIBS
static String	VIEW_SEARCHES_PARAMS
static String	VIEW_SEARCHES_VALUES

Constructor Summary

Constructors

Constructor and Description
HSqlDbSearchesHandler()
HSqlDbSearchesHandler(String schema)

Method Summary

Modifier and Type	Method and Description
protected SearchAttribImpl	buildAttribCondition(ResultSet result)
protected DbSearch	buildSearch(ResultSet result)
protected SearchEqualsImpl	buildValueCondition(ResultSet result)
DbSearch[]	getSearches(Connection c, Boolean enabled)
DbSearch[]	getSearches(Connection c, long[] ids)
long[]	getSearchIds(Connection c, Boolean enabled)
void	loadAttribConditions(Connection c, DbSearch[] searches)
void	loadParameters(Connection c, DbSearch[] searches)
void	loadValueConditions(Connection c, DbSearch[] searches)
void	removeSearches(Connection c, long[] ids)
void	saveSearch(Connection c, DbSearch search, boolean saveParameters, boolean saveConditions)
protected void	saveSearchAdditionally(Connection c, DbSearch search, long searchId, List<Statement> statements)
void	setSearchesEnabled(Connection c, long[] ids, boolean enabled)

Methods inherited from class com.openindex.openestate.impl.db.DbSearchesHandlerImpl

createAttribCondition, createSearch, createValueCondition, getSearch, getSearches, getSearchIds, loadAttribConditions, loadParameters, loadValueConditions, removeSearch, saveSearch, setSearchEnabled

Methods inherited from class com.openindex.openestate.impl.db.DbHandlerImpl

getSchema, getSchemaPath, setSchema

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.openindex.openestate.impl.db.DbHandler

getSchema, setSchema

Field Detail

PROC_REMOVE_SEARCHES

public static final String PROC_REMOVE_SEARCHES

See Also:

Constant Field Values

PROC_REMOVE_SEARCHES_ATTRIBS

public static final String PROC_REMOVE_SEARCHES_ATTRIBS

See Also:

Constant Field Values

PROC_REMOVE_SEARCHES_PARAMS

public static final String PROC_REMOVE_SEARCHES_PARAMS

See Also:

Constant Field Values

PROC_REMOVE_SEARCHES_VALUES

public static final String PROC_REMOVE_SEARCHES_VALUES

See Also:

Constant Field Values

PROC_SAVE_SEARCHES

public static final String PROC_SAVE_SEARCHES

See Also:

Constant Field Values

PROC_SAVE_SEARCHES_ATTRIBS

public static final String PROC_SAVE_SEARCHES_ATTRIBS

See Also:

Constant Field Values

PROC_SAVE_SEARCHES_PARAMS

public static final String PROC_SAVE_SEARCHES_PARAMS

See Also:

Constant Field Values

PROC_SAVE_SEARCHES_VALUES

public static final String PROC_SAVE_SEARCHES_VALUES

See Also:

Constant Field Values

PROC_SET_SEARCHES_ENABLED

public static final String PROC_SET_SEARCHES_ENABLED

See Also:

Constant Field Values

VIEW_SEARCHES

public static final String VIEW_SEARCHES

See Also:

Constant Field Values

VIEW_SEARCHES_ATTRIBS

public static final String VIEW_SEARCHES_ATTRIBS

See Also:

Constant Field Values

VIEW_SEARCHES_PARAMS

public static final String VIEW_SEARCHES_PARAMS

See Also:

Constant Field Values

VIEW_SEARCHES_VALUES

public static final String VIEW_SEARCHES_VALUES

See Also:

Constant Field Values

FIELD_SEARCH_ID

public static final String FIELD_SEARCH_ID

See Also:

Constant Field Values

FIELD_SEARCH_NAME

public static final String FIELD_SEARCH_NAME

See Also:

Constant Field Values

FIELD_SEARCH_NOTES

public static final String FIELD_SEARCH_NOTES

See Also:

Constant Field Values

FIELD_SEARCH_ENABLED

public static final String FIELD_SEARCH_ENABLED

See Also:

Constant Field Values

FIELD_ATTRIB_NAME

public static final String FIELD_ATTRIB_NAME

See Also:

Constant Field Values

FIELD_ATTRIB_EQUALS

public static final String FIELD_ATTRIB_EQUALS

See Also:

Constant Field Values

FIELD_ATTRIB_EQUALS_LIKE

public static final String FIELD_ATTRIB_EQUALS_LIKE

See Also:

Constant Field Values

FIELD_ATTRIB_EQUALS_CASE

public static final String FIELD_ATTRIB_EQUALS_CASE

See Also:

Constant Field Values

FIELD_ATTRIB_MATCHES

public static final String FIELD_ATTRIB_MATCHES

See Also:

Constant Field Values

FIELD_ATTRIB_NUMERIC_MIN

public static final String FIELD_ATTRIB_NUMERIC_MIN

See Also:

Constant Field Values

FIELD_ATTRIB_NUMERIC_MAX

public static final String FIELD_ATTRIB_NUMERIC_MAX

See Also:

Constant Field Values

FIELD_ATTRIB_NUMERIC_UNIT

public static final String FIELD_ATTRIB_NUMERIC_UNIT

See Also:

Constant Field Values

FIELD_ATTRIB_TIME_BEGIN

public static final String FIELD_ATTRIB_TIME_BEGIN

See Also:

Constant Field Values

FIELD_ATTRIB_TIME_END

public static final String FIELD_ATTRIB_TIME_END

See Also:

Constant Field Values

FIELD_ATTRIB_ORDER

public static final String FIELD_ATTRIB_ORDER

See Also:

Constant Field Values

FIELD_PARAM_KEY

public static final String FIELD_PARAM_KEY

See Also:

Constant Field Values

FIELD_PARAM_VALUE

public static final String FIELD_PARAM_VALUE

See Also:

Constant Field Values

FIELD_VALUE_TYPE

public static final String FIELD_VALUE_TYPE

See Also:

Constant Field Values

FIELD_VALUE_EQUALS

public static final String FIELD_VALUE_EQUALS

See Also:

Constant Field Values

FIELD_VALUE_EQUALS_LIKE

public static final String FIELD_VALUE_EQUALS_LIKE

See Also:

Constant Field Values

FIELD_VALUE_EQUALS_CASE

public static final String FIELD_VALUE_EQUALS_CASE

See Also:

Constant Field Values

FIELD_VALUE_ORDER

public static final String FIELD_VALUE_ORDER

See Also:

Constant Field Values

Constructor Detail

HSqlDbSearchesHandler

public HSqlDbSearchesHandler()

HSqlDbSearchesHandler

public HSqlDbSearchesHandler(String schema)

Method Detail

buildAttribCondition

protected SearchAttribImpl buildAttribCondition(ResultSet result)
                                         throws SQLException

Throws:

SQLException

buildSearch

protected DbSearch buildSearch(ResultSet result)
                        throws SQLException

Throws:

SQLException

buildValueCondition

protected SearchEqualsImpl buildValueCondition(ResultSet result)
                                        throws SQLException

Throws:

SQLException

getSearches

public DbSearch[] getSearches(Connection c,
                              Boolean enabled)
                       throws SQLException

Specified by:

getSearches in interface DbSearchesHandler

Specified by:

getSearches in class DbSearchesHandlerImpl

Throws:

SQLException

getSearches

public DbSearch[] getSearches(Connection c,
                              long[] ids)
                       throws SQLException

Specified by:

getSearches in interface DbSearchesHandler

Specified by:

getSearches in class DbSearchesHandlerImpl

Throws:

SQLException

getSearchIds

public long[] getSearchIds(Connection c,
                           Boolean enabled)
                    throws SQLException

Specified by:

getSearchIds in interface DbSearchesHandler

Specified by:

getSearchIds in class DbSearchesHandlerImpl

Throws:

SQLException

loadAttribConditions

public void loadAttribConditions(Connection c,
                                 DbSearch[] searches)
                          throws SQLException

Specified by:

loadAttribConditions in interface DbSearchesHandler

Specified by:

loadAttribConditions in class DbSearchesHandlerImpl

Throws:

SQLException

loadParameters

public void loadParameters(Connection c,
                           DbSearch[] searches)
                    throws SQLException

Specified by:

loadParameters in interface DbSearchesHandler

Specified by:

loadParameters in class DbSearchesHandlerImpl

Throws:

SQLException

loadValueConditions

public void loadValueConditions(Connection c,
                                DbSearch[] searches)
                         throws SQLException

Specified by:

loadValueConditions in interface DbSearchesHandler

Specified by:

loadValueConditions in class DbSearchesHandlerImpl

Throws:

SQLException

removeSearches

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

Specified by:

removeSearches in interface DbSearchesHandler

Specified by:

removeSearches in class DbSearchesHandlerImpl

Throws:

SQLException

saveSearch

public void saveSearch(Connection c,
                       DbSearch search,
                       boolean saveParameters,
                       boolean saveConditions)
                throws SQLException

Specified by:

saveSearch in interface DbSearchesHandler

Specified by:

saveSearch in class DbSearchesHandlerImpl

Throws:

SQLException

saveSearchAdditionally

protected void saveSearchAdditionally(Connection c,
                                      DbSearch search,
                                      long searchId,
                                      List<Statement> statements)
                               throws SQLException

Throws:

SQLException

setSearchesEnabled

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

Specified by:

setSearchesEnabled in interface DbSearchesHandler

Specified by:

setSearchesEnabled in class DbSearchesHandlerImpl

Throws:

SQLException