ObserveSql

java.lang.Object
- util.PropertyContainer
- - util.PropertyResources
  - - mysql.AbstractSql
    - - mysql.ObserveSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying
```
public class ObserveSql
extends AbstractSql
```
A class that allows static access to a database containing observational data of a target. It mainly consists the fits header keys of individual observations. IT is normally a table called obs defined in the following way:
```
 Column | Type | Modifiers
 -----------+-----------------------------+-----------
 date | timestamp without time zone | not null
 dateobs | timestamp without time zone | not null
 instrument | smallint |
 iversion | smallint |
 exptime | real |
 amplmode | character(8) |
 pressure | real |
 dettemp | real |
 cryotemp | real |
 austatus | smallint |
 auseeing | real |
 domestat | boolean |
 observer | smallint |
 transfered | boolean |
 online | boolean |
 filename | character varying(255) |
 path | character varying(255) |
 imagetyp | smallint |
 object | character varying(255) |
 telfocus | real |
 objname | character varying(255) |
 azimuth | real |
 telalt | real |
 ambtemp | real |
 relhum | real |
 maxwind | real |
 telescop | character(8) |
 naquire | smallint |
 guideloss | real |
 tempm1 | real |
 tempm2 | real |
 avrgwind | real |
 winddir | real |
 atmpress | real |
 dewpoint | real |
 aumiss | real |
 seseff | real |
 snest | real |
 aulight | real |
 aulign | real |
 objid | character varying(255) |
 azfirst | real |
 altfirst | real |
 aztotal | real |
 ztotal | real |
 ADU_av | real |
 ADU_var | real |
 ADU_CNM3 | real |
 ADU_CNM4 | real |
 ADU_CNM5 | real |
 ADU_CNM6 | real |
 FILTER | character(8) |
 TELDEROT | real |
 EXPID | integer |
 TARGETID | character varying(255) |
 Indexes:
 "obs_pkey" primary key, btree (dateobs)
 
```
The fields mean the following:
- date :Time fits file was writtn.
- dateobs :Time exposure started
- instrument:1=STELLA
- iversion :1
- exptime :nominal exposure time in seconds
- amplmode :A, B, or AB, for Copenhagen controller
- pressure :pressure in the CCD-head.
- dettemp :Temperature of the detector CCD.
- cryotemp :Temperature of the CCD coolant
- austatus :Number of spurious guiding losses, i.e. when the guide star was not visible or too far of the guider center.
- auseeing :Average seeing estimate from guider images, in arcsec
- domestat :True for open roofs.
- observer :0=robotic
- transfered:True, if fits file was transferred to MCC.
- online :True, if data is still online in RAID, false if deleted/archived
- filename :The fits file name without extension, like science20070131-0018
- path :Path to the fits file. Not an URL, but an absolute path on whatever host, like /space/ses/20070131
- imagetyp :1 for science data,
- object :The unique STELLA target name, like 'HD 12545 cont'. objid in HistorySql.
- telfocus :Distance of M2 or any other focus value during exposure, normally in mm.
- objname :Simbad-resolvable name of main object, like 'HD 12545'. object in TargetSql
- azimuth :Azimuth of telescope, as reported by the TCS at the start of the exposure.
- telalt :Altitude of telescope, as reported by the TCS at the start of the exposure.
- ambtemp :Average ambient temperature during exposure, degrees Celsius
- relhum :Average relative outside humidity during exposure in percent.
- maxwind :Maximum wind during exposure in m/s
- telescop :STELLA
- naquire :Number of acquire attempts.
- guideloss :IRAF-estimated light loss from photometry of averaged guiding frames. 0=all light in fiber.
- tempm1 :Temperature average of M1, as reported by the TCS.
- tempm2 :Temperature average of M2, as reported by the TCS.
- avrgwind :Average wind speed during exposure, m/s
- winddir :Average wind direction during exposure, degrees.
- atmpress :Atmospheric pressure in mbar (hPa).
- dewpoint :Ambient dewpoint average during exposure, degrees Celsius
- aumiss :Averaged exp(-d^2/arcsec^2) of the guider star distance to optimal fiber position.
- seseff :Efficiency estimate of the spectrograph to outside atmosphere light flux.
- snest :Estimated S/N from pure photon statistics.
- aulight :Average photometry on all individual guiding frames
- aulign :Median of light gain into fiber of all guider images.
- objid :Unique ID of the observation, object in HistorySql
- azfirst :First measured offset during acquire, azimuth, deg.
- altfirst :First measured offset during acquire, altitude, deg.
- aztotal :After successful acquire, the total offset between instrumental coordinates and pointing, useful for pointing model. This is the azimuth offset in degrees.
- ztotal :After successful acquire, the total offset between instrumental coordinates and pointing, useful for pointing model. This is the zenith distance offset in degrees.
- ADU_av :Average of the ADU's in the fits file.
- ADU_var :Variance (σ&pow2;) of the ADU's in the fits file.
- ADU_CNM3 :Normalized central 3. ADU moment
- ADU_CNM4 :Normalized central 4. ADU moment
- ADU_CNM5 :Normalized central 5. ADU moment
- ADU_CNM6 :Normalized central 6. ADU moment
The idea of this class is to allow static access from various sides to the history without the need of producing individual db clients. Only numerical values (plus dates) are retrieved.

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`static class`	`ObserveSql.Adu` Connects to the database and returns the ADU statistic for all files of the stated telescope.
`static class`	`ObserveSql.AduStat` Connects to the database and returns the ADU statistic for all files of the stated telescope.
`static class`	`ObserveSql.Ambient` Update ambient temperature.
`static class`	`ObserveSql.Coco` On coco, we reestablish directory structure for 2010 archive raw data.
`static class`	`ObserveSql.Duplicates` Removes double entries in the obs table, which slipped into it during psql upgrade in Feb.
`static class`	`ObserveSql.Extract` A class to retrive columns from a database and output it into an ascii-file for e.g.
`static class`	`ObserveSql.FitsParse` Only in debug mode, we read the fits file and print out what would be entered.
`static class`	`ObserveSql.FitsPut` Only for none-enterd fits, to be executed on wifsip/archive this class enters all found in the fits headers into the db.
`static class`	`ObserveSql.Flat` Connects to the database and tries to find flats with a stuck filterwheel.
`static class`	`ObserveSql.Path` Checks all non-transferred files if they are present in the local archive.
`static class`	`ObserveSql.Retrieve` Connects to the database and gets all values for the given unique object ID.
`static class`	`ObserveSql.Types` Enum version of image types.

