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

Class HSqlDbAgencyObjectsHandler

java.lang.Object

com.openindex.openestate.impl.db.DbHandlerImpl

com.openindex.openestate.impl.db.DbObjectsHandlerImpl

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

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

All Implemented Interfaces:

DbHandler, DbObjectsHandler, DbAgencyObjectsHandler

public class HSqlDbAgencyObjectsHandler
extends HSqlDbObjectsHandler
implements DbAgencyObjectsHandler

HSqlDbAgencyObjectHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_OBJECT_EXPORT_MODE
static String	FIELD_OBJECT_IMPORT_HASH
static String	FIELD_OBJECT_IMPORT_ID
static String	FIELD_OBJECT_NOTES
static String	FIELD_OBJECT_STATUS
static String	PROC_REMOVE_OBJECTS_EXPORTS
static String	PROC_SAVE_OBJECTS_ADDON
static String	PROC_SAVE_OBJECTS_EXPORTS
static String	PROC_SET_OBJECTS_STATUS
static String	TABLE_OBJECTS
static String	TABLE_OBJECTS_EXPORTS
static String	VIEW_OBJECTS_EXPORTS

Fields inherited from class com.openindex.openestate.impl.db.hsql.HSqlDbObjectsHandler

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

Constructor Summary

Constructors

Constructor	Description
HSqlDbAgencyObjectsHandler()

Method Summary

Modifier and Type	Method	Description
protected DbObject	buildObject(ResultSet result)
protected DbObject	createObject()
DbAgencyObject	getObjectByImportHash(Connection c, String importHash)
DbAgencyObject	getObjectByImportId(Connection c, String importId)
long[]	getObjectIdsForExport(Connection c, long exportId, DbAgencySearch search)
DbObject[]	getObjects(Connection c, DbAgencyObject.Status status, DbAgencyObject.ExportMode exportMode)
DbObject[]	getObjectsForExport(Connection c, long exportId)	Deprecated.
void	loadObjectExportIds(Connection c, DbAgencyObject object)
void	loadObjectExportIds(Connection c, DbAgencyObject[] objects)
protected void	loadSearchConditions(DbSearch search, List<String> conditions, Map<String,Object> conditionValues)
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	setObjectStatus(Connection c, long[] objectIds, DbAgencyObject.Status status)
void	setObjectStatus(Connection c, long objectId, DbAgencyObject.Status status)

Methods inherited from class com.openindex.openestate.impl.db.hsql.HSqlDbObjectsHandler

buildAttrib, getNumberOfFiles, getObjectActions, getObjectId, getObjectIds, getObjectIds, getObjects, getObjects, getObjects, getObjectsByKeyword, getObjectTypes, loadObjectAttribs, loadObjectGeoDbAreas, loadObjectTranslations, loadSearchParameters, removeObjects, setObjectContactId

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

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

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

getNumberOfFiles, getNumberOfFiles, getNumberOfFiles, getObject, getObject, getObjectActions, getObjectId, getObjectIds, getObjectIds, getObjectIds, getObjectIds, getObjects, getObjects, getObjects, getObjects, getObjectsByKeyword, getObjectsByKeyword, getObjectTypes, loadObjectAttribs, loadObjectAttribs, loadObjectAttribs, loadObjectAttribs, loadObjectGeoDbAreas, loadObjectGeoDbAreas, loadObjectTranslations, loadObjectTranslations, loadObjectTranslations, loadObjectTranslations, removeObject, removeObjects, saveObject, saveObject, setObjectContactId, setObjectContactId

Field Detail

PROC_REMOVE_OBJECTS_EXPORTS

public static final String PROC_REMOVE_OBJECTS_EXPORTS

See Also:

Constant Field Values

PROC_SAVE_OBJECTS_ADDON

public static final String PROC_SAVE_OBJECTS_ADDON

See Also:

Constant Field Values

PROC_SAVE_OBJECTS_EXPORTS

public static final String PROC_SAVE_OBJECTS_EXPORTS

See Also:

Constant Field Values

PROC_SET_OBJECTS_STATUS

public static final String PROC_SET_OBJECTS_STATUS

See Also:

