com.goldencode.p2j.persist

Class DirtyTempTableHelper

java.lang.Object

com.goldencode.p2j.persist.TempTableHelper

com.goldencode.p2j.persist.DirtyTempTableHelper

public final class DirtyTempTableHelper
extends TempTableHelper

Helper class which generates and caches SQL phrases to create and drop temporary tables, and to create indexes in those tables.

This class is responsible for global temporary tables support: the created tables and indices will be global and available to all sessions.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.util.Map<Database,java.util.Map<java.lang.String,java.util.ArrayList<P2JIndex>>>	indexCache Cache with the indexes retrieved from the database, for each table and database.
private static CentralLogger	LOG Logger

Fields inherited from class com.goldencode.p2j.persist.TempTableHelper

database, schema, UNIQUE_SUFFIX_KEY

Constructor Summary

Constructors

Constructor and Description
DirtyTempTableHelper(java.lang.Class<? extends DataModelObject> dmoIface, Database database) Constructor.

Method Summary

Modifier and Type	Method and Description
(package private) java.lang.String	getAdditionalIndexSuffix() This method returns an empty string: the indexes must be global.
(package private) java.lang.String	getCreateTableStatement() This method will return the needed create table string, which is the "create temporary table" string.
(package private) java.util.Iterator<P2JIndex>	getIndexes(java.lang.String schema, java.lang.Class<? extends DataModelObject> dmoIface) This method will return the indexes associated with a certain DMO, as found in the associated database.
(package private) boolean	isNotNullAllowed() Indicate whether non-nullable columns are permitted.

Methods inherited from class com.goldencode.p2j.persist.TempTableHelper

get, getImplicitIndexName, getImplicitSqlIndexName, getTableName, sqlTempTableCreate, sqlTempTableDrop, sqlTempTableIndexCreate, sqlTempTableIndexDrop

Methods inherited from class java.lang.Object

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

Field Detail

LOG

private static final CentralLogger LOG

Logger

indexCache

private static final java.util.Map<Database,java.util.Map<java.lang.String,java.util.ArrayList<P2JIndex>>> indexCache

Cache with the indexes retrieved from the database, for each table and database.

Constructor Detail

DirtyTempTableHelper

DirtyTempTableHelper(java.lang.Class<? extends DataModelObject> dmoIface,
                     Database database)

Constructor.

Parameters:

dmoIface - DMO interface which provides the public API to the temp table.

database - The database for which we generate the sql's.

Method Detail

getCreateTableStatement

java.lang.String getCreateTableStatement()

This method will return the needed create table string, which is the "create temporary table" string.

Specified by:

getCreateTableStatement in class TempTableHelper

Returns:

The create table string.

getAdditionalIndexSuffix

java.lang.String getAdditionalIndexSuffix()

This method returns an empty string: the indexes must be global.

Specified by:

getAdditionalIndexSuffix in class TempTableHelper

Returns:

An empty string.

getIndexes

java.util.Iterator<P2JIndex> getIndexes(java.lang.String schema,
                                        java.lang.Class<? extends DataModelObject> dmoIface)

This method will return the indexes associated with a certain DMO, as found in the associated database. It must be noted that those indexes will not contain any foreign-key columns (columns with their name ending with a "__fk" suffix); those columns are removed from the index metadata and if an index contains only a such column, that index will not be returned. Furthermore, all indexes will be set to be non-unique, since newly created DMOs can be added from multiple sessions, and the default values of unique properties could conflict.

Once retrieved, the indexes will be kept in a cache, for each table, by database.

Specified by:

getIndexes in class TempTableHelper

Parameters:

schema - The schema used for this DMO.

dmoIface - The DMO for which to retrieve the indexes.

Returns:

An iterator for the indexes associated with this DMO.

Throws:

java.lang.RuntimeException - if there is any error retrieving the index metadata for the given schema and DMO.

isNotNullAllowed

boolean isNotNullAllowed()

Indicate whether non-nullable columns are permitted.

Specified by:

isNotNullAllowed in class TempTableHelper

Returns:

true if non-nullable columns are permitted, else false.