Nested classes/interfaces inherited from class mysql.AbstractSql
AbstractSql.Columns

Nested classes/interfaces inherited from class util.PropertyResources
PropertyResources.Load, PropertyResources.URLResource

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`BIASTYPE` The image type qualifier for scientific observations.
`static String`	`CALIBRATIONTYPE` The image type qualifier for scientific observations.
`static String`	`DARKTYPE` The image type qualifier for scientific observations.
`private static String`	`DEFADU1` The key to the field name for the ADU moment of that order.
`private static String`	`DEFADU2` The key to the field name for the ADU moment of that order.
`private static String`	`DEFADU3` The key to the field name for the ADU moment of that order.
`private static String`	`DEFADU4` The key to the field name for the ADU moment of that order.
`private static String`	`DEFADU5` The key to the field name for the ADU moment of that order.
`private static String`	`DEFADU6` The key to the field name for the ADU moment of that order.
`private static String`	`DEFDATEOBSFIELD` The default target name field in the database
`private static String`	`DEFEXPID` The key to the unique exposure identifier.
`private static String`	`DEFEXPTIMEFIELD` The default target name field in the database
`private static String`	`DEFFILENAME` The key to the filename field.
`private static String`	`DEFFILTER` The key to color filter used.
`private static String`	`DEFIMAGETYPEFIELD` The default target name field in the database
`private static String`	`DEFINSTRUMENT` The key to the unique exposure identifier.
`private static String`	`DEFIVERSION` The key to the unique exposure identifier.
`private static String`	`DEFOBSERVER` The key to the observer integer field.
`private static String`	`DEFPATH` The key to the path field.
`private static String`	`DEFSIMBADNAMEFIELD` The default simbad name field in the database
`private static String`	`DEFTABLE` The default table name.
`private static String`	`DEFTARGETNAMEFIELD` The default target name field in the database
`private static String`	`DEFTARGETUNIQUE` The key to the unique target identifier.
`private static String`	`DEFTELDEROT` The key to color filter used.
`private static String`	`DEFTELESCOPEFIELD` The default target name field in the database
`private static String`	`DEFTRANSFERRED` The key to the trasnferred field.
`private static String`	`DEFUNIQUEFIELD` The default target name field in the database
`static String`	`FLATFIELDTYPE` The image type qualifier for scientific observations.
`private static Map<String,Integer>`	`IMAGETYPES` Mapping of image type numbers to image type qualifiers.
`static String`	`INSTRUME` The header key holding instrument and version number as a string.
`private static Map<String,Integer>`	`INSTYPES` Mapping of instrument names to instrument type qualifiers.
`static String`	`KEY_ADU1` The key to the field name for the ADU moment of that order.
`static String`	`KEY_ADU2` The key to the field name for the ADU moment of that order.
`static String`	`KEY_ADU3` The key to the field name for the ADU moment of that order.
`static String`	`KEY_ADU4` The key to the field name for the ADU moment of that order.
`static String`	`KEY_ADU5` The key to the field name for the ADU moment of that order.
`static String`	`KEY_ADU6` The key to the field name for the ADU moment of that order.
`static String`	`KEY_ADUBOX` If set, this points to a box for moments calculation.
`static String`	`KEY_DATEOBSFIELD` The key to the target name in the database.
`static String`	`KEY_EXPID` The key to the unique exposure identifier.
`static String`	`KEY_EXPTIMEFIELD` The key to the target name in the database.
`static String`	`KEY_FILENAME` The key to the filename field.
`static String`	`KEY_FILTER` The key to the field name for the ADU moment of that order.
`static String`	`KEY_IMAGETYPEFIELD` The key to the imagetype field.
`static String`	`KEY_INSTRUMENT` The key to the instrument int.
`static String`	`KEY_IVERSION` The key to the instrument version.
`static String`	`KEY_LOCALNFS` A mapping of archive path to local accessible ones.
`static String`	`KEY_OBSERVER` The key to the observer integer field.
`static String`	`KEY_PATH` The key to the path field.
`static String`	`KEY_SIMBADNAMEFIELD` The key to the Simbad object name in the database.
`static String`	`KEY_TARGETNAMEFIELD` The key to the target name in the database.
`static String`	`KEY_TARGETUNIQUE` The key to the unique target identifier.
`static String`	`KEY_TELDEROT` The key to the field name for the ADU moment of that order.
`static String`	`KEY_TELESCOPEFIELD` The key to the telescope name in the database.
`static String`	`KEY_TRANSFERRED` The key to the transferred field.
`static String`	`KEY_UNIQUEFIELD` The key to the unique observation ID in the database.
`private static Map<String,String>`	`KEYCOLUMN` Mapping of HDU header keys to column names.
`static String`	`PREFIX_ADU` The prefix for the ADU keys.
`static String`	`SCIENCETYPE` The image type qualifier for scientific observations.
`static String`	`SKYTYPE` The image type qualifier for sky observations.
`static String`	`UNKNOWNTYPE` The image type qualifier for scientific observations.

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

