content: /*
   * Licensed to the Apache Software Foundation (ASF) under one or more
   * contributor license agreements.  See the NOTICE file distributed with
   * this work for additional information regarding copyright ownership.
   * The ASF licenses this file to You under the Apache License, Version 2.0
   * (the "License"); you may not use this file except in compliance with
   * the License.  You may obtain a copy of the License at
   *
   *    http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
   */
  package org.apache.arrow.adapter.jdbc.h2;
  
  import static org.apache.arrow.adapter.jdbc.JdbcToArrowTestHelper.assertDateVectorValues;
  import static org.apache.arrow.adapter.jdbc.JdbcToArrowTestHelper.assertTimeStampVectorValues;
  import static org.apache.arrow.adapter.jdbc.JdbcToArrowTestHelper.assertTimeVectorValues;
  
  import java.io.IOException;
  import java.sql.ResultSetMetaData;
  import java.sql.SQLException;
  import java.util.Arrays;
  import java.util.Calendar;
  import java.util.TimeZone;
  import java.util.stream.Stream;
  import org.apache.arrow.adapter.jdbc.AbstractJdbcToArrowTest;
  import org.apache.arrow.adapter.jdbc.JdbcToArrowConfig;
  import org.apache.arrow.adapter.jdbc.JdbcToArrowConfigBuilder;
  import org.apache.arrow.adapter.jdbc.JdbcToArrowTestHelper;
  import org.apache.arrow.adapter.jdbc.JdbcToArrowUtils;
  import org.apache.arrow.adapter.jdbc.Table;
  import org.apache.arrow.memory.RootAllocator;
  import org.apache.arrow.vector.DateDayVector;
  import org.apache.arrow.vector.TimeMilliVector;
  import org.apache.arrow.vector.TimeStampVector;
  import org.apache.arrow.vector.VectorSchemaRoot;
  import org.apache.arrow.vector.types.pojo.Schema;
  import org.junit.jupiter.params.ParameterizedTest;
  import org.junit.jupiter.params.provider.Arguments;
  import org.junit.jupiter.params.provider.MethodSource;
  
  /**
   * JUnit Test Class which contains methods to test JDBC to Arrow data conversion functionality with
   * TimeZone based Date, Time and Timestamp datatypes for H2 database.
   */
  public class JdbcToArrowTimeZoneTest extends AbstractJdbcToArrowTest {
  
    private static final String EST_DATE = "est_date";
    private static final String EST_TIME = "est_time";
    private static final String EST_TIMESTAMP = "est_timestamp";
    private static final String GMT_DATE = "gmt_date";
    private static final String GMT_TIME = "gmt_time";
    private static final String GMT_TIMESTAMP = "gmt_timestamp";
    private static final String PST_DATE = "pst_date";
    private static final String PST_TIME = "pst_time";
    private static final String PST_TIMESTAMP = "pst_timestamp";
  
    private static final String[] testFiles = {
      "h2/test1_est_date_h2.yml",
      "h2/test1_est_time_h2.yml",
      "h2/test1_est_timestamp_h2.yml",
      "h2/test1_gmt_date_h2.yml",
      "h2/test1_gmt_time_h2.yml",
      "h2/test1_gmt_timestamp_h2.yml",
      "h2/test1_pst_date_h2.yml",
      "h2/test1_pst_time_h2.yml",
      "h2/test1_pst_timestamp_h2.yml"
    };
  
    /**
     * Get the test data as a collection of Table objects for each test iteration.
     *
     * @return Collection of Table objects
     * @throws SQLException on error
     * @throws ClassNotFoundException on error
     * @throws IOException on error
     */
    public static Stream<Arguments> getTestData()
        throws SQLException, ClassNotFoundException, IOException {
      return Arrays.stream(prepareTestData(testFiles, JdbcToArrowTimeZoneTest.class))
          .map(Arguments::of);
    }
  
    /**
     * Test Method to test JdbcToArrow Functionality for various H2 DB based datatypes with TimeZone
     * based Date, Time and Timestamp datatype.
     */
    @ParameterizedTest
    @MethodSource("getTestData")
    @Override
    public void testJdbcToArrowValues(Table table)
        throws SQLException, IOException, ClassNotFoundException {
      this.initializeDatabase(table);
  
      testDataSets(
          sqlToArrow(
              conn,
              table.getQuery(),
              new RootAllocator(Integer.MAX_VALUE),
              Calendar.getInstance(TimeZone.getTimeZone(table.getTimezone()))),
          false);
      testDataSets(
          sqlToArrow(
              conn.createStatement().executeQuery(table.getQuery()),
              new RootAllocator(Integer.MAX_VALUE),
              Calendar.getInstance(TimeZone.getTimeZone(table.getTimezone()))),
          false);
      testDataSets(
          sqlToArrow(
              conn.createStatement().executeQuery(table.getQuery()),
              Calendar.getInstance(TimeZone.getTimeZone(table.getTimezone()))),
          false);
      testDataSets(
          sqlToArrow(
              conn.createStatement().executeQuery(table.getQuery()),
              new JdbcToArrowConfigBuilder(
                      new RootAllocator(Integer.MAX_VALUE),
                      Calendar.getInstance(TimeZone.getTimeZone(table.getTimezone())))
                  .build()),
          false);
      testDataSets(
          sqlToArrow(
              conn,
              table.getQuery(),
              new JdbcToArrowConfigBuilder(
                      new RootAllocator(Integer.MAX_VALUE),
                      Calendar.getInstance(TimeZone.getTimeZone(table.getTimezone())))
                  .build()),
          false);
    }
  
    @ParameterizedTest
    @MethodSource("getTestData")
    public void testJdbcSchemaMetadata(Table table) throws SQLException, ClassNotFoundException {
      this.initializeDatabase(table);
  
      Calendar calendar = Calendar.getInstance(TimeZone.getTimeZone(table.getTimezone()));
      JdbcToArrowConfig config =
          new JdbcToArrowConfigBuilder(new RootAllocator(0), calendar, true).build();
      ResultSetMetaData rsmd = conn.createStatement().executeQuery(table.getQuery()).getMetaData();
      Schema schema = JdbcToArrowUtils.jdbcToArrowSchema(rsmd, config);
      JdbcToArrowTestHelper.assertFieldMetadataMatchesResultSetMetadata(rsmd, schema);
    }
  
    /**
     * This method calls the assert methods for various DataSets.
     *
     * @param root VectorSchemaRoot for test
     * @param isIncludeMapVector is this dataset checks includes map column. Jdbc type to 'map'
     *     mapping declared in configuration only manually
     */
    @Override
    public void testDataSets(VectorSchemaRoot root, boolean isIncludeMapVector) {
      JdbcToArrowTestHelper.assertFieldMetadataIsEmpty(root);
  
      switch (table.getType()) {
        case EST_DATE:
        case GMT_DATE:
        case PST_DATE:
          assertDateVectorValues(
              (DateDayVector) root.getVector(table.getVector()),
              table.getValues().length,
              table.getIntValues());
          break;
        case EST_TIME:
        case GMT_TIME:
        case PST_TIME:
          assertTimeVectorValues(
              (TimeMilliVector) root.getVector(table.getVector()),
              table.getValues().length,
              table.getLongValues());
          break;
        case EST_TIMESTAMP:
        case GMT_TIMESTAMP:
        case PST_TIMESTAMP:
          assertTimeStampVectorValues(
              (TimeStampVector) root.getVector(table.getVector()),
              table.getValues().length,
              table.getLongValues());
          break;
        default:
          // do nothing
          break;
      }
    }
  }
  