Package generalDatabase

Class SuperDetLogging

java.lang.Object

generalDatabase.SQLLogging

generalDatabase.SuperDetLogging

Direct Known Subclasses:

ClickTrainDetLogging, CPODClickTrainLogging, DetectionGroupLogging, DLGroupDetectionLogging, Group3DLogging, MarkGroupSQLLogging, OfflineEventLogging, QASequenceLogging, QATestLogging

public abstract class SuperDetLogging
extends SQLLogging

Extensions to SQLLogging to be used with datablocks that log sub detections. All such blocks will be instances of SuperDetDatablock

Author:

Dougl

Field Summary

Fields

Modifier and Type	Field	Description
static final int	SUBTABLECLAUSE_PARENTDATABASEID	When loading sub table data, load data using a clause which will guarantee loading of all sub detections of loaded super detections based around database indexes.
static final int	SUBTABLECLAUSE_PARENTUID	When loading sub table data, load data using a clause which will guarantee loading of all sub detections of loaded super detections based around UID's
static final int	SUBTABLECLAUSE_TIME	When loading sub table data, load data using the same between times clause as was applied to the super datablock

Fields inherited from class generalDatabase.SQLLogging

superDetLogging, UPDATE_POLICY_OVERWRITE, UPDATE_POLICY_WRITENEW

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SuperDetLogging(SuperDetDataBlock pamDataBlock)
protected	SuperDetLogging(SuperDetDataBlock pamDataBlock, boolean createDataUnits)

Method Summary

Modifier and Type	Method	Description
Boolean	anySubTableItems(PAMSelectClause mainTableClause, PAMSelectClause subTableClause)	find if any sub table items that satisfy a particular clause.
int	checkSubTableCount(int databaseIndex)	Check the number of entries in the sub table which have this database index.
Integer	countSubTableItems(PAMSelectClause mainTableClause, PAMSelectClause subTableClause)	Count the number of sub table items that satisfy a particular clause.
boolean	deleteData(PAMSelectClause pvp)
boolean	deleteIndexedItems(PamConnection connection, int[] deleteIndexes)	Delete one or more rows from the database based on their indexes.
void	doSubTableUIDRepairs()
PamTableItem	getEventEndTimeItem()
SQLLogging	getSubLogging()
int	getSubTableClausePolicy()
protected int	insertCursorRow(PamConnection connection, PamCursor pamCursor, PamDataUnit aUnit)	Used in standard offline save to add data to a scrollable cursor and adds the cursor row id to the data unit.
boolean	isCreateDataUnits()
boolean	loadViewData(PamConnection con, PamViewParameters pamViewParameters, ViewLoadObserver loadObserver)	Load viewer data for a single datablock.
boolean	logData(PamConnection con, PamDataUnit dataUnit, PamDataUnit superDetection)	Called when a new PamDataUnit is added to a PamDataBlock to write those data to the database.
boolean	reLogData(PamConnection con, PamDataUnit dataUnit, PamDataUnit superDetection)	Called when an old PamDataUnit is updated.
boolean	saveOfflineData(DBControlUnit dbControlUnit, PamConnection connection)	Save offline data in viewer mode.
void	setCreateDataUnits(boolean createDataUnits)
void	setEventEndTimeItem(PamTableItem eventEndTimeItem)
void	setSubLogging(SQLLogging subLogging)
void	setSubTableClausePolicy(int subTableClausePolicy)
protected void	updateCursorRow(PamConnection connection, PamCursor pamCursor, PamDataUnit aUnit)	Used in standard offline save to update data in a scrollable cursor.

Methods inherited from class generalDatabase.SQLLogging

