(DataDefinition) performExternalParsing( parameterFile, DataDefinition.class, parameters ); report.setQuery( dataDefinition.getQuery() ); report.setQueryLimit( dataDefinition.getQueryLimit() ); report.setQueryTimeout( dataDefinition.getQueryTimeout() );
protected MasterReport createCrosstabReport( final TableModel tableModel ) { Expression dummy = create( "dummy", null, null ); if ( dummy instanceof AggregationFunction == false ) { return null; } AggregationFunction function = (AggregationFunction) dummy; final MasterReport report = new MasterReport(); report.setPageDefinition( new SimplePageDefinition( PageSize.A3, PageFormat.LANDSCAPE, new Insets( 0, 0, 0, 0 ) ) ); report.setDataFactory( new TableDataFactory( "query", tableModel ) ); report.setQuery( "query" ); final ContextAwareDataSchemaModel dataSchemaModel = new DesignTimeDataSchemaModel( report ); final CrosstabBuilder builder = new CrosstabBuilder( dataSchemaModel ); builder.addRowDimension( ROW_DIMENSION_A ); builder.addRowDimension( ROW_DIMENSION_B ); builder.addColumnDimension( COLUMN_DIMENSION_A ); builder.addColumnDimension( COLUMN_DIMENSION_B ); builder.addDetails( VALUE, function.getClass() ); report.setRootGroup( builder.create() ); return report; }
final TableDataFactory tableDataFactory = new TableDataFactory(); tableDataFactory.addTable( "fruit", createFruitTableModel() ); master.setQuery( "Query Fruit" ); master.setDataFactory( tableDataFactory );
protected MasterReport createRelationalReport( final TableModel tableModel, final String... additionalFields ) { final MasterReport report = new MasterReport(); report.setPageDefinition( new SimplePageDefinition( PageSize.A3, PageFormat.LANDSCAPE, new Insets( 0, 0, 0, 0 ) ) ); report.setDataFactory( new TableDataFactory( "query", tableModel ) ); report.setQuery( "query" ); final DesignTimeDataSchemaModel dataSchemaModel = new DesignTimeDataSchemaModel( report ); final RelationalReportBuilder builder = new RelationalReportBuilder( dataSchemaModel ); builder.addGroup( ROW_DIMENSION_A ); builder.addGroup( ROW_DIMENSION_B ); builder.addGroup( COLUMN_DIMENSION_A ); builder.addGroup( COLUMN_DIMENSION_B ); builder.addDetails( VALUE, null, Color.lightGray ); builder.addDetails( "relational", null, Color.yellow ); for ( int i = 0; i < additionalFields.length; i++ ) { String additionalField = additionalFields[i]; builder.addDetails( additionalField, null, null ); } report.setRootGroup( builder.create() ); return report; }
/** * The default constructor. Creates an empty but fully initialized report. */ public MasterReport() { setElementType( new MasterReportType() ); setResourceBundleFactory( new LibLoaderResourceBundleFactory() ); this.reportConfiguration = new HierarchicalConfiguration( ClassicEngineBoot.getInstance().getGlobalConfig() ); this.parameterValues = new ReportParameterValues(); setPageDefinition( null ); final TableDataFactory dataFactory = new TableDataFactory(); dataFactory.addTable( "default", new DefaultTableModel() ); this.dataFactory = dataFactory; setQuery( "default" ); // Add a listener that will handle keeping the ResourceManager in sync with changes to the Document Bundle addReportModelListener( new DocumentBundleChangeHandler() ); this.reportEnvironment = new DefaultReportEnvironment( getConfiguration() ); this.parameterDefinition = new DefaultParameterDefinition(); final MemoryDocumentBundle documentBundle = new MemoryDocumentBundle(); documentBundle.getWriteableDocumentMetaData().setBundleType( ClassicEngineBoot.BUNDLE_TYPE ); documentBundle.getWriteableDocumentMetaData().setBundleAttribute( ODFMetaAttributeNames.Meta.NAMESPACE, ODFMetaAttributeNames.Meta.CREATION_DATE, new Date() ); setBundle( documentBundle ); setContentBase( documentBundle.getBundleMainKey() ); addReportModelListener( new ResourceBundleChangeHandler() ); updateResourceBundleFactoryInternal(); }
public void testRunWithValidQuery() throws ReportDataFactoryException { final CompoundDataFactory cdf = new CompoundDataFactory(); cdf.add( new TableDataFactory( "query", new DefaultTableModel() ) ); cdf.add( new TableDataFactory( "query", new DefaultTableModel() ) ); final DataFactory tableDataFactory1 = cdf.getReference( 0 ); final DataFactory tableDataFactory2 = cdf.getReference( 1 ); final MasterReport report = new MasterReport(); report.setDataFactory( cdf ); report.setQuery( "query" ); assertFalse( DesignTimeUtil.isSelectedDataSource( report, tableDataFactory2, "query" ) ); assertTrue( DesignTimeUtil.isSelectedDataSource( report, tableDataFactory1, "query" ) ); } }
public void testRunWithInvalidQuery() throws ReportDataFactoryException { final CompoundDataFactory cdf = new CompoundDataFactory(); cdf.add( new TableDataFactory( "query", new DefaultTableModel() ) ); cdf.add( new TableDataFactory( "query", new DefaultTableModel() ) ); final DataFactory tableDataFactory1 = cdf.getReference( 0 ); final DataFactory tableDataFactory2 = cdf.getReference( 1 ); final MasterReport report = new MasterReport(); report.setDataFactory( cdf ); report.setQuery( "default" ); assertFalse( DesignTimeUtil.isSelectedDataSource( report, tableDataFactory2, "query" ) ); assertFalse( DesignTimeUtil.isSelectedDataSource( report, tableDataFactory1, "query" ) ); }
final String query = attrs.getValue( getUri(), "query" ); if ( query != null ) { report.setQuery( query );
@PerfTest( duration = PerfBenchmarkingTest.MAX_DURATION, threads = PerfBenchmarkingTest.MAX_THREADS, rampUp = PerfBenchmarkingTest.MAX_RAMPUP, warmUp = PerfBenchmarkingTest.MAX_WARMUP ) @Test public void perfDataSource() throws Exception { if ( !isExecutePerformanceTest ) { return; } final MasterReport master = new MasterReport(); final TableDataFactory tableDataFactory = new TableDataFactory(); tableDataFactory.addTable( "fruit", createFruitTableModel() ); master.setQuery( "Query Fruit" ); master.setDataFactory( tableDataFactory ); final CompoundDataFactory cdf = new CompoundDataFactory(); cdf.add( tableDataFactory ); master.setDataFactory( cdf ); final CachingDataFactory caDf = new CachingDataFactory( cdf, true ); master.setDataFactory( caDf ); final CompoundDataFactory ccdf = new CascadingDataFactory(); ccdf.add( caDf ); ccdf.add( tableDataFactory ); master.setDataFactory( ccdf ); // assertTrue(ccdf.isQueryExecutable("Query Fruit", new StaticDataRow())); }
final String query = attrs.getValue( getUri(), "query" ); if ( query != null ) { report.setQuery( query );