com.aspc.Layers.aspc_app.DBImport

Class ImportCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.ImportCommand

com.aspc.Layers.aspc_app.DBImport.ImportCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class ImportCommand
extends ImportCommand

Allow a file to be loaded based on a predefined definition

The "import_key" refers to an existing DBImport object which allows for all import parameters to be provided.

The DELIMITER will default to a ","
Syntax

  IMPORT_FROM_DEFINITION 
     [IMPORT_KEY import_key] | 
     [[[FILE path] | 
     [FILE_KEY file_key]] 
     [DELIMITER delimiter] 
     [DATE_FORMAT date_format] 
     [ATTRIBUTES attributes]
     TEMPLATE template_name]
  

Usage

  -- Simple import --
  IMPORT_FROM_DEFINITION FILE /docs/temp.txt TEMPLATE Temp_Import
  

THREAD MODE: SINGLE THREADED command

Since:

3 December 2003

Author:

Nigel Leck

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
ImportCommand(Connection connection, Pattern pattern)

Method Summary

Modifier and Type	Method and Description
protected Importer	buildImporter(Parser p)
protected DBImportFile	getImportDefinition(Parser p)
protected ImportFileSource	getImportSource(DataSource ds, Parser p)
protected DBImportTemplate	getImportTemplate(Parser p)

Methods inherited from class com.aspc.commander.sql.ImportCommand

appendResult, buildFieldDef, configImporter, execute, getColumnName, getColumnType, getCursorName, getImportFile, getRecordID, getValue

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

ImportCommand

public ImportCommand(Connection connection,
                     Pattern pattern)

Parameters:

connection -

pattern -

Method Detail

buildImporter

protected Importer buildImporter(Parser p)
                          throws java.lang.Exception

Overrides:

buildImporter in class ImportCommand

Parameters:

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem

getImportSource

protected ImportFileSource getImportSource(DataSource ds,
                                           Parser p)
                                    throws java.lang.Exception

Overrides:

getImportSource in class ImportCommand

Parameters:

ds - the data source

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem

getImportDefinition

protected DBImportFile getImportDefinition(Parser p)
                                    throws java.lang.Exception

Parameters:

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem

getImportTemplate

protected DBImportTemplate getImportTemplate(Parser p)
                                      throws java.lang.Exception

Parameters:

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem