org.etlunit.feature.sql_server_database
Class BcpCmd

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

public class BcpCmd
extends Object

Nested Class Summary

static class

BcpCmd.bcp_direction

Constructor Summary

BcpCmd(File sqlBinDir, RuntimeSupport runtimeSupport, String serverName, String databaseName, String delimiter, String rowDelimiter)

Method Summary

List<String>	exportSql(String sql, File targetFile)
List<String>	exportTableToCsv(String tableName, String tableSchema, List<String> columns, DatabaseImplementation.ExtractRequest.column_list_mode columnListMode, File data, File format)
void	generateFormatFile(String tableName, String tableSchema, File format)
void	importCsvData(File dataFile, File formatFile, String targetTableName, 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(File sqlBinDir,
              RuntimeSupport runtimeSupport,
              String serverName,
              String databaseName,
              String delimiter,
              String rowDelimiter)

Method Detail

importCsvData

public void importCsvData(File dataFile,
                          File formatFile,
                          String targetTableName,
                          String targetTableSchema)
                   throws IOException

Throws:

IOException

exportSql

public List<String> exportSql(String sql,
                              File targetFile)
                       throws Exception

Throws:

Exception

generateFormatFile

public void generateFormatFile(String tableName,
                               String tableSchema,
                               File format)
                        throws IOException

Throws:

IOException

exportTableToCsv

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

Throws:

Exception