de.ipcon.schema.generators

Class PostgreSQLColumn

java.lang.Object

de.ipcon.schema.generators.SQLColumn

de.ipcon.schema.generators.PostgreSQLColumn

All Implemented Interfaces:

SQLColumnI

public class PostgreSQLColumn
extends SQLColumn

PostgreSQL-specific implementation of a database column definition.

Handles PostgreSQL dialects, enforces timezone-aware timestamps, and tracks the previous state (predecessor) of a column during complex ALTER TABLE migration scenarios.

Constructor Summary

Constructors

Constructor and Description
PostgreSQLColumn(java.lang.String name, CBOAttributeI attr) Constructs a new PostgreSQL column definition.
PostgreSQLColumn(java.lang.String name, java.lang.String colType) Constructs a new PostgreSQL column definition with an explicitly forced SQL type.
PostgreSQLColumn(java.lang.String name, java.lang.String colType, CBOAttributeI attr)
PostgreSQLColumn(java.lang.String name, java.lang.String colTypeName, int colType, int colSize) Constructs a new PostgreSQL column directly from JDBC metadata.

Method Summary

Modifier and Type	Method and Description
SQLColumn	getPredecessor()
boolean	isEmpty(java.sql.Statement statement, java.lang.String tableName) Determines if the actual physical database column currently contains no data.
java.lang.String	normalizeColumnType(java.lang.String typeName, int columnType, int columnWidth) Normalizes raw database types into standard schema types, applying PostgreSQL specifics.
void	setPredecessor(SQLColumn $2)

Methods inherited from class de.ipcon.schema.generators.SQLColumn

equals, getAttribute, getColtype, getCreateStatement, getName, setAttribute, setColtype, setName, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLColumn

public PostgreSQLColumn(java.lang.String name,
                        CBOAttributeI attr)

Constructs a new PostgreSQL column definition. Automatically lowercases and trims the name.

Parameters:

name - The logical column name.

attr - The underlying schema attribute definition.

PostgreSQLColumn

public PostgreSQLColumn(java.lang.String name,
                        java.lang.String colType)

Constructs a new PostgreSQL column definition with an explicitly forced SQL type.

Parameters:

name - The logical column name.

colType - The explicit PostgreSQL type string (e.g. 'hstore').

attr - The underlying schema attribute definition (can be null).

PostgreSQLColumn

public PostgreSQLColumn(java.lang.String name,
                        java.lang.String colType,
                        CBOAttributeI attr)

PostgreSQLColumn

public PostgreSQLColumn(java.lang.String name,
                        java.lang.String colTypeName,
                        int colType,
                        int colSize)

Constructs a new PostgreSQL column directly from JDBC metadata.

Method Detail

normalizeColumnType

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

Normalizes raw database types into standard schema types, applying PostgreSQL specifics.

Dialect Enforcement: Forces all timestamps to timestamptz to ensure timezone correctness natively within the database engine.

Specified by:

normalizeColumnType in interface SQLColumnI

Overrides:

normalizeColumnType in class SQLColumn

Parameters:

typeName - The raw PostgreSQL type name.

columnType - The java.sql.Types integer representation.

columnWidth - The column width.

Returns:

The normalized data type string.

isEmpty

public boolean isEmpty(java.sql.Statement statement,
                       java.lang.String tableName)

Determines if the actual physical database column currently contains no data.

This is highly optimized by executing a SELECT ... LIMIT 1 query. It is utilized during schema migration to decide whether a complex data type conversion is necessary, or if the column can simply be dropped and cleanly recreated.

Security: Table and column names are safely quoted via PostgreSQLDDLBuilder.

Parameters:

statement - The JDBC statement used to execute the check.

tableName - The name of the table containing the column.

Returns:

true if the column contains strictly NULL values (or the table is empty), false otherwise.

Throws:

java.lang.IllegalStateException - if a database error prevents the emptiness check.

getPredecessor

public SQLColumn getPredecessor()

setPredecessor

public void setPredecessor(SQLColumn $2)