OffLimitAlarm

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

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

Direct Known Subclasses:

OffLimitVisual
```
public class OffLimitAlarm
extends NightlyStatistic
```
A class that uses nighly statistics to check for abnoramlities in certain parameters. If gross off-limits are encountered, an e-mail notification is sent to the administrator.

Nested Class Summary
- Nested classes/interfaces inherited from class stella.sql.NightlyStatistic
  NightlyStatistic.Duty, NightlyStatistic.Env, NightlyStatistic.Night
- 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 Map<String,Statistic>`	`env` The retrieved data as column names to statistics.
`private Map<String,Statistic>`	`envtimes` The retrieved data as column names to statistics.
`static String`	`KEY_DONELIST` The fields to query from the env table.
`static String`	`KEY_DONENAMES` How the returned columns are named.
`static String`	`KEY_DONEWHERE` Additional constraints for the done table query.
`static String`	`KEY_ENVLIST` The fields to query from the env table.
`static String`	`KEY_ENVNAMES` How the returned columns are named.
`static String`	`KEY_JOINTLIST` The fields to query from the env table.
`static String`	`KEY_JOINTNAMES` How the returned columns are named.
`static String`	`KEY_JOINTWHERE` Additional constraints for the joint table query.
`static String`	`KEY_MULTILIST` The fields to query from the env table.
`static String`	`KEY_MULTINAMES` How the returned columns are named.
`static String`	`KEY_MULTIWHERE` Additional constraints for the joint table query.
`static String`	`KEY_OBSLIST` The fields to query from the obs table.
`static String`	`KEY_OBSNAMES` How the returned columns are named.
`static String`	`KEY_OBSWHERE` Additional constraints for the obs table query.
`static String`	`KEY_SCILIST` The fields to query from the obs table, with imagetyp=1.
`static String`	`KEY_SCINAMES` How the returned columns are named.
`static String`	`KEY_SCIWHERE` Additional constraints for the sci query, should include imagetyp=1.
`static String`	`KEY_TELESCOPE` The issuing telescopes.
`static String`	`NULL` String instead of limits indicating that this has no meaning.
`private Map<String,Map<String,Statistic>>`	`tel` The retrieved data as column names to statistics.
`static char`	`TELESCOPESEPARATOR` character sparating telescope name from offending column name.
`private Map<String,Map<String,List<Object>>>`	`telkeys` The retrieved data as column names to keys (unique ids).
`private Map<String,Map<String,Statistic>>`	`teltimes` The retrieved data as column names to statistics.

Fields inherited from class stella.sql.NightlyStatistic
KEY_RISETWILIGHT, KEY_SETTWILIGHT

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

OffLimitAlarm(Map<String,String> prop)
Constructs a new off-limit alarm log.

Constructors
Constructor and Description
`OffLimitAlarm(Map<String,String> prop)` Constructs a new off-limit alarm log.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addDone(List<String> donelist, List<String> doneas, Map<String,Function> f, String add, Date now)` Retrieve and cache all information for the date in question.
`void`	`addEnvironment(List<String> envlist, List<String> envas, Map<String,Function> f, Date now)` Retrieve and cache all information for the date in question.
`void`	`addJoint(List<String> jointlist, List<String> jointas, Map<String,Function> f, String add, Date now)` Retrieve and cache all information for the date in question.
`void`	`addMultiple(List<String> multlist, List<String> multas, Map<String,Function> f, String add, Date now)` Retrieve and cache all information for the date in question.
`void`	`addObs(List<String> obslist, List<String> obsas, Map<String,Function> f, String add, Date now)` Retrieve and cache all information for the date in question.
`void`	`clearStats()`
`static Map<String,Statistic>`	`convertToStatistic(Map<String,List<DataCard>> log, int index)` Converts a mapping of strings to List of doubles into a mapping of strings to statistics.
`static Map<String,List<Object>>`	`extractUnique(Map<String,List<DataCard>> log)` We take all the data cards and extract the unique IDs found for the given field names.
`Map<String,Double>`	`getAverageEnvOffs(Map<String,Vector2D> avmap)` From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
`private Map<String,Double>`	`getAverageOffenders(Map<String,Statistic> stats, Map<String,Vector2D> avmap)` From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
`Map<String,Double>`	`getAverageTelOffs(String telescope, Map<String,Vector2D> avmap)` From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
`Statistic`	`getEnvStatistic(String key)` Returns the statistic on a column in the env table.
`Statistic`	`getEnvTimes(String key)` Returns the statistic on a column in the env table.
`Map<String,Double>`	`getMinMaxEnvOffs(Map<String,Vector2D> avmap)` From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
`private Map<String,Double>`	`getMinMaxOffenders(Map<String,Statistic> stats, Map<String,Vector2D> avmap)` From the retireved mappings of column names to list of doubles, we return the column names of those whose min/max are outside the bounds mapped to the offending value.
`Map<String,Double>`	`getMinMaxTelOffs(String telescope, Map<String,Vector2D> avmap)` From the retireved mappings of column names to list of doubles, we return the column names of those whose min/max are outside the bounds mapped to the offending value.
`Map<String,Double>`	`getSigmaEnvOffs(Map<String,Double> limit)` From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
`private Map<String,Double>`	`getSigmaOffenders(Map<String,Statistic> stats, Map<String,Double> limit)` From the retireved mappings of column names to list of doubles, we return the column names of those whose standard deviaition is higher than the allowed maximum, mapped to the offending value.
`Map<String,Double>`	`getSigmaTelOffs(String telescope, Map<String,Double> limit)` From the retireved mappings of column names to list of doubles, we return the column names of those whose standard deviaition is higher than the allowed maximum, mapped to the offending value.
`Map<String,Double>`	`getSpanEnvOffs(Map<String,Double> limit)` From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
`private Map<String,Double>`	`getSpanOffenders(Map<String,Statistic> stats, Map<String,Double> limit)` From the retireved mappings of column names to list of doubles, we return the column names of those whose span deviaition is higher than the allowed maximum, mapped to the offending value.
`Map<String,Double>`	`getSpanTelOffs(String telescope, Map<String,Double> limit)` From the retireved mappings of column names to list of doubles, we return the column names of those whose span deviaition is higher than the allowed maximum, mapped to the offending value.
`List<Object>`	`getTelescopeKeys(String telescope, String key)` Returns the list of uniques for a telescope.
`List<String>`	`getTelescopes()` Returns the list of telescopes.
`Statistic`	`getTelescopeStatistic(String telescope, String key)` Returns the statistic on a column in the env table.
`Statistic`	`getTelescopeTimes(String telescope, String key)` Returns the statistic on a column in the env table.
`void`	`init()` If we are not the default user of the database, try to add ourself here.
`static Map<String,Map<String,Double>>`	`telescopeDoubleMapping(List<String> tels, String prop)` Converts a string-to-string mapping into a string-toVector2D mapping, using the telescope names provided.
`static Map<String,Map<String,Vector2D>>`	`telescopeVectorMapping(List<String> tels, String prop)` Converts a string-to-string mapping into a string-toVector2D mapping, using the telescope names provided.
`static Map<String,Vector2D>`	`vectorMapping(String prop)` Converts a string-to-string mapping into a string-to Vector2D mapping

