mysql

Class PpmXlDatabaseFeeder

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

mysql.HtmStarDatabase

mysql.PpmXlDatabase

mysql.PpmXlDatabaseFeeder

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

public class PpmXlDatabaseFeeder
extends PpmXlDatabase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	PpmXlDatabaseFeeder.Ascii Reads the PPMXL catalog file(s).
private class	PpmXlDatabaseFeeder.AsciiFeeder
static class	PpmXlDatabaseFeeder.Copy Reads the PPMXL catalog file(s).

Nested classes/interfaces inherited from class mysql.PpmXlDatabase

PpmXlDatabase.Query

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
(package private) PrintWriter	bright
private List<SimpleStar>	collect All stars worthy to keep from file.
private static String	DEFCOLUMNORDER Default column order.
(package private) PrintWriter	faint
static String	KEY_COLUMNORDER Column order in table for copy command.
static String	KEY_COPYFROM If stated, a copy-from file name, appended by bright and faint.
static String	KEY_ONLYUPDATE List of field names that should be updated.
(package private) List<String>	order
(package private) long	t0

Fields inherited from class mysql.PpmXlDatabase

DEGMARCSEC, KEY_DEERR, KEY_FAINTMAG, KEY_FAINTTABLE, KEY_MAGERR, KEY_RAERR, KEY_RI, PPMXLDATABASE, PPMXLFURMINT

Fields inherited from class mysql.HtmStarDatabase

KEY_COLOR, KEY_DE, KEY_EPOCH, KEY_EQUINOX, KEY_HTM, KEY_HTMDEPTH, KEY_MAG, KEY_NAME, KEY_PMDE, KEY_PMRA, KEY_RA

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
PpmXlDatabaseFeeder(Map<String,String> prop) Constructs a new generic star database.

Method Summary

Modifier and Type	Method and Description
private boolean	feed(List<SimpleStar> all) We consider that ra, de are stored in milli-arcsec, so we muliply by 3600000.
StarUtilizer	getFeeder()
private Map<String,Object>	prepareMap(SimpleStar to)
private boolean	writeFile(Map<String,Object> row, List<String> order, PrintWriter out, long prep)

Methods inherited from class mysql.PpmXlDatabase

around, getCircularField, getDefaulProperites, getFaintCircularField, getFaintMag, getFullCircularField, getTable, match, parseResultSet

Methods inherited from class mysql.HtmStarDatabase

getCircularField, getHtmIndex, getHtmIndex, parseDefaultResultSet

Methods inherited from class mysql.AbstractSql

delete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, 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_ONLYUPDATE

public static final String KEY_ONLYUPDATE

List of field names that should be updated. No insert.

See Also:

Constant Field Values

KEY_COPYFROM

public static final String KEY_COPYFROM

If stated, a copy-from file name, appended by bright and faint.

See Also:

Constant Field Values

KEY_COLUMNORDER

public static final String KEY_COLUMNORDER

Column order in table for copy command.

See Also:

Constant Field Values

DEFCOLUMNORDER

private static final String DEFCOLUMNORDER

Default column order.

See Also:

Constant Field Values

collect

private List<SimpleStar> collect

All stars worthy to keep from file.

t0

long t0

faint

PrintWriter faint

bright

PrintWriter bright

order

List<String> order

Constructor Detail

PpmXlDatabaseFeeder

public PpmXlDatabaseFeeder(Map<String,String> prop)

Constructs a new generic star database. The connection data are part of the parent class, while this class takes expressions on how to convert individual results from the result set to SimpleStars. Keys that are not defined mean that they are not present in the database.

Method Detail

getFeeder

public StarUtilizer getFeeder()

feed

private boolean feed(List<SimpleStar> all)
              throws SQLException,
                     HTMException,
                     IOException

We consider that ra, de are stored in milli-arcsec, so we muliply by 3600000. Magnitudes are stored in millimag, thus multiply by 1000. Depending on the magnitude, we either store in faint or normal table.

Throws:

SQLException

HTMException

IOException

prepareMap

private Map<String,Object> prepareMap(SimpleStar to)
                               throws HTMException

Throws:

HTMException

writeFile

private boolean writeFile(Map<String,Object> row,
                          List<String> order,
                          PrintWriter out,
                          long prep)