/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package br.uff.ic.oceano.peixeespada.controller.command;
import br.uff.ic.oceano.controller.servlet.command.Command;
import br.uff.ic.oceano.core.dao.controle.JPAUtil;
import br.uff.ic.oceano.peixeespada.contexto.ContextoAmbiente;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Heliomar
*/
public class CommandCleanDataToExecuteExperiments implements Command{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
String strUser = request.getParameter("xpto");
if(strUser == null || !strUser.equals("kann")){
response.getWriter().println("\n Nada foi alterado ");
return;
}
JPAUtil.beginTransaction();
EntityManager em = JPAUtil.getEntityManager();
Query deleteKnowledge = em.createQuery("delete from Knowledge");
response.getWriter().println(deleteKnowledge.executeUpdate()+ " registros de conhecimento deletados <br/>");
Query deleteCiclosAgentes = em.createNativeQuery("update espada_agent set cycles = 0, successCycles = 0, worsenCycles = 0, notImproveNorWorsenCycles = 0");
response.getWriter().println(deleteCiclosAgentes.executeUpdate()+ " Agentes com os ciclos zerados (Sucesso, fracasso e Não Alteração) <br/>");
JPAUtil.commitTransaction();
ContextoAmbiente.getInstance().registraAllAtiveAgents();
response.getWriter().println(" BD preparado para experimentos ");
}
}