Package ai.libs.jaicore.experiments.databasehandle

Class AExperimenterSQLHandle

java.lang.Object

ai.libs.jaicore.experiments.databasehandle.AExperimenterSQLHandle

All Implemented Interfaces:

IExperimentDatabaseHandle, org.api4.java.common.control.ILoggingCustomizable

Direct Known Subclasses:

ExperimenterMySQLHandle, ExperimenterRestSQLHandle

public class AExperimenterSQLHandle
extends java.lang.Object
implements IExperimentDatabaseHandle, org.api4.java.common.control.ILoggingCustomizable

Field Summary

Fields

Modifier and Type	Field	Description
protected ai.libs.jaicore.db.IDatabaseAdapter	adapter
protected java.lang.String	tablename

Constructor Summary

Constructors

Constructor	Description
AExperimenterSQLHandle(ai.libs.jaicore.db.IDatabaseAdapter adapter, java.lang.String tablename)
AExperimenterSQLHandle(ai.libs.jaicore.db.IDatabaseConfig config)

Method Summary

Modifier and Type	Method	Description
ExperimentDBEntry	createAndGetExperiment(Experiment experiment)	Creates a new experiment entry and returns it.
ExperimentDBEntry	createAndGetExperiment(java.util.Map<java.lang.String,java.lang.String> values)
java.util.List<ExperimentDBEntry>	createAndGetExperiments(java.util.List<Experiment> experiments)	Creates a new experiment entry and returns it.
void	deleteDatabase()	Deletes everything known to the experiment database.
void	deleteExperiment(ExperimentDBEntry exp)	Deletes an experiment from the database
void	finishExperiment(ExperimentDBEntry expEntry)	Signals that an experiment has been finished successfully.
void	finishExperiment(ExperimentDBEntry expEntry, java.lang.Throwable error)	Signals that an experiment has failed with an exception.
java.util.List<ExperimentDBEntry>	getAllExperiments()	Returns a list of all experiments contained in the database
java.util.List<ExperimentDBEntry>	getConductedExperiments()	Returns a list of all experiments contained in the database marked as being conducted.
java.util.Collection<java.lang.String>	getConsideredValuesForKey(java.lang.String key)
protected java.lang.String	getDatabaseFieldnameForConfigEntry(java.lang.String configKey)
protected java.util.List<ExperimentDBEntry>	getExperimentsForSQLQuery(java.lang.String sql)
ExperimentDBEntry	getExperimentWithId(int id)	Gets the experiment with the given id.
java.lang.String	getLoggerName()
int	getNumberOfAllExperiments()	Returns a list of all experiments contained in the database
java.util.List<ExperimentDBEntry>	getOpenExperiments()	Returns a list of all experiments contained in the database that have not been started yet.
java.util.List<ExperimentDBEntry>	getRandomOpenExperiments(int limit)	Returns a list of all experiments contained in the database that have not been started yet.
java.util.List<ExperimentDBEntry>	getRunningExperiments()	Returns a list of all experiments that are currently being conducted.
protected java.lang.String	getSetupCreateTableQuery()
protected java.lang.String	getSQLPrefixForKeySelectQuery()
protected java.lang.String	getSQLPrefixForSelectQuery()
void	setLoggerName(java.lang.String name)
void	setup(IExperimentSetConfig config)	Prepares everything so that upcoming calls for create and update will be managed according to the specified configuration.
void	startExperiment(ExperimentDBEntry exp)	Updates non-keyfield values of the experiment.
void	updateExperiment(ExperimentDBEntry exp, java.util.Map<java.lang.String,? extends java.lang.Object> values)	Updates non-keyfield values of the experiment.
boolean	updateExperimentConditionally(ExperimentDBEntry exp, java.util.Map<java.lang.String,java.lang.String> conditions, java.util.Map<java.lang.String,? extends java.lang.Object> values)

Methods inherited from class java.lang.Object

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

Field Detail

adapter

protected final ai.libs.jaicore.db.IDatabaseAdapter adapter

tablename

protected final java.lang.String tablename

Constructor Detail

AExperimenterSQLHandle

public AExperimenterSQLHandle(ai.libs.jaicore.db.IDatabaseAdapter adapter,
                              java.lang.String tablename)

AExperimenterSQLHandle

public AExperimenterSQLHandle(ai.libs.jaicore.db.IDatabaseConfig config)

Method Detail

getSetupCreateTableQuery

protected java.lang.String getSetupCreateTableQuery()

setup

public void setup(IExperimentSetConfig config)
           throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Prepares everything so that upcoming calls for create and update will be managed according to the specified configuration.

Specified by:

setup in interface IExperimentDatabaseHandle

Parameters:

config - Description of the experiment setup

Throws:

ExperimentDBInteractionFailedException

getSQLPrefixForKeySelectQuery

protected java.lang.String getSQLPrefixForKeySelectQuery()

getSQLPrefixForSelectQuery

protected java.lang.String getSQLPrefixForSelectQuery()

getConsideredValuesForKey

public java.util.Collection<java.lang.String> getConsideredValuesForKey(java.lang.String key)
                                                                 throws ExperimentDBInteractionFailedException

Specified by:

getConsideredValuesForKey in interface IExperimentDatabaseHandle

Parameters:

key - The key attribute

Throws:

ExperimentDBInteractionFailedException

getNumberOfAllExperiments

public int getNumberOfAllExperiments()
                              throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Returns a list of all experiments contained in the database

Specified by:

getNumberOfAllExperiments in interface IExperimentDatabaseHandle

Throws:

ExperimentDBInteractionFailedException

getAllExperiments

public java.util.List<ExperimentDBEntry> getAllExperiments()
                                                    throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Returns a list of all experiments contained in the database

Specified by:

getAllExperiments in interface IExperimentDatabaseHandle

Returns:

List of all experiments

Throws:

ExperimentDBInteractionFailedException

getOpenExperiments

public java.util.List<ExperimentDBEntry> getOpenExperiments()
                                                     throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Returns a list of all experiments contained in the database that have not been started yet.

Specified by:

getOpenExperiments in interface IExperimentDatabaseHandle

Returns:

List of all experiments conducted so far

Throws:

ExperimentDBInteractionFailedException

getRandomOpenExperiments

public java.util.List<ExperimentDBEntry> getRandomOpenExperiments(int limit)
                                                           throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Returns a list of all experiments contained in the database that have not been started yet.

Specified by:

getRandomOpenExperiments in interface IExperimentDatabaseHandle

Parameters:

limit - Maximum number of open experiments that should be returned

Returns:

List of all experiments conducted so far

Throws:

ExperimentDBInteractionFailedException

getRunningExperiments

public java.util.List<ExperimentDBEntry> getRunningExperiments()
                                                        throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Returns a list of all experiments that are currently being conducted.

Specified by:

getRunningExperiments in interface IExperimentDatabaseHandle

Returns:

List of all experiments conducted so far

Throws:

ExperimentDBInteractionFailedException

getConductedExperiments

public java.util.List<ExperimentDBEntry> getConductedExperiments()
                                                          throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Returns a list of all experiments contained in the database marked as being conducted.

Specified by:

getConductedExperiments in interface IExperimentDatabaseHandle

Returns:

List of all experiments conducted so far

Throws:

ExperimentDBInteractionFailedException

getExperimentsForSQLQuery

protected java.util.List<ExperimentDBEntry> getExperimentsForSQLQuery(java.lang.String sql)
                                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

createAndGetExperiment

public ExperimentDBEntry createAndGetExperiment(java.util.Map<java.lang.String,java.lang.String> values)
                                         throws ExperimentDBInteractionFailedException,
                                                ExperimentAlreadyExistsInDatabaseException

Throws:

ExperimentDBInteractionFailedException

ExperimentAlreadyExistsInDatabaseException

createAndGetExperiment

public ExperimentDBEntry createAndGetExperiment(Experiment experiment)
                                         throws ExperimentDBInteractionFailedException,
                                                ExperimentAlreadyExistsInDatabaseException

Description copied from interface: IExperimentDatabaseHandle

Creates a new experiment entry and returns it.

Specified by:

createAndGetExperiment in interface IExperimentDatabaseHandle

Returns:

The id of the created experiment

Throws:

