Package io.revealbi.core.data

Class RVPostgresDataSourceItem

java.lang.Object

io.revealbi.core.data.RVDataSourceItem

io.revealbi.core.data.RVSqlBasedDataSourceItem

io.revealbi.core.data.RVSqlPDSDataSourceItem

io.revealbi.core.data.RVPostgresDataSourceItem

All Implemented Interfaces:

ICustomQuerySupport, IParameterizedCustomQuerySupport, IProcessDataOnServerDataSourceItem

public class RVPostgresDataSourceItem
extends RVSqlPDSDataSourceItem
implements IParameterizedCustomQuerySupport

PostgreSQL data source item.

Constructor Summary

Constructors

Constructor	Description
RVPostgresDataSourceItem(RVPostgresDataSource dataSource)

Method Summary

Modifier and Type	Method	Description
HashMap<String,Object>	getCustomQueryParameters()
String	getFunctionName()	(Optional) name of the function to get data from, the function is expected to return a result set and might have multiple parameters.
HashMap<String,Object>	getFunctionParameters()	Parameters to be passed to the function, if there is such specified in getFunctionName().
String	getProcedure()	(Optional) name of the stored procedure to get data from.
HashMap<String,Object>	getProcedureParameters()	Parameters to be passed to the stored procedure, if there is such specified in getProcedure().
String	getSchema()	Name of the schema the referenced table belongs to.
void	setCustomQueryParameters(HashMap<String,Object> value)
String	setFunctionName(String value)	(Optional) name of the function to get data from, the function is expected to return a result set and might have multiple parameters.
HashMap<String,Object>	setFunctionParameters(HashMap<String,Object> value)	Parameters to be passed to the function, if there is such specified in getFunctionName().
String	setProcedure(String value)	(Optional) name of the stored procedure to get data from.
HashMap<String,Object>	setProcedureParameters(HashMap<String,Object> value)	Parameters to be passed to the stored procedure, if there is such specified in getProcedure().
String	setSchema(String value)	Name of the schema the referenced table belongs to.

Methods inherited from class io.revealbi.core.data.RVSqlPDSDataSourceItem

getProcessDataOnServer, setProcessDataOnServer

Methods inherited from class io.revealbi.core.data.RVSqlBasedDataSourceItem

getCustomQuery, getDatabase, getTable, setCustomQuery, setDatabase, setTable

Methods inherited from class io.revealbi.core.data.RVDataSourceItem

getDataSource, getDefaultRefreshRate, getDescription, getId, getSubtitle, getTitle, setDataSource, setDefaultRefreshRate, setDescription, setId, setSubtitle, setTitle

Methods inherited from class java.lang.Object

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

Methods inherited from interface io.revealbi.core.data.ICustomQuerySupport

getCustomQuery, setCustomQuery

Constructor Details

RVPostgresDataSourceItem

public RVPostgresDataSourceItem(RVPostgresDataSource dataSource)

Method Details

setSchema

public String setSchema(String value)

Name of the schema the referenced table belongs to.

Parameters:

value -

Returns:

getSchema

public String getSchema()

Name of the schema the referenced table belongs to.

Returns:

setFunctionName

public String setFunctionName(String value)

(Optional) name of the function to get data from, the function is expected to return a result set and might have multiple parameters.

Parameters:

value -

Returns:

getFunctionName

public String getFunctionName()

(Optional) name of the function to get data from, the function is expected to return a result set and might have multiple parameters.

Returns:

setFunctionParameters

public HashMap<String,Object> setFunctionParameters(HashMap<String,Object> value)

Parameters to be passed to the function, if there is such specified in getFunctionName().

Parameters:

value -

Returns:

getFunctionParameters

public HashMap<String,Object> getFunctionParameters()

Parameters to be passed to the function, if there is such specified in getFunctionName().

Returns:

setProcedure

public String setProcedure(String value)

(Optional) name of the stored procedure to get data from. The procedure is expected to have a REFCURSOR inout parameter and might have additional input parameters.

Parameters:

value -

Returns:

getProcedure

public String getProcedure()

(Optional) name of the stored procedure to get data from. The procedure is expected to have a REFCURSOR inout parameter and might have additional input parameters.

Returns:

setProcedureParameters

public HashMap<String,Object> setProcedureParameters(HashMap<String,Object> value)

Parameters to be passed to the stored procedure, if there is such specified in getProcedure().

Parameters:

value -

Returns:

getProcedureParameters

public HashMap<String,Object> getProcedureParameters()

Parameters to be passed to the stored procedure, if there is such specified in getProcedure().

Returns:

setCustomQueryParameters

public void setCustomQueryParameters(HashMap<String,Object> value)

Specified by:

setCustomQueryParameters in interface IParameterizedCustomQuerySupport

getCustomQueryParameters

public HashMap<String,Object> getCustomQueryParameters()

Specified by:

getCustomQueryParameters in interface IParameterizedCustomQuerySupport