package fr.ifremer.quadrige3.core.action;
   
   /*-
    * #%L
    * Quadrige3 Core :: Shared
    * %%
    * Copyright (C) 2017 - 2019 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.dao.technical.Daos;
  import fr.ifremer.quadrige3.core.exception.QuadrigeTechnicalException;
  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;
  
  /**
   * @author peck7 on 06/06/2019.
   */
  public class DatabaseCreateSchemaAction {
  
      private static final Log LOG = LogFactory.getLog(DatabaseCreateSchemaAction.class);
  
      public void run() {
  
          QuadrigeConfiguration config = QuadrigeConfiguration.getInstance();
          File outputFile = ActionUtils.checkAndGetOutputFile(false, this.getClass());
  
          if (LOG.isInfoEnabled()) {
              LOG.info("Starting generation script file ...");
          }
          ActionUtils.logConnectionProperties();
  
          boolean isValidConnection = Daos.isValidConnectionProperties(config.getJdbcDriver(),
                  config.getJdbcURL(),
                  config.getJdbcUsername(),
                  config.getJdbcPassword());
  
          if (!isValidConnection) {
              LOG.warn("Connection error: could not generate script file.");
              return;
          }
          DatabaseSchemaService databaseSchemaService = ServiceLocator.instance().getService("databaseSchemaService", DatabaseSchemaService.class);
  
          try {
              Version actualDbVersion = databaseSchemaService.getDbVersion();
              if (actualDbVersion != null) {
                  LOG.info("Database schema version is: " + actualDbVersion.toString());
              }
  
              Version modelVersion = config.getVersion();
              LOG.info("Model version is: " + modelVersion.toString());
          } catch (QuadrigeTechnicalException e) {
              LOG.error("Error while getting versions.", e);
          }
  
          try {
              LOG.info("Launching creation file generation...");
              databaseSchemaService.createSchemaToFile(outputFile, false);
              if (outputFile != null) {
                  LOG.info(String.format("Database creation script file successfully generated at %s", outputFile));
              }
              else {
                  LOG.info("Database creation script file successfully generated.");
              }
          } catch (QuadrigeTechnicalException | IOException e) {
              LOG.error("Error while generating creation script file.", e);
          }
      }
  }