ExperimentDBInteractionFailedException

ExperimentAlreadyExistsInDatabaseException

createAndGetExperiments

public java.util.List<ExperimentDBEntry> createAndGetExperiments(java.util.List<Experiment> experiments)
                                                          throws ExperimentDBInteractionFailedException,
                                                                 ExperimentAlreadyExistsInDatabaseException

Description copied from interface: IExperimentDatabaseHandle

Creates a new experiment entry and returns it.

Specified by:

createAndGetExperiments in interface IExperimentDatabaseHandle

Parameters:

experiments - the experiments to be created

Returns:

The id of the created experiment

Throws:

ExperimentDBInteractionFailedException

ExperimentAlreadyExistsInDatabaseException

updateExperiment

public void updateExperiment(ExperimentDBEntry exp,
                             java.util.Map<java.lang.String,? extends java.lang.Object> values)
                      throws ExperimentUpdateFailedException

Description copied from interface: IExperimentDatabaseHandle

Updates non-keyfield values of the experiment.

Specified by:

updateExperiment in interface IExperimentDatabaseHandle

Parameters:

exp - The experiment entry in the database

values - A key-value store where keys are names of result fields. The values will be associated to each key in the database.

Throws:

ExperimentUpdateFailedException

updateExperimentConditionally

public boolean updateExperimentConditionally(ExperimentDBEntry exp,
                                             java.util.Map<java.lang.String,java.lang.String> conditions,
                                             java.util.Map<java.lang.String,? extends java.lang.Object> values)
                                      throws ExperimentUpdateFailedException

Specified by:

updateExperimentConditionally in interface IExperimentDatabaseHandle

Throws:

ExperimentUpdateFailedException

finishExperiment

public void finishExperiment(ExperimentDBEntry expEntry,
                             java.lang.Throwable error)
                      throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Signals that an experiment has failed with an exception. The timestamp and the exception will be stored with the experiment.

Specified by:

finishExperiment in interface IExperimentDatabaseHandle

Throws:

ExperimentDBInteractionFailedException

finishExperiment

public void finishExperiment(ExperimentDBEntry expEntry)
                      throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Signals that an experiment has been finished successfully. A corresponding timestamp will be attached to the experiment entry.

Specified by:

finishExperiment in interface IExperimentDatabaseHandle

Throws:

ExperimentDBInteractionFailedException

getDatabaseFieldnameForConfigEntry

protected java.lang.String getDatabaseFieldnameForConfigEntry(java.lang.String configKey)

deleteExperiment

public void deleteExperiment(ExperimentDBEntry exp)
                      throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Deletes an experiment from the database

Specified by:

deleteExperiment in interface IExperimentDatabaseHandle

Throws:

ExperimentDBInteractionFailedException

deleteDatabase

public void deleteDatabase()
                    throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Deletes everything known to the experiment database. Note that database is understood as an abstract term. In a true database, this could just be a table.

Specified by:

deleteDatabase in interface IExperimentDatabaseHandle

Throws:

ExperimentDBInteractionFailedException

startExperiment

public void startExperiment(ExperimentDBEntry exp)
                     throws ExperimentUpdateFailedException,
                            ExperimentAlreadyStartedException

Description copied from interface: IExperimentDatabaseHandle

Updates non-keyfield values of the experiment.

Specified by:

startExperiment in interface IExperimentDatabaseHandle

Parameters:

exp - The experiment that is started on the current machine

Throws:

ExperimentUpdateFailedException

ExperimentAlreadyStartedException

getLoggerName

public java.lang.String getLoggerName()

Specified by:

getLoggerName in interface org.api4.java.common.control.ILoggingCustomizable

setLoggerName

public void setLoggerName(java.lang.String name)

Specified by:

setLoggerName in interface org.api4.java.common.control.ILoggingCustomizable

getExperimentWithId

public ExperimentDBEntry getExperimentWithId(int id)
                                      throws ExperimentDBInteractionFailedException

Description copied from interface: IExperimentDatabaseHandle

Gets the experiment with the given id.

Specified by:

getExperimentWithId in interface IExperimentDatabaseHandle

Returns:

Throws:

ExperimentDBInteractionFailedException