stella.sql
Class OffLimitVisual

java.lang.Object
  util.PropertyContainer
      util.PropertyResources
          util.PropertyBundles
              mysql.AbstractSql
                  stella.sql.NightlyStatistic
                      stella.sql.OffLimitAlarm
                          stella.sql.OffLimitVisual

All Implemented Interfaces:

Cloneable, Initializable, LocalizedSupplying, PropertySupplying, ResourceSupplying

Direct Known Subclasses:

JOffLimit, JOffTails

public class OffLimitVisual
extends OffLimitAlarm

Uses an offset alert statistic to provide a one-look health display of the two telescopes plus environment conditions.

Nested Class Summary

static class	OffLimitVisual.Flavor
static class	OffLimitVisual.Signal A container class to hold all information of nightly statistics that are derived from the database and evaluated to fulfill certain limits.

Nested classes/interfaces inherited from class stella.sql.NightlyStatistic

NightlyStatistic.Duty, NightlyStatistic.Env, NightlyStatistic.Night

Nested classes/interfaces inherited from class util.PropertyResources

PropertyResources.URLResource

Field Summary

private static String	DEFDONELIST The fields to query from the env table.
private static String	DEFDONENAMES How the returned columns are named.
private static String	DEFDONEWHERE Additional constraints for the done table query.
private static String	DEFENVLIST Properties for the offlimit display.
private static String	DEFENVNAMES Properties for the offlimit display.
private static String	DEFJOINTLIST The fields to query from the env table.
private static String	DEFJOINTNAMES How the returned columns are named.
private static String	DEFJOINTWHERE Additional constraints for the joint table query.
private static String	DEFOBSLIST Properties for the offlimit display.
private static String	DEFOBSNAMES Properties for the offlimit display.
private static String	DEFREDAVENV The list of column names to value-pairs denoting average alerts.
private static String	DEFREDAVTEL Column names to value-pairs denoting average alerts, per telescope.
private static String	DEFREDMINMAXENV The list of column names to value-pairs denoting minmax alerts.
private static String	DEFREDMINMAXTEL The list of column names to value-pairs denoting min/max limits.
private static String	DEFREDSIGMAENV The list of column names to value denoting sigma alerts.
private static String	DEFSCILIST Properties for the offlimit display.
private static String	DEFSCINAMES Properties for the offlimit display.
private static String	DEFSCIWHERE Properties for the offlimit display.
private static String	DEFTELESCOPE The telescope query.
private static String	DEFYELLOWAVENV The list of column names to value-pairs denoting average warnings.
private static String	DEFYELLOWAVTEL Column names to value-pairs denoting average alerts, per telescope.
private static String	DEFYELLOWMINMAXENV The list of column names to value-pairs denoting minmax warmnings.
private static String	DEFYELLOWMINMAXTEL The list of column names to value-pairs denoting min/max limits.
private static String	DEFYELLOWSIGMAENV The list of column names to value denoting sigma warnings.
private List<OffLimitVisual.Signal>	envlist The list of all offenders derived from the environment.
static String	KEY_REDAVENV The values above which we have a 'red' condition.
static String	KEY_REDAVTEL The values above which we have a 'red' condition.
static String	KEY_REDMINMAXENV The values above which we have a 'red' condition.
static String	KEY_REDMINMAXTEL The values above which we have a 'red' condition.
static String	KEY_REDSIGMAENV The values above which we have a 'red' condition.
static String	KEY_YELLOWAVENV The values above which we have a 'yellow' condition.
static String	KEY_YELLOWAVTEL The values above which we have a 'yellow' condition.
static String	KEY_YELLOWMINMAXENV The values above which we have a 'yellow' condition.
static String	KEY_YELLOWMINMAXTEL The values above which we have a 'yellow' condition.
static String	KEY_YELLOWSIGMAENV The values above which we have a 'yellow' condition.
private Map<String,List<OffLimitVisual.Signal>>	tellist The list of offenders derived from either telescope.

Fields inherited from class stella.sql.OffLimitAlarm

KEY_DONELIST, KEY_DONENAMES, KEY_DONEWHERE, KEY_ENVLIST, KEY_ENVNAMES, KEY_JOINTLIST, KEY_JOINTNAMES, KEY_JOINTWHERE, KEY_OBSLIST, KEY_OBSNAMES, KEY_OBSWHERE, KEY_SCILIST, KEY_SCINAMES, KEY_SCIWHERE, KEY_TELESCOPE, NULL, TELESCOPESEPARATOR

