Package com.inductiveautomation.reporting.gateway.data.queries

Class SimpleSqlQuerySource

java.lang.Object

com.inductiveautomation.reporting.gateway.data.queries.SimpleSqlQuerySource

All Implemented Interfaces:

QuerySource<SimpleSqlQueryConfig>

public class SimpleSqlQuerySource
extends Object
implements QuerySource<SimpleSqlQueryConfig>

SimpleSqlQuerySource provides a SQL Query data source that allows for binding-like paths to be added via {} refs in SQL queries.

Nested Class Summary

Nested classes/interfaces inherited from interface com.inductiveautomation.reporting.gateway.api.QuerySource

QuerySource.SubQueryTransaction

Constructor Summary

Constructors

Constructor	Description
SimpleSqlQuerySource()

Method Summary

Modifier and Type	Method	Description
QuerySource.SubQueryTransaction	begin(ReportExecutionContext context, SimpleSqlQueryConfig config, Map<String,Object> extraConfigs, QueryResults parent)	Begin a nested query "transaction".
String	getId()	The unique ID for this query source.
Dataset	query(ReportExecutionContext execContext, SimpleSqlQueryConfig config, Map<String,Object> extraConfigs)	Execute a top level query.

Methods inherited from class java.lang.Object

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

Constructor Details

SimpleSqlQuerySource

public SimpleSqlQuerySource()

Method Details

getId

public String getId()

Description copied from interface: QuerySource

The unique ID for this query source. Should be qualified with module name first

Specified by:

getId in interface QuerySource<SimpleSqlQueryConfig>

query

public Dataset query(ReportExecutionContext execContext,
 SimpleSqlQueryConfig config,
 Map<String,Object> extraConfigs)
              throws Exception

Description copied from interface: QuerySource

Execute a top level query.

Specified by:

query in interface QuerySource<SimpleSqlQueryConfig>

Parameters:

execContext - The context for the report being executed.

config - The config object which was configured in the designer for this query.

extraConfigs - Extra configuration data the designer may need to send. Unused by most data sources, because the queryConfig should contain all data needed to execute the query. May be null.

Returns:

A dataset of results for executing this query

Throws:

Exception

begin

public QuerySource.SubQueryTransaction begin(ReportExecutionContext context,
 SimpleSqlQueryConfig config,
 Map<String,Object> extraConfigs,
 QueryResults parent)
                                      throws Exception

Description copied from interface: QuerySource

Begin a nested query "transaction". This means that a nested query (defined by a single query config) is about to be executed, and will probably be executed many times.

Specified by:

begin in interface QuerySource<SimpleSqlQueryConfig>

Parameters:

context - The context for the report being executed

config - The config object which was configured in designer for this nested query.

extraConfigs - Extra configuration data the designer may need to send. Unused by most data sources, because the queryConfig should contain all data needed to execute the query. May be null.

parent - The QueryResults object for the parent query of this nested query.

Returns:

A new transaction object to handle the execution of this nested query.

Throws:

Exception