/******************************************************************************

  * DatabaseConverterFormController.java - The Spring controller to alter my running production database.

  * 

  * PicMan - The BuckoSoft Picture Manager in Java

  * Copyright(c) 2006 - Dick Balaska

  * 

  */

 package com.buckosoft.PicMan.web;

 import java.util.HashMap;

 import java.util.Iterator;

 import java.util.List;

 import java.util.Map;

 import javax.servlet.http.HttpServletRequest;

 import javax.servlet.http.HttpServletResponse;

 import org.apache.commons.logging.Log;

 import org.apache.commons.logging.LogFactory;

 import org.springframework.validation.BindException;

 import org.springframework.web.servlet.ModelAndView;

 import com.buckosoft.BSAccount.web.BSAccountSimpleFormController;

 import com.buckosoft.BSAccount.web.BSAccountUserWebSession;

 import com.buckosoft.PicMan.business.PicManFacade;

 import com.buckosoft.PicMan.db.DatabaseFacade;

 import com.buckosoft.PicMan.domain.Pic;

 import com.buckosoft.PicMan.domain.Root;

 /**

  * The Spring controller to alter my running production database.

  * Sometimes, it is easier to throw some code in here then it is to try to 

  * fix the database with phpMyAdmin.

  * @author Dick Balaska

  * @since 2006/09/29

  */

 public class DatabaseConverterFormController extends BSAccountSimpleFormController {

 //        private static final boolean DEBUG = true;

     protected final Log logger = LogFactory.getLog(getClass());

     private DatabaseFacade        dbf;

     private PicManFacade        pmf;

         public DatabaseConverterFormController() {

                 setSessionForm(true);

                 setValidateOnBinding(true);

                 setCommandName("databaseConverterForm");

                 setFormView("DatabaseConverterForm");

         }

         public void setPicMan(PicManFacade pmf) {

                 this.pmf = pmf;

                 pmf = this.pmf;                // to remove an "unread locally" warning.

         }

         public void setDatabase(DatabaseFacade dbf) {

                 this.dbf = dbf;

         }

         protected Object formBackingObject(HttpServletRequest request) throws Exception {

             BSAccountUserWebSession userWebSession = this.bsAccountMan.getUserWebSession(request);

                 DatabaseConverterForm dcf = new DatabaseConverterForm();

                 dcf.setUserWebSession(userWebSession);

                 dcf.setRoots(dbf.getRoots());

                 String v;

                 v = request.getParameter("updSize");

                 if (v != null) {

                         dbf.getSystem().setUpdatePicSize(true);

                         dcf.setMessage("Queued updating sizes");

                 }

                 v = request.getParameter("mlbFilters");

                 if (v != null) {

                         dbf.getSystem().setUpdateMlbFilters(true);

                         dcf.setMessage("Queued MlbFilterFixer");

                 }

                 v = request.getParameter("md5sum");

                 if (v != null) {

                         dbf.getSystem().setUpdateMD5Sums(true);

                         dcf.setMessage("Queued UpdateMD5Sums");

                 }

                 v = request.getParameter("mosaicVectors");

                 if (v != null) {

                         dbf.getSystem().setCalcMosaicVectors(true);

                         dcf.setMessage("Queued calc mosaic vectors");

                 }

                 return(dcf);

         }

         protected void onBindAndValidate(HttpServletRequest request, Object command, BindException errors)

                         throws Exception {

 /*

                 AccountForm accountForm = (AccountForm) command;

                 Account account = accountForm.getAccount();

                 if (request.getParameter("account.listOption") == null) {

                         account.setListOption(false);

                 }

                 if (request.getParameter("account.bannerOption") == null) {

                         account.setBannerOption(false);

                 }

                 errors.setNestedPath("account");

                 getValidator().validate(account, errors);

                 errors.setNestedPath("");

 */

         }

         protected Map<String, Object> referenceData(HttpServletRequest request) throws Exception {

             BSAccountUserWebSession userWebSession = this.bsAccountMan.getUserWebSession(request);

                 Map<String, Object> myModel = new HashMap<String, Object>();

                 myModel.put("userWebSession", userWebSession);

 //                if (DEBUG)

 //                        logger.info("referenceData ChainManForm with session " + userWebSession);

                 return myModel;

         }

         protected ModelAndView onSubmit(

                         HttpServletRequest request, HttpServletResponse response, Object command, BindException errors)

                         throws Exception {

                 DatabaseConverterForm dcf = (DatabaseConverterForm) command;

                 boolean success = true;

                 // boolean action = false;

                  logger.info("oldName= '" + dcf.getOldName() + "'");

                  logger.info("newName= '" + dcf.getNewName() + "'");

                 if (dcf.getOldName().length() > 0 && dcf.getNewName().length() > 0) {

                         dcf.setMessage("Moved '" + dcf.getOldName() + "' to root '" + dcf.getNewName() + "'");

                          logger.info("oldName action");

                          Root root = dbf.getRoot(dcf.getNewName());

                          logger.info("rid = " + root.getRid());

                          List<Pic> pics = dbf.getPics();

                          Iterator<Pic> iter = pics.iterator();

                          while (iter.hasNext()) {

                                  Pic pic = iter.next();

                                  logger.info("Pic = " + pic.getName() + " loc: " + pic.getLocation());

                                  if (pic.getLocation().startsWith(dcf.getOldName())) {

                                          pic.setLocation(pic.getLocation().substring(dcf.getOldName().length()));

                                          pic.setRid(root.getRid());

                                          logger.info("Upd = " + pic.getName() + " loc: " + pic.getLocation());

                                          dbf.updatePic(pic);

                                  }

                          }

                  }

                  /*

                 if (cmf.getChainToDelete().length() > 0) {

                         Chain chain = new Chain();

                         chain.setName(cmf.getChainToDelete());

                         dbf.deleteChain(chain);

                         action = true;

                 }

                 if (!action && cmf.getNewChainName().length() > 0) {

                         if (DEBUG)

                                 logger.info("Adding new Chain '" + cmf.getNewChainName());

                         Chain c = new Chain();

                         c.setName(cmf.getNewChainName());

                         dbf.storeChain(c);

                         newChainName = c.getName();

                         action = true;

                 }

                 if (!action && cmf.getActiveChain() != null) {

                         Chain c = cmf.getActiveChain();

                         LinkedList<SetSize> newSetsSizes = parseSetsSizes(request);

                         c.setSetSizes(newSetsSizes);

                         dbf.storeChain(c);

                         action = true;

                 }

                 */

                 if (success) {

                         response.sendRedirect("databaseConverter.do");

                         return(null);

                 }

                 else

                         return super.onSubmit(request, response, command, errors);

         }

 }