db-compare

Simple helper to handle update / insert / delete in a SAFE mode.

Quickstart

Add maven dependency :

<dependency>
    <groupId>org.fugerit.java</groupId>
    <artifactId>db-compare</artifactId>
    <version>${db-compare-version}</version>
</dependency>	

Sample usage :

        try ( InputStream configIs = ...;
              ConnectionFactoryCloseable cf1 = ...;
              ConnectionFactoryCloseable cf2 = .. ) {
            DBCompareConfig config = this.facade.readConfig( configIs );
            String schema = "PUBLIC";
            DBCompareOutput output = this.facade.compare( config, cf1, schema, cf2, schema );
            // print include equals
            log.info( "\nDiff (include equals)" );
            DBCompareUtils.printDiff( output, true );
            // print exclude equals
            log.info( "\nDiff (exclude equals)" );
            DBCompareUtils.printDiff( output, false );
        }