fr.ifremer.adagio.synchro.service

Class SynchroServiceUtils

Object

SynchroServiceUtils

public class SynchroServiceUtils
extends Object

Helper class to :

• Check two database schemas.

Since:

3.5.3

Author:

Benoit Lavenier

Constructor Summary

Constructors

Constructor and Description
SynchroServiceUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static void	checkSchemas(SynchroDatabaseMetadata sourceSchema, SynchroDatabaseMetadata targetSchema, boolean allowMissingOptionalColumn, boolean allowAdditionalMandatoryColumnInSourceSchema, SynchroResult result) Check that the tow given shemas are compatible for a synchronize operation (same tables with same columns).
protected static void	checkSchemasAllowMissingOptionalColumn(SynchroDatabaseMetadata sourceSchema, SynchroDatabaseMetadata targetSchema, boolean allowAdditionalMandatoryColumnInSourceSchema, SynchroResult result) Check that the tow given shemas are compatible for a synchronize operation (same tables with same columns). * This method allow missing columns (if define as nullable in the target schema) If schemas are incompatible, then a SynchroTechnicalException exception will be thrown.
protected static void	checkSchemasStrict(SynchroDatabaseMetadata sourceSchema, SynchroDatabaseMetadata targetSchema) Check that the tow given datasource shemas are compatible for a synchronize operation (same tables with same columns).

Methods inherited from class Object

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

Constructor Detail

SynchroServiceUtils

public SynchroServiceUtils()

Method Detail

checkSchemas

public static void checkSchemas(SynchroDatabaseMetadata sourceSchema,
                SynchroDatabaseMetadata targetSchema,
                boolean allowMissingOptionalColumn,
                boolean allowAdditionalMandatoryColumnInSourceSchema,
                SynchroResult result)

Check that the tow given shemas are compatible for a synchronize operation (same tables with same columns).

If allowMissingOptionalColumn=true then missing columns are allowed. Missing columns will be added to the given result.

If allowAdditionalMandatoryColumnInSourceSchema=true then additional mandatory columns in the source schema are allowed. It could be set to false for data synchronization, to avoid getting data from tables that could not be export later.

If schemas are incompatible, then a SynchroTechnicalException exception will be thrown.

Parameters:

targetSchema - schema 1 to check

sourceSchema - schema 2 to check

allowMissingOptionalColumn - Is missing optional columns are allowed (in source or target schema) ? If true, missing column will be ignore in synchronization.

allowAdditionalMandatoryColumnInSourceSchema - Is additional mandatory columns are allowed in source schema ? If true, source schema could have more mandatory columns.

result - Synchro result. Use to store missing column is any

checkSchemasAllowMissingOptionalColumn

protected static void checkSchemasAllowMissingOptionalColumn(SynchroDatabaseMetadata sourceSchema,
                                          SynchroDatabaseMetadata targetSchema,
                                          boolean allowAdditionalMandatoryColumnInSourceSchema,
                                          SynchroResult result)

Check that the tow given shemas are compatible for a synchronize operation (same tables with same columns). *

This method allow missing columns (if define as nullable in the target schema)

If schemas are incompatible, then a SynchroTechnicalException exception will be thrown.

Parameters:

synchroContext - Synchro context

targetSchema - schema 1 to check

sourceSchema - schema 2 to check

checkSchemasStrict

protected static void checkSchemasStrict(SynchroDatabaseMetadata sourceSchema,
                      SynchroDatabaseMetadata targetSchema)

Check that the tow given datasource shemas are compatible for a synchronize operation (same tables with same columns).

If schemas are incompatible, then a SynchroTechnicalException exception will be thrown.

Parameters:

schema1 - schema 1 to check

schema2 - schema 2 to check