Package org.pgcodekeeper.core.model.graph

Class InsertWriter

java.lang.Object

org.pgcodekeeper.core.model.graph.InsertWriter

public final class InsertWriter
extends Object

Database insert script generator for data migration. Generates INSERT statements with dependency resolution, handling foreign key constraints, cycles, and database-specific data types for PostgreSQL and Microsoft SQL databases.

Method Summary

Modifier and Type	Method	Description
static String	write(AbstractDatabase db, ISettings settings, String name, String filter, String source)	Method for call from external classes to start the process of get all data which will be need to transfer and create insert script.

Methods inherited from class java.lang.Object

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

Method Details

write

public static String write(AbstractDatabase db,
 ISettings settings,
 String name,
 String filter,
 String source)
                    throws InterruptedException,
IOException,
SQLException

Method for call from external classes to start the process of get all data which will be need to transfer and create insert script.

Parameters:

db - - source-database schema

settings - - ISettings

name - - qualified table name which data need to transfer

filter - - condition of WHERE for query select

Throws:

InterruptedException - if operation is interrupted

IOException - if I/O error occurs

SQLException - if database error occurs