public class TelStatSql extends AbstractSql
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)
AbstractSql.Columns, AbstractSql.ExtractPropertyResources.Load, PropertyResources.URLResource| 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.
|
KEY_TABLE, SQLBATCHDIR, SQLFAILDIRKEY_NOINITONCREATE, POSTFIX_ALPHABET, POSTFIX_BYTES, POSTFIX_DIR, POSTFIX_EXT, POSTFIX_FILE, POSTFIX_LIST, POSTFIX_MODTIME, POSTFIX_URLKEY_LISTSEPARATOR, KEY_MAPKEYVALUECHAR, KEY_MAPSEPARATORKEY_URLRESOURCES, KEY_URLUSECONFIG, KEY_URLUSECURRENT, KEY_URLUSEHOMECONFIG, KEY_CLASS| Constructor and Description |
|---|
TelStatSql(Map<String,String> prop)
Constructs a new history database.
|
| Modifier and Type | Method and Description |
|---|---|
boolean |
containsNight(String night,
String telescope) |
delete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, getTable, init, insert, isEntry, release, release, replace, retrieve, retrieve, retrieve, single, singleclone, createFrom, createFrom, createFrom, createInstance, getApplet, getAsResources, getLocate, getPropertiesToKey, getPropertiesToKey, getResource, getResourceAsStream, getResourceFromKey, getResources, hasLocalURLs, initProperties, keyCreate, keyCreate, reload, setAppletaugment, 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, toStringequals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitdefaultBoolean, 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, stringPropertiespublic static final String KEY_NIGHTFIELD
public static final String KEY_TELESCOPEFIELD
public static final String KEY_BUSYFIELD
public static final String KEY_OBSERVINGFIELD
public static final String KEY_SCIENCEFIELD
public static final String KEY_SHUTTEROPENFIELD
private static final String DEFTABLE
private static final String DEFNIGHTFIELD
private static final String DEFTELESCOPEFIELD
private static final String DEFBUSYFIELD
private static final String DEFOBSERVINGFIELD
private static final String DEFSCIENCEFIELD
private static final String DEFSHUTTEROPENFIELD