Methods inherited from class stella.sql.NightlyStatistic
duskToDawn, duskToDawn, getDone, getDone, getDone, getEnvironment, getEnvironment, getEnvironment, getExposureTimeSum, getJoint, getJoint, getJoint, getMultiple, getMultiple, getNightCount, getObs, getObs, getObs, getRoofOpenCount, getScienceTimeSum

Methods inherited from class mysql.AbstractSql
delete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, getTable, 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
  - NULL
```
public static final String NULL
```
    String instead of limits indicating that this has no meaning.
    
    See Also:
    
    Constant Field Values
  - TELESCOPESEPARATOR
```
public static final char TELESCOPESEPARATOR
```
    character sparating telescope name from offending column name.
    
    See Also:
    
    Constant Field Values
  - KEY_TELESCOPE
```
public static final String KEY_TELESCOPE
```
    The issuing telescopes.
    
    See Also:
    
    Constant Field Values
  - KEY_ENVLIST
```
public static final String KEY_ENVLIST
```
    The fields to query from the env table. May include expressions.
    
    See Also:
    
    Constant Field Values
  - KEY_ENVNAMES
```
public static final String KEY_ENVNAMES
```
    How the returned columns are named. Can be null.
    
    See Also:
    
    Constant Field Values
  - KEY_OBSLIST
