com.denodo.scheduler.client.vdpintrospection

Interface VDPManager

All Superinterfaces:

Serializable

public interface VDPManager
extends Serializable

Interface for clients to introspect a VDP Server

Since:

5.0

Method Summary

Modifier and Type	Method and Description
String	generateOrderByExpressionWithPK(int vdpDataSourceID, Collection<String> pkFields) Returns a default ORDER BY expression generated from the selected PK fields.
String	generateOrderByExpressionWithPK(int vdpDataSourceID, String viewName) Returns a default ORDER BY expression generated from the selected view's PK.
Collection<String>	getDateFieldsFromView(int vdpDataSourceID, String viewName) Returns the date-type fields of a VDP view.
VDPViewFields	getFieldsFromView(int vdpDataSourceID, String viewName) Returns the fields of a VDP view and which ones are mandatory.
String	getIncrementalCacheStoredProcedureName(int vdpDataSourceID) Returns the name of the stored procedure for incremental cache load of the VDP Server defined by the identifier of the data source.
Collection<String>	getPKFieldsFromView(int vdpDataSourceID, String viewName) Returns the PK fields of a VDP view.
Collection<String>	getTextFieldsFromView(int vdpDataSourceID, String viewName) Returns the text-type fields of a VDP view.
Collection<String>	getViewNames(int vdpDataSourceID) Returns a collection with the names of the views (base and derived) of the VDP Server defined by the identifier of the data source.
Collection<String>	getViewsWithPKNames(int vdpDataSourceID) Returns a collection with the names of the views (base and derived) of the VDP Server defined by the identifier of the data source.
String	validateQuery(int vdpDataSourceID, String query) Checks if a query is valid (without executing it).
String	validateQuery(int vdpDataSourceID, String query, String contextOpts) Checks if a query is valid (without executing it).

Method Detail

getViewNames

Collection<String> getViewNames(int vdpDataSourceID)
                         throws VDPConnectException,
                                InstanceNotFoundException,
                                InternalErrorException

Returns a collection with the names of the views (base and derived) of the VDP Server defined by the identifier of the data source.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

Returns:

the collection of view names.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

getViewsWithPKNames

Collection<String> getViewsWithPKNames(int vdpDataSourceID)
                                throws VDPConnectException,
                                       InstanceNotFoundException,
                                       InternalErrorException

Returns a collection with the names of the views (base and derived) of the VDP Server defined by the identifier of the data source. Only views which define a PK will be included in the result.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

Returns:

the collection of view names.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

getIncrementalCacheStoredProcedureName

String getIncrementalCacheStoredProcedureName(int vdpDataSourceID)
                                       throws VDPConnectException,
                                              InstanceNotFoundException,
                                              InternalErrorException

Returns the name of the stored procedure for incremental cache load of the VDP Server defined by the identifier of the data source.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

Returns:

the name of the stored procedure.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

generateOrderByExpressionWithPK

String generateOrderByExpressionWithPK(int vdpDataSourceID,
                                       String viewName)
                                throws VDPConnectException,
                                       InstanceNotFoundException,
                                       InternalErrorException

Returns a default ORDER BY expression generated from the selected view's PK. The expression will have the following structure: ORDER BY pk_field_1 ASC[, pk_field_n ASC]*. An empty string will be returned in case the selected view does not have a PK.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

viewName - the name of the view.

Returns:

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

generateOrderByExpressionWithPK

String generateOrderByExpressionWithPK(int vdpDataSourceID,
                                       Collection<String> pkFields)
                                throws VDPConnectException,
                                       InstanceNotFoundException,
                                       InternalErrorException

Returns a default ORDER BY expression generated from the selected PK fields. The expression will have the following structure: ORDER BY pk_field_1 ASC[, pk_field_n ASC]*.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

pkFields - the PK fields to generate the ORDER BY expression.

Returns:

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

getPKFieldsFromView

Collection<String> getPKFieldsFromView(int vdpDataSourceID,
                                       String viewName)
                                throws VDPConnectException,
                                       InstanceNotFoundException,
                                       InternalErrorException

Returns the PK fields of a VDP view. If a PK is not defined for the selected view, the method returns an emtpy collection, never null.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

viewName - the name of the view.

Returns:

the fields of the view and which ones are mandatory.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

getDateFieldsFromView

Collection<String> getDateFieldsFromView(int vdpDataSourceID,
                                         String viewName)
                                  throws VDPConnectException,
                                         InstanceNotFoundException,
                                         InternalErrorException

Returns the date-type fields of a VDP view. If there are none,, the method returns an emtpy collection, never null.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

viewName - the name of the view.

Returns:

the fields of the view and which ones are mandatory.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

getTextFieldsFromView

Collection<String> getTextFieldsFromView(int vdpDataSourceID,
                                         String viewName)
                                  throws VDPConnectException,
                                         InstanceNotFoundException,
                                         InternalErrorException

Returns the text-type fields of a VDP view. If there are none,, the method returns an emtpy collection, never null.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

viewName - the name of the view.

Returns:

the fields of the view and which ones are mandatory.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

getFieldsFromView

VDPViewFields getFieldsFromView(int vdpDataSourceID,
                                String viewName)
                         throws VDPConnectException,
                                InstanceNotFoundException,
                                InternalErrorException

Returns the fields of a VDP view and which ones are mandatory.

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

viewName - the name of the view.

Returns:

the fields of the view and which ones are mandatory.

Throws:

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InstanceNotFoundException - if the data source does not exist.

InternalErrorException - if an error occurs during the process.

validateQuery

String validateQuery(int vdpDataSourceID,
                     String query)
              throws InstanceNotFoundException,
                     VDPConnectException,
                     InternalErrorException

Checks if a query is valid (without executing it). By 'valid', we mean the query syntax is correct and there are conditions for every mandatory field (if any).

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

query - the query to test.

Returns:

if the query is invalid, a String with the error message; null, otherwise.

Throws:

InstanceNotFoundException - if the data source does not exist.

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InternalErrorException - if an error occurs during the process.

validateQuery

String validateQuery(int vdpDataSourceID,
                     String query,
                     String contextOpts)
              throws InstanceNotFoundException,
                     VDPConnectException,
                     InternalErrorException

Checks if a query is valid (without executing it). By 'valid', we mean the query syntax is correct and there are conditions for every mandatory field (if any).

Parameters:

vdpDataSourceID - the identifier of the VDP data source created in Scheduler.

query - the query to test.

contextOpts - the query context options. For instance: "'prop1'='val1','propN'='valN'"

Returns:

if the query is invalid, a String with the error message; null, otherwise.

Throws:

InstanceNotFoundException - if the data source does not exist.

VDPConnectException - if a connection error occurs against VDP. Typically, the connection was refused remotely or the authentication was wrong.

InternalErrorException - if an error occurs during the process.