TestSearch.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.hibernate.*;
import org.hibernate.criterion.*;
import java.util.*;


public class TestSearch{

    @Inject
    private RequestGlobals _reqGlobals;

    @Inject
    private org.hibernate.Session _session;

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

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



//YAxes
    private YAxis _yaxis;
    public YAxis getYAxis() { return _yaxis; }
    public void setYAxis(YAxis y) { _yaxis = y; }
   
    public List <YAxis> getYAxes(){
        Query q = constructQuery();
        // how many results do we want out
        q.setMaxResults(Integer.parseInt(getQueryParam("number")));
        // execute the query and return the list of results
        return q.list();   
    }

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

    public Query constructQuery(String flag){
        
        String theBeam = "";
        String theTarg = "";
        String theFsp1 = "";
        String theFsp2 = "";
        String theFsp3 = "";
        String theMFsp1 = "";
        String theMFsp2 = "";
        String theMFsp3 = "";
        String theObs = "";
        if ( getQueryParam("beam") != "") { theBeam = getQueryParam("beam"); }
        if ( getQueryParam("targ") != "") { theTarg = getQueryParam("targ"); }
        if ( getQueryParam("fsp1") != "") { theFsp1 = getQueryParam("fsp1"); } 
        if ( getQueryParam("mfsp1") != ""){ theMFsp1 = getQueryParam("mfsp1"); }
        if ( getQueryParam("fsp2") != "") { theFsp2 = getQueryParam("fsp2"); } 
        if ( getQueryParam("mfsp2") != ""){ theMFsp2 = getQueryParam("mfsp2"); }
        if ( getQueryParam("fsp3") != "") { theFsp3 = getQueryParam("fsp3"); } 
        if ( getQueryParam("mfsp3") != ""){ theMFsp3 = getQueryParam("mfsp3"); }
        if ( getQueryParam("obs")  != "") { theObs  = getQueryParam("obs");  }

        Query q = null;

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

        // assuming we have a beam particle first 
        if(theBeam != ""){
            if (flag == "count"){
                b.append("select count(yabeam) from YAxis yabeam join yabeam._reactions yrbeam join yrbeam._initialState beam"); 
            }
            else{
                b.append("select distinct yabeam from YAxis yabeam join yabeam._reactions yrbeam join yrbeam._initialState beam"); 
            }
            if (theTarg != ""){ b.append(",YAxis yatarg join yatarg._reactions yrtarg join yrtarg._initialState targ"); }
            if (theFsp1 != ""){ b.append(",YAxis yafsp1 join yafsp1._reactions yrfsp1 join yrfsp1._finalState fsp1"); }
            if (theFsp2 != ""){ b.append(",YAxis yafsp2 join yafsp2._reactions yrfsp2 join yrfsp2._finalState fsp2"); }
            if (theFsp3 != ""){ b.append(",YAxis yafsp3 join yafsp3._reactions yrfsp3 join yrfsp3._finalState fsp3"); }
            b.append(" where beam.name=:beampart");
            if (theTarg != ""){ b.append(" and targ.name=:targpart"); } 
            if (theFsp1 != ""){ b.append(" and fsp1.name=:fsp1part and fsp1.multiplicity=:fsp1mult"); } 
            if (theFsp2 != ""){ b.append(" and fsp2.name=:fsp2part and fsp2.multiplicity=:fsp2mult"); } 
            if (theFsp3 != ""){ b.append(" and fsp3.name=:fsp3part and fsp3.multiplicity=:fsp3mult"); } 
            if (theObs  != ""){ b.append(" and yabeam._observable=:observable"); } 
            if (theTarg != ""){ b.append(" and yrbeam = yrtarg"); }
            if (theFsp1 != ""){ b.append(" and yrbeam = yrfsp1"); }
            if (theFsp2 != ""){ b.append(" and yrbeam = yrfsp2"); }
            if (theFsp3 != ""){ b.append(" and yrbeam = yrfsp3"); }
            q = _session.createQuery(b.toString());
            q.setString("beampart",theBeam);
            if (theTarg != "")  {q.setString( "targpart",theTarg); }
            if (theFsp1 != "")  {q.setString( "fsp1part",theFsp1); }
            if (theFsp2 != "")  {q.setString( "fsp2part",theFsp2); }
            if (theFsp3 != "")  {q.setString( "fsp3part",theFsp3); }
            if (theFsp1 != "")  {q.setString( "fsp1mult",theMFsp1); }
            if (theFsp2 != "")  {q.setString( "fsp2mult",theMFsp2); }
            if (theFsp3 != "")  {q.setString( "fsp3mult",theMFsp3); }
            if (theObs  != "")  {q.setString( "observable",theObs); }
        }

        // no inital state so next assuming we have a fsp
        else if(theFsp1 != "") {
            if (flag == "count"){
                b.append("select count(yafsp1) from YAxis yafsp1 join yafsp1._reactions yrfsp1 join yrfsp1._finalState fsp1"); 
            }
            else {
                b.append("select distinct yafsp1 from YAxis yafsp1 join yafsp1._reactions yrfsp1 join yrfsp1._finalState fsp1"); 
            }
            if (theFsp2 != ""){ b.append(",YAxis yafsp2 join yafsp2._reactions yrfsp2 join yrfsp2._finalState fsp2"); }
            if (theFsp3 != ""){ b.append(",YAxis yafsp3 join yafsp3._reactions yrfsp3 join yrfsp3._finalState fsp3"); }
            b.append(" where fsp1.name=:fsp1part and fsp1.multiplicity=:fsp1mult"); 
            if (theFsp2 != ""){ b.append(" and fsp2.name=:fsp2part and fsp2.multiplicity=:fsp2mult"); } 
            if (theFsp3 != ""){ b.append(" and fsp3.name=:fsp3part and fsp3.multiplicity=:fsp3mult"); } 
            if (theObs  != ""){ b.append(" and yafsp1._observable=:observable"); } 
            if (theFsp2 != ""){ b.append(" and yrfsp1 = yrfsp2"); }
            if (theFsp3 != ""){ b.append(" and yrfsp1 = yrfsp3"); }
            q = _session.createQuery(b.toString());
            q.setString("fsp1part",theFsp1); q.setString("fsp1mult",theMFsp1);
            if (theFsp2 != "") {q.setString("fsp2part",theFsp2); q.setString("fsp2mult",theMFsp2);}
            if (theFsp3 != "") {q.setString("fsp3part",theFsp3); q.setString("fsp3mult",theMFsp3);}
            if (theObs  != "") {q.setString("observable",theObs);}
        }

        // OK no reaction  .. so do we have an observable? 
        else if(theObs != "") {
            if (flag == "count"){
                b.append("select count(yaobs) from YAxis yaobs"); 
            }
            else {
                b.append("select distinct yaobs from YAxis yaobs"); 
            }
            b.append(" where yaobs._observable=:observable");  
            q = _session.createQuery(b.toString());
            q.setString("observable",theObs);
        }

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

        return q;
     }
        
      
    public Long getSpiresId(){
         return _yaxis.getPaper().getSpiresId();
    }      

}

---