```
public static final String KEY_OBSLIST
```
    The fields to query from the obs table. May include expressions.
    
    See Also:
    
    Constant Field Values
  - KEY_OBSNAMES
```
public static final String KEY_OBSNAMES
```
    How the returned columns are named. Can be null.
    
    See Also:
    
    Constant Field Values
  - KEY_OBSWHERE
```
public static final String KEY_OBSWHERE
```
    Additional constraints for the obs table query.
    
    See Also:
    
    Constant Field Values
  - KEY_SCILIST
```
public static final String KEY_SCILIST
```
    The fields to query from the obs table, with imagetyp=1.
    
    See Also:
    
    Constant Field Values
  - KEY_SCINAMES
```
public static final String KEY_SCINAMES
```
    How the returned columns are named. Can be null.
    
    See Also:
    
    Constant Field Values
  - KEY_SCIWHERE
```
public static final String KEY_SCIWHERE
```
    Additional constraints for the sci query, should include imagetyp=1.
    
    See Also:
    
    Constant Field Values
  - KEY_DONELIST
```
public static final String KEY_DONELIST
```
    The fields to query from the env table. May include expressions.
    
    See Also:
    
    Constant Field Values
  - KEY_DONENAMES
```
public static final String KEY_DONENAMES
```
    How the returned columns are named. Can be null.
    
    See Also:
    
    Constant Field Values
  - KEY_DONEWHERE
```
public static final String KEY_DONEWHERE
```
    Additional constraints for the done table query.
    
    See Also:
    
    Constant Field Values
  - KEY_JOINTLIST
```
public static final String KEY_JOINTLIST
```
    The fields to query from the env table. May include expressions.
    
    See Also:
    
    Constant Field Values
  - KEY_JOINTNAMES
```
public static final String KEY_JOINTNAMES
```
    How the returned columns are named. Can be null.
    
    See Also:
    
    Constant Field Values
  - KEY_JOINTWHERE
```
public static final String KEY_JOINTWHERE
```
    Additional constraints for the joint table query.
    
    See Also:
    
    Constant Field Values
  - KEY_MULTILIST
```
public static final String KEY_MULTILIST
```
    The fields to query from the env table. May include expressions.
    
    See Also:
    
    Constant Field Values
  - KEY_MULTINAMES
```
public static final String KEY_MULTINAMES
```
    How the returned columns are named. Can be null.
    
    See Also:
    
    Constant Field Values
  - KEY_MULTIWHERE
```
public static final String KEY_MULTIWHERE
```
    Additional constraints for the joint table query.
    
    See Also:
    
    Constant Field Values
  - env
```
private Map<String,Statistic> env
```
    The retrieved data as column names to statistics.
  - envtimes
```
private Map<String,Statistic> envtimes
```
    The retrieved data as column names to statistics.
  - tel
```
private Map<String,Map<String,Statistic>> tel
```
    The retrieved data as column names to statistics.
  - teltimes
```
private Map<String,Map<String,Statistic>> teltimes
```
    The retrieved data as column names to statistics.
  - telkeys
```
private Map<String,Map<String,List<Object>>> telkeys
```
    The retrieved data as column names to keys (unique ids).
- Constructor Detail
  - OffLimitAlarm
```
public OffLimitAlarm(Map<String,String> prop)
```
    Constructs a new off-limit alarm log.
- Method Detail
  - init
```
public void init()
          throws InitException
```
    Description copied from class: AbstractSql
    
    If we are not the default user of the database, try to add ourself here.
    
    Specified by:
    
    init in interface Initializable
    
    Overrides:
    
    init in class AbstractSql
    
    Throws:
    
    InitException
  - clearStats
```
public void clearStats()
```
  - addEnvironment
```
public void addEnvironment(List<String> envlist,
                           List<String> envas,
                           Map<String,Function> f,
                           Date now)
```
    Retrieve and cache all information for the date in question.
  - addObs
```
public void addObs(List<String> obslist,
                   List<String> obsas,
                   Map<String,Function> f,
                   String add,
                   Date now)
```
    Retrieve and cache all information for the date in question.
  - addDone
```
public void addDone(List<String> donelist,
                    List<String> doneas,
                    Map<String,Function> f,
                    String add,
                    Date now)
```
    Retrieve and cache all information for the date in question.
  - addJoint
```
public void addJoint(List<String> jointlist,
                     List<String> jointas,
                     Map<String,Function> f,
                     String add,
                     Date now)
```
    Retrieve and cache all information for the date in question.
  - addMultiple
```
public void addMultiple(List<String> multlist,
                        List<String> multas,
                        Map<String,Function> f,
                        String add,
                        Date now)
```
    Retrieve and cache all information for the date in question.
  - getTelescopes
```
public List<String> getTelescopes()
```
    Returns the list of telescopes.
  - getEnvStatistic
```
public Statistic getEnvStatistic(String key)
```
    Returns the statistic on a column in the env table.
  - getEnvTimes
```
public Statistic getEnvTimes(String key)
```
    Returns the statistic on a column in the env table.
  - getTelescopeStatistic
```
public Statistic getTelescopeStatistic(String telescope,
                                       String key)
```
    Returns the statistic on a column in the env table.
  - getTelescopeTimes
```
public Statistic getTelescopeTimes(String telescope,
                                   String key)
```
    Returns the statistic on a column in the env table.
  - getTelescopeKeys
```
public List<Object> getTelescopeKeys(String telescope,
                                     String key)
```
    Returns the list of uniques for a telescope.
  - vectorMapping
```
public static Map<String,Vector2D> vectorMapping(String prop)
                                          throws ParseException
```
    Converts a string-to-string mapping into a string-to Vector2D mapping
    
    Throws:
    
    ParseException
  - telescopeVectorMapping
```
public static Map<String,Map<String,Vector2D>> telescopeVectorMapping(List<String> tels,
                                                                      String prop)
                                                               throws ParseException
```
    Converts a string-to-string mapping into a string-toVector2D mapping, using the telescope names provided. Each key is mapped to a double-tokenizable list, semi-colons separating the entries for each telescope. E.g. dettemp=-200,-100;-220,-80:further keys
    
    Throws:
    
    ParseException
  - telescopeDoubleMapping
```
public static Map<String,Map<String,Double>> telescopeDoubleMapping(List<String> tels,
                                                                    String prop)
                                                             throws ParseException
```
    Converts a string-to-string mapping into a string-toVector2D mapping, using the telescope names provided. Each key is mapped to a semi-colons separated list for the entries for each telescope. E.g. dettemp=-200;-220:further keys
    
    Throws:
    
    ParseException
  - getAverageEnvOffs
```
public Map<String,Double> getAverageEnvOffs(Map<String,Vector2D> avmap)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
  - getMinMaxEnvOffs
```
public Map<String,Double> getMinMaxEnvOffs(Map<String,Vector2D> avmap)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
  - getSigmaEnvOffs
```
public Map<String,Double> getSigmaEnvOffs(Map<String,Double> limit)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
  - getSpanEnvOffs
```
public Map<String,Double> getSpanEnvOffs(Map<String,Double> limit)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
  - getAverageTelOffs
```
public Map<String,Double> getAverageTelOffs(String telescope,
                                            Map<String,Vector2D> avmap)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
  - getMinMaxTelOffs
```
public Map<String,Double> getMinMaxTelOffs(String telescope,
                                           Map<String,Vector2D> avmap)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose min/max are outside the bounds mapped to the offending value.
  - getSigmaTelOffs
