com.openindex.openestate.impl.db.hsql

Class HSqlDbObjectsHandler

java.lang.Object

com.openindex.openestate.impl.db.DbHandlerImpl

com.openindex.openestate.impl.db.DbObjectsHandlerImpl

com.openindex.openestate.impl.db.hsql.HSqlDbObjectsHandler

All Implemented Interfaces:

DbHandler, DbObjectsHandler

public class HSqlDbObjectsHandler
extends DbObjectsHandlerImpl

HSqlDbObjectsHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field and Description
static String	FIELD_ADDRESS_CITY
static String	FIELD_ADDRESS_COUNTRY
static String	FIELD_ADDRESS_DISTRICT
static String	FIELD_ADDRESS_LATITUDE
static String	FIELD_ADDRESS_LONGITUDE
static String	FIELD_ADDRESS_POSTAL_CODE
static String	FIELD_ADDRESS_PUBLISHED
static String	FIELD_ADDRESS_REGION
static String	FIELD_ADDRESS_STREET
static String	FIELD_ADDRESS_STREET_NR
static String	FIELD_ADDRESS_STREET2
static String	FIELD_ATTRIB_NAME
static String	FIELD_ATTRIB_UNIT
static String	FIELD_I18N_TITLE
static String	FIELD_OBJECT_ACTION
static String	FIELD_OBJECT_CURRENCY
static String	FIELD_OBJECT_GROUP_ID
static String	FIELD_OBJECT_HIDDEN_PRICES
static String	FIELD_OBJECT_ID
static String	FIELD_OBJECT_PUBLIC_ID
static String	FIELD_OBJECT_PUBLISH_BEGIN
static String	FIELD_OBJECT_PUBLISH_END
static String	FIELD_OBJECT_TYPE
static String	FIELD_VALUE_BOOLEAN
static String	FIELD_VALUE_DATE
static String	FIELD_VALUE_DATETIME
static String	FIELD_VALUE_NUMERIC
static String	FIELD_VALUE_NUMERIC_BASE
static String	FIELD_VALUE_STRING
static String	FIELD_VALUE_TEXT
static String	FIELD_VALUE_TIME
static String	PROC_GET_OBJECT_ID
static String	PROC_REMOVE_OBJECTS
static String	PROC_REMOVE_OBJECTS_ATTRIBS
static String	PROC_REMOVE_OBJECTS_GEODBS_AREAS
static String	PROC_REMOVE_OBJECTS_I18N
static String	PROC_SAVE_OBJECTS
static String	PROC_SAVE_OBJECTS_ATTRIBS
static String	PROC_SAVE_OBJECTS_GEODBS_AREAS
static String	PROC_SAVE_OBJECTS_I18N
static String	PROC_SET_OBJECTS_CONTACT
static String	VIEW_OBJECTS
static String	VIEW_OBJECTS_ACTIONS
static String	VIEW_OBJECTS_ATTRIBS
static String	VIEW_OBJECTS_GEODBS_AREAS
static String	VIEW_OBJECTS_I18N
static String	VIEW_OBJECTS_TYPES

Constructor Summary

Constructors

Constructor and Description
HSqlDbObjectsHandler()
HSqlDbObjectsHandler(String schema)

Method Summary

Modifier and Type	Method and Description
protected AbstractAttribImpl	buildAttrib(ResultSet result, Map<Long,String> languages, EstateImpl estate)
protected DbObject	buildObject(ResultSet result)
int	getNumberOfFiles(Connection c, long objectId, Boolean published, String mimeType)
OpenEstateAction[]	getObjectActions(Connection c)
long	getObjectId(Connection c, String publicId)
long[]	getObjectIds(Connection c, DbSearch search)
long[]	getObjectIds(Connection c, long[] contactIds)
DbObject[]	getObjects(Connection c, DbSearch search)
DbObject[]	getObjects(Connection c, long[] ids)
DbObject[]	getObjects(Connection c, String[] nrs)
DbObject[]	getObjectsByKeyword(Connection c, String keyword, int limit)
OpenEstateType[]	getObjectTypes(Connection c)
void	loadObjectAttribs(Connection c, DbObject[] objects, Map<Long,String> languageMap)
void	loadObjectGeoDbAreas(Connection c, DbObject[] objects, DbGeoHandler geoHandler)
void	loadObjectTranslations(Connection c, DbObject[] objects, Map<Long,String> languageMap)
protected void	loadSearchConditions(DbSearch search, List<String> conditions, Map<String,Object> conditionValues)
protected void	loadSearchParameters(NamedPreparedStatement statement, Map<String,Object> conditionValues)
void	removeObjects(Connection c, long[] ids)
void	saveObject(Connection c, DbObject object, Map<Long,String> languageMap, boolean saveTranslations, boolean saveAttributes)
protected void	saveObjectAdditionally(Connection c, DbObject object, long objectId, List<Statement> statements)
void	setObjectContactId(Connection c, long[] objectIds, long contactId)

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

