mysql

Class TelStatSql

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

mysql.TelStatSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

public class TelStatSql
extends AbstractSql

A class that allows static access to a database containing statistical information on nights, split down to the telescope level. Overall, observatory-wide statistics are in NightStatSql.

 nightid     | character varying(255) | not null  | extended |              | The day that starts at midnight in the format YYYYMMDD of the nigth in question
 telescop    | character varying(255) | not null  | extended |              | The telescope name, STELLA1 or STELLA2
 busy        | real                   |           | plain    |              | The summed seconds the telescope was operating (sum of duration)
 observing   | real                   |           | plain    |              | The summed seconds the telescope was successfully observing (sum of duration with success)
 science     | real                   |           | plain    |              | The summed seconds the telescope was observing night targets (sum of duration of non-calibration data with success)
 shutteropen | real                   |           | plain    |              | The summed seconds the shutter was open on night targets (non-calibration)
Indexes:
    "telstat_pkey" PRIMARY KEY, btree (nightid, telescop)
 
 

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	DEFBUSYFIELD The default target name field in the database
private static String	DEFNIGHTFIELD The default target name field in the database
private static String	DEFOBSERVINGFIELD The default target name field in the database
private static String	DEFSCIENCEFIELD The default target name field in the database
private static String	DEFSHUTTEROPENFIELD The default target name field in the database
private static String	DEFTABLE The default table name.
private static String	DEFTELESCOPEFIELD The default target name field in the database
static String	KEY_BUSYFIELD The key to the block identifier in the database.
static String	KEY_NIGHTFIELD The key to the block identifier in the database.
static String	KEY_OBSERVINGFIELD The key to the block identifier in the database.
static String	KEY_SCIENCEFIELD The key to the image type integer field.
static String	KEY_SHUTTEROPENFIELD The key to the instrument version field.
static String	KEY_TELESCOPEFIELD The key to the block identifier in the database.

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
TelStatSql(Map<String,String> prop) Constructs a new history database.

Method Summary

Modifier and Type	Method and Description
boolean	containsNight(String night, String telescope)

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_NIGHTFIELD

public static final String KEY_NIGHTFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_TELESCOPEFIELD

public static final String KEY_TELESCOPEFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_BUSYFIELD

public static final String KEY_BUSYFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_OBSERVINGFIELD

public static final String KEY_OBSERVINGFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_SCIENCEFIELD

public static final String KEY_SCIENCEFIELD

The key to the image type integer field.

See Also:

Constant Field Values

KEY_SHUTTEROPENFIELD

public static final String KEY_SHUTTEROPENFIELD

The key to the instrument version field.

See Also:

Constant Field Values

DEFTABLE

private static final String DEFTABLE

The default table name.

See Also:

Constant Field Values

DEFNIGHTFIELD

private static final String DEFNIGHTFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFTELESCOPEFIELD

private static final String DEFTELESCOPEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFBUSYFIELD

private static final String DEFBUSYFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFOBSERVINGFIELD

private static final String DEFOBSERVINGFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFSCIENCEFIELD

private static final String DEFSCIENCEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFSHUTTEROPENFIELD

private static final String DEFSHUTTEROPENFIELD

The default target name field in the database

See Also:

Constant Field Values

Constructor Detail

TelStatSql

public TelStatSql(Map<String,String> prop)

Constructs a new history database.

Method Detail

containsNight

public boolean containsNight(String night,
                             String telescope)