```
public Map<String,Double> getSigmaTelOffs(String telescope,
                                          Map<String,Double> limit)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose standard deviaition is higher than the allowed maximum, mapped to the offending value.
  - getSpanTelOffs
```
public Map<String,Double> getSpanTelOffs(String telescope,
                                         Map<String,Double> limit)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose span deviaition is higher than the allowed maximum, mapped to the offending value.
  - convertToStatistic
```
public static Map<String,Statistic> convertToStatistic(Map<String,List<DataCard>> log,
                                                       int index)
```
    Converts a mapping of strings to List of doubles into a mapping of strings to statistics. After a call to this method, no more values can be usefully added to the double list, without calling this method again.
  - extractUnique
```
public static Map<String,List<Object>> extractUnique(Map<String,List<DataCard>> log)
```
    We take all the data cards and extract the unique IDs found for the given field names.
  - getAverageOffenders
```
private Map<String,Double> getAverageOffenders(Map<String,Statistic> stats,
                                               Map<String,Vector2D> avmap)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose average are outside the bounds mapped to the average.
  - getMinMaxOffenders
```
private Map<String,Double> getMinMaxOffenders(Map<String,Statistic> stats,
                                              Map<String,Vector2D> avmap)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose min/max are outside the bounds mapped to the offending value.
  - getSigmaOffenders
```
private Map<String,Double> getSigmaOffenders(Map<String,Statistic> stats,
                                             Map<String,Double> limit)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose standard deviaition is higher than the allowed maximum, mapped to the offending value.
  - getSpanOffenders
```
private Map<String,Double> getSpanOffenders(Map<String,Statistic> stats,
                                            Map<String,Double> limit)
```
    From the retireved mappings of column names to list of doubles, we return the column names of those whose span deviaition is higher than the allowed maximum, mapped to the offending value.

Class OffLimitAlarm

Nested Class Summary

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

Nested classes/interfaces inherited from class mysql.AbstractSql

Nested classes/interfaces inherited from class util.PropertyResources

Field Summary

Fields inherited from class stella.sql.NightlyStatistic

Fields inherited from class mysql.AbstractSql

Fields inherited from class util.PropertyResources

Fields inherited from class util.PropertyContainer

Fields inherited from interface util.ResourceSupplying

Fields inherited from interface util.PropertySupplying

Constructor Summary

Method Summary

Methods inherited from class stella.sql.NightlyStatistic

Methods inherited from class mysql.AbstractSql

Methods inherited from class util.PropertyResources

Methods inherited from class util.PropertyContainer

Methods inherited from class java.lang.Object

Methods inherited from interface util.PropertySupplying

Field Detail

NULL

TELESCOPESEPARATOR

KEY_TELESCOPE

KEY_ENVLIST

KEY_ENVNAMES

KEY_OBSLIST

KEY_OBSNAMES

KEY_OBSWHERE

KEY_SCILIST

KEY_SCINAMES

KEY_SCIWHERE

KEY_DONELIST

KEY_DONENAMES

KEY_DONEWHERE

KEY_JOINTLIST

KEY_JOINTNAMES

KEY_JOINTWHERE

KEY_MULTILIST

KEY_MULTINAMES

KEY_MULTIWHERE

env

envtimes

tel

teltimes

telkeys

Constructor Detail

OffLimitAlarm

Method Detail

init

clearStats

addEnvironment

addObs

addDone

addJoint

addMultiple

getTelescopes

getEnvStatistic

getEnvTimes

getTelescopeStatistic

getTelescopeTimes

getTelescopeKeys

vectorMapping

telescopeVectorMapping

telescopeDoubleMapping

getAverageEnvOffs

getMinMaxEnvOffs

getSigmaEnvOffs

getSpanEnvOffs

getAverageTelOffs

getMinMaxTelOffs

getSigmaTelOffs

getSpanTelOffs

convertToStatistic

extractUnique

getAverageOffenders

getMinMaxOffenders

getSigmaOffenders

getSpanOffenders