de.ipcon.schema.generators

Class SQLColumn

java.lang.Object

de.ipcon.schema.generators.SQLColumn

All Implemented Interfaces:

SQLColumnI

Direct Known Subclasses:

PostgreSQLColumn

public class SQLColumn
extends java.lang.Object
implements SQLColumnI

Base implementation of a database column definition for schema generation.

This class holds the logical name, the normalized SQL data type, and the underlying schema attribute of a column. It acts as the primary data structure for comparing the in-memory MyTISM schema with the physical database schema.

Security Contract:
The generation of the SQL fragment via getCreateStatement() strictly utilizes the PostgreSQLDDLBuilder to guarantee safe quoting of the column identifier, preventing SQL syntax errors and injection vulnerabilities.

Constructor Summary

Constructors

Constructor and Description
SQLColumn(java.lang.String _name, CBOAttributeI _attr) Constructs a new column definition based on a schema attribute.
SQLColumn(java.lang.String _name, java.lang.String _colType, CBOAttributeI _attr) Constructs a new column definition with a specific raw SQL type.
SQLColumn(java.lang.String _name, java.lang.String _colTypeName, int _colType, int _colSize) Constructs a new column directly from JDBC metadata.

Method Summary

Modifier and Type	Method and Description
boolean	equals(SQLColumnI o) Checks if this column definition matches another column definition.
CBOAttributeI	getAttribute()
java.lang.String	getColtype()
java.lang.String	getCreateStatement() Generates the SQL statement fragment needed to create this column.
java.lang.String	getName()
java.lang.String	normalizeColumnType(java.lang.String typeName, int columnType, int columnWidth) Normalizes raw database type names into standard MyTISM schema types.
void	setAttribute(CBOAttributeI $3)
void	setColtype(java.lang.String $2)
void	setName(java.lang.String $1)
java.lang.String	toString() Returns the string representation of this column (its DDL creation fragment).

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLColumn

public SQLColumn(java.lang.String _name,
                 CBOAttributeI _attr)

Constructs a new column definition based on a schema attribute. Automatically resolves relation types to 'int8' (foreign keys).

Parameters:

_name - The logical name of the column.

_attr - The corresponding CBOAttribute definition.

SQLColumn

public SQLColumn(java.lang.String _name,
                 java.lang.String _colType,
                 CBOAttributeI _attr)

Constructs a new column definition with a specific raw SQL type.

Parameters:

_name - The logical name of the column.

_colType - The raw SQL type string (e.g. "varchar(255)").

_attr - The corresponding CBOAttributeI definition.

SQLColumn

public SQLColumn(java.lang.String _name,
                 java.lang.String _colTypeName,
                 int _colType,
                 int _colSize)

Constructs a new column directly from JDBC metadata.

Parameters:

_name - The column name.

_colTypeName - The type name from JDBC metadata.

_colType - The java.sql.Types integer representation.

_colSize - The size/width of the column.

Method Detail

normalizeColumnType

public java.lang.String normalizeColumnType(java.lang.String typeName,
                                            int columnType,
                                            int columnWidth)

Normalizes raw database type names into standard MyTISM schema types. Unifies variations like 'datetime' and 'timestamp' into a single standard.

Specified by:

normalizeColumnType in interface SQLColumnI

Parameters:

typeName - The raw type name from the database.

columnType - The java.sql.Types integer representation.

columnWidth - The column width/size.

Returns:

The normalized data type string.

Throws:

java.lang.IllegalArgumentException - if an unknown database type is encountered.

getCreateStatement

public java.lang.String getCreateStatement()

Generates the SQL statement fragment needed to create this column.

Safely escapes the identifier using PostgreSQLDDLBuilder.quote().

Specified by:

getCreateStatement in interface SQLColumnI

Returns:

The SQL fragment (e.g. "my_column" varchar(255)).

equals

public boolean equals(SQLColumnI o)

Checks if this column definition matches another column definition. Crucial for detecting schema deviations during startup.

Specified by:

equals in interface SQLColumnI

Parameters:

o - The other column definition.

Returns:

true if both name and normalized column type are equal.

toString

public java.lang.String toString()

Returns the string representation of this column (its DDL creation fragment).

Overrides:

toString in class java.lang.Object

getName

public java.lang.String getName()

Specified by:

getName in interface SQLColumnI

Returns:

The logical name of the column.

setName

public void setName(java.lang.String $1)

getColtype

public java.lang.String getColtype()

Specified by:

getColtype in interface SQLColumnI

Returns:

The fully normalized SQL data type of the column (e.g. "varchar(255)").

setColtype

public void setColtype(java.lang.String $2)

getAttribute

public CBOAttributeI getAttribute()

Specified by:

getAttribute in interface SQLColumnI

Returns:

The underlying schema attribute definition.

setAttribute

public void setAttribute(CBOAttributeI $3)