de.ipcon.schema.generators

Class PostgreSQL

java.lang.Object

de.ipcon.schema.generators.AbstractSQL

de.ipcon.schema.generators.PostgreSQL

All Implemented Interfaces:

CBOGeneratorI, DatabaseConnectingCBOGeneratorI, java.io.Serializable

public class PostgreSQL
extends AbstractSQL

Core schema generator and metadata maintenance tool for PostgreSQL.

This class acts strictly as the Orchestrator/Facade pattern. All specialized logic has been extracted into highly cohesive, dedicated handler classes:

• PostgreSQLCatalogInspector - Database metadata reads (pg_class, information_schema).
• PostgreSQLExtensionManager - Management of DB extensions (hstore, pg_trgm, btree_gin).
• PostgreSQLTableMigrator - Core table and column synchronization (CREATE/ALTER).
• PostgreSQLInheritanceManager - Object-relational inheritance mapping (INHERITS).
• PostgreSQLIndexSynchronizer - Index parsing, creation, and cleanup.
• PostgreSQLRelationManager - n-m relation table management.

State is safely encapsulated in PostgreSQLMigrationContext to prevent leakage across consecutive migration runs.

Architectural JDBC Best Practices Enforced:

• Read Queries (Data Fetching): Always use isolated local statements (e.g. getConn().createStatement()) for ResultSet iterations to prevent "silent closures" by the JDBC driver.
• Write Updates (Fire & Forget): Use inherited executeSQL() / executeUpdate() which utilizes the shared defaultStatement for pure DDL operations.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static org.apache.log4j.Logger	log

Fields inherited from interface de.ipcon.schema.CBOGeneratorI

SCOPE_GLOBAL, SCOPE_LOCAL

Constructor Summary

Constructors

Constructor and Description
PostgreSQL() Constructs a new PostgreSQL schema generator instance.
PostgreSQL(electric.xml.Element e) Constructs a new PostgreSQL schema generator instance.

Method Summary

Modifier and Type	Method and Description
void	generateImpl(SchemaI schema) Executes the schema generation and migration process using the provided schema.
void	generateImpl(SchemaI schema, SchemaI newSchema) Core orchestration method for the schema migration process.
java.lang.String	getName() Returns the human-readable name of this generator.
void	handleAdditionalAttributes(electric.xml.Attribute attr) Parses generator-specific XML attributes provided during initialization.
static java.lang.String	optimizePostgresConnectionUrl(java.lang.String connUrl) Optimizes the JDBC connection URL for PostgreSQL to utilize Unix domain sockets instead of TCP sockets if executed locally on a Linux system.

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

generate, getDriver, getPass, getUrl, getUser, initDatabaseConnectionParameters, setDriver, setPass, setUrl, setUser, shutdown

Methods inherited from class java.lang.Object

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

Methods inherited from interface de.ipcon.schema.CBOGeneratorI

generate

Field Detail

log

public static final org.apache.log4j.Logger log

Constructor Detail

PostgreSQL

public PostgreSQL()

Constructs a new PostgreSQL schema generator instance.

PostgreSQL

public PostgreSQL(electric.xml.Element e)

Constructs a new PostgreSQL schema generator instance.

Parameters:

e - Optional XML Element containing initial configuration attributes.

Method Detail

optimizePostgresConnectionUrl

public static java.lang.String optimizePostgresConnectionUrl(java.lang.String connUrl)

Optimizes the JDBC connection URL for PostgreSQL to utilize Unix domain sockets instead of TCP sockets if executed locally on a Linux system.

By skipping network layer overhead, this yields significant performance optimizations for local database interaction during heavy schema migration procedures.

Parameters:

connUrl - The standard TCP JDBC URL (e.g. jdbc:postgresql://localhost:5432/db).

Returns:

The optimized URL injecting the AFUNIXSocketFactory if supported.

handleAdditionalAttributes

public void handleAdditionalAttributes(electric.xml.Attribute attr)

Parses generator-specific XML attributes provided during initialization.

Parameters:

attr - The XML attribute to process (e.g. config for index recreation).

getName

public java.lang.String getName()

Returns the human-readable name of this generator.

Specified by:

getName in interface CBOGeneratorI

Specified by:

getName in class AbstractSQL

Returns:

The constant name of the PostgreSQL metadata maintenance process.

generateImpl

public void generateImpl(SchemaI schema)

Executes the schema generation and migration process using the provided schema.

Parameters:

schema - The target schema definition to map to the database.

generateImpl

public void generateImpl(SchemaI schema,
                         SchemaI newSchema)

Core orchestration method for the schema migration process. Uses dedicated handler classes for highly cohesive, decoupled processing.

Specified by:

generateImpl in class AbstractSQL

Parameters:

schema - The target schema definition.

newSchema - An optional new schema.