mysql

Class FailureSql

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

mysql.FailureSql

All Implemented Interfaces:

Cloneable, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

public class FailureSql
extends AbstractSql

/** A class that allows static access to a database containing pre-reductional check on file validity/usability. For each objid, a usage flag is generated. The modification time is stored automatically to allow easier user manipulation (e.g., delete all flags prior to a certain date.)

 Column | Type | Modifiers
 ----------+-----------------------------+------------------------
 objid | character varying(255) | not null
 fail | smallint |
 modified | timestamp without time zone | not null default now()
 Indexes:
 "failure_pkey" PRIMARY KEY, btree (objid)
 

Author:

wooz

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	FailureSql.Failure
static class	FailureSql.Test

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	DEFFAILFIELD 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_FAILFIELD The key to the unique observation ID in the database.
static String	KEY_UNIQUEFIELD The key to the unique observation ID 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
FailureSql(Map<String,String> prop)

Method Summary

Modifier and Type	Method and Description
List<FailureSql.Failure>	readFailure(String unique) We read the failure flag and convert it to individual failures using the combined bit mask.
boolean	writeFailure(String unique, List<FailureSql.Failure> outcome) Writes the failure flags to the db, updating automatically the modified field.

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 unique observation ID in the database.

See Also:

Constant Field Values

KEY_FAILFIELD

public static final String KEY_FAILFIELD

The key to the unique observation ID 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

DEFFAILFIELD

private static final String DEFFAILFIELD

The default target name field in the database

See Also:

Constant Field Values

DEFTABLE

private static final String DEFTABLE

The default table name.

See Also:

Constant Field Values

Constructor Detail

FailureSql

public FailureSql(Map<String,String> prop)

Parameters:

prop -

Method Detail

readFailure

public List<FailureSql.Failure> readFailure(String unique)

We read the failure flag and convert it to individual failures using the combined bit mask. No reasons are recovered.

writeFailure

public boolean writeFailure(String unique,
                            List<FailureSql.Failure> outcome)

Writes the failure flags to the db, updating automatically the modified field.