org.saiku.reporting.backend.rest.MetadataDiscoverResource.java Source code

Introduction

Here is the source code for org.saiku.reporting.backend.rest.MetadataDiscoverResource.java

Source

/*******************************************************************************
 * Copyright 2013 Marius Giepz
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *   http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 ******************************************************************************/
package org.saiku.reporting.backend.rest;

import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;

import javax.servlet.http.HttpServletRequest;
import javax.ws.rs.Consumes;
import javax.ws.rs.FormParam;
import javax.ws.rs.GET;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.PathParam;
import javax.ws.rs.Produces;
import javax.ws.rs.core.Context;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.pentaho.di.core.database.DatabaseMeta;
import org.pentaho.metadata.model.SqlPhysicalModel;
import org.pentaho.metadata.query.impl.sql.MappedQuery;
import org.pentaho.metadata.query.impl.sql.SqlGenerator;
import org.pentaho.metadata.query.model.Query;
import org.pentaho.metadata.query.model.util.QueryXmlHelper;
import org.pentaho.metadata.util.ThinModelConverter;
import org.pentaho.reporting.engine.classic.core.util.PageFormatFactory;
import org.saiku.reporting.backend.exceptions.MetadataException;
import org.saiku.reporting.backend.exceptions.SaikuClientException;
import org.saiku.reporting.backend.objects.dto.SqlString;
import org.saiku.reporting.backend.objects.metadata.impl.MetadataModel;
import org.saiku.reporting.backend.objects.metadata.impl.MetadataModelInfo;
import org.saiku.reporting.backend.server.MetadataRepository;
import org.saiku.reporting.core.model.ReportSpecification;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Component;

@Component
@Path("saiku-reporting/api/metadata/discover")
@Scope("request")
public class MetadataDiscoverResource {

    public void setMetadataRepository(MetadataRepository metadataRepository) {
        this.metadataRepository = metadataRepository;
    }

    private static final Log log = LogFactory.getLog(MetadataDiscoverResource.class);

    private MetadataRepository metadataRepository;

    /**
     * Returns the datasources available.
     */
    @GET
    @Produces({ "application/json" })
    @Path("/{locale}")
    public MetadataModelInfo[] getModelInfos(@Context HttpServletRequest request) {

        try {

            if (log.isDebugEnabled()) {
                log.debug("REST:GET " + " getModelInfos");
            }

            return metadataRepository.getBusinessModels("", request.getLocale());

        } catch (MetadataException e) {
            log.error(this.getClass().getName(), e);
            return new MetadataModelInfo[] {};
        }
    }

    //    @GET
    //    @Produces({"application/json"})
    //    @Path("/templates")
    //    public String[] getavailable(){
    //       return new String[]{"a","b"};
    //    }

    @GET
    @Produces({ "application/json" })
    @Path("/{domainId}/{modelId}/model")
    public MetadataModel getModel(@PathParam("domainId") String domainId, @PathParam("modelId") String modelId) {
        try {

            if (log.isDebugEnabled()) {
                log.debug("REST:GET " + " getModel domainId=" + domainId + " modelId=" + modelId);
            }

            return metadataRepository.loadModel(URLDecoder.decode(domainId, "UTF-8"), modelId);
        } catch (UnsupportedEncodingException e) {
            log.error(e);
        }
        return null;
    }

    /**
     * Returns the available page formats.
     */
    @GET
    @Produces({ "application/json" })
    @Path("/pageformats")
    public String[] getPageFormats() {

        return PageFormatFactory.getInstance().getPageFormats();

    }

    @POST
    @Produces({ "application/json" })
    @Consumes({ "application/json" })
    @Path("/sql")
    public SqlString getQuerySql(String mqlQueryString) {

        try {

            QueryXmlHelper queryXmlHelper = new QueryXmlHelper();
            Query query = queryXmlHelper.fromXML(metadataRepository.getMetadataDomainRepository(), mqlQueryString);

            SqlPhysicalModel sqlModel = (SqlPhysicalModel) query.getLogicalModel().getPhysicalModel();
            DatabaseMeta databaseMeta = ThinModelConverter.convertToLegacy(sqlModel.getId(),
                    sqlModel.getDatasource());

            SqlGenerator sqlgen = new SqlGenerator();

            MappedQuery mappedQuery = sqlgen.generateSql(query, "en",
                    metadataRepository.getMetadataDomainRepository(), databaseMeta);

            return new SqlString(mappedQuery.getQuery());

        } catch (Exception e) {
            log.error("Cannot get sql", e);
            throw new SaikuClientException(e.getMessage());
        }

    }

}