createObject, getNumberOfFiles, getNumberOfFiles, getObject, getObject, getObjectIds, getObjectIds, getObjects, getObjectsByKeyword, loadObjectAttribs, loadObjectAttribs, loadObjectAttribs, loadObjectGeoDbAreas, loadObjectTranslations, loadObjectTranslations, loadObjectTranslations, removeObject, saveObject, saveObject, setObjectContactId

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_OBJECTS

public static final String PROC_REMOVE_OBJECTS

See Also:

Constant Field Values

PROC_REMOVE_OBJECTS_ATTRIBS

public static final String PROC_REMOVE_OBJECTS_ATTRIBS

See Also:

Constant Field Values

PROC_REMOVE_OBJECTS_GEODBS_AREAS

public static final String PROC_REMOVE_OBJECTS_GEODBS_AREAS

See Also:

Constant Field Values

PROC_REMOVE_OBJECTS_I18N

public static final String PROC_REMOVE_OBJECTS_I18N

See Also:

Constant Field Values

PROC_GET_OBJECT_ID

public static final String PROC_GET_OBJECT_ID

See Also:

Constant Field Values

PROC_SAVE_OBJECTS

public static final String PROC_SAVE_OBJECTS

See Also:

Constant Field Values

PROC_SAVE_OBJECTS_ATTRIBS

public static final String PROC_SAVE_OBJECTS_ATTRIBS

See Also:

Constant Field Values

PROC_SAVE_OBJECTS_GEODBS_AREAS

public static final String PROC_SAVE_OBJECTS_GEODBS_AREAS

See Also:

Constant Field Values

PROC_SAVE_OBJECTS_I18N

public static final String PROC_SAVE_OBJECTS_I18N

See Also:

Constant Field Values

PROC_SET_OBJECTS_CONTACT

public static final String PROC_SET_OBJECTS_CONTACT

See Also:

Constant Field Values

VIEW_OBJECTS

public static final String VIEW_OBJECTS

See Also:

Constant Field Values

VIEW_OBJECTS_ACTIONS

public static final String VIEW_OBJECTS_ACTIONS

See Also:

Constant Field Values

VIEW_OBJECTS_ATTRIBS

public static final String VIEW_OBJECTS_ATTRIBS

See Also:

Constant Field Values

VIEW_OBJECTS_GEODBS_AREAS

public static final String VIEW_OBJECTS_GEODBS_AREAS

See Also:

Constant Field Values

VIEW_OBJECTS_I18N

public static final String VIEW_OBJECTS_I18N

See Also:

Constant Field Values

VIEW_OBJECTS_TYPES

public static final String VIEW_OBJECTS_TYPES

See Also:

Constant Field Values

FIELD_OBJECT_ID

public static final String FIELD_OBJECT_ID

See Also:

Constant Field Values

FIELD_OBJECT_TYPE

public static final String FIELD_OBJECT_TYPE

See Also:

Constant Field Values

FIELD_OBJECT_ACTION

public static final String FIELD_OBJECT_ACTION

See Also:

Constant Field Values

FIELD_OBJECT_PUBLIC_ID

public static final String FIELD_OBJECT_PUBLIC_ID

See Also:

Constant Field Values

FIELD_OBJECT_GROUP_ID

public static final String FIELD_OBJECT_GROUP_ID

See Also:

Constant Field Values

FIELD_OBJECT_CURRENCY

public static final String FIELD_OBJECT_CURRENCY

See Also:

Constant Field Values

FIELD_OBJECT_HIDDEN_PRICES

public static final String FIELD_OBJECT_HIDDEN_PRICES

See Also:

Constant Field Values

FIELD_OBJECT_PUBLISH_BEGIN

public static final String FIELD_OBJECT_PUBLISH_BEGIN

