create ProteinBean
[proteocache.git] / server / compbio / statistic / CassandraRequester.java
index 410a722..c92b9bf 100755 (executable)
@@ -9,7 +9,7 @@ import java.util.Iterator;
 import java.util.List;
 import java.util.Map;
 
-import compbio.cassandra.AnnotatedProteinSequenceBean;
+import compbio.cassandra.ProteinBean;
 import compbio.cassandra.CassandraNativeConnector;
 import compbio.cassandra.CassandraReader;
 import compbio.cassandra.DataBase;
@@ -159,33 +159,59 @@ public class CassandraRequester {
                return query;
        }
 
+       /*
+        * query: jobs and sequence at date
+        */
+       public List<DataBase> readJobByDay (String date) {
+               System.out.println(date);
+               if (null == date) {
+                       return null;
+               }
+               if (!isThisDateValid(date, formatDDMMYY)) {
+                       System.out.println("Wrong date: point 3");
+                       return null;
+               }
+               SetDateRange();
+               long day = DateParsing(date, formatDDMMYY);
+               System.out.println(day);
+               if (day < earlestDate || day > currentDate)
+                       return null;    
+               List<Pair<String, String>>      res = db.ReadProteinData(day);
+               if (res == null)
+                       return null;
+               query = new ArrayList<DataBase>();
+               for (Pair<String, String> entry : res) {                
+                       DataBase bean = new DataBase();
+                       bean.setDate(date);
+                       bean.setId(entry.getElement0());
+                       bean.setProt(entry.getElement1());
+                       query.add(bean);
+               }
+               System.out.println("StatisticsProt.readLength: total number of dates = " + query.size());
+               return query;
+       }
+
+
        /* 
         * query: protein sequence
         * */
-       public List<DataBase> readProteins(String protIn, String flag) {
-               if (protIn == null)
-                       return null;
-               System.out.println(protIn.length());
-               query = new ArrayList<DataBase>();
-               List<AnnotatedProteinSequenceBean> res;
+       public List<ProteinBean> readProteins(String protIn, String flag) {
+               List<ProteinBean> result;
                if (flag.equals("whole")) 
-                       res = db.ReadWholeSequence(protIn);
+                       result = db.ReadWholeSequence(protIn);
                 else 
-                        res = (protIn.length() > 0) ? db.ReadPartOfSequence(protIn) : null;
-               if (res == null)
+                        result = db.ReadPartOfSequence(protIn);
+               if (result == null)
                        return null;
-               for (AnnotatedProteinSequenceBean entry : res) {
-                       DataBase db = new DataBase();
-                       db.setProt(entry.getSequence());
-                       db.setPredictions(entry);
-                       db.setId(entry.getJobid());
-                       if (flag.equals("part")) {
-                               db.setSubProt(CreateSubprot (entry.getSequence(), protIn));
+               
+               if (flag.equals("part")) {
+                       for (ProteinBean entry : result) {
+                               entry.setSubProt(CreateSubprot(entry.getSequence(), protIn));
                        }
-                       query.add(db);
-               }
-               return query;
+               }                                       
+               return result;
        }
+       
 
        /* 
         * query protein sequences with number of jobs
@@ -204,6 +230,26 @@ public class CassandraRequester {
                return query;
        }
        
+       /* 
+        * query ip with number of jobs
+        */
+       public List<DataBase> readIpByCounter(Integer minimalcounter) {
+               query = new ArrayList<DataBase>();
+               Map<String, Integer> map = db.ReadIpByCounter();
+               if (minimalcounter == null)
+                       minimalcounter = 0;
+               if (map == null)
+                       return null;
+               for (Map.Entry<String, Integer> entry : map.entrySet()) {
+                       if (entry.getValue() > minimalcounter) {
+                               DataBase bean = new DataBase();
+                               bean.setTotalId(entry.getValue());
+                               bean.setIp(entry.getKey());
+                               query.add(bean);
+                       }
+               }
+               return query;
+       }
        /*
         * query jobs log info
         */
@@ -218,6 +264,31 @@ public class CassandraRequester {
                return query;
        }
        
+       
+       /*
+        * query jobs by ipStructureJobLog
+        */
+       public List<DataBase> readIp(String ip) {
+               if (ip == null)
+                       return null;
+               List<Pair<String, String>> res = db.ReadIpWithJobs(ip);
+       //      System.out.println(res.size());
+               if (res == null) 
+                       return null;
+               query = new ArrayList<DataBase>();
+               for (Pair<String, String> entry : res) {        
+                       System.out.println("ip " + ip);
+                       System.out.println("id " + entry.getElement0());
+                       DataBase bean = new DataBase();
+                       bean.setIp(ip);
+                       bean.setId(entry.getElement0());
+                       bean.setProt(entry.getElement1());
+                       query.add(bean);
+               }
+               System.out.println(query.size());
+               return query;
+       }
+       
        /*
         * create list of parts of protein sequence;
         */