[HepData-svn] r1481 - trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query

[blackhole at projects.hepforge.org]

Author: whalley
Date: Tue Nov  8 13:56:59 2011
New Revision: 1481

Log:
adding query for inspire id

Modified:
   trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java

Modified: trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java
==============================================================================
--- trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java	Tue Nov  8 13:56:19 2011	(r1480)
+++ trunk/hepdata-webapp/src/main/java/cedar/hepdata/webapp/query/ConstructQueryPaper.java	Tue Nov  8 13:56:59 2011	(r1481)
@@ -67,6 +67,7 @@
        String dsobservable = null;
        String sqrts = null;
        String spiresid = null;
+       String inspireid = null;
        String redid = null;
        String experiment = null;
        String author = null;
@@ -86,6 +87,7 @@
  	 	   }
 		   if(parts[0].equals("OBS")) {observable = parts[1];}
 		   if(parts[0].equals("IRN")) {spiresid = parts[1];}
+		   if(parts[0].equals("INS")) {inspireid = parts[1];}
 		   if(parts[0].equals("RED")) {redid = parts[1];}
  	 	   if(parts[0].equals("EXP") || parts[0].equals("DE") || parts[0].equals("CN")) {experiment = parts[1];}
  	 	   if(parts[0].equals("AUTH") || parts[0].equals("A") || parts[0].equals("AUTHOR") ) {author = parts[1];}
@@ -139,6 +141,7 @@
            }
        }
        if(spiresid != null) { return SpiresId(spiresid,flag,_session);}
+       else if(inspireid != null) { return InspireId(inspireid,flag,_session);}
        else if(redid != null) { return RedId(redid,flag,_session);}
        else if(author != null) { return Author(author,flag,_session);}
        else if(dsreaction!= null) { return DsReaction(dsreaction,dsobservable,flag,_session);}
@@ -569,6 +572,25 @@
        
        return q;
     }
+////// query constructor for INS (InSpire) only///
+    public static Query InspireId(String inspireid,String flag,  org.hibernate.Session _session){
+       String theIrn=inspireid;
+       Query q=null;         
+       StringBuffer b = new StringBuffer();
+           
+       if (flag.equals("count")){
+     	   b.append("select count(distinct p) from Paper p");
+       }
+       else{
+     	   b.append("select distinct p from Paper p");
+       }
+       b.append(" where p._inspireId like '");
+       b.append(inspireid);
+       b.append("' order by p._inspireId desc");
+       q = _session.createQuery(b.toString());
+       
+       return q;
+    }
 ////// query constructor for red only///
     public static Query RedId(String redid,String flag,  org.hibernate.Session _session){
 //       System.out.println("using RedId");