ObserveSql(Map<String,String> prop)
Sets the properties of the history database and adds my defaults.

Constructors
Constructor and Description
`ObserveSql(Map<String,String> prop)` Sets the properties of the history database and adds my defaults.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`enterFits(String unique, File f)` Grabs a fits file and enters all fields it can, if this is the first encounter of the exposure.
`boolean`	`enterFits(String unique, File fits, Rectangle box)` Grabs a fits file and enters all fields it can, if this is the first encounter of the exposure.
`private boolean`	`enterFits(String unique, File fits, Rectangle box, boolean force)` Grabs a fits file and enters all fields it can.
`double[]`	`getAduArray(String unique, String adufield)` Retrieves an sql-array with the specified field name as a primitive float[].
`double[]`	`getAduArray(String table, String ufield, String uval, String adufield)` Static version, specfying also table and field name.
`Date`	`getDateFromUnique(String unique)` Gets the dateobs-field for the specified unique.
`Date`	`getDateFromUnique(String unique, String ufield, String dfield)` Gets the dateobs-field for the specified unique.
`private int`	`getExpId(File fits)` Get exposure id from file name.
`static File`	`getFileFromUnique(String unique)` Gets the file name from the object id.
`File`	`getFileFromUnique(String unique, String ufield, String pfield, String ffield)` Gets the file name from the object id.
`Date`	`getLastScienceObservation(String tel, String filter)` Returns the date the questioned filter was last observed on the specified telescope.
`File`	`getLocalFileFromUnique(String unique)` From the path and filename saved in the db, we have the possibility to divert to a local file name, if the nfs property is set.
`Object`	`getMapping(String unique, String field)` Returns the mapping of the requested column names to the stated unique in the obs table.
`Map<String,Object>`	`getMappings(String unique, Collection<String> f)` Returns the mapping of the requested column names to the stated unique in the obs table.
`private String`	`getObjid(String unique, File fits)` Returns the unique objid from the unique target id and a file name.
`Map<String,Map<String,Object>>`	`getObservationForPick(String unique)` Returns a mapping of columns names to parsed java objects for the required unique pick id
`private Map<String,Map<String,Object>>`	`getObservationMappings(String w)` Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
`Map<String,Map<String,Object>>`	`getObservations(Date from, Date to)` Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
`Map<String,Map<String,Object>>`	`getObservations(Date from, Date to, int type)` Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
`Map<String,Map<String,Object>>`	`getObservations(Date from, Date to, int type, String t)` Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
`Map<String,Map<String,Object>>`	`getObservations(Date from, Date to, String type)` Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
`Map<String,Map<String,Object>>`	`getObservations(String tel, Date from, Date to)` Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
`double`	`getScienceOpen(String tel, Date from, Date to)`
`double`	`getShutterOpen(String tel, Date from, Date to)`
`private Map<String,Object>`	`headerInfo(MHeader h)` We read all key/value pair in the header and then try to get values to the entries in `KEYCOLUMN`.
`boolean`	`isFitsEntry(String unique, File fits)` Test, if for a given file an entry already exists in the table.
`boolean`	`removeObservationFromDatabase(String unique)` Removes an entry from the observe db if the unique specifier is given.
`private Map<String,Map<String,Object>>`	`resultToMapping(ResultSet rs)` We take a result set and convert each row into a mapping of column names to Java objects.
`private String`	`spanWhere(Date from, Date to)`
`private double`	`sumExposureTime(String where)`
`private String`	`telWhere(String tel)`
`private String`	`typeWhere(int type)`
`(package private) String`	`where(Date from, Date to, int type)`
`(package private) String`	`where(String tel, Date from, Date to)`
`(package private) String`	`where(String tel, Date from, Date to, int type)`

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
  - INSTRUME
