org.apache.ctakes.util.JdbcOperationsHelper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ctakes-ytex Show documentation

The newest version!

package org.apache.ctakes.util;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcOperations;

/**
 * Refactors helper functions like dropTableIfExists or other DB operations
 *
 * // TODO: consider renaming it with something more suitable
 */
public abstract class JdbcOperationsHelper {

	static private final Logger LOGGER = LoggerFactory.getLogger(JdbcOperationsHelper.class);

	/**
	 * Helper function to drop a 'table' from a DB, using SQL syntax
	 *
	 * @param jdbc
	 * @param dbEngineType
	 * @param tableName
	 */
	protected final void dropTableIfExist(JdbcOperations jdbc, final String dbEngineType, final String tableName) {
		// TODO: consider refactor using JOOQ
		String sqlStatement = "";
		switch (dbEngineType.toLowerCase()) {
			case "hsql":
			case "mysql":
				sqlStatement = String.format("DROP TABLE IF EXISTS %s", tableName);
				break;
			case "mssql":
				sqlStatement = String.format("IF EXISTS(SELECT * FROM sys.objects WHERE object_id = object_id('%s')) DROP TABLE %s", tableName);
				break;
			case "orcl":
				sqlStatement = String.format("DROP TABLE %s", tableName);
				break;
			default:
				LOGGER.warn(String.format("unsupported DB engine type: %s", dbEngineType));
				break;
		}
		if (!sqlStatement.isEmpty()) {
			try {
				jdbc.execute(sqlStatement);
			} catch (DataAccessException e) {
				LOGGER.warn(String.format("couldn't drop table %s. Maybe it doesn't even exists", tableName), e);
			}
		}
	}
}