1 package compbio.controllers;
3 import java.util.Calendar;
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;
11 import compbio.cassandra.CassandraRemover;
14 * @author Alexander Sherstnev
15 * @author Natasha Sherstneva
18 public class DatabaseController extends BasicController {
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";
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";
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";
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;
53 numberRemover = cr.RemoveJobById(jobId);
55 numberRemover = cr.RemoveJobByDate(date1, date2);
57 numberRemover = cr.RemoveJobByIp(ip);
59 numberRemover = cr.RemoveJobBySequence(seq);
60 model.put("result", numberRemover);
61 return "reportRemoveData";
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());
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";
76 return "support/Blocked";