Package io.jmix.reports.yarg.loaders.impl

Class SqlDataLoader

java.lang.Object

io.jmix.reports.yarg.loaders.impl.AbstractDataLoader

io.jmix.reports.yarg.loaders.impl.AbstractDbDataLoader

io.jmix.reports.yarg.loaders.impl.SqlDataLoader

All Implemented Interfaces:

ReportDataLoader

Direct Known Subclasses:

JmixSqlDataLoader

public class SqlDataLoader
extends AbstractDbDataLoader

Loads data from database using sql You can use aliases for output values Example: select login as "Login", password as "Password" from user where create_ts > ${startDate} ${startDate} is alias of the input parameter, which will be passed to the query

Nested Class Summary

Nested classes/interfaces inherited from class io.jmix.reports.yarg.loaders.impl.AbstractDbDataLoader

AbstractDbDataLoader.OutputValue, AbstractDbDataLoader.QueryPack, AbstractDbDataLoader.QueryParameter

Field Summary

Fields inherited from class io.jmix.reports.yarg.loaders.impl.AbstractDbDataLoader

COMMON_PARAM_PATTERN

Fields inherited from class io.jmix.reports.yarg.loaders.impl.AbstractDataLoader

fieldsConverter, parametersConverter

Constructor Summary

Constructors

Constructor	Description
SqlDataLoader(DataSource dataSource)

Method Summary

Modifier and Type	Method	Description
DataSource	getDataSource()
List<Map<String,Object>>	loadData(ReportQuery reportQuery, BandData parentBand, Map<String,Object> params)	This method MUST return list of mutable maps.
protected List	runQuery(ReportQuery reportQuery, String queryString, Object[] params, ResultSetHandler<List> handler)

Methods inherited from class io.jmix.reports.yarg.loaders.impl.AbstractDbDataLoader

fillOutputData, findParameterNames, insertParameterToQuery, prepareQuery, processQueryTemplate

Methods inherited from class io.jmix.reports.yarg.loaders.impl.AbstractDataLoader

addParentBandDataToParameters, convertOutputValue, convertParameter, getFieldsConverter, getParametersConverter, setFieldsConverter, setParametersConverter

Methods inherited from class java.lang.Object

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

Constructor Details

SqlDataLoader

public SqlDataLoader(DataSource dataSource)

Method Details

loadData

public List<Map<String,Object>> loadData(ReportQuery reportQuery,
 BandData parentBand,
 Map<String,Object> params)

Description copied from interface: ReportDataLoader

This method MUST return list of mutable maps. We need mutability to put there some values implicitly.

runQuery

protected List runQuery(ReportQuery reportQuery,
 String queryString,
 Object[] params,
 ResultSetHandler<List> handler)
                 throws SQLException

Throws:

SQLException

getDataSource

public DataSource getDataSource()