AvaticaResultSetThrowsSqlExceptionTest.java

/*
 * 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.calcite.avatica;

import org.junit.Test;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.util.Properties;

import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertThrows;
import static org.junit.Assert.assertTrue;

/**
 * Test class for {@link AvaticaResultSet}, to make sure we drop
 * {@link SQLException} for non supported function: {@link ResultSet#previous}
 * and {@link ResultSet#updateNull}, for example.
 */
public class AvaticaResultSetThrowsSqlExceptionTest {

  /**
   * A fake test driver for test.
   */
  private static final class TestDriver extends UnregisteredDriver {

    @Override protected DriverVersion createDriverVersion() {
      return new DriverVersion("test", "test 0.0.0", "test", "test 0.0.0", false, 0, 0, 0, 0);
    }

    @Override protected String getConnectStringPrefix() {
      return "jdbc:test";
    }

    @Override public Meta createMeta(AvaticaConnection connection) {
      return new AvaticaResultSetConversionsTest.TestMetaImpl(connection);
    }
  }

  /**
   * Auxiliary method returning a result set on a test table.
   *
   * @return a result set on a test table.
   * @throws SQLException in case of database error
   */
  private ResultSet getResultSet() throws SQLException {
    Properties properties = new Properties();
    properties.setProperty("timeZone", "GMT");

    final TestDriver driver = new TestDriver();
    final Connection connection = driver.connect("jdbc:test", properties);

    return connection.createStatement().executeQuery("SELECT * FROM TABLE");
  }

  @Test public void testPrevious() throws SQLException {
    Properties properties = new Properties();
    properties.setProperty("timeZone", "GMT");

    final TestDriver driver = new TestDriver();
    try (Connection connection = driver.connect("jdbc:test", properties);
         ResultSet resultSet =
             connection.createStatement().executeQuery("SELECT * FROM TABLE")) {
      assertThrows(SQLFeatureNotSupportedException.class, resultSet::previous);
    }
  }

  @Test public void testUpdateNull() throws SQLException {
    Properties properties = new Properties();
    properties.setProperty("timeZone", "GMT");

    final TestDriver driver = new TestDriver();
    try (Connection connection = driver.connect("jdbc:test", properties);
         ResultSet resultSet =
             connection.createStatement().executeQuery("SELECT * FROM TABLE")) {
      assertThrows(SQLFeatureNotSupportedException.class, () -> resultSet.updateNull(1));
    }
  }

  @Test public void testCommonCursorStates() throws SQLException {
    final ResultSet resultSet = getResultSet();

    // right after statement execution, result set is before first row
    assertTrue(resultSet.isBeforeFirst());

    // checking that return values of next and isAfterLast are coherent
    for (int c = 0; c < 3 && !resultSet.isAfterLast(); ++c) {
      assertTrue(resultSet.next() != resultSet.isAfterLast());
    }

    // result set is not closed yet, despite fully consumed
    assertFalse(resultSet.isClosed());

    resultSet.close();

    // result set is now closed
    assertTrue(resultSet.isClosed());

    // once closed, next should fail
    assertThrows(SQLException.class, resultSet::next);
  }

  /**
   * Auxiliary method for testing column access.
   *
   * @param resultSet Result set
   * @param index Index of the column to be accessed
   * @param shouldThrow Whether the column access should throw an exception
   * @return Whether the method invocation succeeded
   * @throws SQLException in case of database error
   */
  private boolean getColumn(final ResultSet resultSet, final int index,
      final boolean shouldThrow) throws SQLException {
    try {
      switch (index) {
      case 1: // BOOLEAN
        resultSet.getBoolean(index);
        break;
      case 2: // TINYINT
        resultSet.getByte(index);
        break;
      case 3: // SMALLINT
        resultSet.getShort(index);
        break;
      case 4: // INTEGER
        resultSet.getInt(index);
        break;
      case 5: // BIGINT
        resultSet.getLong(index);
        break;
      case 6: // REAL
        resultSet.getFloat(index);
        break;
      case 7: // FLOAT
        resultSet.getDouble(index);
        break;
      case 8: // VARCHAR
        resultSet.getString(index);
        break;
      case 9: // DATE
        resultSet.getDate(index);
        break;
      case 10: // TIME
        resultSet.getTime(index);
        break;
      case 11: // TIMESTAMP
        resultSet.getTimestamp(index);
        break;
      default:
        resultSet.getObject(index);
      }
    } catch (SQLException e) {
      if (!shouldThrow) {
        throw e;
      }
      return true;
    }

    return !shouldThrow;
  }

  @Test public void testGetColumnsBeforeNext() throws SQLException {
    try (ResultSet resultSet = getResultSet()) {
      // we have not called next, so each column getter should throw SQLException
      for (int i = 1; i <= resultSet.getMetaData().getColumnCount(); i++) {
        assertTrue(getColumn(resultSet, i, true));
      }
    }
  }

  @Test public void testGetColumnsAfterNext() throws SQLException {
    try (ResultSet resultSet = getResultSet()) {
      // result set is composed by 1 row, we call next before accessing columns
      resultSet.next();

      // after calling next, column getters should succeed
      for (int i = 1; i <= resultSet.getMetaData().getColumnCount(); ++i) {
        assertTrue(getColumn(resultSet, i, false));
      }
    }
  }

  @Test public void testGetColumnsAfterLast() throws SQLException {
    try (ResultSet resultSet = getResultSet()) {
      // these two steps move the cursor after the last row
      resultSet.next();
      resultSet.next();

      // the cursor being after the last row, column getters should fail
      for (int i = 1; i <= resultSet.getMetaData().getColumnCount(); ++i) {
        assertTrue(getColumn(resultSet, i, true));
      }
    }
  }

}

// End AvaticaResultSetThrowsSqlExceptionTest.java