de.hattrickorganizer.database
Class UserConfigurationTable

java.lang.Object
  extended by 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)