nl.topicus.jdbc.statement.CloudSpannerParameterMetaData Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of spanner-jdbc Show documentation
JDBC Driver for Google Cloud Spanner
There is a newer version: 1.1.6
package nl.topicus.jdbc.statement;

import java.math.BigDecimal;
import java.sql.Date;
import java.sql.ParameterMetaData;
import java.sql.SQLException;
import java.sql.Time;
import java.sql.Timestamp;
import java.sql.Types;
import nl.topicus.jdbc.metadata.AbstractCloudSpannerWrapper;

public class CloudSpannerParameterMetaData extends AbstractCloudSpannerWrapper
    implements ParameterMetaData {
  private final CloudSpannerPreparedStatement statement;

  CloudSpannerParameterMetaData(CloudSpannerPreparedStatement statement) throws SQLException {
    this.statement = statement;
    statement.getParameterStore().fetchMetaData(statement.getConnection());
  }

  @Override
  public int getParameterCount() throws SQLException {
    return statement.getParameterStore().getHighestIndex();
  }

  @Override
  public int isNullable(int param) throws SQLException {
    Integer nullable = statement.getParameterStore().getNullable(param);
    return nullable == null ? parameterNullableUnknown : nullable.intValue();
  }

  @Override
  public boolean isSigned(int param) throws SQLException {
    int type = getParameterType(param);
    return type == Types.DOUBLE || type == Types.FLOAT || type == Types.BIGINT
        || type == Types.INTEGER || type == Types.DECIMAL;
  }

  @Override
  public int getPrecision(int param) throws SQLException {
    Integer length = statement.getParameterStore().getScaleOrLength(param);
    return length == null ? 0 : length.intValue();
  }

  @Override
  public int getScale(int param) throws SQLException {
    return 0;
  }

  @Override
  public int getParameterType(int param) throws SQLException {
    Integer type = statement.getParameterStore().getType(param);
    if (type != null)
      return type.intValue();

    Object value = statement.getParameterStore().getParameter(param);
    if (value == null) {
      return Types.OTHER;
    } else if (Boolean.class.isAssignableFrom(value.getClass())) {
      return Types.BOOLEAN;
    } else if (Byte.class.isAssignableFrom(value.getClass())) {
      return Types.TINYINT;
    } else if (Short.class.isAssignableFrom(value.getClass())) {
      return Types.SMALLINT;
    } else if (Integer.class.isAssignableFrom(value.getClass())) {
      return Types.INTEGER;
    } else if (Long.class.isAssignableFrom(value.getClass())) {
      return Types.BIGINT;
    } else if (Float.class.isAssignableFrom(value.getClass())) {
      return Types.FLOAT;
    } else if (Double.class.isAssignableFrom(value.getClass())) {
      return Types.DOUBLE;
    } else if (BigDecimal.class.isAssignableFrom(value.getClass())) {
      return Types.DECIMAL;
    } else if (Date.class.isAssignableFrom(value.getClass())) {
      return Types.DATE;
    } else if (Timestamp.class.isAssignableFrom(value.getClass())) {
      return Types.TIMESTAMP;
    } else if (Time.class.isAssignableFrom(value.getClass())) {
      return Types.TIME;
    } else if (String.class.isAssignableFrom(value.getClass())) {
      return Types.NVARCHAR;
    } else if (byte[].class.isAssignableFrom(value.getClass())) {
      return Types.BINARY;
    } else {
      return Types.OTHER;
    }
  }

  @Override
  public String getParameterTypeName(int param) throws SQLException {
    return getGoogleTypeName(getParameterType(param));
  }

  @Override
  public String getParameterClassName(int param) throws SQLException {
    Object value = statement.getParameterStore().getParameter(param);
    if (value != null)
      return value.getClass().getName();
    Integer type = statement.getParameterStore().getType(param);
    if (type != null)
      return getClassName(type.intValue());
    return null;
  }

  @Override
  public int getParameterMode(int param) throws SQLException {
    return parameterModeIn;
  }

  @Override
  public String toString() {
    StringBuilder res = new StringBuilder();
    try {
      res.append("CloudSpannerPreparedStatementParameterMetaData, parameter count: ")
          .append(getParameterCount());
      for (int param = 1; param <= getParameterCount(); param++) {
        res.append("\nParameter ").append(param).append(":\n\t Class name: ")
            .append(getParameterClassName(param));
        res.append(",\n\t Parameter type name: ").append(getParameterTypeName(param));
        res.append(",\n\t Parameter type: ").append(getParameterType(param));
        res.append(",\n\t Parameter precision: ").append(getPrecision(param));
        res.append(",\n\t Parameter scale: ").append(getScale(param));
        res.append(",\n\t Parameter signed: ").append(isSigned(param));
        res.append(",\n\t Parameter nullable: ").append(isNullable(param));
        res.append(",\n\t Parameter mode: ").append(getParameterMode(param));
      }
    } catch (SQLException e) {
      res.append("Error while fetching parameter metadata: ").append(e.getMessage());
    }
    return res.toString();
  }

}