```
public static final String INSTRUME
```
    The header key holding instrument and version number as a string.
    
    See Also:
    
    Constant Field Values
  - SKYTYPE
```
public static final String SKYTYPE
```
    The image type qualifier for sky observations.
    
    See Also:
    
    Constant Field Values
  - SCIENCETYPE
```
public static final String SCIENCETYPE
```
    The image type qualifier for scientific observations.
    
    See Also:
    
    Constant Field Values
  - FLATFIELDTYPE
```
public static final String FLATFIELDTYPE
```
    The image type qualifier for scientific observations.
    
    See Also:
    
    Constant Field Values
  - CALIBRATIONTYPE
```
public static final String CALIBRATIONTYPE
```
    The image type qualifier for scientific observations.
    
    See Also:
    
    Constant Field Values
  - BIASTYPE
```
public static final String BIASTYPE
```
    The image type qualifier for scientific observations.
    
    See Also:
    
    Constant Field Values
  - DARKTYPE
```
public static final String DARKTYPE
```
    The image type qualifier for scientific observations.
    
    See Also:
    
    Constant Field Values
  - UNKNOWNTYPE
```
public static final String UNKNOWNTYPE
```
    The image type qualifier for scientific observations.
    
    See Also:
    
    Constant Field Values
  - KEY_UNIQUEFIELD
