/*!
* 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.xpath;
import java.io.File;
import java.io.Serializable;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.LinkedHashMap;
import javax.swing.table.TableModel;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.pentaho.reporting.engine.classic.core.AbstractDataFactory;
import org.pentaho.reporting.engine.classic.core.DataFactory;
import org.pentaho.reporting.engine.classic.core.DataRow;
import org.pentaho.reporting.engine.classic.core.ReportDataFactoryException;
import org.pentaho.reporting.libraries.resourceloader.ResourceData;
import org.pentaho.reporting.libraries.resourceloader.ResourceException;
import org.pentaho.reporting.libraries.resourceloader.ResourceKey;
import org.pentaho.reporting.libraries.resourceloader.ResourceManager;
public class XPathDataFactory extends AbstractDataFactory
{
public static class QueryDefinition implements Serializable
{
private boolean legacyQuery;
private String xpathExpression;
public QueryDefinition(final String xpathExpression, final boolean legacyQuery)
{
this.xpathExpression = xpathExpression;
this.legacyQuery = legacyQuery;
}
public boolean isLegacyQuery()
{
return legacyQuery;
}
public String getXpathExpression()
{
return xpathExpression;
}
}
private static final Log logger = LogFactory.getLog(XPathDataFactory.class);
private LinkedHashMap<String, QueryDefinition> queries;
private String xqueryDataFile;
public XPathDataFactory()
{
queries = new LinkedHashMap<String, QueryDefinition>();
}
public String getXqueryDataFile()
{
return xqueryDataFile;
}
public void setXqueryDataFile(final String xqueryDataFile)
{
this.xqueryDataFile = xqueryDataFile;
}
public void setQuery(final String name, final String value, final boolean legacyQuery)
{
if (value == null)
{
queries.remove(name);
}
else
{
queries.put(name, new QueryDefinition(value, legacyQuery));
}
}
public QueryDefinition getQuery(final String name)
{
return queries.get(name);
}
public String[] getQueryNames()
{
return queries.keySet().toArray(new String[queries.size()]);
}
/**
* 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.
* <p/>
* 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.
*/
public TableModel queryData(final String query, final DataRow parameters) throws ReportDataFactoryException
{
final QueryDefinition xpath = queries.get(query);
if (xpath == null)
{
throw new ReportDataFactoryException("No such query");
}
final int queryLimitVal;
final Object queryLimit = parameters.get(DataFactory.QUERY_LIMIT);
if (queryLimit instanceof Number)
{
final Number i = (Number) queryLimit;
queryLimitVal = i.intValue();
}
else
{
queryLimitVal = -1;
}
try
{
final ResourceManager resourceManager = getResourceManager();
final ResourceData resource = load();
if (xpath.isLegacyQuery())
{
return new LegacyXPathTableModel(resource, resourceManager, xpath.getXpathExpression(), parameters, queryLimitVal);
}
return new XPathTableModel(resource, resourceManager, xpath.getXpathExpression(), parameters, queryLimitVal);
}
catch (ResourceException re)
{
throw new ReportDataFactoryException("Failed to load XML data", re);
}
}
private ResourceData load() throws ResourceException
{
try
{
final ResourceKey resourceKey;
final ResourceKey contextKey = getContextKey();
if (contextKey != null)
{
final ResourceManager resourceManager = getResourceManager();
resourceKey = resourceManager.deriveKey(contextKey, getXqueryDataFile());
return resourceManager.load(resourceKey);
}
}
catch (ResourceException re)
{
// failed to load from context
logger.debug("Failed to load datasource as derived path: " + re);
}
try
{
final ResourceManager resourceManager = getResourceManager();
final ResourceKey resourceKey = resourceManager.createKey(new URL(getXqueryDataFile()));
return resourceManager.load(resourceKey);
}
catch (ResourceException re)
{
logger.debug("Failed to load datasource as URL: " + re);
}
catch (MalformedURLException e)
{
//
}
try
{
final ResourceManager resourceManager = getResourceManager();
final ResourceKey resourceKey = resourceManager.createKey(new File(getXqueryDataFile()));
return resourceManager.load(resourceKey);
}
catch (ResourceException re)
{
// failed to load from context
logger.debug("Failed to load datasource as file: " + re);
}
throw new ResourceException("Unable to load the resource");
}
public XPathDataFactory clone()
{
final XPathDataFactory dataFactory = (XPathDataFactory) super.clone();
//noinspection unchecked
dataFactory.queries = (LinkedHashMap<String, QueryDefinition>) queries.clone();
return dataFactory;
}
/**
* Returns a copy of the data factory that is not affected by its anchestor and holds no connection to the anchestor
* anymore. A data-factory will be derived at the beginning of the report processing.
*
* @return a copy of the data factory.
*/
public XPathDataFactory derive()
{
return clone();
}
/**
* Closes the data factory and frees all resources held by this instance.
*/
public void close()
{
}
/**
* Checks whether the query would be executable by this datafactory. This performs a rough check, not a full query.
*
* @param query
* @param parameters
* @return
*/
public boolean isQueryExecutable(final String query, final DataRow parameters)
{
return queries.containsKey(query);
}
}