org.eclipse.osee.framework.db.connection/src/org/eclipse/osee/framework/db/connection/info/SupportedDatabase.java

/*******************************************************************************
 * Copyright (c) 2004, 2007 Boeing.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *     Boeing - initial API and implementation
 *******************************************************************************/
package org.eclipse.osee.framework.db.connection.info;

import java.sql.SQLException;
import org.eclipse.osee.framework.db.connection.ConnectionHandler;
import org.eclipse.osee.framework.db.connection.OseeConnection;
import org.eclipse.osee.framework.db.connection.OseeDbConnection;
import org.eclipse.osee.framework.db.connection.exception.OseeDataStoreException;

public enum SupportedDatabase {
   oracle, derby, foxpro, mysql, postgresql;

   public static SupportedDatabase getDatabaseType(OseeConnection connection) throws OseeDataStoreException {
      try {
         SupportedDatabase toReturn = null;
         String dbName = connection.getMetaData().getDatabaseProductName();
         String lowerCaseName = dbName.toLowerCase();
         if (lowerCaseName.contains(SupportedDatabase.derby.toString())) {
            toReturn = SupportedDatabase.derby;
         } else if (lowerCaseName.contains(SupportedDatabase.oracle.toString())) {
            toReturn = SupportedDatabase.oracle;
         } else if (lowerCaseName.contains(SupportedDatabase.foxpro.toString())) {
            toReturn = SupportedDatabase.foxpro;
         } else if (lowerCaseName.contains(SupportedDatabase.mysql.toString())) {
            toReturn = SupportedDatabase.mysql;
         } else if (lowerCaseName.contains(SupportedDatabase.postgresql.toString())) {
            toReturn = SupportedDatabase.postgresql;
         } else {
            throw new OseeDataStoreException("Unsupported database type: " + dbName);
         }
         return toReturn;
      } catch (SQLException ex) {
         throw new OseeDataStoreException(ex);
      }
   }

   public static SupportedDatabase getDatabaseType() throws OseeDataStoreException {
      OseeConnection connection = OseeDbConnection.getConnection();
      try {
         return SupportedDatabase.getDatabaseType(connection);
      } finally {
         connection.close();
      }
   }

   public static boolean isDatabaseType(SupportedDatabase dbType) throws OseeDataStoreException {
      return getDatabaseType() == dbType;
   }

   public static boolean areHintsSupported() throws OseeDataStoreException {
      try {
         if (SupportedDatabase.isDatabaseType(oracle)) {
            return ConnectionHandler.getMetaData().getDatabaseMajorVersion() > 10;
         }
      } catch (SQLException ex) {
         throw new OseeDataStoreException(ex);
      }
      return false;
   }

   public static String getComplementSql() throws OseeDataStoreException {
      return isDatabaseType(oracle) ? "MINUS" : "EXCEPT";
   }
}