stella.sensor

Class DatabaseSensor

java.lang.Object

util.PropertyContainer

util.PropertyResources

util.rmi.RmiPropertyContainer

util.rmi.AbstractRmiCaster

stella.sensor.AbstractSensor

stella.sensor.TimerTaskSensor

stella.sensor.DataSensor

stella.sensor.CumulativeSensor

stella.sensor.PredictiveSensor

stella.sensor.SmoothingSensor

stella.sensor.DerivativeSensor

stella.sensor.WeatherSensor

stella.sensor.DatabaseSensor

All Implemented Interfaces:

Cloneable, Remote, Caster, DataCaster, RmiDataCaster, RmiErrorCaster, Cumulating, Deriving, Predicting, Smoothing, Telemetering, WeatherJudging, WeatherCaster, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying, RmiCaster, RmiPropertyBearing

public class DatabaseSensor
extends WeatherSensor

A sensor that reads its data out of a (remote) database. Does not use the StaticSql class, unless the remote DB is also a PSQL.

Author:

wooz

Nested Class Summary

Nested classes/interfaces inherited from class stella.sensor.TimerTaskSensor

TimerTaskSensor.SensorRead

Nested classes/interfaces inherited from class util.PropertyResources

PropertyResources.Load, PropertyResources.URLResource

Field Summary

Fields

Modifier and Type	Field and Description
private static DateFormat	DEFDATETIMEFORMAT The default date-time format for sql date and time objects, no ms.
static String	KEY_BRIDGE Class name of the JDBC-DB bridge.
static String	KEY_CONNECT The driver-specific connection string.
static String	KEY_DATACOLUMN What to read.
static String	KEY_DATETIMEFORMAT The date formatter to use.
static String	KEY_PASSWORD The password used for identifying the user.
static String	KEY_USERNAME The user name to identify the class on the database.
static String	KEY_WHERECLAUSE Where to read.
static String	KEY_WHERECOLUMN Where to read.
private long	lastread Last time DB was accessed.
private boolean	lastvalid Last DB access was successful.
private static boolean	LOADED If true, bridge is loaded.

Fields inherited from class stella.sensor.WeatherSensor

KEY_DERIVATIVEINVALID, KEY_DERIVATIVEPARAMETER, KEY_INVERSE, KEY_INVERSEDERIVATIVE, KEY_JUDGEDERIVATIVE, KEY_JUDGEPREDICT, KEY_JUDGERAW, KEY_JUDGESMOOTH, KEY_PREDICTINVALID, KEY_PREDICTPARAMETER, KEY_RAWINVALID, KEY_RAWPARAMETER, KEY_RETARDBADDERIVATIVE, KEY_RETARDBADPREDICT, KEY_RETARDBADRAW, KEY_RETARDBADSMOOTH, KEY_RETARDGOODDERIVATIVE, KEY_RETARDGOODPREDICT, KEY_RETARDGOODRAW, KEY_RETARDGOODSMOOTH, KEY_SMOOTHINVALID, KEY_SMOOTHPARAMETER

Fields inherited from class stella.sensor.DerivativeSensor

DEFRAWDERIVATIVE, derive, KEY_DERIVATIVEADVISE, KEY_DERIVE, KEY_PATH, KEY_RAWDERIVATIVE, z

Fields inherited from class stella.sensor.SmoothingSensor

f, g, KEY_SMOOTH, KEY_SMOOTHADVISE

Fields inherited from class stella.sensor.PredictiveSensor

KEY_CHI, KEY_EXTRAPOLATE, KEY_FUTURE, KEY_PREDICTADVISE, predict

Fields inherited from class stella.sensor.CumulativeSensor

KEY_AVERAGE, KEY_MEMORY, KEY_PACK

Fields inherited from class stella.sensor.DataSensor

DEFRAWFORMAT, DEFREPORT, DEFSIGMAFORMAT, KEY_RAWFORMAT, KEY_REPORT, KEY_SIGMAFORMAT