```
public static final String KEY_UNIQUEFIELD
```
    The key to the unique observation ID in the database.
    
    See Also:
    
    Constant Field Values
  - KEY_TARGETNAMEFIELD
```
public static final String KEY_TARGETNAMEFIELD
```
    The key to the target name in the database.
    
    See Also:
    
    Constant Field Values
  - KEY_TELESCOPEFIELD
```
public static final String KEY_TELESCOPEFIELD
```
    The key to the telescope name in the database.
    
    See Also:
    
    Constant Field Values
  - KEY_DATEOBSFIELD
```
public static final String KEY_DATEOBSFIELD
```
    The key to the target name in the database.
    
    See Also:
    
    Constant Field Values
  - KEY_EXPTIMEFIELD
```
public static final String KEY_EXPTIMEFIELD
```
    The key to the target name in the database.
    
    See Also:
    
    Constant Field Values
  - KEY_IMAGETYPEFIELD
```
public static final String KEY_IMAGETYPEFIELD
```
    The key to the imagetype field.
    
    See Also:
    
    Constant Field Values
  - KEY_SIMBADNAMEFIELD
```
public static final String KEY_SIMBADNAMEFIELD
```
    The key to the Simbad object name in the database.
    
    See Also:
    
    Constant Field Values
  - KEY_TARGETUNIQUE
```
public static final String KEY_TARGETUNIQUE
```
    The key to the unique target identifier.
    
    See Also:
    
    Constant Field Values
  - KEY_EXPID
```
public static final String KEY_EXPID
```
    The key to the unique exposure identifier.
    
    See Also:
    
    Constant Field Values
  - KEY_INSTRUMENT
```
public static final String KEY_INSTRUMENT
```
    The key to the instrument int.
    
    See Also:
    
    Constant Field Values
  - KEY_IVERSION
```
public static final String KEY_IVERSION
```
    The key to the instrument version.
    
    See Also:
    
    Constant Field Values
  - KEY_FILENAME
```
public static final String KEY_FILENAME
```
    The key to the filename field.
    
    See Also:
    
    Constant Field Values
  - KEY_PATH
```
public static final String KEY_PATH
```
    The key to the path field.
    
    See Also:
    
    Constant Field Values
  - KEY_TRANSFERRED
```
public static final String KEY_TRANSFERRED
```
    The key to the transferred field.
    
    See Also:
    
    Constant Field Values
  - KEY_OBSERVER
```
public static final String KEY_OBSERVER
```
    The key to the observer integer field.
    
    See Also:
    
    Constant Field Values
  - KEY_ADUBOX
```
public static final String KEY_ADUBOX
```
    If set, this points to a box for moments calculation.
    
    See Also:
    
    Constant Field Values
  - KEY_ADU1
```
public static final String KEY_ADU1
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_ADU2
```
public static final String KEY_ADU2
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_ADU3
```
public static final String KEY_ADU3
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_ADU4
```
public static final String KEY_ADU4
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_ADU5
```
public static final String KEY_ADU5
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_ADU6
```
public static final String KEY_ADU6
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_FILTER
```
public static final String KEY_FILTER
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_TELDEROT
```
public static final String KEY_TELDEROT
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - KEY_LOCALNFS
```
public static final String KEY_LOCALNFS
```
    A mapping of archive path to local accessible ones.
    
    See Also:
    
    Constant Field Values
  - PREFIX_ADU
```
public static final String PREFIX_ADU
```
    The prefix for the ADU keys.
    
    See Also:
    
    Constant Field Values
  - KEYCOLUMN
```
private static final Map<String,String> KEYCOLUMN
```
    Mapping of HDU header keys to column names.
  - IMAGETYPES