addAddOn, clearAllAddOns, countTableItems, countTableItems, createDataUnit, createEarlyResultSet, createInClause, createViewResultSet, createViewResultSet, deleteData, deleteData, deleteSubtableItem, deleteSubtableItems, doExtraChecks, double2Float, fillTableData, finalize, findClosestDataPoint, findLogger, getBaseTableDefinition, getEarlyLoadClause, getIdListUpdatClause, getLastLoadIndex, getLastLoadUID, getLastTime, getLoggingAddOns, getPamDataBlock, getTableDefinition, getTimesUpdateClause, getUIDMatchClause, getUpdatePolicy, getViewerCursorFinder, getViewerEverythingClause, getViewerLessThanClause, getViewerLoadClause, getViewerOverlapClause, getViewerUpdateClause, isCanView, isLoadViewData, loadDataFrom, loadEarlyData, loadEarlyData, loadLastDataUnit, loadSubtableData, loadSubtableData, loadViewData, loadViewerData, logData, logSubtableData, prepareEmulation, prepareForMixedMode, readLastData, readMixedModeData, readNextEmulation, reCheckTable, reLogData, removeAddOn, removeAddOn, reset, setCanView, setColumnData, setLoadViewData, setTableData, setTableDefinition, setUpdatePolicy, transferDataFromResult, updateSubtable

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

SUBTABLECLAUSE_TIME

public static final int SUBTABLECLAUSE_TIME

When loading sub table data, load data using the same between times clause as was applied to the super datablock

See Also:

• Constant Field Values

SUBTABLECLAUSE_PARENTUID

public static final int SUBTABLECLAUSE_PARENTUID

When loading sub table data, load data using a clause which will guarantee loading of all sub detections of loaded super detections based around UID's

See Also:

• Constant Field Values

SUBTABLECLAUSE_PARENTDATABASEID

public static final int SUBTABLECLAUSE_PARENTDATABASEID

When loading sub table data, load data using a clause which will guarantee loading of all sub detections of loaded super detections based around database indexes.

See Also:

• Constant Field Values

Constructor Details

SuperDetLogging

protected SuperDetLogging(SuperDetDataBlock pamDataBlock)

SuperDetLogging

protected SuperDetLogging(SuperDetDataBlock pamDataBlock,
 boolean createDataUnits)

Method Details

getSubLogging

public SQLLogging getSubLogging()

Returns:

the subLogging

setSubLogging

public void setSubLogging(SQLLogging subLogging)

Parameters:

subLogging - the subLogging to set

logData

public boolean logData(PamConnection con,
 PamDataUnit dataUnit,
 PamDataUnit superDetection)

Description copied from class: SQLLogging

Called when a new PamDataUnit is added to a PamDataBlock to write those data to the database. Functionality moved down to PamCursor so that exact writing method can become database specific if necessary.

Overrides:

logData in class SQLLogging

Parameters:

con - Database Connection

dataUnit - Pamguard Data unit.

superDetection - reference to a super detection so additional cross referencing can be filled

Returns:

true if written and new index of dataUnit retrieved OK

See Also:

• PamDataUnit

reLogData

public boolean reLogData(PamConnection con,
 PamDataUnit dataUnit,
 PamDataUnit superDetection)

Description copied from class: SQLLogging

Called when an old PamDataUnit is updated. The record is either updated or a new record is written, but cross referenced to the old unit for bookkeeping purposes based on the updatePolicy flag.

Overrides:

reLogData in class SQLLogging

Parameters:

con - Database Connection

dataUnit - Pamguard Data unit.

superDetection - reference to a super detection so additional cross referencing can be filled

Returns:

the number of rows written to the database.

See Also:

• PamDataUnit

saveOfflineData

public boolean saveOfflineData(DBControlUnit dbControlUnit,
 PamConnection connection)

Description copied from class: SQLLogging

Save offline data in viewer mode.

This is a pretty basic function which assumes pretty much a 1:1 correspondence between data loaded into the viewer and data to be saved.

Three types of saving to do

1. Pre existing 1:1 correspondence between data in memory and database
2. Viewer will have added or removed data (e.g. map comments may easily have added data)
3. Weird stuff like in the click detector where the database is only holding information about a subset of clicks held in the binary data files

