com.mockturtlesolutions.snifflib.reposconfig.database

Class RepositoryStorageSQL

java.lang.Object

com.mockturtlesolutions.snifflib.reposconfig.database.AbstractRepositoryStorage

com.mockturtlesolutions.snifflib.reposconfig.database.RepositoryStorageSQL

All Implemented Interfaces:

DOMStorable, RepositoryStorage, RepositoryStorageTransfer

Direct Known Subclasses:

CanonicalSetSQL, DblMatrixSQL, FlatFileSetSQL, FlatFileSQL, ImageFileSQL, ImageStackSQL, MCMCRunSQL, MCMCSQL, MCMCTraceSQL, ParameterSetSQL, ProposalDistributionSQL, StatisticalModelSQL, TimerListenerSQL, TimerSQL, WordSQL

public class RepositoryStorageSQL
extends AbstractRepositoryStorage

Field Summary

Fields

Modifier and Type	Field and Description
protected RepositorySQLConnection	connection
protected java.lang.String	name_id

Fields inherited from class com.mockturtlesolutions.snifflib.reposconfig.database.AbstractRepositoryStorage

nickname, reposListeners, transferAgent

Constructor Summary

Constructors

Constructor and Description
RepositoryStorageSQL(RepositoryConnectivity conn, java.lang.String nickname)

Method Summary

Methods

Modifier and Type	Method and Description
protected java.sql.PreparedStatement	addPreparedStatement(java.lang.String mapKey, java.lang.String cmd1) Add a prepared statement.
void	afterTransferStorage()
protected void	commit()
protected java.sql.Statement	createStatement()
void	executeAllBatchedStatements()
protected java.lang.Integer	getBatchCount(java.lang.String mapKey)
java.util.HashMap	getBatchCounts()
java.lang.String	getComment() Gets the descriptive comment for this Wedge inverse problem as a whole.
RepositorySQLConnection	getConnection()
java.lang.String	getCreatedBy()
java.lang.String	getCreatedOn()
java.lang.Class	getDefaultGraphicalEditorClass()
protected java.lang.String	getDetailsTable()
protected java.lang.String	getDetailsTableCommentColumn()
protected java.lang.String	getDetailsTableCreatedByColumn()
protected java.lang.String	getDetailsTableCreatedOnColumn()
protected java.lang.String	getDetailsTableEnabledColumn()
protected java.lang.String	getDetailsTableIDColumn()
java.lang.Class	getDOMStorageClass() Returns a DOM storage variant of this storage instance.
java.lang.String	getDoublyNarrowerSingleEntry(java.lang.String tablename, java.lang.String columnname, java.lang.String identifier, java.lang.String identifier_value, java.lang.String ident, java.lang.String ident_value, java.lang.String dident, java.lang.String dident_value)
java.lang.String	getEnabled() Gets the state of the (possibly remote) storage.
protected int	getMaxBatchCount()
java.util.Vector	getMultipleData(java.lang.String tablename, java.lang.String columnname, java.lang.String narrower, java.lang.String narrowvalue)
protected java.lang.String	getNameByID(java.lang.String id) Get the name for the given name_id.
protected java.lang.String	getNameID() Get the name_id for this storage.
protected java.lang.String	getNameID(java.lang.String name) Get the name_id for a given name.
java.lang.String	getNarrowerSingleEntry(java.lang.String tablename, java.lang.String columnname, java.lang.String identifier, java.lang.String identifier_value, java.lang.String ident, java.lang.String ident_value)
java.lang.String	getNickname() Gets the project name for this Wedge inverse problem.
protected java.sql.PreparedStatement	getPreparedStatement(java.lang.String S) Get a stored prepared statement.
java.util.LinkedHashMap	getPreparedStatements()
java.lang.String	getSingleEntry(java.lang.String tablename, java.lang.String columnname, java.lang.String identifier, java.lang.String identifier_value) Gets a single entry from a database.
RepositoryStorage	getStorage(RepositoryElement elem)
boolean	isBatchSettingOn()
protected void	putNameID(java.lang.String name, java.lang.String id)
void	setAutoCommit(boolean x)
protected void	setBatchCount(java.lang.String mapKey, java.lang.Integer k)
void	setBatchSettingOff()
void	setBatchSettingOn()
void	setComment(java.lang.String n)
void	setConnection(RepositorySQLConnection conn)
void	setCreatedBy(java.lang.String n)
void	setCreatedOn(java.lang.String n)
void	setDoublyNarrowerSingleEntry(java.lang.String tablename, java.lang.String columnname, java.lang.String identifier, java.lang.String identifier_value, java.lang.String narrower, java.lang.String nvalue, java.lang.String dnarrower, java.lang.String dnvalue, java.lang.String value)
void	setEnabled(java.lang.String n) Sets the enabled state of the (possibly remote) storage instance.
void	setNarrowerSingleEntry(java.lang.String tablename, java.lang.String columnname, java.lang.String identifier, java.lang.String identifier_value, java.lang.String narrower, java.lang.String nvalue, java.lang.String value)
void	setNickname(java.lang.String n) Sets the project name for this Wedge inverse problem.
void	setNoAfterTransferExecuteBatch(boolean x)
void	setSingleEntry(java.lang.String tablename, java.lang.String columnname, java.lang.String identifier, java.lang.String identifier_value, java.lang.String value)
void	usePreparedInfo(RepositoryStorageSQL otherstor)