See Also:

Constant Field Values

FIELD_OBJECT_PUBLISH_END

public static final String FIELD_OBJECT_PUBLISH_END

See Also:

Constant Field Values

FIELD_ADDRESS_PUBLISHED

public static final String FIELD_ADDRESS_PUBLISHED

See Also:

Constant Field Values

FIELD_ADDRESS_STREET

public static final String FIELD_ADDRESS_STREET

See Also:

Constant Field Values

FIELD_ADDRESS_STREET2

public static final String FIELD_ADDRESS_STREET2

See Also:

Constant Field Values

FIELD_ADDRESS_STREET_NR

public static final String FIELD_ADDRESS_STREET_NR

See Also:

Constant Field Values

FIELD_ADDRESS_POSTAL_CODE

public static final String FIELD_ADDRESS_POSTAL_CODE

See Also:

Constant Field Values

FIELD_ADDRESS_CITY

public static final String FIELD_ADDRESS_CITY

See Also:

Constant Field Values

FIELD_ADDRESS_DISTRICT

public static final String FIELD_ADDRESS_DISTRICT

See Also:

Constant Field Values

FIELD_ADDRESS_COUNTRY

public static final String FIELD_ADDRESS_COUNTRY

See Also:

Constant Field Values

FIELD_ADDRESS_REGION

public static final String FIELD_ADDRESS_REGION

See Also:

Constant Field Values

FIELD_ADDRESS_LATITUDE

public static final String FIELD_ADDRESS_LATITUDE

See Also:

Constant Field Values

FIELD_ADDRESS_LONGITUDE

public static final String FIELD_ADDRESS_LONGITUDE

See Also:

Constant Field Values

FIELD_ATTRIB_NAME

public static final String FIELD_ATTRIB_NAME

See Also:

Constant Field Values

FIELD_ATTRIB_UNIT

public static final String FIELD_ATTRIB_UNIT

See Also:

Constant Field Values

FIELD_VALUE_TEXT

public static final String FIELD_VALUE_TEXT

See Also:

Constant Field Values

FIELD_VALUE_STRING

public static final String FIELD_VALUE_STRING

See Also:

Constant Field Values

FIELD_VALUE_BOOLEAN

public static final String FIELD_VALUE_BOOLEAN

See Also:

Constant Field Values

FIELD_VALUE_NUMERIC

public static final String FIELD_VALUE_NUMERIC

See Also:

Constant Field Values

FIELD_VALUE_NUMERIC_BASE

public static final String FIELD_VALUE_NUMERIC_BASE

See Also:

Constant Field Values

FIELD_VALUE_DATE

public static final String FIELD_VALUE_DATE

See Also:

Constant Field Values

FIELD_VALUE_TIME

public static final String FIELD_VALUE_TIME

See Also:

Constant Field Values

FIELD_VALUE_DATETIME

public static final String FIELD_VALUE_DATETIME

See Also:

Constant Field Values

FIELD_I18N_TITLE

public static final String FIELD_I18N_TITLE

See Also:

Constant Field Values

Constructor Detail

HSqlDbObjectsHandler

public HSqlDbObjectsHandler()

HSqlDbObjectsHandler

public HSqlDbObjectsHandler(String schema)

Method Detail

buildAttrib

protected AbstractAttribImpl buildAttrib(ResultSet result,
                                         Map<Long,String> languages,
                                         EstateImpl estate)
                                  throws SQLException

Throws:

SQLException

buildObject

protected DbObject buildObject(ResultSet result)
                        throws SQLException

Throws:

SQLException

getNumberOfFiles

public int getNumberOfFiles(Connection c,
                            long objectId,
                            Boolean published,
                            String mimeType)
                     throws SQLException

Specified by:

getNumberOfFiles in interface DbObjectsHandler

Specified by:

getNumberOfFiles in class DbObjectsHandlerImpl

Throws:

SQLException

getObjects

public DbObject[] getObjects(Connection c,
                             long[] ids)
                      throws SQLException

Specified by:

getObjects in interface DbObjectsHandler

Specified by:

getObjects in class DbObjectsHandlerImpl

Throws:

SQLException

getObjects

public DbObject[] getObjects(Connection c,
                             String[] nrs)
                      throws SQLException

Specified by:

getObjects in interface DbObjectsHandler

Specified by:

getObjects in class DbObjectsHandlerImpl

