/*!
* This program is free software; you can redistribute it and/or modify it under the
* terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software
* Foundation.
*
* You should have received a copy of the GNU Lesser General Public License along with this
* program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
* or from the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*
* This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU Lesser General Public License for more details.
*
* Copyright (c) 2002-2017 Pentaho Corporation.. All rights reserved.
*/
package org.pentaho.reporting.engine.classic.extensions.datasources.mondrian;
import junit.framework.TestCase;
import org.pentaho.reporting.engine.classic.core.ClassicEngineBoot;
import org.pentaho.reporting.engine.classic.core.DataFactory;
import org.pentaho.reporting.engine.classic.core.ParameterDataRow;
import org.pentaho.reporting.engine.classic.core.ReportDataFactoryException;
import org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory;
import org.pentaho.reporting.engine.classic.core.testsupport.DebugJndiContextFactoryBuilder;
import javax.naming.spi.NamingManager;
import javax.swing.table.TableModel;
public class EmptyCellsetTest extends TestCase {
public void setUp() throws Exception {
ClassicEngineBoot.getInstance().start();
if ( NamingManager.hasInitialContextFactoryBuilder() == false ) {
NamingManager.setInitialContextFactoryBuilder( new DebugJndiContextFactoryBuilder() );
}
}
/**
* Validates that queries with empty results (no rows or no columns) are correctly handled by CachingDataFactory.
* <p/>
* http://jira.pentaho.com/browse/PRD-4628
*/
public void testEmptyResult() throws ReportDataFactoryException {
final String query = "SELECT NON EMPTY [Product].[All Products].[Classic Cars]"
+ ".[Highway 66 Mini Classics].[1985 Toyota Supra] "
+ "on 0 from SteelWheelsSales where measures.Sales\n";
DataFactory dataFactory = createDataFactory( query );
final TableModel tableModel = ( (CachingDataFactory) dataFactory )
.queryStatic( "default", new ParameterDataRow() );
assertEquals( "results should be empty, rowcount should be 0.",
0, tableModel.getRowCount() );
assertEquals( "results should be empty, columncount should be 0",
0, tableModel.getColumnCount() );
}
protected DataFactory createDataFactory( final String query ) throws ReportDataFactoryException {
final DriverDataSourceProvider provider = new DriverDataSourceProvider();
provider.setDriver( "org.hsqldb.jdbcDriver" );
provider.setUrl( "jdbc:hsqldb:mem:SampleData" );
final BandedMDXDataFactory mondrianDataFactory = new BandedMDXDataFactory();
mondrianDataFactory.setCubeFileProvider( new DefaultCubeFileProvider
( "src/test/resources/org/pentaho/reporting/engine/classic/extensions/datasources/mondrian/steelwheels.mondrian.xml" ) );
mondrianDataFactory.setDataSourceProvider( provider );
mondrianDataFactory.setJdbcUser( "sa" );
mondrianDataFactory.setJdbcPassword( "" );
mondrianDataFactory.setQuery( "default", query, null, null );
CachingDataFactory cachingFactory = new CachingDataFactory( mondrianDataFactory, true );
return cachingFactory;
}
}