com.mageddo.db.DBUtils Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of tobby-transactional-outbox Show documentation

null

There is a newer version: 2.1.6-alpha

Show newest version

package com.mageddo.db;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.sql.DataSource;

import com.mageddo.tobby.UncheckedSQLException;
import com.mageddo.tobby.internal.utils.Validator;

public class DBUtils {

  private static final Pattern DB_NAME_REGEX = Pattern.compile("jdbc:(\\w+):");

  private DBUtils() {
  }

  public static DB discoverDB(Connection connection) throws SQLException {
    final String url = connection
        .getMetaData()
        .getURL();
    return DB.of(findDBName(url));
  }

  public static DB discoverDB(DataSource dataSource) {
    try (Connection con = dataSource.getConnection()) {
      return DBUtils.discoverDB(con);
    } catch (SQLException e) {
      throw new UncheckedSQLException(e);
    }
  }

  private static String findDBName(String jdbcUrl) {
    final Matcher matcher = DB_NAME_REGEX.matcher(jdbcUrl);
    Validator.isTrue(matcher.find(), "Couldn't parse jdbc url: %s", jdbcUrl);
    return matcher.group(1);
  }

}