com.goldencode.p2j.persist.orm

Class DDLGeneratorWorker

java.lang.Object

com.goldencode.p2j.pattern.AbstractPatternWorker

com.goldencode.p2j.persist.orm.DDLGeneratorWorker

All Implemented Interfaces:

PatternWorker

public final class DDLGeneratorWorker
extends AbstractPatternWorker

This worker gathers schema information from TRPL and constructs DDL statements for initializing the permanent database (tables, indexes and sequences).

The generated DDL is quite FWD-specific, the following particular-case processing are performed:

• the id unique column is injected;
• the EXTENT fields are extracted to satellite tables with specific extent size. Their records are linked using foreign key to mother table. Constraints to keep data integrity are also generated. A dedicated index is also constructed for fast access to normalized data;
• the case-insensitive character fields that are index components are processed in a dialect specific. If the dialect support expressions in index components they are inlined, otherwise a computed column is created and used in index;
• all indexes are forced to be unique by adding the id column at the end if they are not already unique. As special case, for the SQL Server, we are forced to add it to all indexes. See inline comment;
• the datetime-tz ABL fields are generated with multiple (double) column. The supplementary integer column was added to compensate a PostgreSQL issue and is added in all cases in order to have a uniform management for this datatype;

TODO: implement support for merging in data from hand-written tables (parse some xml?).

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	DDLGeneratorWorker.Helper The class that exposes its public methods as worker interface in TRPL.
private static class	DDLGeneratorWorker.Sequence Dialect-independent data structure class for SQL sequences.
private static class	DDLGeneratorWorker.Table Dialect-independent data structure class for SQL tables.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	DTZ_OFFSET The datetime-tz suffix for offset filed.
static P2JField	ID This represents the surrogate id column, added to each SQL record.
static java.lang.String	INDENT Fixed size space used to make the output pretty.
static P2JField	list__index This column represents the index of the extent value.
private static CentralLogger	LOG Logger
private static java.util.List<java.lang.String>	MY_CONNECTION_AUX Auxiliary database objects for _MyConnection VST
static P2JField	PARENT 'parent' field of the word table
static P2JField	parent__id This column is used as foreign key in a normalized composite table.
private static java.lang.String	PK Name of the primary key column.
static P2JField	WORD 'word' field of the word table

Constructor Summary

Constructors

Constructor and Description
DDLGeneratorWorker() The constructor configures the supporting library with exported functionality.

Method Summary

Modifier and Type	Method and Description
private java.lang.String	getSchemaName(java.lang.String dbName) Get the schema name based on database name.

Methods inherited from class com.goldencode.p2j.pattern.AbstractPatternWorker

getCopy, getLibrary, getResolver, getSource, isConditionalRuleSets, isFlagActivated, isRuntimeQueryMode, registerTree, resolveConstant, setLibrary

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.goldencode.p2j.pattern.PatternWorker

finish, initialize, leaveAst, visitAst

Field Detail

LOG

private static final CentralLogger LOG

Logger

PK

private static final java.lang.String PK

Name of the primary key column.

MY_CONNECTION_AUX

private static final java.util.List<java.lang.String> MY_CONNECTION_AUX

Auxiliary database objects for _MyConnection VST

ID

public static final P2JField ID

This represents the surrogate id column, added to each SQL record.

PARENT

public static final P2JField PARENT

'parent' field of the word table

WORD

public static final P2JField WORD

'word' field of the word table

parent__id

public static final P2JField parent__id

This column is used as foreign key in a normalized composite table. The value refer to the record to which the extent components belongs to.

list__index

public static final P2JField list__index

This column represents the index of the extent value.

DTZ_OFFSET

public static final java.lang.String DTZ_OFFSET

The datetime-tz suffix for offset filed. This second field is used to compensate the fact that PostgreSQL SQL engine will drop this piece of information (the zone offset) to simplify the stored data. Although the time and date arithmetic is correct (due the timestamp is converted to GMT internally), we are unable to retrieve back the offset

See Also:

Constant Field Values

INDENT

public static final java.lang.String INDENT

Fixed size space used to make the output pretty.

See Also:

Constant Field Values

Constructor Detail

DDLGeneratorWorker

public DDLGeneratorWorker()

The constructor configures the supporting library with exported functionality.

Method Detail

getSchemaName

private java.lang.String getSchemaName(java.lang.String dbName)

Get the schema name based on database name.

Parameters:

dbName - The database name.

Returns:

The schema name.