/*
    * This file is part of Waarp Project (named also Waarp or GG).
    *
    *  Copyright (c) 2019, Waarp SAS, and individual contributors by the @author
    *  tags. See the COPYRIGHT.txt in the distribution for a full listing of
    * individual contributors.
    *
    *  All Waarp Project is free software: you can redistribute it and/or
    * modify it under the terms of the GNU General Public License as published by
   * the Free Software Foundation, either version 3 of the License, or (at your
   * option) any later version.
   *
   * Waarp 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 General Public License along with
   * Waarp . If not, see <http://www.gnu.org/licenses/>.
   */
  package org.waarp.gateway.kernel.database.model;
  
  import org.waarp.common.database.DbRequest;
  import org.waarp.common.database.DbSession;
  import org.waarp.common.database.exception.WaarpDatabaseNoConnectionException;
  import org.waarp.common.database.exception.WaarpDatabaseSqlException;
  import org.waarp.common.database.model.DbModelOracle;
  import org.waarp.common.guid.LongUuid;
  import org.waarp.common.logging.SysErrLogger;
  import org.waarp.gateway.kernel.database.data.DbTransferLog;
  
  /**
   * Oracle Database Model implementation
   */
  public class DbModelOracleKernel extends DbModelOracle {
    /**
     * Create the object and initialize if necessary the driver
     *
     * @param dbserver
     * @param dbuser
     * @param dbpasswd
     *
     * @throws WaarpDatabaseNoConnectionException
     */
    public DbModelOracleKernel(final String dbserver, final String dbuser,
                               final String dbpasswd)
        throws WaarpDatabaseNoConnectionException {
      super(dbserver, dbuser, dbpasswd);
    }
  
    @Override
    public final void createTables(final DbSession session)
        throws WaarpDatabaseNoConnectionException {
      createTableMonitoring(session);
    }
  
    public static void createTableMonitoring(final DbSession session)
        throws WaarpDatabaseNoConnectionException {
      // Create tables: logs
      final String createTableH2 = "CREATE TABLE ";
      final String constraint = " CONSTRAINT ";
      final String primaryKey = " PRIMARY KEY ";
      final String notNull = " NOT NULL ";
  
      final DbRequest request = new DbRequest(session);
      // TRANSLOG
      StringBuilder action =
          new StringBuilder(createTableH2 + DbTransferLog.table + '(');
      final DbTransferLog.Columns[] acolumns = DbTransferLog.Columns.values();
      for (int i = 0; i < acolumns.length; i++) {
        action.append(acolumns[i].name())
              .append(DBType.getType(DbTransferLog.dbTypes[i])).append(notNull)
              .append(", ");
      }
      // Several columns for primary key
      action.append(constraint + " TRANSLOG_PK " + primaryKey + '(');
      for (int i = DbTransferLog.NBPRKEY; i > 1; i--) {
        action.append(acolumns[acolumns.length - i].name()).append(',');
      }
      action.append(acolumns[acolumns.length - 1].name()).append("))");
      SysErrLogger.FAKE_LOGGER.sysout(action);
      try {
        request.query(action.toString());
      } catch (final WaarpDatabaseNoConnectionException e) {
        SysErrLogger.FAKE_LOGGER.ignoreLog(e);
        return;
      } catch (final WaarpDatabaseSqlException e) {
        SysErrLogger.FAKE_LOGGER.ignoreLog(e);
        // XXX FIX No return
      } finally {
        request.close();
      }
      // Index TRANSLOG
      action = new StringBuilder(
          "CREATE INDEX IDX_TRANSLOG ON " + DbTransferLog.table + '(');
      final DbTransferLog.Columns[] icolumns = DbTransferLog.indexes;
      for (int i = 0; i < icolumns.length - 1; i++) {
        action.append(icolumns[i].name()).append(", ");
      }
      action.append(icolumns[icolumns.length - 1].name()).append(')');
     SysErrLogger.FAKE_LOGGER.sysout(action);
     try {
       request.query(action.toString());
     } catch (final WaarpDatabaseNoConnectionException e) {
       SysErrLogger.FAKE_LOGGER.ignoreLog(e);
       return;
     } catch (final WaarpDatabaseSqlException e) {
       SysErrLogger.FAKE_LOGGER.ignoreLog(e);
       // XXX FIX No return
     } finally {
       request.close();
     }
 
     // cptrunner
     action = new StringBuilder("DROP SEQUENCE " + DbTransferLog.fieldseq);
     SysErrLogger.FAKE_LOGGER.sysout(action);
     try {
       request.query(action.toString());
     } catch (final WaarpDatabaseNoConnectionException e) {
       SysErrLogger.FAKE_LOGGER.ignoreLog(e);
     } catch (final WaarpDatabaseSqlException e) {
       SysErrLogger.FAKE_LOGGER.ignoreLog(e);
     } finally {
       request.close();
     }
   }
 
   @Override
   public final void resetSequence(final DbSession session, final long newvalue)
       throws WaarpDatabaseNoConnectionException {
     // Nothing
   }
 
   @Override
   public final long nextSequence(final DbSession dbSession) {
     return LongUuid.getLongUuid();
   }
 
   @Override
   public final boolean upgradeDb(final DbSession session,
                                  final String version) {
     return true;
   }
 
   @Override
   public final boolean needUpgradeDb(final DbSession session,
                                      final String version,
                                      final boolean tryFix) {
     return false;
   }
 }