FindYAxisPhysics2.java

Go to the documentation of this file.

package cedar.hepdata.webapp.pages;

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

import org.apache.tapestry5.annotations.*;
import org.apache.tapestry5.ioc.annotations.*;
import org.apache.tapestry5.services.*;
import org.apache.tapestry5.MarkupWriter;

import org.hibernate.*;
import org.hibernate.criterion.*;
import java.util.*;
//import java.math.*;

public class FindYAxisPhysics2{

    @Inject
    private RequestGlobals _reqGlobals;

    @Inject
    private org.hibernate.Session _session;

    public String getQueryParam(String param){
       return _reqGlobals.getRequest().getParameter(param);
    }

    public String getQueryParameters(){
        StringBuffer qs = new StringBuffer();
        String mid = "";
        int number =  Integer.parseInt(getQueryParam("number"));
        int newstart = Integer.parseInt(getQueryParam("start"));
        newstart += number;
        qs.append(mid + "reac=" + getQueryParam("reac"));  mid = "&";
        qs.append(mid + "obs=" + getQueryParam("obs"));  mid = "&";
        qs.append(mid + "sqrtslo=" + getQueryParam("sqrtslo"));  mid = "&";
        qs.append(mid + "number=" + getQueryParam("number") + mid + "start=" + Integer.toString(newstart));
        return qs.toString().replaceAll("\\+","%2B");
    }

    public String getFirstNumber(){
       return getQueryParam("start");
    }

    public String getSearchString(){
        StringBuffer qs = new StringBuffer();
        qs.append("(");
        qs.append(getQueryParam("reac"));
        qs.append(")");
        qs.append(" " + getQueryParam("obs"));
        qs.append(" " + getQueryParam("sqrtslo"));
        qs.append(" " + getQueryParam("sqrtshi"));
        return qs.toString();
    }

    public String getLastNumber(){
        int first =  Integer.parseInt(getQueryParam("start"));
        int number = Integer.parseInt(getQueryParam("number"));
        int last = first + number - 1;
        return Integer.toString(last);
   }

    public String getPageSize(){
       return getQueryParam("number");
    }

    public Long getCount(){
        return (Long) constructQuery("count").uniqueResult();
    }

 
    private String getInitialState(String r){
        String is="";
        int ipos = r.indexOf("-->");
        if(ipos > -1 ){ is = r.substring(0,ipos); }
        else { is = r; }
        return is.trim();
    }
    private String getFinalState(String r){
        String fs="";
        int ipos = r.indexOf("-->");
        if(ipos > -1) {fs = r.substring(ipos+3);}
        return fs.trim();
    }

// test list output

    private Paper _currentPaper;

    public Paper getPaper() { return _currentPaper; }
    public void setPaper(Paper p) { _currentPaper = p; }

    private Map <Paper,ArrayList<YAxis>> map = new HashMap<Paper,ArrayList<YAxis>>();
    
    public Set <Paper> getPapers() {
        Query q = constructQuery();
        int first = Integer.parseInt(getQueryParam("start"));
        first=first-1;
        
//      q.setFirstResult(first).setMaxResults(Integer.parseInt(getQueryParam("number")));
//      q.setFirstResult(first).setMaxResults(50);

        map.clear();
        for (Iterator it=q.iterate(); it.hasNext(); ){
            YAxis _yAxis = (YAxis) it.next();
            Paper _paper=_yAxis.getDataset().getPaper();
            if(map.get(_paper) == null) { map.put(_paper,new ArrayList<YAxis>());}
            map.get(_paper).add(_yAxis);
            if (map.size() > (Integer.parseInt(getQueryParam("number"))-1)) { break; }
        }
        return map.keySet();
    }


    private YAxis _yAxis;

    public YAxis getYAxis() { return _yAxis; }
    public void setYAxis(YAxis yax) { _yAxis = yax; }