Throws:

SQLException

getObjects

public DbObject[] getObjects(Connection c,
                             DbSearch search)
                      throws SQLException

Specified by:

getObjects in interface DbObjectsHandler

Overrides:

getObjects in class DbObjectsHandlerImpl

Throws:

SQLException

getObjectsByKeyword

public DbObject[] getObjectsByKeyword(Connection c,
                                      String keyword,
                                      int limit)
                               throws SQLException

Specified by:

getObjectsByKeyword in interface DbObjectsHandler

Specified by:

getObjectsByKeyword in class DbObjectsHandlerImpl

Throws:

SQLException

getObjectActions

public OpenEstateAction[] getObjectActions(Connection c)
                                    throws SQLException

Specified by:

getObjectActions in interface DbObjectsHandler

Specified by:

getObjectActions in class DbObjectsHandlerImpl

Throws:

SQLException

getObjectId

public long getObjectId(Connection c,
                        String publicId)
                 throws SQLException

Specified by:

getObjectId in interface DbObjectsHandler

Specified by:

getObjectId in class DbObjectsHandlerImpl

Throws:

SQLException

getObjectIds

public long[] getObjectIds(Connection c,
                           long[] contactIds)
                    throws SQLException

Specified by:

getObjectIds in interface DbObjectsHandler

Specified by:

getObjectIds in class DbObjectsHandlerImpl

Throws:

SQLException

getObjectIds

public long[] getObjectIds(Connection c,
                           DbSearch search)
                    throws SQLException

Specified by:

getObjectIds in interface DbObjectsHandler

Specified by:

getObjectIds in class DbObjectsHandlerImpl

Throws:

SQLException

getObjectTypes

public OpenEstateType[] getObjectTypes(Connection c)
                                throws SQLException

Specified by:

getObjectTypes in interface DbObjectsHandler

Specified by:

getObjectTypes in class DbObjectsHandlerImpl

Throws:

SQLException

loadObjectAttribs

public void loadObjectAttribs(Connection c,
                              DbObject[] objects,
                              Map<Long,String> languageMap)
                       throws SQLException

Specified by:

loadObjectAttribs in interface DbObjectsHandler

Specified by:

loadObjectAttribs in class DbObjectsHandlerImpl

Throws:

SQLException

loadObjectGeoDbAreas

public void loadObjectGeoDbAreas(Connection c,
                                 DbObject[] objects,
                                 DbGeoHandler geoHandler)
                          throws SQLException

Specified by:

loadObjectGeoDbAreas in interface DbObjectsHandler

Specified by:

loadObjectGeoDbAreas in class DbObjectsHandlerImpl

Throws:

SQLException

loadObjectTranslations

public void loadObjectTranslations(Connection c,
                                   DbObject[] objects,
                                   Map<Long,String> languageMap)
                            throws SQLException

Specified by:

loadObjectTranslations in interface DbObjectsHandler

Specified by:

loadObjectTranslations in class DbObjectsHandlerImpl

Throws:

SQLException

loadSearchConditions

protected void loadSearchConditions(DbSearch search,
                                    List<String> conditions,
                                    Map<String,Object> conditionValues)

loadSearchParameters

protected void loadSearchParameters(NamedPreparedStatement statement,
                                    Map<String,Object> conditionValues)
                             throws SQLException

Throws:

SQLException

removeObjects

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

Specified by:

removeObjects in interface DbObjectsHandler

Specified by:

removeObjects in class DbObjectsHandlerImpl

Throws:

SQLException

saveObject

public void saveObject(Connection c,
                       DbObject object,
                       Map<Long,String> languageMap,
                       boolean saveTranslations,
                       boolean saveAttributes)
                throws SQLException

Specified by:

saveObject in interface DbObjectsHandler

Specified by:

saveObject in class DbObjectsHandlerImpl

Throws:

SQLException

saveObjectAdditionally

protected void saveObjectAdditionally(Connection c,
                                      DbObject object,
                                      long objectId,
                                      List<Statement> statements)
                               throws SQLException

Throws:

SQLException

setObjectContactId

public void setObjectContactId(Connection c,
                               long[] objectIds,
                               long contactId)
                        throws SQLException

Specified by:

setObjectContactId in interface DbObjectsHandler

Specified by:

setObjectContactId in class DbObjectsHandlerImpl

Throws:

SQLException