/*
    * 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.common.database.properties;
  
  import io.netty.util.internal.PlatformDependent;
  
  import java.sql.Connection;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.sql.Statement;
  
  import static org.waarp.common.database.model.DbModelMysql.*;
  
  /**
   * MySQL Database Model
   */
  public class MySQLProperties implements DbProperties {
    public static final String PROTOCOL = "mysql";
  
    private static final String VALIDATION_QUERY = "select 1";
  
    private final String driverName;
  
    public MySQLProperties() {
      if (PlatformDependent.javaVersion() >= 8) {
        String driver = MYSQL_DRIVER_JRE6;
        try {
          Class.forName(MYSQL_DRIVER_JRE8);
          driver = MYSQL_DRIVER_JRE8;
        } catch (final Exception e) {
          driver = MYSQL_DRIVER_JRE6;
        } finally {
          driverName = driver;
        }
      } else {
        driverName = MYSQL_DRIVER_JRE6;
      }
    }
  
    public static String getProtocolID() {
      return PROTOCOL;
    }
  
    @Override
    public String getDriverName() {
      return driverName;
    }
  
    @Override
    public String getValidationQuery() {
      return VALIDATION_QUERY;
    }
  
    @Override
    public int getMaximumConnections(final Connection connection)
        throws SQLException {
      Statement stm = null;
      ResultSet rs = null;
      try {
        stm = connection.createStatement();
        rs = stm.executeQuery("SELECT @@GLOBAL.max_connections");
        if (!rs.next()) {
          throw new SQLException("Cannot find max connection");
        }
        return rs.getInt(1);
      } finally {
        if (rs != null) {
          try {
            rs.close();
          } catch (final SQLException ignored) {
            // nothing
          }
        }
        if (stm != null) {
          try {
            stm.close();
          } catch (final SQLException ignored) {
            // nothing
          }
        }
      }
   }
 }