com.aspc.commander.sql

Class MergeCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.MergeCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class MergeCommand
extends SQLCommand

Merge two objects into one. Will not delete the source object.
Syntax

  MERGE target_key WITH source_key[,...] [LINKSONLY] [RULES rule[,...]]
  

Usage

  /* Move the objects linked to source over to target */
  MERGE 1@1~1@1 WITH 2@1~1@1 LINKSONLY
  

THREAD MODE: SINGLE THREADED command

Since:

February 20, 2007

Author:

luke

Field Summary

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

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
MergeCommand(Connection connection, Pattern pattern) Creates a new MergeCommand

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser parser) Executes the command.
java.lang.String	getColumnName(int column) Gets the column name
java.lang.String	getColumnType(int column) Gets the data type of the column
java.lang.String	getRecordID(int row) Gets the record id
java.lang.Object	getValue(int row, int column) Gets the value for a cell

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

appendResult, appendResult, getCursorName, 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

MergeCommand

public MergeCommand(Connection connection,
                    Pattern pattern)

Creates a new MergeCommand

Parameters:

connection - the command connection

pattern - the command pattern

Method Detail

execute

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

Executes the command. Will merge two objects

Specified by:

execute in class Command

Parameters:

parser - the command parser

Throws:

java.lang.Exception - command failure

getValue

public java.lang.Object getValue(int row,
                                 int column)
                          throws java.lang.Exception

Gets the value for a cell

Parameters:

row - the cell row

column - the cell column

Returns:

Object cell value

Throws:

java.lang.Exception - a serious problem

getColumnType

public java.lang.String getColumnType(int column)
                               throws java.lang.Exception

Gets the data type of the column

Parameters:

column - the column to type

Returns:

String the column type

Throws:

java.lang.Exception - failure to type column

getColumnName

public java.lang.String getColumnName(int column)

Gets the column name

Parameters:

column - the column to name

Returns:

String the column name

getRecordID

public java.lang.String getRecordID(int row)

Gets the record id

Parameters:

row - the record to id

Returns:

String the record id