Package org.pentaho.di.trans.steps.databaselookup

Class DatabaseLookupHelper

java.lang.Object

org.pentaho.di.trans.step.BaseStepHelper

org.pentaho.di.trans.steps.databaselookup.DatabaseLookupHelper

All Implemented Interfaces:

StepHelperInterface

public class DatabaseLookupHelper
extends BaseStepHelper

Field Summary

Fields

Modifier and Type	Field	Description
static final String	COLUMNS
static final String	CONNECTION
static final String	GET_TABLE_FIELD_AND_TYPE
static final String	SCHEMA
static final String	TABLE

Fields inherited from class org.pentaho.di.trans.step.BaseStepHelper

IS_TRANS_REFERENCE, IS_VALID_REFERENCE, log, REFERENCE_PATH, SEPARATOR

Fields inherited from interface org.pentaho.di.trans.step.StepHelperInterface

ACTION_STATUS, FAILURE_METHOD_NOT_FOUND_RESPONSE, FAILURE_RESPONSE, STATUS, SUCCESS_RESPONSE

Constructor Summary

Constructors

Constructor	Description
DatabaseLookupHelper()

Method Summary

Modifier and Type	Method	Description
org.json.simple.JSONObject	getTableFieldAndType(TransMeta transMeta, Map<String,String> queryParams)	Get table fields and their types.
protected org.json.simple.JSONObject	handleStepAction(String method, TransMeta transMeta, Map<String,String> queryParams)	Handles step-specific actions for Database lookup.

Methods inherited from class org.pentaho.di.trans.step.BaseStepHelper

getReferencePath, isFailedResponse, stepAction, validateAndPutReferenceStatus

Methods inherited from class java.lang.Object

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

Field Details

GET_TABLE_FIELD_AND_TYPE

public static final String GET_TABLE_FIELD_AND_TYPE

See Also:

• Constant Field Values

CONNECTION

public static final String CONNECTION

See Also:

• Constant Field Values

SCHEMA

public static final String SCHEMA

See Also:

• Constant Field Values

TABLE

public static final String TABLE

See Also:

• Constant Field Values

COLUMNS

public static final String COLUMNS

See Also:

• Constant Field Values

Constructor Details

DatabaseLookupHelper

public DatabaseLookupHelper()

Method Details

handleStepAction

protected org.json.simple.JSONObject handleStepAction(String method,
 TransMeta transMeta,
 Map<String,String> queryParams)

Handles step-specific actions for Database lookup.

Specified by:

handleStepAction in class BaseStepHelper

Parameters:

method - The name of the method to execute.

transMeta - The transformation metadata associated with the step.

queryParams - A map of query parameters for the action.

Returns:

A JSON object containing the action status and any additional response data.

getTableFieldAndType

public org.json.simple.JSONObject getTableFieldAndType(TransMeta transMeta,
 Map<String,String> queryParams)

Get table fields and their types.

Parameters:

transMeta - contains the metadata of transformation.

queryParams - Query parameters containing connection, schema, and table.

Returns:

JSON object containing the table fields and types or error message.