com.toolsverse.etl.core.function.sqlserver

Class MsSqlFunctions

Object

com.toolsverse.etl.core.function.DefFunctions

com.toolsverse.etl.core.function.sqlserver.MsSqlFunctions

All Implemented Interfaces:

Function

public class MsSqlFunctions
extends DefFunctions

The Microsoft Sql Server specific functions. By default used by MsSqlDriver.

Since:

1.0

Version:

2.0

See Also:

MsSqlDriver

Field Summary

Fields inherited from class com.toolsverse.etl.core.function.DefFunctions

DEFAULT_FUNCTION, SCENARIO_VARIABLE_ATTR, SCRIPT_FUNCTION, START_ATTR

Constructor Summary

Constructors

Constructor and Description
MsSqlFunctions()

Method Summary

Modifier and Type	Method and Description
String	assignVar(LoadFunctionContext context, String value) Assigns value to variable.
String[]	getAfterFunctions() Gets the array of functions which will be executed after main etl action (insert, update, delete, merge, etc).
String	getAutoInc(LoadFunctionContext context) Gets the auto increment value.
String[]	getBeforeFunctions() Gets the array of functions which will be executed before main etl action (insert, update, delete, merge, etc).
String[]	getExcludeFunctions() Gets the array of functions which will be executed to calculate visibility of the field.
String	getFk(LoadFunctionContext context) Gets the new value for the field from the corresponding "primary key" field.
String	getPk(LoadFunctionContext context) Gets the new value for the field using in-memory map or other mechanism, for example db sequence.
String[]	getRuntimeFunctions() Gets the array of functions which will be executed at run time.
String	getValue(LoadFunctionContext context) Gets the current field value.

Methods inherited from class com.toolsverse.etl.core.function.DefFunctions

assignVar, getGlobalVarValue, getSeq, getSql, getSqlType, getValueFromRecordOrVar, getVariableValue, getVarSql, getVarSql, script

Methods inherited from class Object

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

Constructor Detail

MsSqlFunctions

public MsSqlFunctions()

Method Detail

assignVar

public String assignVar(LoadFunctionContext context,
                        String value)
                 throws Exception

Description copied from class: DefFunctions

Assigns value to variable.

Overrides:

assignVar in class DefFunctions

Parameters:

context - the context

value - the value

Returns:

the string

Throws:

Exception - the exception

getAfterFunctions

public String[] getAfterFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed after main etl action (insert, update, delete, merge, etc).

Specified by:

getAfterFunctions in interface Function

Overrides:

getAfterFunctions in class DefFunctions

Returns:

the array of "after" functions

getAutoInc

public String getAutoInc(LoadFunctionContext context)
                  throws Exception

Gets the auto increment value.

Parameters:

context - the context

Returns:

the auto increment value

Throws:

Exception - the exception

getBeforeFunctions

public String[] getBeforeFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed before main etl action (insert, update, delete, merge, etc).

Specified by:

getBeforeFunctions in interface Function

Overrides:

getBeforeFunctions in class DefFunctions

Returns:

the array of "before" functions

getExcludeFunctions

public String[] getExcludeFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed to calculate visibility of the field. Can be used to exclude field from the main etl action (insert, update, delete, merge, etc).

Specified by:

getExcludeFunctions in interface Function

Overrides:

getExcludeFunctions in class DefFunctions

Returns:

the array of "exclude" functions

getFk

public String getFk(LoadFunctionContext context)
             throws Exception

Description copied from class: DefFunctions

Gets the new value for the field from the corresponding "primary key" field.

Overrides:

getFk in class DefFunctions

Parameters:

context - the context

Returns:

the foreign key

Throws:

Exception - in case of any error

getPk

public String getPk(LoadFunctionContext context)
             throws Exception

Description copied from class: DefFunctions

Gets the new value for the field using in-memory map or other mechanism, for example db sequence.

Overrides:

getPk in class DefFunctions

Parameters:

context - the context

Returns:

the primary key

Throws:

Exception - in case of any error

getRuntimeFunctions

public String[] getRuntimeFunctions()

Description copied from interface: Function

Gets the array of functions which will be executed at run time. Use them to calculate field values.

Specified by:

getRuntimeFunctions in interface Function

Overrides:

getRuntimeFunctions in class DefFunctions

Returns:

the array of "runtime" functions

getValue

public String getValue(LoadFunctionContext context)
                throws Exception

Description copied from class: DefFunctions

Gets the current field value.

Overrides:

getValue in class DefFunctions

Parameters:

context - the context

Returns:

the current field value

Throws:

Exception - in case of any error