Methods inherited from class com.mockturtlesolutions.snifflib.reposconfig.database.AbstractRepositoryStorage

addRepositoryListener, afterCopyStorage, beforeCopyStorage, beforeTransferStorage, copyStorage, copyStorageCommands, getStorageCalculationsAgentClass, getStorageTransferAgentClass, removeRepositoryListener, show, transferStorage, transferStorageCommands

Methods inherited from class java.lang.Object

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

Field Detail

name_id

protected java.lang.String name_id

connection

protected RepositorySQLConnection connection

Constructor Detail

RepositoryStorageSQL

public RepositoryStorageSQL(RepositoryConnectivity conn,
                    java.lang.String nickname)

Method Detail

usePreparedInfo

public void usePreparedInfo(RepositoryStorageSQL otherstor)

setNoAfterTransferExecuteBatch

public void setNoAfterTransferExecuteBatch(boolean x)

getPreparedStatements

public java.util.LinkedHashMap getPreparedStatements()

getBatchCounts

public java.util.HashMap getBatchCounts()

getDefaultGraphicalEditorClass

public java.lang.Class getDefaultGraphicalEditorClass()

getDetailsTable

protected java.lang.String getDetailsTable()

getDetailsTableIDColumn

protected java.lang.String getDetailsTableIDColumn()

getDetailsTableCreatedOnColumn

protected java.lang.String getDetailsTableCreatedOnColumn()

getDetailsTableCreatedByColumn

protected java.lang.String getDetailsTableCreatedByColumn()

getDetailsTableEnabledColumn

protected java.lang.String getDetailsTableEnabledColumn()

getDetailsTableCommentColumn

protected java.lang.String getDetailsTableCommentColumn()

isBatchSettingOn

public boolean isBatchSettingOn()

setBatchSettingOn

public void setBatchSettingOn()

setBatchSettingOff

public void setBatchSettingOff()

getMultipleData

public java.util.Vector getMultipleData(java.lang.String tablename,
                               java.lang.String columnname,
                               java.lang.String narrower,
                               java.lang.String narrowvalue)

afterTransferStorage

public void afterTransferStorage()

Specified by:

afterTransferStorage in interface RepositoryStorageTransfer

Overrides:

afterTransferStorage in class AbstractRepositoryStorage

setAutoCommit

public void setAutoCommit(boolean x)

setConnection

public void setConnection(RepositorySQLConnection conn)

getConnection

public RepositorySQLConnection getConnection()

getDOMStorageClass

public java.lang.Class getDOMStorageClass()

Description copied from class: AbstractRepositoryStorage

Returns a DOM storage variant of this storage instance. DOM storage classes, because they are independent of any repository, are by definition transient and often used when transfering amond RepositoryStorage classes which may be more persistent (e.g. backed by an XML or an SQL repository).

Specified by:

getDOMStorageClass in interface DOMStorable

Specified by:

getDOMStorageClass in class AbstractRepositoryStorage

setComment

public void setComment(java.lang.String n)

Specified by:

setComment in interface RepositoryStorage

Specified by:

setComment in class AbstractRepositoryStorage

getComment

public java.lang.String getComment()

Description copied from class: AbstractRepositoryStorage

Gets the descriptive comment for this Wedge inverse problem as a whole.

Specified by:

getComment in interface RepositoryStorage

Specified by:

getComment in class AbstractRepositoryStorage

getCreatedOn

public java.lang.String getCreatedOn()

Specified by:

getCreatedOn in interface RepositoryStorage

Specified by:

getCreatedOn in class AbstractRepositoryStorage

setCreatedOn

public void setCreatedOn(java.lang.String n)

Specified by:

setCreatedOn in interface RepositoryStorage

Specified by:

setCreatedOn in class AbstractRepositoryStorage