Fields inherited from class stella.sql.NightlyStatistic

DEFPASSWORD, DEFUSERNAME, KEY_RISETWILIGHT, KEY_SETTWILIGHT

Fields inherited from class mysql.AbstractSql

KEY_TABLE

Fields inherited from class util.PropertyBundles

KEY_LOCALECOUNTRY, KEY_LOCALELANGUAGE, KEY_RESOURCEBUNDLES

Fields inherited from class util.PropertyResources

KEY_NOINITONCREATE, localurl, locate, POSTFIX_DIR, POSTFIX_EXT, POSTFIX_FILE, POSTFIX_LIST, POSTFIX_URL, urlset

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

OffLimitVisual(Map<String,String> prop)
Constructs a new JOffLimit object that is updated at regular intervals.

Method Summary

protected boolean	gather(Date now) Gathers the db-data.
List<OffLimitVisual.Signal>	getEnvironmentSignals() Returns the list of environment signals gathered.
List<OffLimitVisual.Signal>	getTelescopeSignals(String tel) Returns the list of telescope signals for the specified telescope.

Methods inherited from class stella.sql.OffLimitAlarm

addDone, addEnvironment, addJoint, addObs, clearStats, convertToStatistic, extractUnique, getAverageEnvOffs, getAverageTelOffs, getEnvStatistic, getEnvTimes, getMinMaxEnvOffs, getMinMaxTelOffs, getSigmaEnvOffs, getSigmaTelOffs, getSpanEnvOffs, getSpanTelOffs, getTelescopeKeys, getTelescopes, getTelescopeStatistic, getTelescopeTimes, init, telescopeDoubleMapping, telescopeVectorMapping, vectorMapping

Methods inherited from class stella.sql.NightlyStatistic

duskToDawn, duskToDawn, getDone, getDone, getDone, getEnvironment, getEnvironment, getEnvironment, getExposureTimeSum, getJoint, getJoint, getJoint, getNightCount, getObs, getObs, getObs, getRoofOpenCount, getScienceTimeSum

Methods inherited from class mysql.AbstractSql

getPassword, getTable, getUserName, isEntry

Methods inherited from class util.PropertyBundles

clone, getLocalized, getLocalized, getLocalizedString, getLocalizedString, loadResource

Methods inherited from class util.PropertyResources

createFrom, createFrom, createFrom, getApplet, getAsResources, getLocalClassLoader, getPropertiesToKey, getPropertiesToKey, getResource, getResourceAsStream, getResourceFromKey, getResources, keyCreate, keyCreate, reload, setApplet

Methods inherited from class util.PropertyContainer

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, reload, removeProperty, 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.ResourceSupplying

getResource, getResourceAsStream, getResources

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_REDAVENV

public static final String KEY_REDAVENV

The values above which we have a 'red' condition.

See Also:

Constant Field Values

KEY_YELLOWAVENV

public static final String KEY_YELLOWAVENV

The values above which we have a 'yellow' condition.

See Also:

Constant Field Values

KEY_REDMINMAXENV

public static final String KEY_REDMINMAXENV

The values above which we have a 'red' condition.

See Also:

Constant Field Values

KEY_YELLOWMINMAXENV

public static final String KEY_YELLOWMINMAXENV

The values above which we have a 'yellow' condition.

See Also:

Constant Field Values

KEY_REDSIGMAENV

public static final String KEY_REDSIGMAENV

The values above which we have a 'red' condition.

See Also:

Constant Field Values

KEY_YELLOWSIGMAENV

public static final String KEY_YELLOWSIGMAENV

The values above which we have a 'yellow' condition.

See Also:

Constant Field Values

KEY_REDAVTEL

public static final String KEY_REDAVTEL

The values above which we have a 'red' condition.

See Also:

Constant Field Values

KEY_YELLOWAVTEL

public static final String KEY_YELLOWAVTEL

The values above which we have a 'yellow' condition.

See Also:

Constant Field Values

KEY_REDMINMAXTEL

public static final String KEY_REDMINMAXTEL

The values above which we have a 'red' condition.

See Also:

Constant Field Values

KEY_YELLOWMINMAXTEL