    public List <YAxis> getYAxes(){
       return map.get(_currentPaper);
    }



    private Query constructQuery(){
        return this.constructQuery("blank");
    }

    private Query constructQuery(String flag){

        List <String> isp = new ArrayList();
        List  <String> fsp = new ArrayList();
        List <String>  mfsp = new ArrayList();
        
        if( getQueryParam("reac") != "") {
            String is = getInitialState(getQueryParam("reac"));
            java.util.StringTokenizer stis = new java.util.StringTokenizer(is);
            while(stis.hasMoreTokens()){
               isp.add(stis.nextToken());
            }
            String fs = getFinalState(getQueryParam("reac"));
            java.util.StringTokenizer stfs = new java.util.StringTokenizer(fs);
            String st = "";
            while(stfs.hasMoreTokens()){
                st = stfs.nextToken();
                if(st.matches("^[A-Za-z].*")){
                    fsp.add(st);
                    mfsp.add("1");
                }
                else{
                    fsp.add(st.substring(1));
                    mfsp.add(st.substring(0,1));
                }
            }
        }
        String theObs = "";
        if ( getQueryParam("obs")  != "") { theObs  = getQueryParam("obs");  }
        
        String theSqrtsLo = "";
        if ( getQueryParam("sqrtslo")  != "") { theSqrtsLo  = getQueryParam("sqrtslo");  }

//        System.out.println("this is a line output" + " " + isp.size() + " " + fsp.size());
        Query q = null;

        // the string buffer way!!
        StringBuffer b = new StringBuffer();

        // assuming a spiresid search first 
        // assuming we have a beam particle next 
        if(isp.size() > 0){
//select...
            if (flag == "count"){
                b.append("select count(distinct yabeam) from YAxis yabeam");
            }
            else{
                b.append("select distinct yabeam from YAxis yabeam");
            }
//joins....
            b.append(" join yabeam._reactions yrbeam");
            b.append(" join yrbeam._initialState beam"); 
            if (isp.size() > 1){ 
                b.append(",YAxis yatarg");
                b.append(" join yatarg._reactions yrtarg");
                b.append(" join yrtarg._initialState targ"); 
            }
            for (int i = 1 ; i <= fsp.size(); i++){ 
               b.append(",YAxis yafsp"+i);
               b.append(" join yafsp"+i+"._reactions yrfsp"+i);
               b.append(" join yrfsp"+i+"._finalState fsp"+i);
            }
            if(theSqrtsLo != ""){
               b.append(",YAxis yaprop");
               b.append(" join yaprop._properties prop");
            }  
//where...
            b.append(" where beam.name=:beampart");
            if (isp.size() > 1){ 
                b.append(" and targ.name=:targpart");  
                b.append(" and yrbeam = yrtarg");
            } 
            for (int i = 1 ; i <= fsp.size(); i++){ 
               b.append(" and fsp"+i+".name=:fsp"+i+"part and fsp"+i+".multiplicity=:fsp"+i+"mult");
               b.append(" and yrbeam = yrfsp"+i);
            }
            if (theObs  != "") { b.append(" and yabeam._observable like:observable"); } 
            if(theSqrtsLo != ""){ 
                b.append(" and yabeam = yaprop");
                b.append(" and prop._name like 'sqrts' and prop._lowValue>:sqrtslo");
            }

//create query
//make substitutions
            q = _session.createQuery(b.toString());
            q.setString("beampart",isp.get(0));
            if (isp.size() > 1)  {q.setString( "targpart",isp.get(1)); }
            for (int i = 1 ; i <= fsp.size(); i++){
                q.setString( "fsp"+i+"part",fsp.get(i-1));
                q.setString( "fsp"+i+"mult",mfsp.get(i-1)); 
            }
            System.out.println(theObs);
            if (theObs  != "")   {q.setString( "observable",theObs); }
            if (theSqrtsLo  != "")   {q.setString( "sqrtslo",theSqrtsLo); }
        }

        // no inital state so next assuming we have a fsp
        else if(fsp.size() > 0) {
//select(no initialstate)...
            if (flag == "count"){
                b.append("select count(distinct yafsp1) from YAxis yafsp1");
            }
            else{
                b.append("select distinct yafsp1 from YAxis yafsp1");
            }
//joins(no initialstate)...
            b.append(" join yafsp1._reactions yrfsp1");
            b.append(" join yrfsp1._finalState fsp1"); 
            for (int i = 2 ; i <= fsp.size(); i++){ 
               b.append(",YAxis yafsp"+i);
               b.append(" join yafsp"+i+"._reactions yrfsp"+i);
               b.append(" join yrfsp"+i+"._finalState fsp"+i);
            }
            if(theSqrtsLo != ""){
               b.append(",YAxis yaprop");
               b.append(" join yaprop._properties prop");
            }  
//where(no initialstate)...
            b.append(" where fsp1.name=:fsp1part and fsp1.multiplicity=:fsp1mult"); 
            for (int i = 2 ; i <= fsp.size(); i++){ 
               b.append(" and fsp"+i+".name=:fsp"+i+"part and fsp"+i+".multiplicity=:fsp"+i+"mult");
               b.append(" and yrfsp1 = yrfsp"+i);
            }
            if (theObs  != ""){ b.append(" and yafsp1._observable like:observable"); } 
            if(theSqrtsLo != ""){ 
                b.append(" and yafsp1 = yaprop");
                b.append(" and prop._name like 'sqrts' and prop._lowValue>:sqrtslo");
            }
//create query...
//make substitutions...
            q = _session.createQuery(b.toString());
            for (int i = 1 ; i <= fsp.size(); i++){
              q.setString("fsp"+i+"part",fsp.get(i-1)); 
              q.setString("fsp"+i+"mult",mfsp.get(i-1)); 
            }
            if (theObs  != "") {q.setString("observable",theObs);}
            if (theSqrtsLo  != "")   {q.setString( "sqrtslo",theSqrtsLo); }
        }
// OK no reaction  .. so do we have an observable? 
        else if(theObs != "") {
            if (flag == "count"){
                b.append("select count(distinct yaobs) from YAxis yaobs");
            }
            else{
                b.append("select distinct yaobs from YAxis yaobs");
            }
            if(theSqrtsLo != ""){
               b.append(",YAxis yaprop");
               b.append(" join yaprop._properties prop");
            }  
            b.append(" where yaobs._observable like:observable");  
            if(theSqrtsLo != ""){ 
                b.append(" and yaobs = yaprop");
                b.append(" and prop._name like 'sqrts' and prop._lowValue>:sqrtslo");
            }
            q = _session.createQuery(b.toString());
            q.setString("observable",theObs);
            if (theSqrtsLo  != "")   {q.setString( "sqrtslo",theSqrtsLo); }
        }

// here if sqrtslo on its own ! just to test 
        else if(theSqrtsLo != "") {
            if (flag == "count"){
                b.append("select count(distinct yaprop) from YAxis yaprop");
            }
            else{
                b.append("select distinct yaprop from YAxis yaprop");
            }
            b.append(" join yaprop._properties prop");

            b.append(" where prop._name like 'sqrts' and prop._lowValue>:sqrtslo");

            q = _session.createQuery(b.toString());
            q.setString("sqrtslo",theSqrtsLo);
        }
// nothing left so must want everything !!
        else{
            if (flag == "count"){
                b.append("select count(distinct ya) from YAxis ya");
            }
            else{
                b.append("select distinct ya from YAxis ya");
            }
            q = _session.createQuery(b.toString());
        }

        // how many results do we want out
//      q.setMaxResults(Integer.parseInt(getQueryParam("number")));

        // execute the query and return the list of results
        System.out.println(q.toString());
        return q;

    }
}

---