| java.lang.Object workbench.db.datacopy.DataCopier
Method Summary | |
public void | beginMultiTableCopy() | public void | cancel() | public void | commitNothing() | public void | copyFromQuery(WbConnection source, WbConnection target, String aSourceQuery, TableIdentifier aTargetTable, ColumnIdentifier[] queryColumns, boolean createTarget, boolean dropTarget) Copy data from a SQL SELECT result to the given target table. | public void | copyFromTable(WbConnection source, WbConnection target, TableIdentifier aSourceTable, TableIdentifier aTargetTable, Map<String, String> columnMapping, String additionalWhere, boolean createTable, boolean dropTable) Define the source table, the target table and the column mapping
for the copy process.
If the columnMapping is null, the matching columns from both tables are used.
It is expected that the mapping contains String objects. | public void | endMultiTableCopy() | public long | getAffectedRows() | public CharSequence | getAllMessages() | public String | getErrorMessage() | public MessageBuffer | getMessageBuffer() | public RowDataReceiver | getReceiver() | public String | getRowsInsertedMessage() | public String | getRowsUpdatedMessage() | public RowDataProducer | getSource() | public boolean | hasWarnings() | public boolean | isSuccess() | public void | reset() | public void | setBatchSize(int size) | public void | setCommitBatch(boolean flag) | public void | setCommitEvery(int interval) | public void | setContinueOnError(boolean cont) | public void | setDeleteTarget(boolean delete) | public void | setErrorHandler(JobErrorHandler handler) | public void | setKeyColumns(List<ColumnIdentifier> keys) | public void | setKeyColumns(String keys) | public boolean | setMode(String mode) Forwards the setMode() call to the DataImporter. | public void | setPerTableStatements(TableStatements stmt) | public void | setProducer(RowDataProducer source, WbConnection target, TableIdentifier targetTbl) | public void | setReportInterval(int value) | public void | setRowActionMonitor(RowActionMonitor rowMonitor) | public void | setTransactionControl(boolean flag) | public void | setUseBatch(boolean flag) | public void | startBackgroundCopy() | public void | startCopy() |
DataCopier | public DataCopier()(Code) | | |
beginMultiTableCopy | public void beginMultiTableCopy()(Code) | | |
cancel | public void cancel()(Code) | | |
commitNothing | public void commitNothing()(Code) | | |
copyFromTable | public void copyFromTable(WbConnection source, WbConnection target, TableIdentifier aSourceTable, TableIdentifier aTargetTable, Map<String, String> columnMapping, String additionalWhere, boolean createTable, boolean dropTable) throws SQLException(Code) | | Define the source table, the target table and the column mapping
for the copy process.
If the columnMapping is null, the matching columns from both tables are used.
It is expected that the mapping contains String objects. The key is the name of the
source column, the mapped value is the name of the target column
|
endMultiTableCopy | public void endMultiTableCopy()(Code) | | |
getAffectedRows | public long getAffectedRows()(Code) | | |
getRowsInsertedMessage | public String getRowsInsertedMessage()(Code) | | |
getRowsUpdatedMessage | public String getRowsUpdatedMessage()(Code) | | |
hasWarnings | public boolean hasWarnings()(Code) | | |
isSuccess | public boolean isSuccess()(Code) | | |
reset | public void reset()(Code) | | |
setBatchSize | public void setBatchSize(int size)(Code) | | |
setCommitBatch | public void setCommitBatch(boolean flag)(Code) | | |
setCommitEvery | public void setCommitEvery(int interval)(Code) | | |
setContinueOnError | public void setContinueOnError(boolean cont)(Code) | | |
setDeleteTarget | public void setDeleteTarget(boolean delete)(Code) | | |
setReportInterval | public void setReportInterval(int value)(Code) | | |
setTransactionControl | public void setTransactionControl(boolean flag)(Code) | | |
setUseBatch | public void setUseBatch(boolean flag)(Code) | | |
startBackgroundCopy | public void startBackgroundCopy()(Code) | | |
|
|