List of queryData() Examples

Examples of queryData()

org.pentaho.platform.plugin.action.jfreereport.helper.PentahoDataFactory.queryData()
org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData()
Queries a datasource. The string 'query' defines the name of the query. The Parameterset given here may contain more data than actually needed for the query.
The parameter-dataset may change between two calls, do not assume anything, and do not hold references to the parameter-dataset or the position of the columns in the dataset. @param query the query string @param parameters the parameters for the query @return the result of the query as table model. @throws ReportDataFactoryException if an error occured while performing the query.
org.pentaho.reporting.engine.classic.core.DataFactory.queryData()
Queries a datasource. The string 'query' defines the name of the query. The Parameterset given here may contain more data than actually needed for the query.
The parameter-dataset may change between two calls, do not assume anything, and do not hold references to the parameter-dataset or the position of the columns in the dataset. @param query the query string, never null. @param parameters the parameters for the query, never null. @return the result of the query as table model. @throws ReportDataFactoryException if an error occured while performing the query.
org.pentaho.reporting.engine.classic.core.TableDataFactory.queryData()
Queries a datasource. The string 'query' defines the name of the query. The Parameterset given here may contain more data than actually needed.
The dataset may change between two calls, do not assume anything! @param query the name of the table. @param parameters are ignored for this factory. @return the report data or null.
org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData()
Queries a datasource. The string 'query' defines the name of the query. The Parameterset given here may contain more data than actually needed.
The dataset may change between two calls, do not assume anything! @param query @param parameters @return
org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.StaticDataFactory.queryData()
Queries a datasource. The string 'query' defines the name of the query. The Parameterset given here may contain more data than actually needed.
The dataset may change between two calls, do not assume anything! @param query the method call. @param parameters the set of parameters. @return the tablemodel from the executed method call, never null.
org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData()
Queries a datasource. The string 'query' defines the name of the query. The Parameterset given here may contain more data than actually needed.
The dataset may change between two calls, do not assume anything! @param query @param parameters @return
org.pentaho.reporting.engine.classic.core.states.CascadingDataFactory.queryData()

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

    final TableModel burstingData;
    final DataFactory dataFactory = definition.getDataFactory();
    if (definition.getBurstQuery() != null &&
        dataFactory.isQueryExecutable(definition.getBurstQuery(), parameterValues))
    {
      burstingData = wrapWithParameters(dataFactory.queryData(definition.getBurstQuery(), parameterValues), parameterValues);
    }
    else
    {
      burstingData = wrapWithParameters(new DefaultTableModel(1, 0), parameterValues);
    }

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

  {


    try
    {
      final DataFactory dataFactory = context.getRuntime().getDataFactory();
      final TableModel tableModel = dataFactory.queryData(query,
          new QueryDataRowWrapper(context.getDataRow(), 1, queryTimeout));
      if (tableModel == null)
      {
        return null;
      }

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

  {


    try
    {
      final DataFactory dataFactory = context.getRuntime().getDataFactory();
      final TableModel tableModel = dataFactory.queryData(query,
          new QueryDataRowWrapper(context.getDataRow(), queryLimit, queryTimeout));
      if (tableModel == null)
      {
        return null;
      }

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

      {
        mappings[i] = new ParameterMapping(fields[i], fields[i]);
      }


      final QueryParametersDataRow params = new QueryParametersDataRow(getDataRow(), mappings);
      final TableModel tableModel = dataFactory.queryData(query, new QueryDataRowWrapper(params, 1, queryTimeout));
      if (tableModel == null)
      {
        return null;
      }
      final int columnCount = tableModel.getColumnCount();

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

   */
  @Test
  public void testQuery() throws ReportDataFactoryException
  {
    DataFactory dataFactory = createDataFactory(queryBroken);
    final TableModel tableModel = dataFactory.queryData("default", new ParameterDataRow());
//    new DataPreviewDialog().showData(tableModel);


    Assert.assertEquals("[Markets].[(All)]", tableModel.getColumnName(2));
    Assert.assertEquals("[Product].[Line]", tableModel.getColumnName(1));
    Assert.assertNotNull(tableModel.getValueAt(0, 3));

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

   */
  @Test
  public void testQueryOK() throws ReportDataFactoryException
  {
    DataFactory dataFactory = createDataFactory(query);
    final TableModel tableModel = dataFactory.queryData("default", new ParameterDataRow());
//    new DataPreviewDialog().showData(tableModel);


    Assert.assertEquals("[Markets].[(All)]", tableModel.getColumnName(2));
    Assert.assertEquals("[Product].[Line]", tableModel.getColumnName(1));
    Assert.assertNotNull(tableModel.getValueAt(1, 1));

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()


  @Test
  public void testQueryMultipleH() throws ReportDataFactoryException
  {
    DataFactory dataFactory = createDataFactory(queryMultipleH);
    final TableModel tableModel = dataFactory.queryData("default", new ParameterDataRow());


    Assert.assertEquals("[Time].[Quarters]", tableModel.getColumnName(2));
    Assert.assertEquals("[Time].[Years]", tableModel.getColumnName(1));
    Assert.assertNotNull(tableModel.getValueAt(1, 1));
    Assert.assertNotNull(tableModel.getValueAt(2, 2));

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

    PerformanceLoggingStopWatch sw = context.getPerformanceMonitorContext().createStopWatch
            (PerformanceTags.REPORT_PARAMETER_QUERY, new FormattedMessage("query={%s}", getQueryName()));
    try
    {
      sw.start();
      final TableModel tableModel = dataFactory.queryData(getQueryName(),
          new CompoundDataRow(envDataRow, parameterData));


      final String formula = getParameterAttribute(ParameterAttributeNames.Core.NAMESPACE,
          ParameterAttributeNames.Core.DISPLAY_VALUE_FORMULA, context);
      if (StringUtils.isEmpty(formula, true))

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

   */
  @Test
  public void testQuery() throws ReportDataFactoryException
  {
    DataFactory dataFactory = createDataFactory(queryBroken);
    final TableModel tableModel = dataFactory.queryData("default", new ParameterDataRow());
//    new DataPreviewDialog().showData(tableModel);


    Assert.assertEquals("[Markets].[(All)]", tableModel.getColumnName(2));
    Assert.assertEquals("[Product].[Line]", tableModel.getColumnName(1));
    Assert.assertNotNull(tableModel.getValueAt(0, 3));

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.DataFactory.queryData()

   */
  @Test
  public void testQueryOK() throws ReportDataFactoryException
  {
    DataFactory dataFactory = createDataFactory(query);
    final TableModel tableModel = dataFactory.queryData("default", new ParameterDataRow());
//    new DataPreviewDialog().showData(tableModel);


    Assert.assertEquals("[Markets].[(All)]", tableModel.getColumnName(2));
    Assert.assertEquals("[Product].[Line]", tableModel.getColumnName(1));
    Assert.assertNotNull(tableModel.getValueAt(1, 1));

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.