com.im.df.impl.db.api
Class DBImplConstants

java.lang.Object
  com.im.df.impl.db.api.DBImplConstants

public class DBImplConstants
extends Object

The default DIF implementation constants. Most of them are used as implementation type constants (see DFItem.getType()).

Field Summary

static String	DATA_TREE_STANDARD Default DB implementation of datatree type constant (see DFItem.getType()).
static String	ENTITY_TYPE_JCHEMBASE Default DB implementation of jchem entity type constant (see DFItem.getType()).
static String	ENTITY_TYPE_JCHEMCART_JCHEMBASE Default DB implementation of jchem cartridge based on a JChemBase table entity type constant (see DFItem.getType()).
static String	ENTITY_TYPE_JCHEMCART_STANDARD Default DB implementation of jchem cartridge based on a standard table entity type constant (see DFItem.getType()).
static String	ENTITY_TYPE_STANDARD Default DB implementation of standard entity type constant (see DFItem.getType()).
static String	FIELD_CHEMICAL_TERMS_BOOLEAN Default DB implementation of boolean chemical terms field type constant (see DFItem.getType()).
static String	FIELD_CHEMICAL_TERMS_FLOAT Default DB implementation of float chemical terms field type constant (see DFItem.getType()).
static String	FIELD_CHEMICAL_TERMS_INTEGER Default DB implementation of integer chemical terms field type constant (see DFItem.getType()).
static String	FIELD_CHEMICAL_TERMS_TEXT Default DB implementation of text chemical terms field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_BINARY Default DB implementation of standard BINARY field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_BOOLEAN Default DB implementation of standard boolean field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_CALCULATED_BOOLEAN
static String	FIELD_STANDARD_CALCULATED_FLOAT
static String	FIELD_STANDARD_CALCULATED_INTEGER
static String	FIELD_STANDARD_CALCULATED_TEXT
static String	FIELD_STANDARD_DATE Default DB implementation of standard date field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_FLOAT Default DB implementation of standard float field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_INTEGER Default DB implementation of standard integer field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_JCHEM_STRUCTURE Default DB implementation of standard molecule field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_TEXT Default DB implementation of standard text field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_TEXT_ARRAY Default DB implementation of standard text field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_URL Default DB implementation of standard URL field type constant (see DFItem.getType()).
static String	FIELD_STANDARD_URL_DYN Default DB implementation of standard dynamic URL field type constant (see DFItem.getType()).
static String	FORM_VIEW_STANDARD Default DB implementation of form designer view type constant (see DFItem.getType()).
static String	GRID_VIEW_STANDARD Default DB implementation of grid view type constant (see DFItem.getType()).
static String	LIST_STANDARD Default DB implementation of list type constant (see DFItem.getType()).
static String	QUERY_STANDARD Default DB implementation of query type constant (see DFItem.getType()).
static String	RELATIONSHIP_TYPE_DB Default DB implementation of relationship type constant (see DFItem.getType()).
static String	SCHEMA_TYPE_DB Default DB implementation of DFSchema type constant (see DFItem.getType()).
static String	SCRIPT_STANDARD Default DB implementation of query type constant (see DFItem.getType()).
static String	UNKNOWN_TYPE Special case constant.
static String	WRAPPER

Constructor Summary

DBImplConstants()

Method Summary

static String	determineBestColumnDefinition(DBType dbType, String fieldType, int length) Utility method to determine the best column type to use.
static String	getFieldTypeDisplayName(String fieldType) Get display name for the specific type constant.

Methods inherited from class java.lang.Object

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

Field Detail

UNKNOWN_TYPE

public static final String UNKNOWN_TYPE

Special case constant. Can be used e.g. in newtype when the type of create object is not yet determined.

See Also:

Constant Field Values

SCHEMA_TYPE_DB

public static final String SCHEMA_TYPE_DB

Default DB implementation of DFSchema type constant (see DFItem.getType()).

See Also:

Constant Field Values

WRAPPER

public static final String WRAPPER

See Also:

Constant Field Values

ENTITY_TYPE_STANDARD

public static final String ENTITY_TYPE_STANDARD

Default DB implementation of standard entity type constant (see DFItem.getType()).

See Also:

Constant Field Values

ENTITY_TYPE_JCHEMBASE

public static final String ENTITY_TYPE_JCHEMBASE

Default DB implementation of jchem entity type constant (see DFItem.getType()).

See Also:

Constant Field Values

ENTITY_TYPE_JCHEMCART_JCHEMBASE

public static final String ENTITY_TYPE_JCHEMCART_JCHEMBASE

Default DB implementation of jchem cartridge based on a JChemBase table entity type constant (see DFItem.getType()).

See Also:

Constant Field Values

ENTITY_TYPE_JCHEMCART_STANDARD

