Class SQLUtil

src/main/java/com/oltpbenchmark/util/SQLUtil.java:36–753

import org.slf4j.LoggerFactory;

public abstract class SQLUtil {
  private static final Logger LOG = LoggerFactory.getLogger(SQLUtil.class);

  private static final DateFormat[] timestamp_formats =
      new DateFormat[] {
        new SimpleDateFormat("yyyy-MM-dd"),
        new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"),
        new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"),
      };

  /**
   * Return a long from the given object Handles the different cases from the various DBMSs
   *
   * @param obj
   * @return
   */
  public static Long getLong(Object obj) {
    if (obj == null) {
      return (null);
    }

    if (obj instanceof Long) {
      return (Long) obj;
    } else if (obj instanceof Integer) {
      return ((Integer) obj).longValue();
    } else if (obj instanceof BigDecimal) {
      return ((BigDecimal) obj).longValue();
    }

    LOG.warn("BAD BAD BAD: returning null because getLong does not support {}", obj.getClass());

    return (null);
  }

  public static Integer getInteger(Object obj) {
    if (obj == null) {
      return (null);
    }

    if (obj instanceof Integer) {
      return (Integer) obj;
    } else if (obj instanceof Long) {
      return ((Long) obj).intValue();
    } else if (obj instanceof BigDecimal) {
      return ((BigDecimal) obj).intValue();
    }

    LOG.warn("BAD BAD BAD: returning null because getInteger does not support {}", obj.getClass());

    return (null);
  }

  /**
   * Return a double from the given object Handles the different cases from the various DBMSs
   *
   * @param obj
   * @return
   */