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 fr.ifremer.quadrige3.core.dao.technical.Daos;
  import fr.ifremer.quadrige3.core.service.DatabaseSchemaService;
  import fr.ifremer.quadrige3.core.service.ServiceLocator;
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  import org.nuiton.version.Version;
  
  import java.io.File;
  import java.io.IOException;
  
  /**
   * <p>DatabaseStatusAction class.</p>
   */
  public class DatabaseStatusAction {
      /* Logger */
      private static final Log log = LogFactory.getLog(DatabaseStatusAction.class);
  
      /**
       * <p>run.</p>
       */
      public void run() {
          QuadrigeConfiguration config = QuadrigeConfiguration.getInstance();
          
          if (log.isInfoEnabled()) {
              log.info("Starting database status report...");
          }
          ActionUtils.logConnectionProperties();
          
          boolean isValidConnection = Daos.isValidConnectionProperties(config.getJdbcDriver(),
                  config.getJdbcURL(),
                  config.getJdbcUsername(),
                  config.getJdbcPassword()); 
          
          if (!isValidConnection) {
              log.warn("Connection error : could not check database status.");
              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 check database status.");
              return;
          }
  
          try {
              Version actualDbVersion = databaseSchemaService.getDbVersion();
              if (actualDbVersion != null) {
                  log.info("Database schema version is: " + actualDbVersion.toString());
              }
  
              Version expectedDbVersion = databaseSchemaService.getApplicationVersion();
              log.info("Database schema version AFTER an update should be: " + expectedDbVersion.toString());
          } catch (QuadrigeTechnicalException e) {
              log.error("Error while getting versions.", e);
          }
          
          File outputFile = ActionUtils.checkAndGetOutputFile(false, this.getClass());
  
          try {
              log.info("Launching status report generation...");
              databaseSchemaService.generateStatusReport(outputFile);
              if (outputFile != null) {
                  log.info(String.format("Database status report successfully generated at %s", outputFile));
              }
              else {
                  log.info("Database status report successfully generated.");
              }
          } catch (QuadrigeTechnicalException | IOException e) {
              log.error("Error while writing database status report.", e);
          }
     }
 
 }