public static final String ENTITY_TYPE_JCHEMCART_STANDARD

Default DB implementation of jchem cartridge based on a standard table entity type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_INTEGER

public static final String FIELD_STANDARD_INTEGER

Default DB implementation of standard integer field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_TEXT

public static final String FIELD_STANDARD_TEXT

Default DB implementation of standard text field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_FLOAT

public static final String FIELD_STANDARD_FLOAT

Default DB implementation of standard float field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_BOOLEAN

public static final String FIELD_STANDARD_BOOLEAN

Default DB implementation of standard boolean field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_DATE

public static final String FIELD_STANDARD_DATE

Default DB implementation of standard date field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_BINARY

public static final String FIELD_STANDARD_BINARY

Default DB implementation of standard BINARY field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_URL

public static final String FIELD_STANDARD_URL

Default DB implementation of standard URL field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_URL_DYN

public static final String FIELD_STANDARD_URL_DYN

Default DB implementation of standard dynamic URL field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_CALCULATED_INTEGER

public static final String FIELD_STANDARD_CALCULATED_INTEGER

See Also:

Constant Field Values

FIELD_STANDARD_CALCULATED_FLOAT

public static final String FIELD_STANDARD_CALCULATED_FLOAT

See Also:

Constant Field Values

FIELD_STANDARD_CALCULATED_TEXT

public static final String FIELD_STANDARD_CALCULATED_TEXT

See Also:

Constant Field Values

FIELD_STANDARD_CALCULATED_BOOLEAN

public static final String FIELD_STANDARD_CALCULATED_BOOLEAN

See Also:

Constant Field Values

FIELD_STANDARD_JCHEM_STRUCTURE

public static final String FIELD_STANDARD_JCHEM_STRUCTURE

Default DB implementation of standard molecule field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_STANDARD_TEXT_ARRAY

public static final String FIELD_STANDARD_TEXT_ARRAY

Default DB implementation of standard text field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_CHEMICAL_TERMS_INTEGER

public static final String FIELD_CHEMICAL_TERMS_INTEGER

Default DB implementation of integer chemical terms field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_CHEMICAL_TERMS_TEXT

public static final String FIELD_CHEMICAL_TERMS_TEXT

Default DB implementation of text chemical terms field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_CHEMICAL_TERMS_FLOAT

public static final String FIELD_CHEMICAL_TERMS_FLOAT

Default DB implementation of float chemical terms field type constant (see DFItem.getType()).

See Also:

Constant Field Values

FIELD_CHEMICAL_TERMS_BOOLEAN

public static final String FIELD_CHEMICAL_TERMS_BOOLEAN

Default DB implementation of boolean chemical terms field type constant (see DFItem.getType()).

See Also:

Constant Field Values

RELATIONSHIP_TYPE_DB

public static final String RELATIONSHIP_TYPE_DB

Default DB implementation of relationship type constant (see DFItem.getType()).

See Also:

Constant Field Values

DATA_TREE_STANDARD

public static final String DATA_TREE_STANDARD

Default DB implementation of datatree type constant (see DFItem.getType()).

See Also:

Constant Field Values

GRID_VIEW_STANDARD

public static final String GRID_VIEW_STANDARD

Default DB implementation of grid view type constant (see DFItem.getType()).

See Also:

Constant Field Values

FORM_VIEW_STANDARD

public static final String FORM_VIEW_STANDARD

Default DB implementation of form designer view type constant (see DFItem.getType()).

See Also:

Constant Field Values

LIST_STANDARD

public static final String LIST_STANDARD

Default DB implementation of list type constant (see DFItem.getType()).

See Also:

Constant Field Values

QUERY_STANDARD

public static final String QUERY_STANDARD

Default DB implementation of query type constant (see DFItem.getType()).

See Also:

Constant Field Values

SCRIPT_STANDARD

public static final String SCRIPT_STANDARD

Default DB implementation of query type constant (see DFItem.getType()).

See Also:

Constant Field Values

Constructor Detail

DBImplConstants

public DBImplConstants()

Method Detail

getFieldTypeDisplayName

public static String getFieldTypeDisplayName(String fieldType)

Get display name for the specific type constant. It can return null if the type is not found.

TODO P4 - if necessary this method can be extended (and renamed) to return display names for other types too (schema, entities,...)

determineBestColumnDefinition

public static String determineBestColumnDefinition(DBType dbType,
                                                   String fieldType,
                                                   int length)

Utility method to determine the best column type to use. This is needed because this information is not available from the API. This needs to be improved.

Parameters:

dbType - The type of the database. One of derby, oracle or mysql

fieldType - The field type

length - The desired length of the value e.g. for a text column

Returns:

The column definition e.g. VARCHAR2(1000)