```
private static final Map<String,Integer> IMAGETYPES
```
    Mapping of image type numbers to image type qualifiers.
  - INSTYPES
```
private static final Map<String,Integer> INSTYPES
```
    Mapping of instrument names to instrument type qualifiers.
  - DEFTABLE
```
private static final String DEFTABLE
```
    The default table name.
    
    See Also:
    
    Constant Field Values
  - DEFTELESCOPEFIELD
```
private static final String DEFTELESCOPEFIELD
```
    The default target name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFTARGETNAMEFIELD
```
private static final String DEFTARGETNAMEFIELD
```
    The default target name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFSIMBADNAMEFIELD
```
private static final String DEFSIMBADNAMEFIELD
```
    The default simbad name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFUNIQUEFIELD
```
private static final String DEFUNIQUEFIELD
```
    The default target name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFDATEOBSFIELD
```
private static final String DEFDATEOBSFIELD
```
    The default target name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFEXPTIMEFIELD
```
private static final String DEFEXPTIMEFIELD
```
    The default target name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFIMAGETYPEFIELD
```
private static final String DEFIMAGETYPEFIELD
```
    The default target name field in the database
    
    See Also:
    
    Constant Field Values
  - DEFINSTRUMENT
```
private static final String DEFINSTRUMENT
```
    The key to the unique exposure identifier.
    
    See Also:
    
    Constant Field Values
  - DEFIVERSION
```
private static final String DEFIVERSION
```
    The key to the unique exposure identifier.
    
    See Also:
    
    Constant Field Values
  - DEFFILENAME
```
private static final String DEFFILENAME
```
    The key to the filename field.
    
    See Also:
    
    Constant Field Values
  - DEFPATH
```
private static final String DEFPATH
```
    The key to the path field.
    
    See Also:
    
    Constant Field Values
  - DEFTRANSFERRED
```
private static final String DEFTRANSFERRED
```
    The key to the trasnferred field.
    
    See Also:
    
    Constant Field Values
  - DEFOBSERVER
```
private static final String DEFOBSERVER
```
    The key to the observer integer field.
    
    See Also:
    
    Constant Field Values
  - DEFADU1
```
private static final String DEFADU1
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - DEFADU2
```
private static final String DEFADU2
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - DEFADU3
```
private static final String DEFADU3
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - DEFADU4
```
private static final String DEFADU4
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - DEFADU5
```
private static final String DEFADU5
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - DEFADU6
```
private static final String DEFADU6
```
    The key to the field name for the ADU moment of that order.
    
    See Also:
    
    Constant Field Values
  - DEFTARGETUNIQUE
```
private static final String DEFTARGETUNIQUE
```
    The key to the unique target identifier.
    
    See Also:
    
    Constant Field Values
  - DEFEXPID
```
private static final String DEFEXPID
```
    The key to the unique exposure identifier.
    
    See Also:
    
    Constant Field Values
  - DEFFILTER
```
private static final String DEFFILTER
```
    The key to color filter used.
    
    See Also:
    
    Constant Field Values
  - DEFTELDEROT
```
private static final String DEFTELDEROT
```
    The key to color filter used.
    
    See Also:
    
    Constant Field Values
- Constructor Detail
  - ObserveSql
```
public ObserveSql(Map<String,String> prop)
```
    Sets the properties of the history database and adds my defaults.
- Method Detail
  - removeObservationFromDatabase
```
public final boolean removeObservationFromDatabase(String unique)
```
    Removes an entry from the observe db if the unique specifier is given. This will always delete a single entry, as the unique field is truely unique. If for whatever reason more than a single entry match the delete query, it is not executed.
    
    Returns:
    
    True If a single pick was removed from the database.
  - getObservationForPick
```
public Map<String,Map<String,Object>> getObservationForPick(String unique)
```
    Returns a mapping of columns names to parsed java objects for the required unique pick id
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - getObservations
```
public Map<String,Map<String,Object>> getObservations(Date from,
                                                      Date to)
