mysql

Class NightStatSql

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

mysql.NightStatSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

public class NightStatSql
extends AbstractSql

A class that allows static access to a database containing statistical information on nights. These are overall information valid for an entire observatory. For splitting into telescopes, see TelStatSql.

 nightid   | character varying(255)      | not null  | extended |              | The day that starts at midnight in the format YYYYMMDD of the nigth in question
 opentime  | timestamp without time zone | not null  | plain    |              | The calculated time the dome should open
 opentrue  | timestamp without time zone |           | plain    |              | The time the dome opened for the first time
 closetime | timestamp without time zone | not null  | plain    |              | The calculated time the dome should close
 closetrue | timestamp without time zone |           | plain    |              | The time the dome closed finally
 maxtime   | real                        | not null  | plain    |              | The calculated maximum possible time the dome is open in seconds
 opensum   | real                        |           | plain    |              | The summed time the dome was open in seconds
Indexes:
    "nightstat_pkey" PRIMARY KEY, btree (nightid)
 
 

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	DEFCLOSECALCFIELD The default target name field in the database
private static String	DEFCLOSETRUEFIELD The default target name field in the database
private static String	DEFMAXTIMEFIELD The default target name field in the database
private static String	DEFNIGHTFIELD The default target name field in the database
private static String	DEFOPENCALCFIELD The default target name field in the database
private static String	DEFOPENSUMFIELD The default target name field in the database
private static String	DEFOPENTRUEFIELD The default target name field in the database
private static String	DEFTABLE The default table name.
static String	KEY_CLOSECALCFIELD The key to the block identifier in the database.
static String	KEY_CLOSETRUEFIELD The key to the image type integer field.
static String	KEY_MAXTIMEFIELD The key to the instrument version field.
static String	KEY_NIGHTFIELD The key to the block identifier in the database.
static String	KEY_OPENCALCFIELD The key to the block identifier in the database.
static String	KEY_OPENSUMFIELD The key to the telescope name in the database.
static String	KEY_OPENTRUEFIELD 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
NightStatSql(Map<String,String> prop) Constructs a new history database.

Method Summary

Modifier and Type	Method and Description
boolean	containsNight(String unique)

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_OPENCALCFIELD

public static final String KEY_OPENCALCFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_OPENTRUEFIELD

public static final String KEY_OPENTRUEFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_CLOSECALCFIELD

public static final String KEY_CLOSECALCFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_CLOSETRUEFIELD

public static final String KEY_CLOSETRUEFIELD

The key to the image type integer field.

See Also:

Constant Field Values

KEY_MAXTIMEFIELD

public static final String KEY_MAXTIMEFIELD

The key to the instrument version field.

See Also:

Constant Field Values

KEY_OPENSUMFIELD

public static final String KEY_OPENSUMFIELD

The key to the telescope name in the database.

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

DEFOPENCALCFIELD

private static final String DEFOPENCALCFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFOPENTRUEFIELD

private static final String DEFOPENTRUEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFCLOSECALCFIELD

private static final String DEFCLOSECALCFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFCLOSETRUEFIELD

private static final String DEFCLOSETRUEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFMAXTIMEFIELD

private static final String DEFMAXTIMEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFOPENSUMFIELD

private static final String DEFOPENSUMFIELD

The default target name field in the database

See Also:

Constant Field Values

Constructor Detail

NightStatSql

public NightStatSql(Map<String,String> prop)

Constructs a new history database.

Method Detail

containsNight

public boolean containsNight(String unique)