/*!
* 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-2013 Pentaho Corporation.. All rights reserved.
*/
package org.pentaho.reporting.engine.classic.extensions.datasources.mondrian;
import javax.naming.spi.NamingManager;
import javax.swing.table.TableModel;
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;
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.
*
* 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
("test/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;
}
}