generalDatabase

Class PamTableDefinition

java.lang.Object

generalDatabase.EmptyTableDefinition

generalDatabase.PamTableDefinition

Direct Known Subclasses:

ImportHydrophoneTableDef, PamSettingsTableDefinition, SLTableDefinition, TargetMotionTableInformation

public class PamTableDefinition
extends EmptyTableDefinition

Defines a database table for use with the Pamguard database The Pamguard database can query this table definition to see what columns should be present and to create appropriate tables. Also used to prepare Sql statements for writing and reading back data. I did a bit of redifining what columns are used for on 4 Oct, 2012. PCLocalTime was a UTC time from the PC of the time analysis took place. When running in real time, this would be the same as the data in the UTC column (give or take the odd second for data to get through the system). I've now defined this to be the UTC time + the timezone offset. I've added another column PCTime which is the system clock from the PC at the time data were stored - which will be different to UTC if the sound card is sampling too slow or too fast or if you're reprocessing archived data from file.

Author:

Doug Gillespie

See Also:

PamTableItem, pamDatabase.DatabaseProcess

Constructor Summary

Constructors

Constructor and Description
PamTableDefinition(java.lang.String tableName, int updatePolicy)

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	getBetweenString(PamViewParameters pvp) Get the where clause for Viewer SQL statements.
java.sql.Connection	getCheckedConnection()
PamTableItem	getLocalTimeItem()
PamTableItem	getPCTimeItem()
java.lang.String	getSQLSelectString(SQLTypes sqlTypes) Get a very basic select string which queries for all items in the table, no ordering or selection
java.lang.String	getSQLSelectString(SQLTypes sqlTypes, PamViewParameters pamViewParameters) gets an sql select string for the table that selects all fields.
PamTableItem	getTimeStampItem()
PamTableItem	getTimeStampMillis()
PamTableItem	getUpdateReference()
void	setCheckedConnection(java.sql.Connection checkedConnection)
void	setUpdateReference(PamTableItem updateReference)

Methods inherited from class generalDatabase.EmptyTableDefinition

addTableItem, deblankString, findTableItem, findTableItem, getBasicSelectString, getIndexItem, getSQLInsertString, getTableItem, getTableItemCount, getTableName, isUseCheatIndexing, reblankString, removeTableItem, removeTableItem, setTableName, setUseCheatIndexing, unpackResultSet

Methods inherited from class java.lang.Object

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

Constructor Detail

PamTableDefinition

public PamTableDefinition(java.lang.String tableName,
                  int updatePolicy)

Parameters:

tableName - Name of the database table. Spaces in the database name will automatically be replaced by the _ character.

Method Detail

getSQLSelectString

public java.lang.String getSQLSelectString(SQLTypes sqlTypes)

Description copied from class: EmptyTableDefinition

Get a very basic select string which queries for all items in the table, no ordering or selection

Overrides:

getSQLSelectString in class EmptyTableDefinition

Returns:

an SQL string.

getSQLSelectString

public java.lang.String getSQLSelectString(SQLTypes sqlTypes,
                                  PamViewParameters pamViewParameters)

gets an sql select string for the table that selects all fields. Note that some databases don't support the " around a column name, so this has been omitted, making it impossible to use fields with spaces.

Returns:

SQL Select string

getBetweenString

public java.lang.String getBetweenString(PamViewParameters pvp)

Get the where clause for Viewer SQL statements.

Parameters:

pvp -

Returns:

clause string

getTimeStampItem

public PamTableItem getTimeStampItem()

getTimeStampMillis

public PamTableItem getTimeStampMillis()

getPCTimeItem

public PamTableItem getPCTimeItem()

getLocalTimeItem

public PamTableItem getLocalTimeItem()

getCheckedConnection

public java.sql.Connection getCheckedConnection()

setCheckedConnection

public void setCheckedConnection(java.sql.Connection checkedConnection)

getUpdateReference

public PamTableItem getUpdateReference()

setUpdateReference

public void setUpdateReference(PamTableItem updateReference)