sapphire.talend

Class LabVantageUtil

java.lang.Object

sapphire.talend.LabVantageUtil

public class LabVantageUtil
extends java.lang.Object

Public class for using from Talend. Contains utility methods for working with LabVantage.

Constructor Summary

Constructors

Constructor and Description
LabVantageUtil()

Method Summary

Modifier and Type	Method and Description
static DataSet	getSQLDataSet(java.lang.String query, java.util.Properties context, java.util.Map<java.lang.String,java.lang.Object> globalmap) Query the Labvantage system for data.
static java.lang.String	getVariable(java.lang.String name, java.lang.String defaultValue, java.util.Properties context, java.util.Map<java.lang.String,java.lang.Object> globalmap) Will return a set up variable for either a report or attachment hander.
static java.lang.String	getVariable(java.lang.String name, java.lang.String defaultValue, java.util.Properties context, java.util.Map<java.lang.String,java.lang.Object> globalmap, boolean ignoreCase) Will return a set up variable for either a report or attachment hander.
static PropertyList	processAction(java.lang.String actionid, java.lang.String actionversion, PropertyList propertyList, java.util.Properties context, java.util.Map<java.lang.String,java.lang.Object> globalmap) Execute an action in LabVantage.
static void	startJob(java.lang.String jobName, java.util.Properties context, java.util.Map<java.lang.String,java.lang.Object> globalmap) Entry point for Jobs which use the LV API.

Methods inherited from class java.lang.Object

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

Constructor Detail

LabVantageUtil

public LabVantageUtil()

Method Detail

startJob

public static void startJob(java.lang.String jobName,
                            java.util.Properties context,
                            java.util.Map<java.lang.String,java.lang.Object> globalmap)

Entry point for Jobs which use the LV API. By using this in your first component it will build up all the context variables and do an prechecks. This is an optional assistance.

Parameters:

jobName - The name of the job

context - The talend context object

globmap - The talend global map object

getVariable

public static java.lang.String getVariable(java.lang.String name,
                                           java.lang.String defaultValue,
                                           java.util.Properties context,
                                           java.util.Map<java.lang.String,java.lang.Object> globalmap)

Will return a set up variable for either a report or attachment hander. These variables are loaded into the context.

Parameters:

name - name of the variable with or without the property_ prefix

defaultValue - The default value. If null is provided then an empty string is used.

context - The talend context object

globmap - The talend global map object

Returns:

Returns the context variable value or the default provided.

getVariable

public static java.lang.String getVariable(java.lang.String name,
                                           java.lang.String defaultValue,
                                           java.util.Properties context,
                                           java.util.Map<java.lang.String,java.lang.Object> globalmap,
                                           boolean ignoreCase)

Will return a set up variable for either a report or attachment hander. These variables are loaded into the context.

Parameters:

name - name of the variable with or without the property_ prefix

defaultValue - The default value. If null is provided then an empty string is used.

context - The talend context object

globmap - The talend global map object

ignoreCase - Set to true to ignore case when finding the variable name

Returns:

Returns the context variable value or the default provided.

getSQLDataSet

public static DataSet getSQLDataSet(java.lang.String query,
                                    java.util.Properties context,
                                    java.util.Map<java.lang.String,java.lang.Object> globalmap)

Query the Labvantage system for data. Please note that when executing from Talend you will need to allow Webservices and unregistered sql from the security policy.

Parameters:

query - The query to execute

context - The talend context object

globmap - The talend global map object

Returns:

Returns the data in a data set

processAction

public static PropertyList processAction(java.lang.String actionid,
                                         java.lang.String actionversion,
                                         PropertyList propertyList,
                                         java.util.Properties context,
                                         java.util.Map<java.lang.String,java.lang.Object> globalmap)

Execute an action in LabVantage. Please note that when executing from Talend you will need to allow Webservices and unregistered sql from the security policy.

Parameters:

actionid - The id of the action

actionversion - The verson of the action

propertyList - The input properties for the action

context - The talend context object

globmap - The talend global map object

Returns:

Returns the action properties