mysql

Class ScaleSql

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

mysql.ScaleSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

public class ScaleSql
extends AbstractSql

A class that allows static access to a database containing observed history in block format. A block is defined as a consecuetive row of exposures of the same type (bias, dark, flat, thar, science, sky), eventually grouped further by filter (flat, science) and/or derotator stage. A block is normally used during the reduction process to create master entries in the master table.

 Table "public.block"
   Column  |            Type             |       Modifiers        
 ----------+-----------------------------+------------------------
  blkid    | character varying(255)      | not null
  firstid  | character varying(255)      |
  lastid   | character varying(255)      |
  imagetyp | smallint                    | 
  telescop | character(8)                | 
  first    | timestamp without time zone | 
  last     | timestamp without time zone | 
  filter   | character(8)                | 
  telderot | real                        | 
  modified | timestamp without time zone | not null default now()
 Indexes:
     "block_pkey" PRIMARY KEY, btree (objid)
 

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	DEFBLOCKIDFIELD The default target name field in the database
private static String	DEFCHICONVOLVEFIELD The key to color filter used.
private static String	DEFCHIGRADFIELD The default field with the first dateobs of the block in the database
private static String	DEFCHISCALEFIELD The default target name field in the database
private static String	DEFGRADLENFIELD The default target name field in the database
private static String	DEFGRADPHIFIELD The default field with the first dateobs of the block in the database
private static String	DEFSCALEFIELD The default target name field in the database
private static String	DEFTABLE The default table name.
private static String	DEFUNIQUEFIELD The default target name field in the database
static String	KEY_BLOCKIDFIELD The key to the block identifier in the database.
static String	KEY_CHICONVOLVEFIELD The key to the field name for the filter of the block, if distinctive.
static String	KEY_CHIGRADFIELD The key to the end date of the block.
static String	KEY_CHISCALEFIELD The key to the image type integer field.
static String	KEY_GRADLENFIELD The key to the telescope name in the database.
static String	KEY_GRADPHIFIELD The key to the start date of the block.
static String	KEY_SCALEFIELD The key to the block identifier in the database.
static String	KEY_UNIQUEFIELD 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
ScaleSql(Map<String,String> prop) Constructs a new history database.

Method Summary

Modifier and Type	Method and Description
boolean	writeBlock(String blkid, String uniq, double scale, double chi, double convchi, Vector2D grad, double gradchi) Writes the image block to the db.

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_UNIQUEFIELD

public static final String KEY_UNIQUEFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_BLOCKIDFIELD

public static final String KEY_BLOCKIDFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_SCALEFIELD

public static final String KEY_SCALEFIELD

The key to the block identifier in the database.

See Also:

Constant Field Values

KEY_CHISCALEFIELD

public static final String KEY_CHISCALEFIELD

The key to the image type integer field.

See Also:

Constant Field Values

KEY_GRADLENFIELD

public static final String KEY_GRADLENFIELD

The key to the telescope name in the database.

See Also:

Constant Field Values

KEY_GRADPHIFIELD

public static final String KEY_GRADPHIFIELD

The key to the start date of the block.

See Also:

Constant Field Values

KEY_CHIGRADFIELD

public static final String KEY_CHIGRADFIELD

The key to the end date of the block.

See Also:

Constant Field Values

KEY_CHICONVOLVEFIELD

public static final String KEY_CHICONVOLVEFIELD

The key to the field name for the filter of the block, if distinctive.

See Also:

Constant Field Values

DEFTABLE

private static final String DEFTABLE

The default table name.

See Also:

Constant Field Values

DEFUNIQUEFIELD

private static final String DEFUNIQUEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFBLOCKIDFIELD

private static final String DEFBLOCKIDFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFSCALEFIELD

private static final String DEFSCALEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFCHISCALEFIELD

private static final String DEFCHISCALEFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFGRADLENFIELD

private static final String DEFGRADLENFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFGRADPHIFIELD

private static final String DEFGRADPHIFIELD

The default field with the first dateobs of the block in the database

See Also:

Constant Field Values

DEFCHIGRADFIELD

private static final String DEFCHIGRADFIELD

The default field with the first dateobs of the block in the database

See Also:

Constant Field Values

DEFCHICONVOLVEFIELD

private static final String DEFCHICONVOLVEFIELD

The key to color filter used.

See Also:

Constant Field Values

Constructor Detail

ScaleSql

public ScaleSql(Map<String,String> prop)

Constructs a new history database.

Method Detail

writeBlock

public boolean writeBlock(String blkid,
                          String uniq,
                          double scale,
                          double chi,
                          double convchi,
                          Vector2D grad,
                          double gradchi)

Writes the image block to the db. Writes filter, derotator and list if non-null.

Returns:

True, if successful