getCreatedBy

public java.lang.String getCreatedBy()

Specified by:

getCreatedBy in interface RepositoryStorage

Specified by:

getCreatedBy in class AbstractRepositoryStorage

setCreatedBy

public void setCreatedBy(java.lang.String n)

Specified by:

setCreatedBy in interface RepositoryStorage

Specified by:

setCreatedBy in class AbstractRepositoryStorage

getNickname

public java.lang.String getNickname()

Description copied from class: AbstractRepositoryStorage

Gets the project name for this Wedge inverse problem.

Specified by:

getNickname in interface RepositoryStorage

Specified by:

getNickname in class AbstractRepositoryStorage

setNickname

public void setNickname(java.lang.String n)

Description copied from class: AbstractRepositoryStorage

Sets the project name for this Wedge inverse problem.

Specified by:

setNickname in interface RepositoryStorage

Specified by:

setNickname in class AbstractRepositoryStorage

getEnabled

public java.lang.String getEnabled()

Description copied from class: AbstractRepositoryStorage

Gets the state of the (possibly remote) storage. For example, dis-enabled storages may be slated for deletion from some repostories. Typically a storage is backed by static information stored in a database.

Specified by:

getEnabled in interface RepositoryStorage

Specified by:

getEnabled in class AbstractRepositoryStorage

setEnabled

public void setEnabled(java.lang.String n)

Description copied from class: AbstractRepositoryStorage

Sets the enabled state of the (possibly remote) storage instance. Typically a storage is backed by static information stored in a database.

Specified by:

setEnabled in interface RepositoryStorage

Specified by:

setEnabled in class AbstractRepositoryStorage

getSingleEntry

public java.lang.String getSingleEntry(java.lang.String tablename,
                              java.lang.String columnname,
                              java.lang.String identifier,
                              java.lang.String identifier_value)

Gets a single entry from a database. Returns null if no matching entry is found.

getNarrowerSingleEntry

public java.lang.String getNarrowerSingleEntry(java.lang.String tablename,
                                      java.lang.String columnname,
                                      java.lang.String identifier,
                                      java.lang.String identifier_value,
                                      java.lang.String ident,
                                      java.lang.String ident_value)

getDoublyNarrowerSingleEntry

public java.lang.String getDoublyNarrowerSingleEntry(java.lang.String tablename,
                                            java.lang.String columnname,
                                            java.lang.String identifier,
                                            java.lang.String identifier_value,
                                            java.lang.String ident,
                                            java.lang.String ident_value,
                                            java.lang.String dident,
                                            java.lang.String dident_value)

executeAllBatchedStatements

public void executeAllBatchedStatements()

setSingleEntry

public void setSingleEntry(java.lang.String tablename,
                  java.lang.String columnname,
                  java.lang.String identifier,
                  java.lang.String identifier_value,
                  java.lang.String value)

setDoublyNarrowerSingleEntry

public void setDoublyNarrowerSingleEntry(java.lang.String tablename,
                                java.lang.String columnname,
                                java.lang.String identifier,
                                java.lang.String identifier_value,
                                java.lang.String narrower,
                                java.lang.String nvalue,
                                java.lang.String dnarrower,
                                java.lang.String dnvalue,
                                java.lang.String value)

setNarrowerSingleEntry

public void setNarrowerSingleEntry(java.lang.String tablename,
                          java.lang.String columnname,
                          java.lang.String identifier,
                          java.lang.String identifier_value,
                          java.lang.String narrower,
                          java.lang.String nvalue,
                          java.lang.String value)

createStatement

protected java.sql.Statement createStatement()

getPreparedStatement

protected java.sql.PreparedStatement getPreparedStatement(java.lang.String S)

Get a stored prepared statement.

getBatchCount

protected java.lang.Integer getBatchCount(java.lang.String mapKey)

setBatchCount

protected void setBatchCount(java.lang.String mapKey,
                 java.lang.Integer k)

commit

protected void commit()

addPreparedStatement

protected java.sql.PreparedStatement addPreparedStatement(java.lang.String mapKey,
                                              java.lang.String cmd1)

Add a prepared statement.

getMaxBatchCount

protected int getMaxBatchCount()

getNameID

protected java.lang.String getNameID()

Get the name_id for this storage.

putNameID

protected void putNameID(java.lang.String name,
             java.lang.String id)

getNameID

protected java.lang.String getNameID(java.lang.String name)

Get the name_id for a given name.

getNameByID

protected java.lang.String getNameByID(java.lang.String id)

Get the name for the given name_id.

getStorage

public RepositoryStorage getStorage(RepositoryElement elem)