Fields inherited from class stella.sensor.TimerTaskSensor

KEY_LOGRAWABOVE, KEY_LOGRAWBELOW, KEY_LOGREADLAG, KEY_RESPAWN

Fields inherited from class stella.sensor.AbstractSensor

KEY_BIND, KEY_BINDNAME, KEY_CONVERT, KEY_DESCRIPTION, KEY_SENSORNAME

Fields inherited from class util.rmi.AbstractRmiCaster

ALTERNATEHOST, ALTERNATEPORT, KEY_EXPORTPORT, KEY_REGISTRYHOST, KEY_REGISTRYPORT

Fields inherited from class util.PropertyResources

KEY_NOINITONCREATE, POSTFIX_ALPHABET, POSTFIX_BYTES, POSTFIX_DIR, POSTFIX_EXT, POSTFIX_FILE, POSTFIX_LIST, POSTFIX_MODTIME, POSTFIX_URL

Fields inherited from class util.PropertyContainer

KEY_LISTSEPARATOR, KEY_MAPKEYVALUECHAR, KEY_MAPSEPARATOR

Fields inherited from interface stella.rmi.RmiDataCaster

NAMING_EXTENSION

Fields inherited from interface util.PropertySupplying

CONFIG, KEY_CLASS

Fields inherited from interface util.ResourceSupplying

KEY_URLRESOURCES, KEY_URLUSECONFIG, KEY_URLUSECURRENT, KEY_URLUSEHOME

Constructor Summary

Constructors

Constructor and Description
DatabaseSensor(Map<String,String> qualify)

Method Summary

Modifier and Type	Method and Description
protected String	getColumnClause() Returns average of data column as part of a select clause.
protected String	getWhereClause(long from, long to)
void	init() Does some initialization immediately after the construction phase.
protected double	readSensor() This read from the database.
boolean	validReading() Returns true if the last reading is valid.

Methods inherited from class stella.sensor.WeatherSensor

addWeatherListener, conductOneMeasure, currentlyClear, currentlyRetarding, generateDataEvent, getMinClearUpTime, getSensorInitInfo, goodFromDerivative, goodFromPredict, goodFromRaw, goodFromSmooth, isDerivativeRetard, isPredictRetard, isRawRetard, isSmoothRetard, judgeWeather, notifyWeatherListener, removeWeatherListener, status

Methods inherited from class stella.sensor.DerivativeSensor

deriveAt, getDerivativeFormat, getDerivativeToggleInfo, getDerivator, getLastDerivative, isDerivativeAdvise, isDeriving, newData, regetDerive, registerDerivator

Methods inherited from class stella.sensor.SmoothingSensor

getLastSmooth, getSmoother, getSmoothToggleInfo, isSmoothAdvise, isSmoothing, regetSmooth, registerSmoother, smoothOne

Methods inherited from class stella.sensor.PredictiveSensor

getExtrapolation, getLastPredict, getPredictToggleInfo, isPredictAdvise, isPredicting, isReliable, predictFrom, regetPredict

Methods inherited from class stella.sensor.CumulativeSensor

cumulateOne, getLastRaw, getLastTime, getMaxSize, getMemory, getSize

Methods inherited from class stella.sensor.DataSensor

addDataListener, addRmiDataListener, exit, getRawFormat, getSigmaFormat, removeDataListener, removeRmiDataListener, report

Methods inherited from class stella.sensor.TimerTaskSensor

cancel, equals, getRawToggleInfo, getReading, getRespawn, getTimeOfRead, hashCode, initSensorTimerTask, isReady, regetRaw, setTimeOfRead, validReading

Methods inherited from class stella.sensor.AbstractSensor

addRmiErrorListener, createSensor, getBindName, getConvert, getSensorDescription, getSensorName, notifyErrorListener, removeRmiErrorListener, setConvert, toString