```
    Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - getObservations
```
public Map<String,Map<String,Object>> getObservations(String tel,
                                                      Date from,
                                                      Date to)
```
    Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - getObservations
```
public Map<String,Map<String,Object>> getObservations(Date from,
                                                      Date to,
                                                      String type)
```
    Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - getObservations
```
public Map<String,Map<String,Object>> getObservations(Date from,
                                                      Date to,
                                                      int type)
```
    Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - getObservations
```
public Map<String,Map<String,Object>> getObservations(Date from,
                                                      Date to,
                                                      int type,
                                                      String t)
```
    Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - getShutterOpen
```
public double getShutterOpen(String tel,
                             Date from,
                             Date to)
                      throws SQLException
```
    Throws:
    
    SQLException
  - getScienceOpen
```
public double getScienceOpen(String tel,
                             Date from,
                             Date to)
                      throws SQLException
```
    Throws:
    
    SQLException
  - sumExposureTime
```
private double sumExposureTime(String where)
                        throws SQLException
```
    Throws:
    
    SQLException
  - getObservationMappings
```
private Map<String,Map<String,Object>> getObservationMappings(String w)
```
    Returns a mapping of unique ID's to observational parameters (as maps) for all observations between the stated dates.
    
    Returns:
    
    A mapping of unique observation ids to observation mapping.
  - telWhere
```
private String telWhere(String tel)
```
  - typeWhere
```
private String typeWhere(int type)
```
  - where
```
String where(String tel,
             Date from,
             Date to,
             int type)
```
    Parameters:
    
    from -
    
    to -
    
    type -
    
    tel -
    
    Returns:
  - where
```
String where(Date from,
             Date to,
             int type)
```
    Parameters:
    
    from -
    
    to -
    
    type -
    
    tel -
    
    Returns:
  - where
```
String where(String tel,
             Date from,
             Date to)
```
    Parameters:
    
    from -
    
    to -
    
    tel -
    
    Returns:
  - spanWhere
```
private String spanWhere(Date from,
                         Date to)
```
    Parameters:
    
    from -
    
    to -
    
    Returns:
  - getLastScienceObservation
```
public Date getLastScienceObservation(String tel,
                                      String filter)
```
    Returns the date the questioned filter was last observed on the specified telescope. Executes a query similar to select dateobs from obs where telescop='STELLA1' and "FILTER" = 'rp' and imagetyp = 1 order by dateobs desc
  - getObjid
```
private String getObjid(String unique,
                        File fits)
```
    Returns the unique objid from the unique target id and a file name.
  - getExpId
```
private int getExpId(File fits)
```
    Get exposure id from file name.
  - getMapping
```
public Object getMapping(String unique,
                         String field)
```
    Returns the mapping of the requested column names to the stated unique in the obs table.
  - getMappings
```
public Map<String,Object> getMappings(String unique,
                                      Collection<String> f)
```
    Returns the mapping of the requested column names to the stated unique in the obs table.
  - getDateFromUnique
```
public Date getDateFromUnique(String unique)
                       throws SQLException
```
    Gets the dateobs-field for the specified unique.
    
    Throws:
    
    SQLException
  - getDateFromUnique
```
public Date getDateFromUnique(String unique,
                              String ufield,
                              String dfield)
                       throws SQLException
```
    Gets the dateobs-field for the specified unique.
    
    Throws:
    
    SQLException
  - getLocalFileFromUnique
```
public File getLocalFileFromUnique(String unique)
                            throws SQLException
```
    From the path and filename saved in the db, we have the possibility to divert to a local file name, if the nfs property is set. There is no guarantee that the named file exists or is readable.
    
    Throws:
    
    SQLException
  - getFileFromUnique
```
public static File getFileFromUnique(String unique)
                              throws SQLException
```
    Gets the file name from the object id.
    
    Throws:
    
    SQLException
  - getFileFromUnique
```
public File getFileFromUnique(String unique,
                              String ufield,
                              String pfield,
                              String ffield)
                       throws SQLException
```
    Gets the file name from the object id.
    
    Throws:
    
    SQLException
  - getAduArray
```
public double[] getAduArray(String unique,
                            String adufield)
                     throws SQLException