public static final String KEY_YELLOWMINMAXTEL

The values above which we have a 'yellow' condition.

See Also:

Constant Field Values

DEFENVLIST

private static final String DEFENVLIST

Properties for the offlimit display.

See Also:

Constant Field Values

DEFENVNAMES

private static final String DEFENVNAMES

Properties for the offlimit display.

See Also:

Constant Field Values

DEFOBSLIST

private static final String DEFOBSLIST

Properties for the offlimit display.

See Also:

Constant Field Values

DEFOBSNAMES

private static final String DEFOBSNAMES

Properties for the offlimit display.

See Also:

Constant Field Values

DEFSCILIST

private static final String DEFSCILIST

Properties for the offlimit display.

See Also:

Constant Field Values

DEFSCINAMES

private static final String DEFSCINAMES

Properties for the offlimit display.

See Also:

Constant Field Values

DEFSCIWHERE

private static final String DEFSCIWHERE

Properties for the offlimit display.

See Also:

Constant Field Values

DEFDONELIST

private static final String DEFDONELIST

The fields to query from the env table. May include expressions.

See Also:

Constant Field Values

DEFDONENAMES

private static final String DEFDONENAMES

How the returned columns are named. Can be null.

See Also:

Constant Field Values

DEFDONEWHERE

private static final String DEFDONEWHERE

Additional constraints for the done table query.

See Also:

Constant Field Values

DEFJOINTLIST

private static final String DEFJOINTLIST

The fields to query from the env table. May include expressions.

See Also:

Constant Field Values

DEFJOINTNAMES

private static final String DEFJOINTNAMES

How the returned columns are named. Can be null.

See Also:

Constant Field Values

DEFJOINTWHERE

private static final String DEFJOINTWHERE

Additional constraints for the joint table query.

See Also:

Constant Field Values

DEFTELESCOPE

private static final String DEFTELESCOPE

The telescope query.

See Also:

Constant Field Values

DEFREDAVENV

private static final String DEFREDAVENV

The list of column names to value-pairs denoting average alerts.

See Also:

Constant Field Values

DEFYELLOWAVENV

private static final String DEFYELLOWAVENV

The list of column names to value-pairs denoting average warnings.

See Also:

Constant Field Values

DEFREDMINMAXENV

private static final String DEFREDMINMAXENV

The list of column names to value-pairs denoting minmax alerts.

See Also:

Constant Field Values

DEFYELLOWMINMAXENV

private static final String DEFYELLOWMINMAXENV

The list of column names to value-pairs denoting minmax warmnings.

See Also:

Constant Field Values

DEFREDSIGMAENV

private static final String DEFREDSIGMAENV

The list of column names to value denoting sigma alerts.

See Also:

Constant Field Values

DEFYELLOWSIGMAENV

private static final String DEFYELLOWSIGMAENV

The list of column names to value denoting sigma warnings.

See Also:

Constant Field Values

DEFREDAVTEL

private static final String DEFREDAVTEL

Column names to value-pairs denoting average alerts, per telescope.

See Also:

Constant Field Values

DEFYELLOWAVTEL

private static final String DEFYELLOWAVTEL

Column names to value-pairs denoting average alerts, per telescope.

See Also:

Constant Field Values

DEFREDMINMAXTEL

private static final String DEFREDMINMAXTEL

The list of column names to value-pairs denoting min/max limits.

See Also:

Constant Field Values

DEFYELLOWMINMAXTEL

private static final String DEFYELLOWMINMAXTEL

The list of column names to value-pairs denoting min/max limits.

See Also:

Constant Field Values

envlist

private List<OffLimitVisual.Signal> envlist

The list of all offenders derived from the environment.

tellist

private Map<String,List<OffLimitVisual.Signal>> tellist

The list of offenders derived from either telescope.

Constructor Detail

OffLimitVisual

public OffLimitVisual(Map<String,String> prop)

Constructs a new JOffLimit object that is updated at regular intervals.

Method Detail

getEnvironmentSignals

public List<OffLimitVisual.Signal> getEnvironmentSignals()

Returns the list of environment signals gathered.

getTelescopeSignals

public List<OffLimitVisual.Signal> getTelescopeSignals(String tel)

Returns the list of telescope signals for the specified telescope.

gather

protected boolean gather(Date now)

Gathers the db-data.