com.googlecode.psiprobe.controllers.sql.QueryHistoryItemController.java Source code

Introduction

Here is the source code for com.googlecode.psiprobe.controllers.sql.QueryHistoryItemController.java

Source

/*
 * Licensed under the GPL License.  You may not use this file except in
 * compliance with the License.  You may obtain a copy of the License at
 *
 *     http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 *
 * THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
 * WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
 * MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
 */
package com.googlecode.psiprobe.controllers.sql;

import com.googlecode.psiprobe.model.sql.DataSourceTestInfo;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.web.bind.ServletRequestUtils;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractController;

/**
 * Retrieves a single query from a history list.
 * 
 * @author Andy Shapoval
 */
public class QueryHistoryItemController extends AbstractController {
    protected ModelAndView handleRequestInternal(HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        int sqlId = ServletRequestUtils.getIntParameter(request, "sqlId", -1);

        HttpSession sess = request.getSession(false);

        if (sess != null) {
            DataSourceTestInfo sessData = (DataSourceTestInfo) sess
                    .getAttribute(DataSourceTestInfo.DS_TEST_SESS_ATTR);

            if (sessData != null) {
                List queryHistory = sessData.getQueryHistory();

                if (queryHistory != null) {
                    try {
                        String sql = (String) queryHistory.get(sqlId);
                        response.setCharacterEncoding("UTF-8");
                        response.getWriter().print(sql);
                    } catch (IndexOutOfBoundsException e) {
                        logger.error("Cannot find a query history entry for history item id = " + sqlId);
                    }
                }
            }
        }

        return null;
    }
}