import compbio.cassandra.DateFormatter;
/**
+ * MVC controller for direct interaction with the internal DB
+ * A really dangerous controller since it can change data in the DB
+ * Should be available to administrators only
+ *
* @author Alexander Sherstnev
* @author Natasha Sherstneva
+ *
+ * @version 1.0
+ * @since Nov 2013
*/
@Controller
public class DatabaseController extends BasicController {
model.put("seq", sequence);
CassandraRemover cr = new CassandraRemover();
- int njobs = 0;
+ int njobs1 = 0;
+ int njobs2 = 0;
+ int njobs3 = 0;
+ int njobs4 = 0;
if (byId.equals("on,off"))
- njobs = cr.RemoveJobById(jobid);
+ njobs1 = cr.RemoveJobById(jobid);
if (byDate.equals("on,off")) {
long longDate1 = DateFormatter.DateParsing(date1, formaterYYMMDD) / 1000;
long longDate2 = DateFormatter.DateParsing(date2, formaterYYMMDD) / 1000;
int timerange = (int)(longDate2 - longDate1) /24 / 3600 + 1;
model.put("ndays", timerange);
- njobs = cr.RemoveJobByDate(date1, date2);
+ njobs2 = cr.RemoveJobByDate(date1, date2);
}
if (byIp.equals("on,off"))
- njobs = cr.RemoveJobByIp(ip);
+ njobs3 = cr.RemoveJobByIp(ip);
if (bySequence.equals("on,off"))
- njobs = cr.RemoveJobBySequence(sequence);
- model.put("njobs", njobs);
+ njobs4 = cr.RemoveJobBySequence(sequence);
+ model.put("njobs", njobs1 + njobs2 + njobs3 + njobs4);
+ model.put("njobsbyDate", njobs2);
+ model.put("njobsbyIP", njobs3);
+ model.put("njobsbySeq", njobs4);
return "reports/RemoveJobs";
}