All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.neo4j.jdbc.ResultSetImpl Maven / Gradle / Ivy

There is a newer version: 6.0.1
Show newest version
/*
 * Copyright (c) 2023-2024 "Neo4j,"
 * Neo4j Sweden AB [https://neo4j.com]
 *
 * This file is part of Neo4j.
 *
 * Licensed 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
 *
 *     https://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.neo4j.jdbc;

import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.io.Reader;
import java.io.StringReader;
import java.math.BigDecimal;
import java.net.URL;
import java.nio.charset.StandardCharsets;
import java.sql.Array;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Date;
import java.sql.NClob;
import java.sql.Ref;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.RowId;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.SQLWarning;
import java.sql.SQLXML;
import java.sql.Statement;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.concurrent.atomic.AtomicBoolean;
import java.util.concurrent.atomic.AtomicReference;

import org.neo4j.jdbc.internal.bolt.response.PullResponse;
import org.neo4j.jdbc.internal.bolt.response.RunResponse;
import org.neo4j.jdbc.values.Record;
import org.neo4j.jdbc.values.Type;
import org.neo4j.jdbc.values.UncoercibleException;
import org.neo4j.jdbc.values.Value;

final class ResultSetImpl implements ResultSet {

	/**
	 * A constant for the only holdability we support.
	 */
	static final int SUPPORTED_HOLDABILITY = ResultSet.CLOSE_CURSORS_AT_COMMIT;

	/**
	 * A constant for the only result type we support.
	 */
	static final int SUPPORTED_TYPE = ResultSet.TYPE_FORWARD_ONLY;

	/**
	 * A constant for the only concurrency we support.
	 */
	static final int SUPPORTED_CONCURRENCY = ResultSet.CONCUR_READ_ONLY;

	/**
	 * A constant for the only fetch direction we support.
	 */
	static final int SUPPORTED_FETCH_DIRECTION = ResultSet.FETCH_FORWARD;

	private final StatementImpl statement;

	private final Neo4jTransaction transaction;

	private final RunResponse runResponse;

	private final List keys;

	private final Record firstRecord;

	private final int maxFieldSize;

	private PullResponse batchPullResponse;

	private int fetchSize;

	private int remainingRowAllowance;

	private Iterator recordsBatchIterator;

	private Record currentRecord;

	private Value value;

	private boolean closed;

	private final AtomicBoolean beforeFirst = new AtomicBoolean(true);

	private final AtomicReference first = new AtomicReference<>();

	private final AtomicBoolean last = new AtomicBoolean(false);

	private final AtomicBoolean afterLast = new AtomicBoolean(false);

	ResultSetImpl(StatementImpl statement, Neo4jTransaction transaction, RunResponse runResponse,
			PullResponse batchPullResponse, int fetchSize, int maxRowLimit, int maxFieldSize) {
		this.statement = Objects.requireNonNull(statement);
		this.transaction = Objects.requireNonNull(transaction);
		this.runResponse = Objects.requireNonNull(runResponse);
		this.batchPullResponse = Objects.requireNonNull(batchPullResponse);
		this.setFetchSize(fetchSize);
		this.remainingRowAllowance = (maxRowLimit > 0) ? maxRowLimit : -1;
		var recordsBatch = batchPullResponse.records();
		this.recordsBatchIterator = recordsBatch.iterator();
		this.firstRecord = recordsBatch.isEmpty() ? null : recordsBatch.get(0);
		this.keys = (this.firstRecord != null) ? recordsBatch.get(0).keys() : runResponse.keys();
		this.maxFieldSize = maxFieldSize;
	}

	@Override
	public boolean next() throws SQLException {
		this.beforeFirst.compareAndSet(true, false);
		var result = next0();
		if (result) {
			if (!this.first.compareAndSet(null, true)) {
				this.first.compareAndSet(true, false);
			}
			this.last.compareAndSet(false, !(this.recordsBatchIterator.hasNext() || this.batchPullResponse.hasMore()));
		}
		else {
			this.first.compareAndSet(true, false);
			this.last.compareAndSet(true, false);
			this.afterLast.compareAndSet(false, true);
		}
		return result;
	}

	private boolean next0() throws SQLException {
		if (this.closed) {
			throw new SQLException("This result set is closed");
		}
		if (this.remainingRowAllowance == 0) {
			return false;
		}
		if (this.recordsBatchIterator.hasNext()) {
			this.currentRecord = this.recordsBatchIterator.next();
			decrementRemainingRowAllowance();
			return true;
		}
		if (this.batchPullResponse.hasMore()) {
			this.batchPullResponse = this.transaction.pull(this.runResponse, calculateFetchSize());
			this.recordsBatchIterator = this.batchPullResponse.records().iterator();
			return next();
		}
		this.currentRecord = null;
		return false;
	}

	@Override
	public void close() throws SQLException {
		if (this.closed) {
			return;
		}
		if (this.transaction.isAutoCommit() && this.transaction.isRunnable()) {
			this.transaction.commit();
		}
		this.closed = true;
		if (this.statement.isCloseOnCompletion()) {
			this.statement.close();
		}
	}

	@Override
	public boolean wasNull() throws SQLException {
		assertIsOpen();
		if (this.value == null) {
			throw new SQLException("No column has been read prior to this call");
		}
		return Type.NULL.isTypeOf(this.value);
	}

	@Override
	public String getString(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> mapToString(value, this.maxFieldSize));
	}

	@Override
	public boolean getBoolean(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToBoolean);
	}

	@Override
	public byte getByte(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToByte);
	}

	@Override
	public short getShort(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToShort);
	}

	@Override
	public int getInt(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToInteger);
	}

	@Override
	public long getLong(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToLong);
	}

	@Override
	public float getFloat(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToFloat);
	}

	@Override
	public double getDouble(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, ResultSetImpl::mapToDouble);
	}

	@Override
	@SuppressWarnings("deprecation")
	public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException {
		return getValueByColumnIndex(columnIndex, v -> mapToBigDecimal(v, scale));
	}

	@Override
	public byte[] getBytes(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> mapToBytes(value, this.maxFieldSize));
	}

	@Override
	public Date getDate(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, Neo4jConversions::asDate);
	}

	@Override
	public Time getTime(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, Neo4jConversions::asTime);
	}

	@Override
	public Timestamp getTimestamp(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, Neo4jConversions::asTimestamp);
	}

	@Override
	public InputStream getAsciiStream(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> mapToAsciiStream(value, this.maxFieldSize));
	}

	@Override
	@SuppressWarnings("deprecation")
	public InputStream getUnicodeStream(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public InputStream getBinaryStream(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> mapToBinaryStream(value, this.maxFieldSize));
	}

	@Override
	public String getString(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> mapToString(value, this.maxFieldSize));
	}

	@Override
	public boolean getBoolean(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToBoolean);
	}

	@Override
	public byte getByte(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToByte);
	}

	@Override
	public short getShort(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToShort);
	}

	@Override
	public int getInt(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToInteger);
	}

	@Override
	public long getLong(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToLong);
	}

	@Override
	public float getFloat(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToFloat);
	}

	@Override
	public double getDouble(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, ResultSetImpl::mapToDouble);
	}

	@Override
	@SuppressWarnings("deprecation")
	public BigDecimal getBigDecimal(String columnLabel, int scale) throws SQLException {
		return getValueByColumnLabel(columnLabel, v -> mapToBigDecimal(v, scale));
	}

	@Override
	public byte[] getBytes(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> mapToBytes(value, this.maxFieldSize));
	}

	@Override
	public Date getDate(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, Neo4jConversions::asDate);
	}

	@Override
	public Time getTime(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, Neo4jConversions::asTime);
	}

	@Override
	public Timestamp getTimestamp(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, Neo4jConversions::asTimestamp);
	}

	@Override
	public InputStream getAsciiStream(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> mapToAsciiStream(value, this.maxFieldSize));
	}

	@Override
	@SuppressWarnings("deprecation")
	public InputStream getUnicodeStream(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public InputStream getBinaryStream(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> mapToBinaryStream(value, this.maxFieldSize));
	}

	@Override
	public SQLWarning getWarnings() {
		// warnings are not supported
		return null;
	}

	@Override
	public void clearWarnings() {
		// warnings are not supported
	}

	@Override
	public String getCursorName() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public ResultSetMetaData getMetaData() {
		return new ResultSetMetaDataImpl(this.keys, this.firstRecord);
	}

	@Override
	public Object getObject(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> mapToObject(value, this.maxFieldSize));
	}

	@Override
	public Object getObject(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> mapToObject(value, this.maxFieldSize));
	}

	@Override
	public int findColumn(String columnLabel) throws SQLException {
		assertIsOpen();
		var index = this.keys.indexOf(columnLabel);
		if (index == -1) {
			throw new SQLException("No such column is present");
		}
		return ++index;
	}

	@Override
	public Reader getCharacterStream(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> mapToReader(value, this.maxFieldSize));
	}

	@Override
	public Reader getCharacterStream(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> mapToReader(value, this.maxFieldSize));
	}

	@Override
	public BigDecimal getBigDecimal(int columnIndex) throws SQLException {
		return getValueByColumnIndex(columnIndex, v -> mapToBigDecimal(v, null));
	}

	@Override
	public BigDecimal getBigDecimal(String columnLabel) throws SQLException {
		return getValueByColumnLabel(columnLabel, v -> mapToBigDecimal(v, null));
	}

	@Override
	public boolean isBeforeFirst() {
		return this.beforeFirst.get();
	}

	@Override
	public boolean isAfterLast() {
		return this.afterLast.get();
	}

	@Override
	public boolean isFirst() {
		return Boolean.TRUE.equals(this.first.get());
	}

	@Override
	public boolean isLast() {
		return this.last.get();
	}

	@Override
	public void beforeFirst() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void afterLast() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean first() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean last() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public int getRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean absolute(int row) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean relative(int rows) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean previous() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void setFetchDirection(int direction) throws SQLException {
		assertIsOpen();
		if (direction != SUPPORTED_FETCH_DIRECTION) {
			throw new SQLException("Only forward fetching is supported");
		}
	}

	@Override
	public int getFetchDirection() {
		return SUPPORTED_FETCH_DIRECTION;
	}

	@Override
	public void setFetchSize(int rows) {
		this.fetchSize = (rows > 0) ? rows : Neo4jStatement.DEFAULT_FETCH_SIZE;
	}

	@Override
	public int getFetchSize() {
		return this.fetchSize;
	}

	@Override
	public int getType() {
		return SUPPORTED_TYPE;
	}

	@Override
	public int getConcurrency() {
		return SUPPORTED_CONCURRENCY;
	}

	@Override
	public boolean rowUpdated() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean rowInserted() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public boolean rowDeleted() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNull(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBoolean(int columnIndex, boolean x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateByte(int columnIndex, byte x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateShort(int columnIndex, short x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateInt(int columnIndex, int x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateLong(int columnIndex, long x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateFloat(int columnIndex, float x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateDouble(int columnIndex, double x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateString(int columnIndex, String x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBytes(int columnIndex, byte[] x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateDate(int columnIndex, Date x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateTime(int columnIndex, Time x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateObject(int columnIndex, Object x, int scaleOrLength) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateObject(int columnIndex, Object x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNull(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBoolean(String columnLabel, boolean x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateByte(String columnLabel, byte x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateShort(String columnLabel, short x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateInt(String columnLabel, int x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateLong(String columnLabel, long x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateFloat(String columnLabel, float x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateDouble(String columnLabel, double x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBigDecimal(String columnLabel, BigDecimal x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateString(String columnLabel, String x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBytes(String columnLabel, byte[] x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateDate(String columnLabel, Date x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateTime(String columnLabel, Time x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateTimestamp(String columnLabel, Timestamp x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateAsciiStream(String columnLabel, InputStream x, int length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBinaryStream(String columnLabel, InputStream x, int length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateCharacterStream(String columnLabel, Reader reader, int length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateObject(String columnLabel, Object x, int scaleOrLength) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateObject(String columnLabel, Object x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void insertRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void deleteRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void refreshRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void cancelRowUpdates() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void moveToInsertRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void moveToCurrentRow() throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Statement getStatement() {
		return this.statement;
	}

	@Override
	public Object getObject(int columnIndex, Map> map) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Ref getRef(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Blob getBlob(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Clob getClob(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Array getArray(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Object getObject(String columnLabel, Map> map) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Ref getRef(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Blob getBlob(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Clob getClob(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Array getArray(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Date getDate(int columnIndex, Calendar cal) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> Neo4jConversions.asDate(value, cal));
	}

	@Override
	public Date getDate(String columnLabel, Calendar cal) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> Neo4jConversions.asDate(value, cal));
	}

	@Override
	public Time getTime(int columnIndex, Calendar cal) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> Neo4jConversions.asTime(value, cal));
	}

	@Override
	public Time getTime(String columnLabel, Calendar cal) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> Neo4jConversions.asTime(value, cal));
	}

	@Override
	public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException {
		return getValueByColumnIndex(columnIndex, value -> Neo4jConversions.asTimestamp(value, cal));
	}

	@Override
	public Timestamp getTimestamp(String columnLabel, Calendar cal) throws SQLException {
		return getValueByColumnLabel(columnLabel, value -> Neo4jConversions.asTimestamp(value, cal));
	}

	@Override
	public URL getURL(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public URL getURL(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateRef(int columnIndex, Ref x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateRef(String columnLabel, Ref x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBlob(int columnIndex, Blob x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBlob(String columnLabel, Blob x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateClob(int columnIndex, Clob x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateClob(String columnLabel, Clob x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateArray(int columnIndex, Array x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateArray(String columnLabel, Array x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public RowId getRowId(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public RowId getRowId(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateRowId(int columnIndex, RowId x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateRowId(String columnLabel, RowId x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public int getHoldability() {
		return SUPPORTED_HOLDABILITY;
	}

	@Override
	public boolean isClosed() {
		return this.closed;
	}

	@Override
	public void updateNString(int columnIndex, String nString) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNString(String columnLabel, String nString) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNClob(int columnIndex, NClob nClob) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNClob(String columnLabel, NClob nClob) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public NClob getNClob(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public NClob getNClob(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public SQLXML getSQLXML(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public SQLXML getSQLXML(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public String getNString(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public String getNString(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Reader getNCharacterStream(int columnIndex) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public Reader getNCharacterStream(String columnLabel) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateClob(int columnIndex, Reader reader, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateClob(String columnLabel, Reader reader, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateCharacterStream(int columnIndex, Reader x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateClob(int columnIndex, Reader reader) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateClob(String columnLabel, Reader reader) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNClob(int columnIndex, Reader reader) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public void updateNClob(String columnLabel, Reader reader) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}

	@Override
	public  T getObject(int columnIndex, Class type) throws SQLException {
		return getValueByColumnIndex(columnIndex, valueMapperFor(type));
	}

	private  ValueMapper valueMapperFor(Class type) {
		return value -> {
			if (type.isInstance(value)) {
				return type.cast(value);
			}
			var obj = mapToObject(value, this.maxFieldSize);
			if (type.isInstance(obj)) {
				return type.cast(obj);
			}
			throw new SQLException(new UncoercibleException(obj.getClass().getName(), type.getName()));
		};
	}

	@Override
	public  T getObject(String columnLabel, Class type) throws SQLException {

		return getValueByColumnLabel(columnLabel, valueMapperFor(type));
	}

	@Override
	public  T unwrap(Class iface) throws SQLException {
		if (iface.isAssignableFrom(getClass())) {
			return iface.cast(this);
		}
		else {
			throw new SQLException("This object does not implement the given interface");
		}
	}

	@Override
	public boolean isWrapperFor(Class iface) {
		return iface.isAssignableFrom(getClass());
	}

	private void assertCurrentRecordIsNotNull() throws SQLException {
		if (this.currentRecord == null) {
			throw new SQLException("Invalid cursor position");
		}
	}

	private void assertIsOpen() throws SQLException {
		if (this.closed) {
			throw new SQLException("The result set is closed");
		}
	}

	private void assertColumnIndexIsPresent(int columnIndex) throws SQLException {
		if (columnIndex < 1 || columnIndex > this.currentRecord.size()) {
			throw new SQLException("Invalid column index value");
		}
	}

	private void assertColumnLabelIsPresent(String columnLabel) throws SQLException {
		if (!this.currentRecord.containsKey(columnLabel)) {
			throw new SQLException("Invalid column label value");
		}
	}

	private  T getValueByColumnIndex(int columnIndex, ValueMapper valueMapper) throws SQLException {
		assertIsOpen();
		assertCurrentRecordIsNotNull();
		assertColumnIndexIsPresent(columnIndex);
		columnIndex--;
		this.value = this.currentRecord.get(columnIndex);
		return valueMapper.map(this.value);
	}

	private  T getValueByColumnLabel(String columnLabel, ValueMapper valueMapper) throws SQLException {
		assertIsOpen();
		assertCurrentRecordIsNotNull();
		assertColumnLabelIsPresent(columnLabel);
		this.value = this.currentRecord.get(columnLabel);
		return valueMapper.map(this.value);
	}

	private int calculateFetchSize() {
		return (this.remainingRowAllowance > 0) ? Math.min(this.remainingRowAllowance, this.fetchSize) : this.fetchSize;
	}

	private void decrementRemainingRowAllowance() {
		if (this.remainingRowAllowance > 0) {
			this.remainingRowAllowance--;
		}
	}

	private static String mapToString(Value value, int maxFieldSize) throws SQLException {
		if (Type.STRING.isTypeOf(value)) {
			return truncate(value.asString(), maxFieldSize);
		}
		if (Type.NULL.isTypeOf(value)) {
			return null;
		}
		throw new SQLException(String.format("%s value can not be mapped to String", value.type()));
	}

	private static boolean mapToBoolean(Value value) throws SQLException {
		if (Type.BOOLEAN.isTypeOf(value)) {
			return value.asBoolean();
		}
		if (Type.NULL.isTypeOf(value)) {
			return false;
		}
		if (Type.INTEGER.isTypeOf(value)) {
			var number = value.asNumber().longValue();
			if (number == 0) {
				return false;
			}
			else if (number == 1) {
				return true;
			}
			else {
				throw new SQLException("Number values can not be mapped to boolean aside from 0 and 1 values");
			}
		}
		if (Type.STRING.isTypeOf(value)) {
			var string = value.asString();
			if ("0".equals(string)) {
				return false;
			}
			else if ("1".equals(string)) {
				return true;
			}
			else {
				throw new SQLException("String values can not be mapped to boolean aside from '0' and '1' values");
			}
		}
		throw new SQLException(String.format("%s value can not be mapped to boolean", value.type()));
	}

	private static Byte mapToByte(Value value) throws SQLException {
		if (Type.INTEGER.isTypeOf(value)) {
			var longValue = value.asNumber().longValue();
			if (longValue >= Byte.MIN_VALUE && longValue <= Byte.MAX_VALUE) {
				return (byte) longValue;
			}
			throw new SQLException("The number is out of byte range");
		}
		if (Type.NULL.isTypeOf(value)) {
			return (byte) 0;
		}
		throw new SQLException(String.format("%s value can not be mapped to byte", value.type()));
	}

	private static Short mapToShort(Value value) throws SQLException {
		if (Type.INTEGER.isTypeOf(value)) {
			var longValue = value.asNumber().longValue();
			if (longValue >= Short.MIN_VALUE && longValue <= Short.MAX_VALUE) {
				return (short) longValue;
			}
			throw new SQLException("The number is out of short range");
		}
		if (Type.NULL.isTypeOf(value)) {
			return (short) 0;
		}
		throw new SQLException(String.format("%s value can not be mapped to short", value.type()));
	}

	private static int mapToInteger(Value value) throws SQLException {
		if (Type.INTEGER.isTypeOf(value)) {
			var longValue = value.asNumber().longValue();
			if (longValue >= Integer.MIN_VALUE && longValue <= Integer.MAX_VALUE) {
				return (int) longValue;
			}
			throw new SQLException("The number is out of int range");
		}
		if (Type.NULL.isTypeOf(value)) {
			return 0;
		}
		throw new SQLException(String.format("%s value can not be mapped to int", value.type()));
	}

	private static long mapToLong(Value value) throws SQLException {
		if (Type.INTEGER.isTypeOf(value)) {
			return value.asNumber().longValue();
		}
		if (Type.NULL.isTypeOf(value)) {
			return 0L;
		}
		throw new SQLException(String.format("%s value can not be mapped to long", value.type()));
	}

	private static float mapToFloat(Value value) throws SQLException {
		if (Type.FLOAT.isTypeOf(value)) {
			var doubleValue = value.asNumber().doubleValue();
			var floatValue = (float) doubleValue;
			if (Double.compare(doubleValue, floatValue) == 0) {
				return floatValue;
			}
			throw new SQLException("The number is out of float range");
		}
		if (Type.NULL.isTypeOf(value)) {
			return 0.0f;
		}
		throw new SQLException(String.format("%s value can not be mapped to float", value.type()));
	}

	private static double mapToDouble(Value value) throws SQLException {
		if (Type.FLOAT.isTypeOf(value)) {
			return value.asNumber().doubleValue();
		}
		if (Type.NULL.isTypeOf(value)) {
			return 0.0;
		}
		throw new SQLException(String.format("%s value can not be mapped to double", value.type()));
	}

	@SuppressWarnings("squid:S1168")
	private static byte[] mapToBytes(Value value, int maxFieldSize) throws SQLException {
		if (Type.NULL.isTypeOf(value)) {
			return null;
		}
		if (Type.BYTES.isTypeOf(value)) {
			return truncate(value.asByteArray(), maxFieldSize);
		}
		throw new SQLException(String.format("%s value can not be mapped to byte array", value.type()));
	}

	private static Reader mapToReader(Value value, int maxFieldSize) throws SQLException {
		if (Type.STRING.isTypeOf(value)) {
			return new StringReader(truncate(value.asString(), maxFieldSize));
		}
		if (Type.NULL.isTypeOf(value)) {
			return null;
		}
		throw new SQLException(String.format("%s value can not be mapped to Reader", value.type()));
	}

	@SuppressWarnings("BigDecimalMethodWithoutRoundingCalled")
	private static BigDecimal mapToBigDecimal(Value value, Integer scale) throws SQLException {

		var result = switch (value.type()) {
			case STRING -> new BigDecimal(value.asString());
			case INTEGER -> BigDecimal.valueOf(value.asLong());
			case FLOAT -> BigDecimal.valueOf(value.asDouble());
			case NULL -> null;
			default -> throw new SQLException(
					String.format("%s value can not be mapped to java.math.BigDecimal", value.type()));
		};

		if (result != null && scale != null) {
			try {
				return result.setScale(scale);
			}
			catch (ArithmeticException ae) {
				throw new SQLException(ae);
			}
		}
		return result;
	}

	private static InputStream mapToAsciiStream(Value value, int maxFieldSize) throws SQLException {
		if (Type.STRING.isTypeOf(value)) {
			return new ByteArrayInputStream(
					truncate(value.asString(), maxFieldSize).getBytes(StandardCharsets.US_ASCII));
		}
		if (Type.NULL.isTypeOf(value)) {
			return null;
		}
		throw new SQLException(String.format("%s value can not be mapped to java.io.InputStream", value.type()));
	}

	private static InputStream mapToBinaryStream(Value value, int maxFieldSize) throws SQLException {
		if (Type.STRING.isTypeOf(value)) {
			return new ByteArrayInputStream(truncate(value.asString(), maxFieldSize).getBytes(StandardCharsets.UTF_8));
		}
		if (Type.BYTES.isTypeOf(value)) {
			return new ByteArrayInputStream(truncate(value.asByteArray(), maxFieldSize));
		}
		if (Type.NULL.isTypeOf(value)) {
			return null;
		}
		throw new SQLException(String.format("%s value can not be mapped to java.io.InputStream", value.type()));
	}

	private static Object mapToObject(Value value, int maxFieldSize) {
		if (Type.STRING.isTypeOf(value)) {
			return truncate(value.asString(), maxFieldSize);
		}
		if (Type.BYTES.isTypeOf(value)) {
			return truncate(value.asByteArray(), maxFieldSize);
		}
		return value.asObject();
	}

	private static String truncate(String string, int limit) {
		if (limit > 0) {
			var bytes = string.getBytes(StandardCharsets.UTF_8);
			if (bytes.length > limit) {
				string = new String(truncateBytes(bytes, limit), StandardCharsets.UTF_8);
			}
		}
		return string;
	}

	private static byte[] truncate(byte[] bytes, int limit) {
		return (limit > 0 && bytes.length > limit) ? truncateBytes(bytes, limit) : bytes;
	}

	private static byte[] truncateBytes(byte[] bytes, int limit) {
		var truncatedBytes = new byte[limit];
		System.arraycopy(bytes, 0, truncatedBytes, 0, limit);
		return truncatedBytes;
	}

	@FunctionalInterface
	private interface ValueMapper {

		T map(Value value) throws SQLException;

	}

}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy