de.hattrickorganizer.database
Class UserConfigurationTable

java.lang.Object
  de.hattrickorganizer.database.UserConfigurationTable

public final class UserConfigurationTable
extends java.lang.Object

The Table UserConfiguration contain all User properties. CONFIG_KEY = Primary Key, fieldname of the class CONFIG_VALUE = value of the field, save as VARCHAR. Convert to right datatype if loaded

Since:

1.36

Author:

Thorsten Dietz

Field Summary

protected JDBCAdapter	adapter Database connection
protected de.hattrickorganizer.database.ColumnDescriptor[]	columns describes a tableColumn (name, datatype, nullable ..)
static java.lang.String	TABLENAME tablename

Constructor Summary

protected

UserConfigurationTable(JDBCAdapter adapter)

Method Summary

void	createTable()
protected int	delete(java.lang.String[] whereColumns, java.lang.String[] whereValues)
protected void	dropTable() Drop the current table
protected de.hattrickorganizer.database.ColumnDescriptor[]	getColumns()
protected java.lang.String[]	getCreateIndizeStatements()
int	getDBVersion()
double	getLastConfUpdate() Get the last HO release where we have completed successfully a config update
protected java.sql.ResultSet	getSelectByHrfID(int hrfID) TODO Missing Method Documentation
protected java.lang.String	getTableName()
protected java.lang.String	getTableType()
protected void	initColumns()
void	load(IUserConfiguration obj)
protected void	setColumns(de.hattrickorganizer.database.ColumnDescriptor[] columns)
void	store(IUserConfiguration obj) update/ insert method
protected void	truncateTable() Truncate the current table (i.e.
void	update(java.lang.String key, java.lang.String value) Update a key in the user configuration if the key does not exist yet, insert it

Methods inherited from class java.lang.Object

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

Field Detail

TABLENAME

public static final java.lang.String TABLENAME

tablename

See Also:

Constant Field Values

columns

protected de.hattrickorganizer.database.ColumnDescriptor[] columns

describes a tableColumn (name, datatype, nullable ..)

adapter

protected JDBCAdapter adapter

Database connection

Constructor Detail

UserConfigurationTable

protected UserConfigurationTable(JDBCAdapter adapter)

Method Detail

initColumns

protected void initColumns()

update

public void update(java.lang.String key,
                   java.lang.String value)

Update a key in the user configuration if the key does not exist yet, insert it

Parameters:

key -

value -

getDBVersion

public int getDBVersion()

getLastConfUpdate

public double getLastConfUpdate()

Get the last HO release where we have completed successfully a config update

Returns:

the ho version of the last conf update

store

public void store(IUserConfiguration obj)

update/ insert method

Parameters:

obj -

load

public void load(IUserConfiguration obj)

Parameters:

obj -

getTableType

protected java.lang.String getTableType()

getTableName

protected java.lang.String getTableName()

setColumns

protected void setColumns(de.hattrickorganizer.database.ColumnDescriptor[] columns)

getColumns

protected de.hattrickorganizer.database.ColumnDescriptor[] getColumns()

getCreateIndizeStatements

protected java.lang.String[] getCreateIndizeStatements()

delete

protected int delete(java.lang.String[] whereColumns,
                     java.lang.String[] whereValues)

createTable

public void createTable()

getSelectByHrfID

protected java.sql.ResultSet getSelectByHrfID(int hrfID)

TODO Missing Method Documentation

Parameters:

tableName - TODO Missing Method Parameter Documentation

hrfID - TODO Missing Method Parameter Documentation

Returns:

TODO Missing Return Method Documentation

dropTable

protected void dropTable()

Drop the current table

truncateTable

protected void truncateTable()

Truncate the current table (i.e. remove all rows)