org.etlunit.feature.sql_server_database
Class BcpCmd

java.lang.Object
  org.etlunit.feature.sql_server_database.BcpCmd

public class BcpCmd
extends java.lang.Object

Nested Class Summary

static class

BcpCmd.bcp_direction

Constructor Summary

BcpCmd(java.io.File sqlBinDir, RuntimeSupport runtimeSupport, java.lang.String serverName, java.lang.String databaseName, java.lang.String delimiter, java.lang.String rowDelimiter)

Method Summary

java.util.List<java.lang.String>	exportSql(java.lang.String sql, java.io.File targetFile)
java.util.List<java.lang.String>	exportTableToCsv(java.lang.String tableName, java.lang.String tableSchema, java.util.List<java.lang.String> columns, DatabaseImplementation.ExtractRequest.column_list_mode columnListMode, java.io.File data, java.io.File format)
void	generateFormatFile(java.lang.String tableName, java.lang.String tableSchema, java.io.File format)
void	importCsvData(java.io.File dataFile, java.io.File formatFile, java.lang.String targetTableName, java.lang.String targetTableSchema)

Methods inherited from class java.lang.Object

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

Constructor Detail

BcpCmd

public BcpCmd(java.io.File sqlBinDir,
              RuntimeSupport runtimeSupport,
              java.lang.String serverName,
              java.lang.String databaseName,
              java.lang.String delimiter,
              java.lang.String rowDelimiter)

Method Detail

importCsvData

public void importCsvData(java.io.File dataFile,
                          java.io.File formatFile,
                          java.lang.String targetTableName,
                          java.lang.String targetTableSchema)
                   throws java.io.IOException

Throws:

java.io.IOException

exportSql

public java.util.List<java.lang.String> exportSql(java.lang.String sql,
                                                  java.io.File targetFile)
                                           throws java.lang.Exception

Throws:

java.lang.Exception

generateFormatFile

public void generateFormatFile(java.lang.String tableName,
                               java.lang.String tableSchema,
                               java.io.File format)
                        throws java.io.IOException

Throws:

java.io.IOException

exportTableToCsv

public java.util.List<java.lang.String> exportTableToCsv(java.lang.String tableName,
                                                         java.lang.String tableSchema,
                                                         java.util.List<java.lang.String> columns,
                                                         DatabaseImplementation.ExtractRequest.column_list_mode columnListMode,
                                                         java.io.File data,
                                                         java.io.File format)
                                                  throws java.lang.Exception

Throws:

java.lang.Exception