Should be able to deal with first two here, but functions must override for 3.

Overrides:

saveOfflineData in class SQLLogging

Parameters:

dbControlUnit -

connection -

Returns:

loadViewData

public boolean loadViewData(PamConnection con,
 PamViewParameters pamViewParameters,
 ViewLoadObserver loadObserver)

Description copied from class: SQLLogging

Load viewer data for a single datablock.

this executes in a Swing Worker thread, so needs to send notification objects to that thread, and not direct to the Controller so that they can be published back in the AWT thread.

Overrides:

loadViewData in class SQLLogging

Parameters:

con - database connection

pamViewParameters - viewer parameters.

loadObserver -

Returns:

deleteData

public boolean deleteData(PAMSelectClause pvp)

Overrides:

deleteData in class SQLLogging

insertCursorRow

protected int insertCursorRow(PamConnection connection,
 PamCursor pamCursor,
 PamDataUnit aUnit)
                       throws SQLException

Description copied from class: SQLLogging

Used in standard offline save to add data to a scrollable cursor and adds the cursor row id to the data unit.

Overrides:

insertCursorRow in class SQLLogging

Parameters:

connection -

pamCursor -

aUnit -

Returns:

The

Throws:

SQLException

updateCursorRow

protected void updateCursorRow(PamConnection connection,
 PamCursor pamCursor,
 PamDataUnit aUnit)
                        throws SQLException

Description copied from class: SQLLogging

Used in standard offline save to update data in a scrollable cursor.

Overrides:

updateCursorRow in class SQLLogging

Parameters:

connection -

pamCursor -

aUnit -

Throws:

SQLException

deleteIndexedItems

public boolean deleteIndexedItems(PamConnection connection,
 int[] deleteIndexes)

Description copied from class: SQLLogging

Delete one or more rows from the database based on their indexes.

Overrides:

deleteIndexedItems in class SQLLogging

Parameters:

connection -

deleteIndexes - list of Id's

Returns:

true if no exception

checkSubTableCount

public int checkSubTableCount(int databaseIndex)

Check the number of entries in the sub table which have this database index.

Parameters:

databaseIndex -

Returns:

number of sub detections.

anySubTableItems

public Boolean anySubTableItems(PAMSelectClause mainTableClause,
 PAMSelectClause subTableClause)

find if any sub table items that satisfy a particular clause.

Parameters:

mainTableClause -

subTableClause -

Returns:

true if any items satisfy clause.

countSubTableItems

public Integer countSubTableItems(PAMSelectClause mainTableClause,
 PAMSelectClause subTableClause)

Count the number of sub table items that satisfy a particular clause.

Parameters:

mainTableClause -

subTableClause -

Returns:

count of items.

getSubTableClausePolicy

public int getSubTableClausePolicy()

Returns:

the subTableClausePolicy

See Also:

• SUBTABLECLAUSE_TIME
• SUBTABLECLAUSE_PARENTUID

setSubTableClausePolicy

public void setSubTableClausePolicy(int subTableClausePolicy)

Parameters:

subTableClausePolicy - the subTableClausePolicy to set

See Also:

• SUBTABLECLAUSE_TIME
• SUBTABLECLAUSE_PARENTUID

doSubTableUIDRepairs

public void doSubTableUIDRepairs()

getEventEndTimeItem

public PamTableItem getEventEndTimeItem()

Returns:

the eventEndTimeItem

setEventEndTimeItem

public void setEventEndTimeItem(PamTableItem eventEndTimeItem)

Parameters:

eventEndTimeItem - the eventEndTimeItem to set

isCreateDataUnits

public boolean isCreateDataUnits()

Returns:

the createDataUnits

setCreateDataUnits

public void setCreateDataUnits(boolean createDataUnits)

Parameters:

createDataUnits - the createDataUnits to set