```
    Retrieves an sql-array with the specified field name as a primitive float[]. Promoting from float[] to double[] can be done with ArrayTool.
    
    Throws:
    
    SQLException
  - getAduArray
```
public double[] getAduArray(String table,
                            String ufield,
                            String uval,
                            String adufield)
                     throws SQLException
```
    Static version, specfying also table and field name.
    
    Throws:
    
    SQLException
  - isFitsEntry
```
public boolean isFitsEntry(String unique,
                           File fits)
                    throws SQLException
```
    Test, if for a given file an entry already exists in the table.
    
    Throws:
    
    SQLException
  - enterFits
```
public boolean enterFits(String unique,
                         File f)
                  throws SQLException
```
    Grabs a fits file and enters all fields it can, if this is the first encounter of the exposure. This also includes the path and filename, but *not* the transfered flag.
    
    Throws:
    
    SQLException
  - enterFits
```
public boolean enterFits(String unique,
                         File fits,
                         Rectangle box)
                  throws SQLException
```
    Grabs a fits file and enters all fields it can, if this is the first encounter of the exposure. This also includes the path and filename, but *not* the transfered flag.
    
    Throws:
    
    SQLException
  - enterFits
```
private boolean enterFits(String unique,
                          File fits,
                          Rectangle box,
                          boolean force)
                   throws SQLException
```
    Grabs a fits file and enters all fields it can. This also includes the path and filename, but *not* the transfered flag.
    
    Parameters:
    
    force - If true, we overwrite an old entry with same objid
    
    Throws:
    
    SQLException
  - headerInfo
```
private Map<String,Object> headerInfo(MHeader h)
```
    We read all key/value pair in the header and then try to get values to the entries in KEYCOLUMN. All non-null values are parsed to appropriate objects and put as values to the column names.
  - resultToMapping
```
private Map<String,Map<String,Object>> resultToMapping(ResultSet rs)
                                                throws SQLException
```
    We take a result set and convert each row into a mapping of column names to Java objects. Each mapping is then added to the map returned with its unique observation identifier.
    
    Throws:
    
    SQLException

Class ObserveSql

Nested Class Summary

Nested classes/interfaces inherited from class mysql.AbstractSql

Nested classes/interfaces inherited from class util.PropertyResources

Field Summary

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 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

INSTRUME

SKYTYPE

SCIENCETYPE

FLATFIELDTYPE

CALIBRATIONTYPE

BIASTYPE

DARKTYPE

UNKNOWNTYPE

KEY_UNIQUEFIELD

KEY_TARGETNAMEFIELD

KEY_TELESCOPEFIELD

KEY_DATEOBSFIELD

KEY_EXPTIMEFIELD

KEY_IMAGETYPEFIELD

KEY_SIMBADNAMEFIELD

KEY_TARGETUNIQUE

KEY_EXPID

KEY_INSTRUMENT

KEY_IVERSION

KEY_FILENAME

KEY_PATH

KEY_TRANSFERRED

KEY_OBSERVER

KEY_ADUBOX

KEY_ADU1

KEY_ADU2

KEY_ADU3

KEY_ADU4

KEY_ADU5

KEY_ADU6

KEY_FILTER

KEY_TELDEROT

KEY_LOCALNFS

PREFIX_ADU

KEYCOLUMN

IMAGETYPES

INSTYPES

DEFTABLE

DEFTELESCOPEFIELD

DEFTARGETNAMEFIELD

DEFSIMBADNAMEFIELD

DEFUNIQUEFIELD

DEFDATEOBSFIELD

DEFEXPTIMEFIELD

DEFIMAGETYPEFIELD

DEFINSTRUMENT

DEFIVERSION

DEFFILENAME

DEFPATH

DEFTRANSFERRED

DEFOBSERVER

DEFADU1

DEFADU2

DEFADU3

DEFADU4

DEFADU5

DEFADU6

DEFTARGETUNIQUE

DEFEXPID

DEFFILTER

DEFTELDEROT

Constructor Detail