Constant Field Values

VIEW_OBJECTS_EXPORTS

public static final String VIEW_OBJECTS_EXPORTS

See Also:

Constant Field Values

TABLE_OBJECTS

public static final String TABLE_OBJECTS

See Also:

Constant Field Values

FIELD_OBJECT_STATUS

public static final String FIELD_OBJECT_STATUS

See Also:

Constant Field Values

FIELD_OBJECT_EXPORT_MODE

public static final String FIELD_OBJECT_EXPORT_MODE

See Also:

Constant Field Values

FIELD_OBJECT_IMPORT_ID

public static final String FIELD_OBJECT_IMPORT_ID

See Also:

Constant Field Values

FIELD_OBJECT_IMPORT_HASH

public static final String FIELD_OBJECT_IMPORT_HASH

See Also:

Constant Field Values

FIELD_OBJECT_NOTES

public static final String FIELD_OBJECT_NOTES

See Also:

Constant Field Values

TABLE_OBJECTS_EXPORTS

public static final String TABLE_OBJECTS_EXPORTS

See Also:

Constant Field Values

Constructor Detail

HSqlDbAgencyObjectsHandler

public HSqlDbAgencyObjectsHandler()

Method Detail

buildObject

protected DbObject buildObject(ResultSet result)
                        throws SQLException

Overrides:

buildObject in class HSqlDbObjectsHandler

Throws:

SQLException

createObject

protected DbObject createObject()

Overrides:

createObject in class DbObjectsHandlerImpl

getObjectByImportHash

public DbAgencyObject getObjectByImportHash(Connection c,
                                            String importHash)
                                     throws SQLException

Specified by:

getObjectByImportHash in interface DbAgencyObjectsHandler

Throws:

SQLException

getObjectByImportId

public DbAgencyObject getObjectByImportId(Connection c,
                                          String importId)
                                   throws SQLException

Specified by:

getObjectByImportId in interface DbAgencyObjectsHandler

Throws:

SQLException

getObjectIdsForExport

public long[] getObjectIdsForExport(Connection c,
                                    long exportId,
                                    DbAgencySearch search)
                             throws SQLException

Specified by:

getObjectIdsForExport in interface DbAgencyObjectsHandler

Throws:

SQLException

getObjects

public DbObject[] getObjects(Connection c,
                             DbAgencyObject.Status status,
                             DbAgencyObject.ExportMode exportMode)
                      throws SQLException

Specified by:

getObjects in interface DbAgencyObjectsHandler

Throws:

SQLException

getObjectsForExport

@Deprecated
public DbObject[] getObjectsForExport(Connection c,
                                      long exportId)
                               throws SQLException

Deprecated.

Specified by:

getObjectsForExport in interface DbAgencyObjectsHandler

Throws:

SQLException

loadObjectExportIds

public void loadObjectExportIds(Connection c,
                                DbAgencyObject object)
                         throws SQLException

Specified by:

loadObjectExportIds in interface DbAgencyObjectsHandler

Throws:

SQLException

loadObjectExportIds

public void loadObjectExportIds(Connection c,
                                DbAgencyObject[] objects)
                         throws SQLException

Specified by:

loadObjectExportIds in interface DbAgencyObjectsHandler

Throws:

SQLException

loadSearchConditions

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

Overrides:

loadSearchConditions in class HSqlDbObjectsHandler

saveObject

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

Specified by:

saveObject in interface DbObjectsHandler

Overrides:

saveObject in class HSqlDbObjectsHandler

Throws:

SQLException

saveObjectAdditionally

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

Overrides:

saveObjectAdditionally in class HSqlDbObjectsHandler

Throws:

SQLException

setObjectStatus

public void setObjectStatus(Connection c,
                            long objectId,
                            DbAgencyObject.Status status)
                     throws SQLException

Specified by:

setObjectStatus in interface DbAgencyObjectsHandler

Throws:

SQLException

setObjectStatus

public void setObjectStatus(Connection c,
                            long[] objectIds,
                            DbAgencyObject.Status status)
                     throws SQLException

Specified by:

setObjectStatus in interface DbAgencyObjectsHandler

Throws:

SQLException