QueryTest.java

Go to the documentation of this file.

package cedar.hepdata.webapp;

import cedar.hepdata.model.*;
import cedar.hepdata.xml.*;

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class QueryTest extends HttpServlet {

    public String getServletInfo() {
        return "Test servlet. Do not use.";
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws IOException, ServletException
    {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        out.println("Currently disabled while the db code is refactored");

//         // Get params from the query string
//         String irnStr = request.getParameter("irn");
//         String reacStr = request.getParameter("reac");
//         String obsStr = request.getParameter("obs");
//         String exptStr = request.getParameter("expt");
//         String detrStr = request.getParameter("detr");
//         if (irnStr == null)  irnStr = "";
//         if (obsStr == null)  obsStr = "";
//         if (reacStr == null) reacStr = "K+ P --> K0 X";
//         if (exptStr == null) exptStr = "";
//         if (detrStr == null) detrStr = "";

        try {
//             String exptquery = "SELECT * FROM experiment WHERE description NOT LIKE '\\?%' ORDER BY description";
//             String detrquery = "SELECT * FROM detector WHERE description NOT LIKE '\\?%' ORDER BY description";

//             // Write out query form
//             out.println("<h1>HepData query testing</h1>");
//             out.println("<form style=\"margin-bottom:1em; padding:0.5em; background:beige; border:2px solid lightgrey;\" method=\"GET\" action=\"/server/hepdata-test/query\" />");
//             out.println("<p>Empty fields will match any value of the corresponding quantity:</p>");
//             out.println("<table>");
//             // IRN field
//             out.println("<tr><td><label for=\"irn\">Paper IRN: </label></td>");
//             out.println("<td><input name=\"irn\" type=\"text\" value=\"" + irnStr + "\" size=\"20\"></td></tr>");
//             // Reaction field
//             out.println("<tr><td><label for=\"reac\">Reaction: </label></td>");
//             out.println("<td><input name=\"reac\" type=\"text\" value=\"" + reacStr + "\" size=\"20\"></td></tr>");
//             // Observable field
//             out.println("<tr><td><label for=\"obs\">Observable: </label></td>");
//             out.println("<td><select name=\"obs\">");
//             out.println("<option value=\"ANY\">Any</option>");
//             out.println("<option value=\"SIG\">Cross-section</option>");
//             out.println("<option value=\"SQRTS\">CoM energy</option>");
//             out.println("</select></td></tr>");
//             // Experiment field
//             /*
//             out.println("<tr><td><label for=\"expt\">Experiment: </label></td>");
//             out.println("<td><select name=\"expt\">");
//             out.println("<option value=\"ANY\">Any</option>");
//             while (rsexpts.next()) {
//                 String exptDesc = rsexpts.getString("description");
//                 String exptId = rsexpts.getString("experiment_id");
//                 if (exptId != null && exptDesc != null) {
//                     out.print("<option value=\"" + exptId + "\"");
//                     if (exptStr.equals(exptId)) {
//                         out.print(" selected=\"selected\"");
//                     }
//                     out.println(">" + exptDesc + "</option>");
//                 }
//             }
//             out.println("</select></td></tr>");
//             */
//             // Detector field
//             out.println("<tr><td><label for=\"expt\">Detector: </label></td>");
//             out.println("<td><select name=\"detr\">");
//             out.println("<option value=\"ANY\">Any</option>");
//             while (rsdetrs.next()) {
//                 String detrDesc = rsdetrs.getString("description");
//                 String detrId = rsdetrs.getString("detector_id");
//                 if (detrId != null && detrDesc != null) {
//                     out.print("<option value=\"" + detrId + "\"");
//                     if (detrStr.equals(detrId)) {
//                         out.print(" selected=\"selected\"");
//                     }
//                     out.println(">" + detrDesc + "</option>");
//                 }
//             }
//             out.println("</select></td></tr>");
//             // Submit button
//             out.println("<tr><td/><td><input type=\"submit\" value=\"Go!\" style=\"float:right\" /></td></tr>");
//             out.println("</table>");
//             out.println("</form>");

//             // Show params from query string
//             // out.println("<h3>Params:</h3>");
//             // out.println("<ul>");
//             // out.println("<li>irn  = " + irnStr + "</li>");
//             // out.println("<li>obs  = " + obsStr  + "</li>");
//             // out.println("<li>reac = " + reacStr + "</li>");
//             // out.println("<li>expt = " + exptStr + "</li>");
//             // out.println("</ul>");

//             //Vector<String> finalstate = new Vector<String>();
//             //finalstate.add("K+");
//             //finalstate.add("PI-");

//             // Build SQL query
//             String query = new String();
//             query += "SELECT DISTINCT kr.paper_id paperId, kr.ds_id dsId, o.description obsDesc, r.description reacDesc ";
//             query += "FROM (keyword kr JOIN keyword ko USING (paper_id,ds_id)) ";
//             query += "JOIN observable o ON o.observable_id=ko.observable_id ";
//             query += "JOIN reaction r ON r.reaction_id=kr.reaction_id ";
//             query += "JOIN final_particle fp ON fp.reaction_id=r.reaction_id ";
//             query += "JOIN particle p ON p.particle_id=fp.particle_id ";
//             query += "JOIN paper ON paper.paper_id=kr.paper_id ";
//             query += "JOIN paper_experiment pp_ex ON pp_ex.paper_id=kr.paper_id ";
//             query += "JOIN experiment ex ON ex.experiment_id=pp_ex.experiment_id ";
//             query += "JOIN paper_detector pp_det ON pp_det.paper_id=kr.paper_id ";
//             query += "JOIN detector det ON det.detector_id=pp_det.detector_id ";
//             query += "WHERE (ko.observable_id IS NOT NULL and kr.reaction_id IS NOT NULL) ";
//             // Handle conditional bits of the query:
//             // IRN
//             if (irnStr != null && irnStr.length() != 0 && ! irnStr.equalsIgnoreCase("ANY")) {
//                 query += "AND paper.irn=" + irnStr + " ";
//             }
//             // Observable
//             if (obsStr != null && obsStr.length() != 0 && ! obsStr.equalsIgnoreCase("ANY")) {
//                 query += "AND o.description='" + obsStr + "' ";
//             }
//             // Reaction (we may need to be able to do SQL UNION operations on the final states)
//             if (reacStr != null && reacStr.length() != 0 && ! reacStr.equalsIgnoreCase("ANY")) {
//                 query += "AND r.description='" + reacStr + "' ";
//             }
//             // Experiment
//             if (exptStr != null && exptStr.length() != 0 && ! exptStr.equalsIgnoreCase("ANY")) {
//                 query += "AND ex.experiment_id=" + exptStr + " ";
//             }
//             // Detector
//             if (detrStr != null && detrStr.length() != 0 && ! detrStr.equalsIgnoreCase("ANY")) {
//                 query += "AND det.detector_id=" + detrStr + " ";
//             }
//             query += "LIMIT 100;";

//             // Database searching
//             //Statement stmt = DBConfig.getConnection().createStatement();
//             ResultSet rs = stmt.executeQuery(query);
//             out.println("<h3>Results</h3>");
//             out.println("<p>Click on the paper or dataset link to see the data:</p>");
//             out.println("<ol>");
//             while (rs.next()) {
//                 Integer paperId = new Integer(rs.getString("paperId"));
//                 Integer dsId = new Integer(rs.getString("dsId"));
//                 Paper paper = new Paper((int) paperId);
//                 Integer irn = paper.getIrn();
//                 out.println("<li>");
//                 if (irn != null) { out.println("<a href=\"/server/hepdata-test/xsl?irn=" + irn + "\">"); }
//                 out.println("Paper " + paperId);
//                 if (irn != null) { out.println("</a>"); }
//                 out.println(", ");
//                 if (irn != null) { out.println("<a href=\"/server/hepdata-test/xsl?irn=" + irn + "#dataset" + dsId + "\">"); }
//                 out.println("dataset " + dsId);
//                 if (irn != null) { out.println("</a>"); }
//                 out.print(": " + rs.getString("obsDesc") + " / " + rs.getString("reacDesc"));
//                 Dataset ds = new Dataset(paperId, dsId);
//                 out.println(" " + ds.toString());
//                 out.println("</li>");
//             }
//             out.println("</ol>");

//             // Close up...
//             rs.close();
//             stmt.close();

//             // Write out SQL query
//             out.println("<h3>SQL query (for debug)</h3>");
//             out.println("<code style=\"font-size:50%\">" + query + "</code>");
//             out.println("<br/>");

        } catch (Exception e) {
            out.println("Exception: " + e.toString());
        }

    }
}

---