net.snowflake.client.core.arrow.VarCharConverter Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of snowflake-jdbc Show documentation
Snowflake JDBC Driver
There is a newer version: 3.18.0
/*
 * Copyright (c) 2012-2019 Snowflake Computing Inc. All rights reserved.
 */
package net.snowflake.client.core.arrow;

import net.snowflake.client.core.DataConversionContext;
import net.snowflake.client.core.SFException;
import net.snowflake.client.jdbc.ErrorCode;
import net.snowflake.client.jdbc.SnowflakeType;
import net.snowflake.client.jdbc.SnowflakeUtil;
import org.apache.arrow.vector.ValueVector;
import org.apache.arrow.vector.VarCharVector;

import java.math.BigDecimal;
import java.nio.charset.StandardCharsets;

/**
 * Convert Arrow VarCharVector to Java types
 */
public class VarCharConverter extends AbstractArrowVectorConverter
{
  private VarCharVector varCharVector;

  public VarCharConverter(ValueVector valueVector, int columnIndex, DataConversionContext context)
  {
    super(SnowflakeType.TEXT.name(), valueVector, columnIndex, context);
    this.varCharVector = (VarCharVector) valueVector;
  }

  @Override
  public String toString(int index)
  {
    byte[] bytes = toBytes(index);
    return bytes == null ? null : new String(bytes, StandardCharsets.UTF_8);
  }

  @Override
  public byte[] toBytes(int index)
  {
    return isNull(index) ? null : varCharVector.get(index);
  }

  @Override
  public Object toObject(int index)
  {
    return toString(index);
  }

  @Override
  public short toShort(int index) throws SFException
  {
    String str = toString(index);
    try
    {
      if (str == null)
      {
        return 0;
      }
      else
      {
        return Short.parseShort(str);
      }
    }
    catch (NumberFormatException ex)
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT,
                            logicalTypeStr,
                            SnowflakeUtil.SHORT_STR,
                            str);
    }
  }

  @Override
  public int toInt(int index) throws SFException
  {
    String str = toString(index);
    try
    {
      if (str == null)
      {
        return 0;
      }
      else
      {
        return Integer.parseInt(str);
      }
    }
    catch (NumberFormatException ex)
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT,
                            logicalTypeStr,
                            SnowflakeUtil.INT_STR,
                            str);
    }
  }

  @Override
  public long toLong(int index) throws SFException
  {
    String str = toString(index);
    try
    {
      if (str == null)
      {
        return 0;
      }
      else
      {
        return Long.parseLong(str);
      }
    }
    catch (NumberFormatException ex)
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT,
                            logicalTypeStr,
                            SnowflakeUtil.LONG_STR,
                            str);
    }
  }

  @Override
  public float toFloat(int index) throws SFException
  {
    String str = toString(index);
    try
    {
      if (str == null)
      {
        return 0;
      }
      else
      {
        return Float.parseFloat(str);
      }
    }
    catch (NumberFormatException ex)
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT,
                            logicalTypeStr,
                            SnowflakeUtil.FLOAT_STR,
                            str);
    }
  }

  @Override
  public double toDouble(int index) throws SFException
  {
    String str = toString(index);
    try
    {
      if (str == null)
      {
        return 0;
      }
      else
      {
        return Double.parseDouble(str);
      }
    }
    catch (NumberFormatException ex)
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT,
                            logicalTypeStr,
                            SnowflakeUtil.DOUBLE_STR,
                            str);
    }
  }

  @Override
  public BigDecimal toBigDecimal(int index) throws SFException
  {
    String str = toString(index);
    try
    {
      if (str == null)
      {
        return null;
      }
      else
      {
        return new BigDecimal(str);
      }
    }
    catch (Exception ex)
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT,
                            logicalTypeStr,
                            SnowflakeUtil.BIG_DECIMAL_STR,
                            str);
    }
  }

  @Override
  public boolean toBoolean(int index) throws SFException
  {
    String str = toString(index);
    if (str == null)
    {
      return false;
    }
    else if ("0".equals(str) || Boolean.FALSE.toString().equalsIgnoreCase(str))
    {
      return false;
    }
    else if ("1".equals(str) || Boolean.TRUE.toString().equalsIgnoreCase(str))
    {
      return true;
    }
    else
    {
      throw new SFException(ErrorCode.INVALID_VALUE_CONVERT, logicalTypeStr,
                            SnowflakeUtil.BOOLEAN_STR, str);
    }
  }
}