ca.sqlpower.architect.etl.datamover
Class DataMover

java.lang.Object
  ca.sqlpower.architect.etl.datamover.DataMover

public class DataMover
extends java.lang.Object

Constructor Summary

DataMover()

Method Summary

int	copyTable(SQLTable destTable, SQLTable sourceTable) Copies all the data in the source table (in the source database) to the table the the given name in the destination database.
void	copyTables(SQLObject destTableContainer, java.util.Collection<SQLTable> sourceTables) Copies all the tables in the sourceTables collection which also exist in the destTableContainer.
java.lang.String	getBlobTextEncoding()
java.lang.String	getLastSqlString()
boolean	isTruncatingDestinationTable()
static void	main(java.lang.String[] args)
void	setBlobTextEncoding(java.lang.String blobTextEncoding)
void	setTruncatingDestinationTable(boolean truncatingDestinationTable)

Methods inherited from class java.lang.Object

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

Constructor Detail

DataMover

public DataMover()

Method Detail

copyTable

public int copyTable(SQLTable destTable,
                     SQLTable sourceTable)
              throws java.sql.SQLException,
                     ArchitectException,
                     java.io.UnsupportedEncodingException

Copies all the data in the source table (in the source database) to the table the the given name in the destination database.

Throws:

ArchitectException

java.io.UnsupportedEncodingException - if there is a blob-to-text mapping and the current setting of blobTextEncoding is not recognised by the java library.

java.sql.SQLException

copyTables

public void copyTables(SQLObject destTableContainer,
                       java.util.Collection<SQLTable> sourceTables)
                throws ArchitectException,
                       java.sql.SQLException,
                       java.io.UnsupportedEncodingException

Copies all the tables in the sourceTables collection which also exist in the destTableContainer. This is done in a safe order based on the foreign key constraints that exist in the destination database.

Parameters:

destTableContainer - The SQLDatabase, SQLSchema, or SQLCatalog that directly contains the destination tables.

sourceTables - The list of tables to copy (the order is unimportant)

Throws:

java.sql.SQLException

java.io.UnsupportedEncodingException

ArchitectException

getBlobTextEncoding

public java.lang.String getBlobTextEncoding()

setBlobTextEncoding

public void setBlobTextEncoding(java.lang.String blobTextEncoding)

isTruncatingDestinationTable

public boolean isTruncatingDestinationTable()

setTruncatingDestinationTable

public void setTruncatingDestinationTable(boolean truncatingDestinationTable)

getLastSqlString

public java.lang.String getLastSqlString()

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Parameters:

args -

Throws:

java.lang.Exception