de.ipcon.schema.generators

Class PostgreSQLRelationManager

java.lang.Object

de.ipcon.schema.generators.PostgreSQLRelationManager

public class PostgreSQLRelationManager
extends java.lang.Object

Handler for synchronizing n-m (Many-to-Many) relation tables between entities.

This manager ensures that cross-reference (link) tables are created correctly for any relation defined as SchemaI.RELATION_TYPE_N_M. It is responsible for:

• Creating missing n-m tables with exact int8 foreign key columns.
• Ensuring the structural integrity of existing link tables.
• Enforcing and repairing necessary indices (individual column indices and a combined unique index) to prevent duplicate relations at the database level.
• Identifying and logging obsolete (orphaned) link tables for administrator cleanup.

Incorporates early-exit optimization strategies to bypass heavy JDBC catalog checks when the relational structure is already pristine.

Constructor Summary

Constructors

Constructor and Description
PostgreSQLRelationManager(PostgreSQL pg, PostgreSQLMigrationContext ctx, PostgreSQLCatalogInspector inspector, PostgreSQLIndexSynchronizer idxSync)

Method Summary

Modifier and Type	Method and Description
void	generateRelationTables(SchemaI schema, boolean nonDestructive) Synchronizes n-m (many-to-many) relation tables.
void	logObsoleteN2MTables(SchemaI schema) Identifies and logs n-m tables that physically exist in the database but are no longer defined in the current application schema.

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLRelationManager

public PostgreSQLRelationManager(PostgreSQL pg,
                                 PostgreSQLMigrationContext ctx,
                                 PostgreSQLCatalogInspector inspector,
                                 PostgreSQLIndexSynchronizer idxSync)

Method Detail

generateRelationTables

public void generateRelationTables(SchemaI schema,
                                   boolean nonDestructive)

Synchronizes n-m (many-to-many) relation tables. Verifies existence, validates column structure, enforces unique combined constraints, and creates the link tables if they are missing.

Parameters:

schema - The active schema definition.

nonDestructive - If true, prevents dropping obsolete relation tables.

logObsoleteN2MTables

public void logObsoleteN2MTables(SchemaI schema)

Identifies and logs n-m tables that physically exist in the database but are no longer defined in the current application schema. Prompts the administrator to generate a cleanup script to avoid database bloat.

Parameters:

schema - The current in-memory schema definition.