server/compbio/controllers/DatabaseController.java

   1 package compbio.controllers;
   2
   3 import java.util.Calendar;
   4 import java.util.Map;
   5
   6 import org.springframework.stereotype.Controller;
   7 import org.springframework.web.bind.annotation.RequestMapping;
   8 import org.springframework.web.bind.annotation.RequestMethod;
   9 import org.springframework.web.bind.annotation.RequestParam;
  10
  11 import compbio.cassandra.CassandraRemover;
  12
  13 /**
  14  * @author Alexander Sherstnev
  15  * @author Natasha Sherstneva
  16  */
  17 @Controller
  18 public class DatabaseController extends BasicController {
  19
  20         @RequestMapping(value = "/database/remove", method = RequestMethod.GET)
  21         public String initRemoveForm(Map<String, Object> model) {
  22                 model.put("username", getPrincipalName());
  23                 Calendar cal = Calendar.getInstance();
  24                 String date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
  25                 cal.add(Calendar.DATE, -3);
  26                 String date1 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
  27                 String jobid = "jp_NzBOJKo";
  28
  29                 model.put("samplejobid", jobid);
  30                 model.put("date1", date1);
  31                 model.put("date2", date2);
  32                 model.put("sampleip", "127.0.0.1");
  33                 model.put("sampleseq", "ATA");
  34                 return "query/RemoveJobs";
  35         }
  36
  37         @RequestMapping(value = "/database/state", method = RequestMethod.GET)
  38         public String initDBStatRequest(Map<String, Object> model) {
  39                 model.put("username", getPrincipalName());
  40                 // return "queryDBState";
  41                 return "support/Denied";
  42         }
  43
  44         @RequestMapping(value = "/database/remove/goreal", method = RequestMethod.GET)
  45         public String findIPwithCounter(@RequestParam("byId") String flagId, @RequestParam("id") String jobId,
  46                         @RequestParam("byDate") String flagDate, @RequestParam("date1") String date1, @RequestParam("date2") String date2,
  47                         @RequestParam("byIp") String flagIp, @RequestParam("ip") String ip, @RequestParam("bySequence") String flagSeq,
  48                         @RequestParam("seq") String seq, Map<String, Object> model) {
  49                 model.put("username", getPrincipalName());
  50                 CassandraRemover cr = new CassandraRemover();
  51                 int numberRemover = 0;
  52                 if (flagId != null)
  53                         numberRemover = cr.RemoveJobById(jobId);
  54                 if (flagDate != null)
  55                         numberRemover = cr.RemoveJobByDate(date1, date2);
  56                 if (flagIp != null)
  57                         numberRemover = cr.RemoveJobByIp(ip);
  58                 if (flagSeq != null)
  59                         numberRemover = cr.RemoveJobBySequence(seq);
  60                 model.put("result", numberRemover);
  61                 return "reports/RemoveDBrecords";
  62         }
  63
  64         @RequestMapping(value = "/database/remove/go", method = RequestMethod.GET)
  65         public String findIPwithCounter(@RequestParam("id") String jobId, @RequestParam("date1") String date1,
  66                         @RequestParam("date2") String date2, @RequestParam("ip") String ip, @RequestParam("seq") String seq, Map<String, Object> model) {
  67                 model.put("username", getPrincipalName());
  68                 /*
  69                  * CassandraRemover cr = new CassandraRemover(); int numberRemover = 0;
  70                  * if (flagId != null) numberRemover = cr.RemoveJobById(jobId); if
  71                  * (flagDate != null) numberRemover = cr.RemoveJobByDate(date1, date2);
  72                  * if (flagIp != null) numberRemover = cr.RemoveJobByIp(ip); if (flagSeq
  73                  * != null) numberRemover = cr.RemoveJobBySequence(seq);
  74                  * model.put("result", numberRemover); return "reportRemoveData";
  75                  */
  76                 return "support/Blocked";
  77         }
  78
  79 }