org.ohdsi.webapi.service.TherapyPathResultsService.java Source code

Introduction

Here is the source code for org.ohdsi.webapi.service.TherapyPathResultsService.java

Source

/*
 * 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.ohdsi.webapi.service;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import javax.ws.rs.Consumes;
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.MediaType;
import org.ohdsi.sql.SqlRender;
import org.ohdsi.sql.SqlTranslate;
import org.ohdsi.webapi.helper.ResourceHelper;
import org.ohdsi.webapi.source.Source;
import org.ohdsi.webapi.source.SourceDaimon;
import org.ohdsi.webapi.therapy.TherapyPathReport;
import org.ohdsi.webapi.therapy.TherapyPathVector;
import org.ohdsi.webapi.therapy.TherapySummary;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Component;

/**
 *
 * @author fdefalco
 *
 * I envision this eventually being subsumed within the cohortresults service
 *
 */
@Path("{sourceKey}/txpathresults/")
@Component
public class TherapyPathResultsService extends AbstractDaoService {

    @Path("reports")
    @GET
    @Produces(MediaType.APPLICATION_JSON)
    public List<TherapyPathReport> getReports(@PathParam("sourceKey") String sourceKey) {
        try {

            Source source = getSourceRepository().findBySourceKey(sourceKey);
            String tableQualifier = source.getTableQualifier(SourceDaimon.DaimonType.Results);

            String sql_statement = ResourceHelper
                    .GetResourceAsString("/resources/therapypathresults/sql/getTherapyPathReports.sql");
            sql_statement = SqlRender.renderSql(sql_statement, new String[] { "OHDSI_schema" },
                    new String[] { tableQualifier });
            sql_statement = SqlTranslate.translateSql(sql_statement, "sql server", source.getSourceDialect());
            return getSourceJdbcTemplate(source).query(sql_statement, new RowMapper<TherapyPathReport>() {
                @Override
                public TherapyPathReport mapRow(final ResultSet rs, final int arg1) throws SQLException {
                    final TherapyPathReport report = new TherapyPathReport();
                    report.reportId = rs.getInt(1);
                    report.reportCaption = rs.getString(2);
                    report.year = Integer.toString(rs.getInt(3));

                    if (report.year.equals("9999")) {
                        report.year = "All Years";
                    }

                    report.disease = rs.getString(4);
                    report.datasource = rs.getString(5);
                    return report;
                }
            });
        } catch (Exception exception) {
            throw new RuntimeException("Error getting therapy path reports" + exception.getMessage());
        }
    }

    @Path("report/{id}")
    @GET
    @Produces(MediaType.APPLICATION_JSON)
    public List<TherapyPathVector> getTherapyPathVectors(@PathParam("id") String id,
            @PathParam("sourceKey") String sourceKey) {
        try {

            Source source = getSourceRepository().findBySourceKey(sourceKey);
            String tableQualifier = source.getTableQualifier(SourceDaimon.DaimonType.Results);

            String sql_statement = ResourceHelper
                    .GetResourceAsString("/resources/therapypathresults/sql/getTherapyPathVectors.sql");
            sql_statement = SqlRender.renderSql(sql_statement, new String[] { "id" }, new String[] { id });
            sql_statement = SqlTranslate.translateSql(sql_statement, "sql server", source.getSourceDialect());
            return getSourceJdbcTemplate(source).query(sql_statement, new RowMapper<TherapyPathVector>() {
                @Override
                public TherapyPathVector mapRow(final ResultSet rs, final int arg1) throws SQLException {
                    final TherapyPathVector vector = new TherapyPathVector();
                    vector.key = rs.getString("ResultKey");
                    vector.count = rs.getInt("ResultCount");
                    return vector;
                }
            });
        } catch (Exception exception) {
            throw new RuntimeException("Error getting therapy path vectors - " + exception.getMessage());
        }
    }

    @Path("summary")
    @POST
    @Produces(MediaType.APPLICATION_JSON)
    @Consumes(MediaType.APPLICATION_JSON)
    public List<TherapySummary> getSummaries(@PathParam("sourceKey") String sourceKey, String[] identifiers) {
        try {
            String sql_statement = ResourceHelper
                    .GetResourceAsString("/resources/therapypathresults/sql/getTherapySummaries.sql");

            Source source = getSourceRepository().findBySourceKey(sourceKey);
            String tableQualifier = source.getTableQualifier(SourceDaimon.DaimonType.Results);

            String identifiersList = "";
            for (String identifier : identifiers) {
                if (identifiersList.length() > 0) {
                    identifiersList += ", ";
                }

                identifiersList += identifier;
            }

            sql_statement = SqlRender.renderSql(sql_statement, new String[] { "identifiersList" },
                    new String[] { identifiersList });
            sql_statement = SqlTranslate.translateSql(sql_statement, "sql server", source.getSourceDialect());
            return getSourceJdbcTemplate(source).query(sql_statement, new RowMapper<TherapySummary>() {
                @Override
                public TherapySummary mapRow(final ResultSet rs, final int arg1) throws SQLException {
                    final TherapySummary summary = new TherapySummary();
                    summary.key = rs.getString(1);
                    summary.name = rs.getString(2);
                    summary.tx1 = rs.getInt(3);
                    summary.tx2 = rs.getInt(4);
                    summary.tx3 = rs.getInt(5);
                    summary.total = rs.getInt(6);
                    return summary;
                }
            });
        } catch (Exception exception) {
            throw new RuntimeException("Error getting therapy path summary - " + exception.getMessage());
        }
    }
}