com.aspc.commander.sql

Class ImportCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.ImportCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

Direct Known Subclasses:

ImportCommand

public class ImportCommand
extends SQLCommand

Allow a file to be loaded into a class.

The "fields" format is :-

path [POS position] [DEFAULT value] [UNIQUE]

The DELIMITER will default to a ","
Syntax

  IMPORT CLASS class_name 
   [[[FILE path] | 
      [FILE_KEY file_key]] 
      [DELIMITER delimiter] 
      [DATE_FORMAT date_format] 
      COLUMNS fields[,...]]
  

Usage

  /* Simple import */
  IMPORT CLASS person FILE /docs/temp.txt COLUMNS firstName POS 1, lastName
  

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) std.

Method Summary

Modifier and Type	Method and Description
void	appendResult(org.w3c.dom.Element group, int seq) append the result set to a result group.
protected ImportFieldDef	buildFieldDef(java.lang.String text, DBClass baseClass)
protected Importer	buildImporter(Parser p)
protected void	configImporter(Parser p, Importer importer)
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) Gets the column type for the given column index, starting at one
java.lang.String	getCursorName() Returns the name for the current cursor
protected DBFile	getImportFile(DataSource ds, Parser p)
protected ImportFileSource	getImportSource(DataSource ds, Parser p)
java.lang.String	getRecordID(int row) the record ID
java.lang.Object	getValue(int row, int col) the value for this row, column

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)

std. Command.

Parameters:

connection - the connection

pattern - the pattern

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

appendResult

public void appendResult(org.w3c.dom.Element group,
                         int seq)
                  throws java.lang.Exception

append the result set to a result group.

Overrides:

appendResult in class SQLCommand

Parameters:

group - The XML Element for the result group

seq - The sequence in the result group.

Throws:

java.lang.Exception - A serious problem.

getCursorName

public java.lang.String getCursorName()
                               throws java.lang.Exception

Description copied from class: SQLCommand

Returns the name for the current cursor

Specified by:

getCursorName in interface CommandBuildResultsPlugin

Overrides:

getCursorName in class SQLCommand

Returns:

the value

Throws:

java.lang.Exception - a serious problem

buildImporter

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

Parameters:

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem

configImporter

protected void configImporter(Parser p,
                              Importer importer)
                       throws java.lang.Exception

Parameters:

p -

importer -

Throws:

java.lang.Exception - a serious problem

getImportSource

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

Parameters:

ds - the data source

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem

getImportFile

protected DBFile getImportFile(DataSource ds,
                               Parser p)
                        throws java.lang.Exception

Parameters:

ds - the data source

p -

Returns:

the value

Throws:

java.lang.Exception - a serious problem

buildFieldDef

protected ImportFieldDef buildFieldDef(java.lang.String text,
                                       DBClass baseClass)
                                throws java.lang.Exception

Parameters:

text -

baseClass - The base class

Returns:

the value

Throws:

java.lang.Exception - a serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Parameters:

col - the column

Returns:

the name

getRecordID

public java.lang.String getRecordID(int row)

the record ID

Parameters:

row - the row index

Returns:

the record ID

getColumnType

public java.lang.String getColumnType(int col)

Gets the column type for the given column index, starting at one

Parameters:

col - the column index

Returns:

String the column type

getValue

public java.lang.Object getValue(int row,
                                 int col)

the value for this row, column

Parameters:

row - the row index

col - the column

Returns:

Object the value for the given row and column