Package org.pgcodekeeper.core

Class PgDiff

java.lang.Object

org.pgcodekeeper.core.PgDiff

public class PgDiff
extends Object

Main class for generating SQL scripts that transform one database schema to another.

This class compares two database schemas (old and new) and generates the SQL statements needed to migrate from the old schema to the new one.

Author:

fordfrog

Constructor Summary

Constructors

Constructor	Description
PgDiff(ISettings settings)	Creates a new PgDiff instance with the specified settings.

Method Summary

Modifier and Type	Method	Description
String	diff(TreeElement root, AbstractDatabase oldDb, AbstractDatabase newDb, List<Map.Entry<PgStatement,PgStatement>> additionalDepciesOldDb, List<Map.Entry<PgStatement,PgStatement>> additionalDepciesNewDb, IgnoreList ignoreList)	Gets selected elements from root, compares them between source and target and generates a migration script.
String	diff(AbstractDatabase oldDb, AbstractDatabase newDb, IgnoreList ignoreList)	Selects all objects for diff, compares them between source and target and generates a migration script.
List<Object>	getErrors()

Methods inherited from class java.lang.Object

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

Constructor Details

PgDiff

public PgDiff(ISettings settings)

Creates a new PgDiff instance with the specified settings.

Parameters:

settings - the configuration settings for the diff operation

Method Details

getErrors

public List<Object> getErrors()

diff

public String diff(AbstractDatabase oldDb,
 AbstractDatabase newDb,
 IgnoreList ignoreList)
            throws InterruptedException,
IOException

Selects all objects for diff, compares them between source and target and generates a migration script.

Parameters:

oldDb - the source database schema

newDb - the target database schema

ignoreList - list of objects to ignore during comparison

Returns:

SQL migration script

Throws:

InterruptedException - if the operation is interrupted

IOException - if an I/O error occurs

diff

public String diff(TreeElement root,
 AbstractDatabase oldDb,
 AbstractDatabase newDb,
 List<Map.Entry<PgStatement,PgStatement>> additionalDepciesOldDb,
 List<Map.Entry<PgStatement,PgStatement>> additionalDepciesNewDb,
 IgnoreList ignoreList)
            throws IOException

Gets selected elements from root, compares them between source and target and generates a migration script.

Parameters:

root - the root of the diff tree

oldDb - the source database schema

newDb - the target database schema

additionalDepciesOldDb - additional dependencies in old database

additionalDepciesNewDb - additional dependencies in new database

ignoreList - list of objects to ignore during comparison

Returns:

SQL migration script

Throws:

IOException - if an I/O error occurs