Methods inherited from class util.rmi.AbstractRmiCaster

bindToRegistry, bindToRegistry, bindToRegistry, bindToRegistry, bindToRegistry, bindToRegistry, casterExit, casterExit, getBindName, isValid, unbindFromRegistry, unbindFromRegistry

Methods inherited from class util.rmi.RmiPropertyContainer

containsRemoteProperty, getRemoteProperties, getRemoteProperty, setRemoteProperty

Methods inherited from class util.PropertyResources

clone, createFrom, createFrom, createFrom, createInstance, getApplet, getAsResources, getLocate, getPropertiesToKey, getPropertiesToKey, getResource, getResourceAsStream, getResourceFromKey, getResources, hasLocalURLs, initProperties, keyCreate, keyCreate, reload, setApplet

Methods inherited from class util.PropertyContainer

augment, augment, augment, augment, augment, defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsEnums, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, isNew, parseObject, parseObject, reload, removeProperty, requires, rescanned, setObject, setProperties, setProperty, stringProperties

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface stella.sensor.Cumulating

cumulateOne, getLastRaw, getLastTime, getMaxSize, getSize, getTimeOfRead, regetRaw

Methods inherited from interface util.rmi.RmiCaster

bindToRegistry, isValid, unbindFromRegistry

Methods inherited from interface util.PropertySupplying

defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, parseObject, removeProperty, setObject, setProperty, stringProperties

Field Detail

KEY_BRIDGE

public static final String KEY_BRIDGE

Class name of the JDBC-DB bridge. If empty(=PSQL), no bridge loaded.

See Also:

Constant Field Values

KEY_CONNECT

public static final String KEY_CONNECT

The driver-specific connection string.

See Also:

Constant Field Values

KEY_USERNAME

public static final String KEY_USERNAME

The user name to identify the class on the database.

See Also:

Constant Field Values

KEY_PASSWORD

public static final String KEY_PASSWORD

The password used for identifying the user. Not encrypted.

See Also:

Constant Field Values

KEY_DATETIMEFORMAT

public static final String KEY_DATETIMEFORMAT

The date formatter to use.

See Also:

Constant Field Values

KEY_WHERECOLUMN

public static final String KEY_WHERECOLUMN

Where to read.

See Also:

Constant Field Values

KEY_WHERECLAUSE

public static final String KEY_WHERECLAUSE

Where to read.

See Also:

Constant Field Values

KEY_DATACOLUMN

public static final String KEY_DATACOLUMN

What to read.

See Also:

Constant Field Values

DEFDATETIMEFORMAT

private static final DateFormat DEFDATETIMEFORMAT

The default date-time format for sql date and time objects, no ms.

LOADED

private static boolean LOADED

If true, bridge is loaded.

lastread

private long lastread

Last time DB was accessed.

lastvalid

private boolean lastvalid

Last DB access was successful.

Constructor Detail

DatabaseSensor

public DatabaseSensor(Map<String,String> qualify)

Parameters:

qualify -

Method Detail

init

public void init()
          throws InitException

Description copied from class: AbstractSensor

Does some initialization immediately after the construction phase. This construct can be used to circumvent timing conflicts during the construction phase. E.g. subclasses can override this method by a simple empty method, comence the construction with the super keyword and add another init routine after the construction phase that eventually calls this method.

Specified by:

init in interface Initializable

Overrides:

init in class PredictiveSensor

Throws:

InitException

validReading

public boolean validReading()

Description copied from interface: Telemetering

Returns true if the last reading is valid.

readSensor

protected double readSensor()

This read from the database. As requested for sensor, NaN is returned on invalid readings.

Specified by:

readSensor in class TimerTaskSensor

See Also:

ConvertToPhysical

getWhereClause

protected String getWhereClause(long from,
                                long to)

getColumnClause

protected String getColumnClause()

Returns average of data column as part of a select clause.

Returns: