mysql

Class EnvironmentSql

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

mysql.EnvironmentSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

Direct Known Subclasses:

WeatherSql

public class EnvironmentSql
extends AbstractSql

Author:

wooz

Nested Class Summary

Nested classes/interfaces inherited from class mysql.AbstractSql

AbstractSql.Columns, AbstractSql.Extract

Nested classes/interfaces inherited from class util.PropertyResources

PropertyResources.Load, PropertyResources.URLResource

Field Summary

Fields

Modifier and Type	Field and Description
private static String	DEFDATEFIELD Default field name.
private static String	DEFGOODFIELD Default field name.
private static double	DEFINTERVAL Default 5 min interval.
private static String	DEFTABLE The default table name.
static String	KEY_DATEFIELD Primary key.
static String	KEY_GOODFIELD The weather-good indicator, linked to either 'y' or 'n'.
static String	KEY_INTERVAL Default seconds between weather entries.

Fields inherited from class mysql.AbstractSql

KEY_TABLE, SQLBATCHDIR, SQLFAILDIR

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 util.ResourceSupplying

KEY_URLRESOURCES, KEY_URLUSECONFIG, KEY_URLUSECURRENT, KEY_URLUSEHOME

Fields inherited from interface util.PropertySupplying

CONFIG, KEY_CLASS

Constructor Summary

Constructors

Constructor and Description
EnvironmentSql(Map<String,String> prop)

Method Summary

Modifier and Type	Method and Description
private int	count(String where)
int	countAll(Date from, Date to)
int	countGood(Date from, Date to)
private String	dateConstraint(Date from, Date to)
double	getInterval() Returns the average interval between measurement entries in the env table.

Methods inherited from class mysql.AbstractSql

delete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, getTable, init, insert, isEntry, release, release, replace, retrieve, retrieve, retrieve, single, single

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, toString

Methods inherited from class java.lang.Object

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

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_DATEFIELD

public static final String KEY_DATEFIELD

Primary key.

See Also:

Constant Field Values

KEY_GOODFIELD

public static final String KEY_GOODFIELD

The weather-good indicator, linked to either 'y' or 'n'.

See Also:

Constant Field Values

KEY_INTERVAL

public static final String KEY_INTERVAL

Default seconds between weather entries.

See Also:

Constant Field Values

DEFTABLE

private static final String DEFTABLE

The default table name.

See Also:

Constant Field Values

DEFDATEFIELD

private static final String DEFDATEFIELD

Default field name.

See Also:

Constant Field Values

DEFGOODFIELD

private static final String DEFGOODFIELD

Default field name.

See Also:

Constant Field Values

DEFINTERVAL

private static final double DEFINTERVAL

Default 5 min interval.

See Also:

Constant Field Values

Constructor Detail

EnvironmentSql

public EnvironmentSql(Map<String,String> prop)

Parameters:

prop -

Method Detail

getInterval

public double getInterval()

Returns the average interval between measurement entries in the env table. Counting the total number of entries within a ceratin time interval multiplied with this value gives you the best indicator of system uptime.

Returns:

300 seconds

countAll

public int countAll(Date from,
                    Date to)
             throws SQLException

Throws:

SQLException

countGood

public int countGood(Date from,
                     Date to)
              throws SQLException

Throws:

SQLException

count

private int count(String where)
           throws SQLException

Throws:

SQLException

dateConstraint

private String dateConstraint(Date from,
                              Date to)