package fr.ifremer.quadrige3.core.action;
   
   /*-
    * #%L
    * Quadrige3 Core :: Quadrige3 Core Shared
    * $Id:$
    * $HeadURL:$
    * %%
    * Copyright (C) 2017 Ifremer
   * %%
   * This program is free software: you can redistribute it and/or modify
   * it under the terms of the GNU Affero General Public License as published by
   * the Free Software Foundation, either version 3 of the License, or
   * (at your option) any later version.
   * 
   * This program is distributed in the hope that it will be useful,
   * but WITHOUT ANY WARRANTY; without even the implied warranty of
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   * GNU General Public License for more details.
   * 
   * You should have received a copy of the GNU Affero General Public License
   * along with this program.  If not, see <http://www.gnu.org/licenses/>.
   * #L%
   */
  
  
  import fr.ifremer.quadrige3.core.config.QuadrigeConfiguration;
  import fr.ifremer.quadrige3.core.exception.QuadrigeTechnicalException;
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  import org.nuiton.version.Version;
  
  import fr.ifremer.quadrige3.core.dao.technical.Daos;
  import fr.ifremer.quadrige3.core.service.DatabaseSchemaService;
  import fr.ifremer.quadrige3.core.service.ServiceLocator;
  
  /**
   * <p>DatabaseUpdateSchemaAction class.</p>
   *
   */
  public class DatabaseUpdateSchemaAction {
      /* Logger */
      private static final Log log = LogFactory.getLog(DatabaseUpdateSchemaAction.class);
  
      /**
       * <p>run.</p>
       */
      public void run() {
          QuadrigeConfiguration config = QuadrigeConfiguration.getInstance();
  
          if (log.isInfoEnabled()) {
              log.info("Starting database schema update...");
          }
          ActionUtils.logConnectionProperties();
  
          boolean isValidConnection = Daos.isValidConnectionProperties(config.getJdbcDriver(),
                  config.getJdbcURL(),
                  config.getJdbcUsername(),
                  config.getJdbcPassword());
  
          if (!isValidConnection) {
              log.warn("Connection error: could not update the schema.");
              return;
          }
          DatabaseSchemaService databaseSchemaService = ServiceLocator.instance().getService("databaseSchemaService", DatabaseSchemaService.class);
  
          // Check if database is well loaded
          if (!databaseSchemaService.isDbLoaded()) {
              log.warn("Database not start ! Could not update the schema.");
              return;
          }
  
          // Getting the database version 
          try {
              Version actualDbVersion = databaseSchemaService.getDbVersion();
              // result could be null, is DB is empty (mantis #21013)
              if (actualDbVersion == null) {
                  log.warn("Could not get database schema version");
              }
              else {
                  log.info(String.format("Database schema version is [%s]", actualDbVersion));
              }
              
          } catch (QuadrigeTechnicalException e) {
              log.error("Error while getting database version.", e);
          }
  
          // Getting the version after update
          try {
              Version expectedDbVersion = databaseSchemaService.getApplicationVersion();
              if (expectedDbVersion == null) {
                  log.warn("Unable to get the database schema version AFTER the update. Nothing to update !");
                  return;
              }
              log.info(String.format("Database schema version AFTER the update should be [%s]", expectedDbVersion));            
          } catch (QuadrigeTechnicalException e) {
              log.error("Error while getting database version AFTER the update.", e);
          }
  
         // Run the update process
         try {
             log.info("Launching update...");
             databaseSchemaService.updateSchema();
             log.info("Database schema successfully updated.");
         } catch (QuadrigeTechnicalException e) {
             log.error("Error while updating the database schema.", e);
         }
     }
 }