stella.sql

Class Database

java.lang.Object

util.PropertyContainer

util.PropertyResources

mysql.AbstractSql

stella.sql.Database

All Implemented Interfaces:

Cloneable, PsqlTables, ExitCleaning, Initializable, PropertySupplying, ResourceSupplying

public class Database
extends AbstractSql
implements PsqlTables

Author:

wooz

Nested Class Summary

Nested classes/interfaces inherited from class mysql.AbstractSql

AbstractSql.Columns, AbstractSql.Extract

Nested classes/interfaces inherited from class util.PropertyResources

PropertyResources.Load, PropertyResources.URLResource

Field Summary

Fields

Modifier and Type	Field and Description
private static String	DEFHOSTNAME Default user name for the table.
private static String	DEFUSERNAME Default user name for the table.
static String	KEY_HOSTNAME The key to the user name for db-acces if not default.
static String	KEY_USERNAME The key to the user name for db-acces if not default.

Fields inherited from class mysql.AbstractSql

KEY_TABLE, SQLBATCHDIR, SQLFAILDIR

Fields inherited from class util.PropertyResources

KEY_NOINITONCREATE, POSTFIX_ALPHABET, POSTFIX_BYTES, POSTFIX_DIR, POSTFIX_EXT, POSTFIX_FILE, POSTFIX_LIST, POSTFIX_MODTIME, POSTFIX_URL

Fields inherited from class util.PropertyContainer

KEY_LISTSEPARATOR, KEY_MAPKEYVALUECHAR, KEY_MAPSEPARATOR

Fields inherited from interface stella.sql.PsqlTables

DEFDONETABLE, DEFENVTABLE, DEFOBJID, DEFOBSTABLE, DEFPERMISSIONTABLE, DEFPROPOSALTABLE, DEFREDUCEDTABLE, DEFTARGETID, DEFTARGETTABLE, DEFTASKTABLE, DEFUSERTABLE, KEY_DONETABLE, KEY_ENVTABLE, KEY_OBJID, KEY_OBSTABLE, KEY_PERMISSIONTABLE, KEY_PROPOSALTABLE, KEY_REDUCEDTABLE, KEY_TARGETID, KEY_TARGETTABLE, KEY_TASKTABLE, KEY_USERTABLE

Fields inherited from interface util.ResourceSupplying

KEY_URLRESOURCES, KEY_URLUSECONFIG, KEY_URLUSECURRENT, KEY_URLUSEHOME

Fields inherited from interface util.PropertySupplying

CONFIG, KEY_CLASS

Constructor Summary

Constructors

Constructor and Description
Database(Map<String,String> prop)

Method Summary

Modifier and Type	Method and Description
protected static void	error(Exception e)
Map<String,String>	getRequestedNames(Set<String> requestkeys) In SQL, column names have to be augmented with a leading table name plus '.', if there are equally named columns in the tables queried.
static Method	getResultSetMethod(String name) Returns the method in the result set with the given name, catches exception.
String	lookUp(String unique, String uniquecolumn, String table, String lookup) Looks up a key in a database.
Map<String,List<Object>>	queryDatabase(String where, String table, Map<String,Method> request) This method is called from subclasses if they want to retrieve data from the database.
Map<String,List<Object>>	queryDatabase(String where, String table, String order, int limit, Map<String,Method> request) This method is called from subclasses if they want to retrieve data from the database.
Map<String,List<Object>>	queryDatabase(String where, String table, String order, Map<String,Method> request) This method is called from subclasses if they want to retrieve data from the database.
Map<String,Object>	querySingle(String where, String table, Map<String,Method> request) For convenience, this queries for a single result set.

Methods inherited from class mysql.AbstractSql

delete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, getTable, init, insert, isEntry, release, release, replace, retrieve, retrieve, retrieve, single, single

Methods inherited from class util.PropertyResources

clone, createFrom, createFrom, createFrom, createInstance, getApplet, getAsResources, getLocate, getPropertiesToKey, getPropertiesToKey, getResource, getResourceAsStream, getResourceFromKey, getResources, hasLocalURLs, initProperties, keyCreate, keyCreate, reload, setApplet

Methods inherited from class util.PropertyContainer

augment, augment, augment, augment, augment, defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsEnums, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, isNew, parseObject, parseObject, reload, removeProperty, requires, rescanned, setObject, setProperties, setProperty, stringProperties, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface util.PropertySupplying

defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, parseObject, removeProperty, setObject, setProperty, stringProperties

Field Detail

KEY_USERNAME

public static final String KEY_USERNAME

The key to the user name for db-acces if not default.

See Also:

Constant Field Values

KEY_HOSTNAME

public static final String KEY_HOSTNAME

The key to the user name for db-acces if not default.

See Also:

Constant Field Values

DEFUSERNAME

private static final String DEFUSERNAME

Default user name for the table.

See Also:

Constant Field Values

DEFHOSTNAME

private static final String DEFHOSTNAME

Default user name for the table.

See Also:

Constant Field Values

Constructor Detail

Database

public Database(Map<String,String> prop)

Parameters:

prop -

Method Detail

lookUp

public String lookUp(String unique,
                     String uniquecolumn,
                     String table,
                     String lookup)

Looks up a key in a database.

querySingle

public Map<String,Object> querySingle(String where,
                                      String table,
                                      Map<String,Method> request)

For convenience, this queries for a single result set. We return a mapping of keys to the single objects.

queryDatabase

public Map<String,List<Object>> queryDatabase(String where,
                                              String table,
                                              Map<String,Method> request)

This method is called from subclasses if they want to retrieve data from the database. The where clause is directly piped to the sql database. If the where is constructed out of a pick event, either target name or unique queries seam meaningful.

queryDatabase

public Map<String,List<Object>> queryDatabase(String where,
                                              String table,
                                              String order,
                                              Map<String,Method> request)

This method is called from subclasses if they want to retrieve data from the database. The where clause is directly piped to the sql database. If the where is constructed out of a pick event, either target name or unique queries seam meaningful.

queryDatabase

public Map<String,List<Object>> queryDatabase(String where,
                                              String table,
                                              String order,
                                              int limit,
                                              Map<String,Method> request)

This method is called from subclasses if they want to retrieve data from the database. The where clause is directly piped to the sql database. If the where is constructed out of a pick event, either target name or unique queries seam meaningful.

getRequestedNames

public Map<String,String> getRequestedNames(Set<String> requestkeys)

In SQL, column names have to be augmented with a leading table name plus '.', if there are equally named columns in the tables queried. But, as a painful feature, this table names are skipped from the column names in the result set, if they are unique in the result set. Just to make that clear, because it counter-acts logic:
If you have a select like (name is a cloumn in tab1 and tab2)

 SELECT from tab1,tab2 tab1.name,colonlyin2,colonlyin1 where ...
 

then your result set will have cloumns names

 name,colonlyin2,colonlyin1
 

If you have a select like

 SELECT from tab1,tab2 tab1.name,tab2.name,colonlyin2,colonlyin1
 

then your result set will contain table names, thus

 tab1.name,tab2.name,colonlyin2,colonlyin1
 

This method now stripps unneeded table names from column names.

getResultSetMethod

public static Method getResultSetMethod(String name)

Returns the method in the result set with the given name, catches exception.

error

protected static void error(Exception e)