com.openindex.openestate.impl.db.hsql

Class HSqlDbGeoHandler

java.lang.Object

com.openindex.openestate.impl.db.DbHandlerImpl

com.openindex.openestate.impl.db.DbGeoHandlerImpl

com.openindex.openestate.impl.db.hsql.HSqlDbGeoHandler

All Implemented Interfaces:

DbGeoHandler, DbHandler

public class HSqlDbGeoHandler
extends DbGeoHandlerImpl

HSqlDbGeoHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field and Description
static String	FIELD_AREA_ID
static String	FIELD_AREA_LEVEL
static String	FIELD_AREA_NAME
static String	FIELD_AREA_PARENT_ID
static String	FIELD_AREA_PROVIDER_ID
static String	FIELD_COUNTRY_ID
static String	FIELD_COUNTRY_ISO
static String	FIELD_COUNTRY_NAME
static String	FIELD_COUNTRY_PROVIDER_ID
static String	FIELD_GEODB_BUILD_TIME
static String	FIELD_GEODB_ID
static String	FIELD_GEODB_NAME
static String	FIELD_GEODB_PROVIDER
static String	PROC_REMOVE_AREAS
static String	PROC_REMOVE_COUNTRIES
static String	PROC_REMOVE_GEODBS
static String	PROC_SAVE_AREAS
static String	PROC_SAVE_COUNTRIES
static String	PROC_SAVE_GEODBS
static String	VIEW_AREAS
static String	VIEW_COUNTRIES
static String	VIEW_GEODBS

Constructor Summary

Constructors

Constructor and Description
HSqlDbGeoHandler()
HSqlDbGeoHandler(String schema)

Method Summary

Modifier and Type	Method and Description
DbGeoArea[]	getGeoAreas(Connection c, long parentAreaId)
DbGeoArea[]	getGeoAreas(Connection c, long[] ids)
DbGeoArea[]	getGeoAreas(Connection c, long countryId, boolean recursive)
DbGeoArea[]	getGeoAreas(Connection c, long countryId, GeoAreaLevel level)
DbGeoCountry[]	getGeoCountries(Connection c, long geoDbId)
DbGeoCountry[]	getGeoCountries(Connection c, long[] ids)
DbGeoCountry	getGeoCountry(Connection c, long geoDbId, String iso)
DbGeo[]	getGeoDbs(Connection c, long[] ids)
DbGeo[]	getGeoDbs(Connection c, String[] names)
void	removeGeoAreas(Connection c, long[] ids)
void	removeGeoCountries(Connection c, long[] ids)
void	removeGeoDbs(Connection c, long[] ids)
void	saveGeoArea(Connection c, DbGeoArea area, boolean recursive)
void	saveGeoCountry(Connection c, DbGeoCountry country, boolean recursive)
void	saveGeoDb(Connection c, DbGeo geo, boolean recursive)

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

getGeoArea, getGeoCountry, getGeoDb, getGeoDb, getGeoDbs, mergeFromXml, removeGeoArea, removeGeoCountry, removeGeoDb

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

VIEW_AREAS

public static final String VIEW_AREAS

See Also:

Constant Field Values

VIEW_COUNTRIES

public static final String VIEW_COUNTRIES

See Also:

Constant Field Values

VIEW_GEODBS

public static final String VIEW_GEODBS

See Also:

Constant Field Values

PROC_REMOVE_AREAS

public static final String PROC_REMOVE_AREAS

See Also:

Constant Field Values

PROC_REMOVE_COUNTRIES

public static final String PROC_REMOVE_COUNTRIES

See Also:

Constant Field Values

PROC_REMOVE_GEODBS

public static final String PROC_REMOVE_GEODBS

See Also:

Constant Field Values

PROC_SAVE_AREAS

public static final String PROC_SAVE_AREAS

See Also:

Constant Field Values

PROC_SAVE_COUNTRIES

public static final String PROC_SAVE_COUNTRIES

See Also:

Constant Field Values

PROC_SAVE_GEODBS

public static final String PROC_SAVE_GEODBS

See Also:

Constant Field Values

FIELD_GEODB_ID

public static final String FIELD_GEODB_ID

See Also:

Constant Field Values

FIELD_GEODB_NAME

public static final String FIELD_GEODB_NAME

See Also:

Constant Field Values

FIELD_GEODB_PROVIDER

public static final String FIELD_GEODB_PROVIDER

See Also:

Constant Field Values

FIELD_GEODB_BUILD_TIME

public static final String FIELD_GEODB_BUILD_TIME

See Also:

Constant Field Values

FIELD_AREA_ID

public static final String FIELD_AREA_ID

See Also:

Constant Field Values

FIELD_AREA_PARENT_ID

public static final String FIELD_AREA_PARENT_ID

See Also:

Constant Field Values

FIELD_AREA_NAME

public static final String FIELD_AREA_NAME

See Also:

Constant Field Values

FIELD_AREA_LEVEL

public static final String FIELD_AREA_LEVEL

See Also:

Constant Field Values

FIELD_AREA_PROVIDER_ID

public static final String FIELD_AREA_PROVIDER_ID

See Also:

Constant Field Values

FIELD_COUNTRY_ID

public static final String FIELD_COUNTRY_ID

See Also:

Constant Field Values

FIELD_COUNTRY_ISO

public static final String FIELD_COUNTRY_ISO

See Also:

Constant Field Values

FIELD_COUNTRY_NAME

public static final String FIELD_COUNTRY_NAME

See Also:

Constant Field Values

FIELD_COUNTRY_PROVIDER_ID

public static final String FIELD_COUNTRY_PROVIDER_ID

See Also:

Constant Field Values

Constructor Detail

HSqlDbGeoHandler

public HSqlDbGeoHandler()

HSqlDbGeoHandler

public HSqlDbGeoHandler(String schema)

Method Detail

getGeoAreas

public DbGeoArea[] getGeoAreas(Connection c,
                               long[] ids)
                        throws SQLException

Specified by:

getGeoAreas in interface DbGeoHandler

Specified by:

getGeoAreas in class DbGeoHandlerImpl

Throws:

SQLException

getGeoAreas

public DbGeoArea[] getGeoAreas(Connection c,
                               long parentAreaId)
                        throws SQLException

Specified by:

getGeoAreas in interface DbGeoHandler

Specified by:

getGeoAreas in class DbGeoHandlerImpl

Throws:

SQLException

getGeoAreas

public DbGeoArea[] getGeoAreas(Connection c,
                               long countryId,
                               GeoAreaLevel level)
                        throws SQLException

Specified by:

getGeoAreas in interface DbGeoHandler

Specified by:

getGeoAreas in class DbGeoHandlerImpl

Throws:

SQLException

getGeoAreas

public DbGeoArea[] getGeoAreas(Connection c,
                               long countryId,
                               boolean recursive)
                        throws SQLException

Specified by:

getGeoAreas in interface DbGeoHandler

Specified by:

getGeoAreas in class DbGeoHandlerImpl

Throws:

SQLException

getGeoCountries

public DbGeoCountry[] getGeoCountries(Connection c,
                                      long[] ids)
                               throws SQLException

Specified by:

getGeoCountries in interface DbGeoHandler

Specified by:

getGeoCountries in class DbGeoHandlerImpl

Throws:

SQLException

getGeoCountries

public DbGeoCountry[] getGeoCountries(Connection c,
                                      long geoDbId)
                               throws SQLException

Specified by:

getGeoCountries in interface DbGeoHandler

Specified by:

getGeoCountries in class DbGeoHandlerImpl

Throws:

SQLException

getGeoCountry

public DbGeoCountry getGeoCountry(Connection c,
                                  long geoDbId,
                                  String iso)
                           throws SQLException

Specified by:

getGeoCountry in interface DbGeoHandler

Specified by:

getGeoCountry in class DbGeoHandlerImpl

Throws:

SQLException

getGeoDbs

public DbGeo[] getGeoDbs(Connection c,
                         long[] ids)
                  throws SQLException

Specified by:

getGeoDbs in interface DbGeoHandler

Specified by:

getGeoDbs in class DbGeoHandlerImpl

Throws:

SQLException

getGeoDbs

public DbGeo[] getGeoDbs(Connection c,
                         String[] names)
                  throws SQLException

Specified by:

getGeoDbs in interface DbGeoHandler

Specified by:

getGeoDbs in class DbGeoHandlerImpl

Throws:

SQLException

removeGeoAreas

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

Specified by:

removeGeoAreas in interface DbGeoHandler

Specified by:

removeGeoAreas in class DbGeoHandlerImpl

Throws:

SQLException

removeGeoCountries

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

Specified by:

removeGeoCountries in interface DbGeoHandler

Specified by:

removeGeoCountries in class DbGeoHandlerImpl

Throws:

SQLException

removeGeoDbs

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

Specified by:

removeGeoDbs in interface DbGeoHandler

Specified by:

removeGeoDbs in class DbGeoHandlerImpl

Throws:

SQLException

saveGeoArea

public void saveGeoArea(Connection c,
                        DbGeoArea area,
                        boolean recursive)
                 throws SQLException

Specified by:

saveGeoArea in interface DbGeoHandler

Specified by:

saveGeoArea in class DbGeoHandlerImpl

Throws:

SQLException

saveGeoCountry

public void saveGeoCountry(Connection c,
                           DbGeoCountry country,
                           boolean recursive)
                    throws SQLException

Specified by:

saveGeoCountry in interface DbGeoHandler

Specified by:

saveGeoCountry in class DbGeoHandlerImpl

Throws:

SQLException

saveGeoDb

public void saveGeoDb(Connection c,
                      DbGeo geo,
                      boolean recursive)
               throws SQLException

Specified by:

saveGeoDb in interface DbGeoHandler

Specified by:

saveGeoDb in class DbGeoHandlerImpl

Throws:

SQLException